Excel 2013 Lesson 5 Vocabulary Question Preview (ID: 37693)
Excel 2013 Lesson 5 Vocabulary.
TEACHERS: click here for quick copy question ID numbers.
A predefined formula that performs calculations.
a) arguement
b) autosum
c) average funciton
d) function
A function that returns the largest value in a set of values
a) MAX funciton
b) function
c) MIN function
d) NOW function
A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
a) count function
b) countA function
c) function
d) average function
A function that calculates the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
a) argument
b) autosum
c) average function
d) count function
A function that determines how many cells in a range contain a number
a) argument
b) autosum
c) average funtion
d) count function
A formula that calculates the total from the adjacent cell through the first non-numeric cell using the SUM function
a) argument
b) autosum
c) average function
d) count function
The parameters of a function.
a) argumement
b) autosum
c) average function
d) count function
Two or more cells combined into a single cell.
a) autosum
b) argument
c) merged cells
d) PMT function
A function that determines the minimum value in a range of cells
a) MAX funciton
b) MIN function
c) function
d) merged cells
A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.
a) MIN function
b) MAX function
c) NOW function
d) PMT function
A function that requires a series of inputs regarding interest rate, loan amount, and loan duration, and then calculates the resulting loan payment.
a) PMT function
b) NOW function
c) Count function
d) Counta function
A function that returns a subtotal for a list.
a) PMT function
b) NOW function
c) SUBTOTAL function
d) function
A function that totals all of the cells in a range.
a) autosum
b) argument
c) Count function
d) SUM function
A function that returns the current date in a worksheet.
a) TODAY function
b) PMT function
c) NOW function
d) MIN function
An arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error.
a) trace arrow
b) argument
c) autosum
d) function
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37693 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 37693 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register