WorksheetsFormulas and Functions in Excel
Total questions: 21
Worksheet time: 13mins
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!
Which response best completes the following statement: A formula is used to
perform calculations or other actions.
find averages.
Look Up data
Match the following
absolute cell reference
give the exact address of a cell regardless of its position
mixed cell reference
give the address of a cell that combines both relative and absolute references
relative cell reference
cell address based on relative position
A _____________ is a range of cells that are next to each other.
Continuing Selection
Contiguous Selection
Non-Continuing selection
Non-Contiguous Selection
A _______-is a selection of multiple cells that are not next to each other.
Continuing Selection
Non Continuing
Contiguous Selection
Non-Contiguous
Select all of the following data that can be entered in an Excel Spreadsheet.
Numbers
Text
Formulas
Only numbers
Only text
Determine whether the statements are true or false.
You can have more than one worksheet in a workbook
Worksheets cannot be deleted
Worksheets can be moved or copied to other workbooks.
You can rename a worksheet
You can format cells in a worksheet
You can use formulas in a worksheet
Worksheets cannot be shared with others
All worksheets automatically save.
Match the following
Formulas
Written expressions that return a value
equal sign
Begin every formula with this
A1
Relative Cell reference
$C$4
Absolute Cell reference
C$4
Mixed cell reference
Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiplies the results by 10. Which of the following formulas should he enter?
+A1+B1*10
.A1=b1*10
=(A1+B1)*10
Tim notices cell A5 of his worksheet contains the railroad track (#####) formulas error. What should he do?
Delete the formulas and just enter the value he wants in the cell
Resize the cell to fit the contents
Clear formatting on the cell
Filter the cell
Why is it better to use cell reference like (A2+A3) instead of typing the actual numbers like (2+4) in a formula?
Because it looks more professional
Because numbers cannot be used in Excel formulas
Because Excel doesn't recognize numbers typed directly into formulas
Because cell references make formulas easier to change when Data updates
