Formulas and Functions in Excel

A cell reference is ________

• The highlighted area that shows the sum of a selected cells.

• The unique identifier for a cell based on its column letter and row number

• The group of commands used to insert Formulas into a worksheet

• The text or number entered into a cell

All formulas in Excel begin with the following symbol

• A. +

• B. =

• C. %

• D. #

A worksheet range is a

• a. A command used for data modeling

• b. A range of values such as from 23 to 234

• c. A group of cells

• d. A group of worksheets

In the order of operations, which of the following comes first?

• a.Multiplication

• b.Operations involving large numbers

• c.Exponential calculations

• d.Operations enclosed in parentheses

Which error is obtained when a formatted number does not fit within a cell?

• a.#####

• b.#DIV/0

• c.#DIV@

• d.#VALUE!

What kind of software is Excel?

• Word processing software
• Spreadsheet Software
• Data Base Software

In Excel rows are labeled by

• letters
• numbers
• rows and numbers

In excel, columns are labeled by

• Letters
• Numbers
• Letters and numbers

If the parenthesis is removed, what will 9.5% be multiplied by? 

• D2 +D3+D4+D5
• D5
• D2
• None

Which response best completes the following statement: A formula is used to

• perform calculations or other actions.

• find averages.

• Look Up data