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
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
What is the most likely cause? D

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture