Exam 1: Applying Fundamental Excel Skills and Tools in Problem Solving

To use a "general" formula over and over again but with a different set of numbers, use a feature called absolute cell referencing. _________________________

The Excel error message for "no answer" is ____.

To toggle between the display of formulas and the display of values, press and hold the Ctrl key while pressing ____.

If a column shows the numbers 1, 2, and 3 as well as the SUM equaling 6, the number 6 is a ____.

The function inputs are referred to as arguments. _________________________

The ____________________ Format button formats numbers with commas, two decimal places, values aligned on the decimal point, and the dollar sign displayed at the left edge of the cell.

The ____ function determines the number of values in a list.

The fill handle is a small square in the lower-right corner of a selected cell that you use to delete the contents of the selected cell.

The Comma Style button formats numbers with commas and no decimal places.

$B1 is an example of a(n) ____ reference.

Calculations and their results are called ____.

The function inputs are referred to as ____.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -Input

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -Output

Each function has its own ____, which specifies the function name and order of the arguments.

Case 1-2 Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column. -Peter has updated the production and cost figures and wants to enter them in the input area, which is ____.

A formula in Excel always begins with a(n) ____.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -Text labels

A word such as component, when used in a cell of the worksheet, is an example of a(n) ____________________.

Case 1-2 Peter is creating a spreadsheet to summarize labor costs, which is shown above. He has entered information into the Description column, Quantity/Shoe column, and Total Cost column. However, there are several errors in the Total Cost column. -What does the ###### error in cell D13 indicate?