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

The function inputs are referred to as ____________________.

____ is/are second in the order of precedence rules.

Identify the letter of the choice that best matches the phrase or definition. -Insufficient width in cell to display data, or negative date/time

The ____ function calculates the average of a list of values.

Excel's ____________________ feature gives you quick access to the SUM function and other similar functions.

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

MAX determines the number of values in a list. _________________________

After clicking the AutoSum button and choosing the function you want, Excel presents a suggested range to include in the calculation based on ____.

Excel formulas can contain ____.

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

Identify the letter of the choice that best matches the phrase or definition. -Invalid cell reference

The default print format has ____________________ rather than formulas printed in the cells.

The error message #REF! means that there is ____.

Some of the most common formatting options available in the Format Cells dialog box are also available on the HOME tab and on the Mini toolbar.

When entering a value in a cell, you should enter the value with commas.

In the Format Cells dialog box, the Category box lists the available number formats.

Typing a value into a cell instead of entering the formula that produced the value is a good practice when building a spreadsheet.

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 cell would have the formula =C5*C6?

Excel's ____ feature gives you quick access to the SUM function and other similar functions.

The ____ function calculates a minimum in a list of values.