IC3-Key-Applications-(IC3-2).pdf - Certiport IC3-2 IC3 Key Applications http\/killexams.com\/exam-detail\/IC3-2 QUESTION 104 You work as a Sales Manager

IC3-Key-Applications-(IC3-2).pdf - Certiport IC3-2 IC3 Key...

This preview shows page 1 - 4 out of 9 pages.

IC3-2 Certiport IC3 Key Applications
Image of page 1
QUESTION: 104 You work as a Sales Manager for Tech Perfect Inc. You have to create a report in Excel 2007 in the following format: You want to insert formulas in the cells in the First Quarter column. These cells will display the sum of values of respective columns in January, February, and March columns. For this, you insert the following formula in the E2 cell: =sum(B2:D2) However, Excel is treating the formula as a text and displaying it in the following format: 108
Image of page 2
What is the most likely cause? A. Show Formula is enabled in the workbook. B. Manual Calculation is enabled in the workbook. C. The document is in the Page Layout view. D. A blank space is inserted before the equal sign (=) in the formula. Answer: D Explanation: The most likely cause of the issue is that a blank space is accidentally inserted before the equal sign. As a blank space is the first character, Excel is treating the expression as a text. While creating a formula, a user should make sure that equal sign (=) must be the first character in the cell. To resolve the issue, you will have to delete the space before the equal sign. QUESTION: 105 You work as an Office Assistant for BlueSoft Inc. All computers in the company have Microsoft Office 2007 installed. You are working in an Excel 2007 worksheet. You enter the following formula in a cell: =$D$14+E10 Which of the following types of cell references are used in the formula? Each correct
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 9 pages?

  • Fall '20
  • Microsoft Office 2007

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture