A function performs a calculation that results in A) Cell Reference B) A label C) A range of values D) Single value
What is D
100
The data required by a function
What is an Argument
100
$A6 is an absolute cell reference
What is FALSE it must be $A$6
100
The amount of money owed in a loan
What is Principal
100
Numbers that can be used in a calculation are called _____________
What are Values
200
Shee order can be changed by A) Clicking the insert worksheet tab B) dragging a sheet tab to a new location C) right-clicking a sheet tab and typing a new number for the sheet D) using home ---> Cut and copy ----> Paste
What is B
200
Function that shows the smallest number in a group of cells
What is MIN
200
#DIV/0? error indicates an error due to dividing by 0
What is TRUE
200
The function used to calculate the monthly payment
What is PMT Function
200
Words that are not used in calculations are known as ________
What are labels
300
Which key can be used to create an absolute cell reference?
A) Enter B) Tab C) F4 D) Ctrl
What is C
300
In order from highest to lowest
What is DESCENDING
300
An absolute cell reference changes when it's copied
What is FALSE
300
The orientation needed to print a worksheet on one page
What is LANDSCAPE
300
_______ _____ contain a reference to the original data and will automatically update if the source data changes
What are linked cells
400
What will be displayed by the formula =ROUND(B3, 1) if the number 34.7844 is stored in cell B3? A) 35 B) 34 C) =ROUND (B3,1) D) 34.8
What is D
400
A cell reference that does not change when copied because a dollar sign has been placed in front of both the column letter and the row number
What is ABSOLUTE CELL REFERENCE
400
Ascending order is also called alphabetical order when the data is text
What is TRUE
400
The extra amount you must payback on a loan
What is INTEREST
400
=ROUND(C16, 1) would round cell C16 how many decimal places?
What is 1
500
A group of cells that have been selected are called a A) Cell reference B) Label C) Range D) Single value
What is C
500
The process of making decisions using a spreadsheet model
What is a WHAT-IF-ANALYSIS
500
Headers, footers, and print orientation must be the same for each sheet in the work sheet
What is FALSE
500
The number of payments you would have on a 7 year loan at 9% interest.
What is 72
500
#### occurs when the result of the formula is too wide to fit in the ___________