MS Office Excel
Your co-worker sent you a workbook to update. You have entered new numbers in your worksheet, but the totals are not updating. Which of the following statements best describes how to remedy the problem?
Click the Share Workbook button on the Review tab.
Go to the cells with the totals that are not updating, press the F2 key and then press Enter to re-enter the formulas.
Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
None of these
Click the Calculation Options button on the Formulas tab and change the calculation setting from Manual to Automatic.
Related posts
Which tool you will use to join some cells and place the content at the middle of joined cell?A. From Format Cells dialog box click on Merge Cells check box
B. From Format Cells dialog box select the Centered alignment
C. From Format Cells dialog box choose Merge and Center check box
D. Click on Merge and Center tool on formatting toolbar
A(n) _________ is a prewritten formula that is built into EXCEL.
A. function
B. problem
C. equation
D. equal sign
The design of text.
A. Font
B. Cell
C. Range
D. Merge
You can print only an embedded chart by
A. Moving the chart to a chart sheet before you print.
B. Formatting the chart before you print
C. Selecting the chart before you print
D. a and c
Colton is calculating his GPA. If he uses =(A1+A2+A3+A4)/4, this is an example of which type of entry?
A. Values
B. Formulas
C. Labels
D. Functions
Which of the following is the oldest spreadsheet package?
A. VisiCalc
B. Lotus 1-2-3
C. Excel
D. StarCalc
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cell in that range that contain 100. Wha
A. SUMIF
B. AVERAGEIF
C. TOTALIF
D. COUNTIF
Leave a Reply