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

A range is considered to be ____ if it contains multiple rows and columns.

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.

Describe the difference between the three predefined styles in the Number group on the HOME tab or the Mini toolbar.

The ____ function adds a list of values and/or cell ranges.

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.

To correct the problem of the error message ######, ____.

When working with multiple worksheets in a workbook, it's a good idea to ____ each worksheet tab.

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 should Peter do to correct the ###### error?

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 word such as component, when used in a cell of the worksheet, is an example of a(n) ____________________.

The ### signs indicate that the column width is insufficient to display the complete value in the cell.

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.

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

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

To use a "general" formula over and over again but with a different set of numbers, use a feature called Rotating Values.

Calculations and their results are called ____.

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

Identify the letter of the choice that best matches the phrase or definition. -Wrong argument type or operand

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

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