Microsoft Excel Ch. 4 Study Guide
Sign in to Google to save your progress. Learn more
Date *
MM
/
DD
/
YYYY
First Name *
Last Name *
Hour *
Multiple Choice
Identify the choice that best completes the statement or answers the question.
To switch to manual calculation, click the ____ button in the Calculation group on the Formulas tab, and then click Manual. *
The sequence used to calculate the value of a formula is called the ____. *
The formula = E6/4 is an example of a(n) ____ operation. *
If you discover that you need to make a correction, you can edit the formula. Click the cell with the formula you want to edit. Press the ____ or double-click the cell to enter editing mode. *
When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____. *
When evaluating formulas, the ____ of parentheses is evaluated first. *
After you finish typing a formula in a cell, you must enter it by pressing the ____. *
The SUM function that adds the numbers in the range D5:D17 is ____. *
In the figure below, number 3 is pointing to the ____ menu. *
Captionless Image
You cannot enter a formula with an incorrect structure in Excel. If you attempt to do so, a(n) ____ appears, explaining the error and providing a possible correction. *
The formula = B3^3 is an example of a(n) ____ operation. *
You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys. *
A ____ border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range. *
You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range. *
If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5. *
To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group. *
You can press the ____ key to cycle a selected cell reference from a relative reference to an absolute reference to a mixed reference with an absolute row to a mixed reference with an absolute column and back to a relative reference. *
Case EX 4-1
Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers.
Kayden wants to customize which calculations appear on the status bar. What should she do next? *
Case EX 4-2
Ben is copying some formulas and wants to make sure he has the cell references correct.
Ben wants to copy a formula that is the sum of five rows.  He wants the formula to change as he copies it so that it shows the sum of five rows for each column.  What type of cell reference should Ben use? *
Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section.  He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use? *
Submit
Clear form
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy
Google Forms