Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel 2013 Lesson 5 Vocabulary
Test Description: Excel 2013 lesson 5 vocabulary
Instructions: Answer all questions to get your test result.
1) The parameters of a function.
A
average function
B
count function
C
autosum
D
argumement
2) A formula that calculates the total from the adjacent cell through the first non-numeric cell using the SUM function
A
autosum
B
average function
C
argument
D
count function
3) A function that calculates the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
A
average function
B
argument
C
autosum
D
count function
4) A function that determines how many cells in a range contain a number
A
average funtion
B
count function
C
autosum
D
argument
5) A function that returns the number of cells in the selected range that contain text or values, but not blank cells.
A
countA function
B
count function
C
average function
D
function
6) A predefined formula that performs calculations.
A
arguement
B
function
C
average funciton
D
autosum
7) A function that returns the largest value in a set of values
A
function
B
NOW function
C
MIN function
D
MAX funciton
8) Two or more cells combined into a single cell.
A
autosum
B
merged cells
C
PMT function
D
argument
9) A function that determines the minimum value in a range of cells
A
MAX funciton
B
function
C
MIN function
D
merged cells
10) A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.
A
NOW function
B
PMT function
C
MIN function
D
MAX function
11) 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
Counta function
D
Count function
12) A function that returns a subtotal for a list.
A
SUBTOTAL function
B
PMT function
C
function
D
NOW function
13) A function that totals all of the cells in a range.
A
SUM function
B
Count function
C
argument
D
autosum
14) A function that returns the current date in a worksheet.
A
PMT function
B
NOW function
C
TODAY function
D
MIN function
15) An arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error.
A
function
B
argument
C
autosum
D
trace arrow
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?