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

In the SUM function, two cell references separated by a colon are referred to as a(n) ____________________.

The ____ function ignores blank cells and text.

A function is always structured beginning with the function name and an opening ____.

The pound sign (#) is the syntax used by Excel to indicate that a cell reference is absolute.

To display formulas in a worksheet, click the FORMULAS tab on the ribbon and then click Show Formulas in the ____.

In a spreadsheet, a number such as 12 entered into a cell represents a ____.

A formula is an equation that performs calculations, the result of which can be either a value or a label.

The word Component entered into a cell represents a ____.

In the formula =$B$1*B11*C5, the cell reference B11 is a(n) ____________________ reference.

When the formulas are displayed, the worksheet column widths and formats ____.

The syntax used for referencing cells with their worksheet names is the sheet name, followed by ____, then the usual column letter and, finally, the row number.

If 5% is displayed in a cell, the actual value that is stored is ____.

Describe three ways to correct the formatting problem of modifying column width as shown by the error message ###### in a calculated cell.

Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet. -Which of the rows on the spreadsheet could easily make use of the SUM function?

The Excel operator for exponent is ____.

The labels and values upon which the calculations are based are called ____.

If A1=2, the resulting value of =3*A1^3 is ____.

Jane has just started a job at a local shoe retailer. One of her first tasks was to compile the above worksheet, showing the first quarter. Her boss has reviewed the worksheet and asked her to add some functions and formulas to the worksheet. -Cell D11 can be calculated with what formula?

B3:D7 represents ____.

The rules programmed into the function are referred to as the function's ____________________.