Exam 10: Excel Lesson 4: Entering Worksheet Formulas

After you finish typing a formula in a cell, you must enter it by pressing the ____.

The formula =4*D5 is an example of a(n) ____________________ operation.

The results of the calculation appear in the cell in which the formula is entered.

When you need to edit a worksheet with many formulas, you can specify ____________________ calculation, which lets you determine when Excel calculates the formulas.

Three types of cell references are used in formulas that do NOT include ____.

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

The ____________________ calculation lists how many of the selected cells contain numbers.

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?

You can also switch between showing formulas and showing formula results in a worksheet by pressing the ____ keys.

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.

Worksheet users frequently need to add long columns or rows of numbers. The ____________________ button, makes this operation simple.

A ____ border indicates that you can replace the current reference in the formula by clicking another cell or selecting a range.

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.

The sequence used to calculate the value of a formula is called the ____.

The formula =B5+C5 is an example of a multiplication operation.

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. What should Kayden do to show the default calculations for a range of cells?

Please briefly describe these three summary calculation options and provide an example of when it would be used: Average, Minimum, and Maximum.

The equation used to calculate values in a cell is called a command .