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

When working with multiple worksheets in a workbook, it's a good idea to rename each worksheet tab based on the default labels (Sheet1, Sheet2, and so on).

The Accounting Number Format displays ____.

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

The COUNT function recognizes both text and number cells. _________________________

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

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

MAX determines the number of values in a list. _________________________

A(n) ____________________ in Excel always begins with an equal sign (=).

A paper spreadsheet is simply a sheet organized into columns and headings. _________________________

A(n) ____________________ is an equation that performs calculations.

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

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?

A(n) value is an equation that performs calculations. _________________________

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

A function contains a list of inputs in a specific order, separated by ____.

If there is insufficient room to display a label in a cell, the text may be displayed in a truncated format.

Identify the letter of the choice that best matches the phrase or definition. -Invalid numeric values in a formula or function

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 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. -Which of the rows on the spreadsheet could easily make use of the SUM function?

Excel stores dates as sequential numbers starting with January 1st of the year ____.