Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Microsoft Excel 1.05
Test Description: Excel 2016
Instructions: Answer all questions to get your test result.
1) Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
A
Calculation
B
Function Library
C
Formula Auditing
D
Defined Names
2) Where is the Insert Function button found in Microsoft Excel?
A
Status bar
B
Quick Access Toolbar
C
Shortcut menu
D
Formula bar
3) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
A
MIN
B
AVERAGE
C
MAX
D
SUM
4) Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
A
Defined Names
B
Function Library
C
Formula Auditing
D
Calculation
5) Angie is calculating her average sales for the past four months. If she uses '=AVERAGE(B1:B4)', this is an example of which type of entry?
A
Labels
B
Formulas
C
Functions
D
Values
6) Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
A
Formula Auditing
B
Calculation
C
Function Library
D
Defined Names
7) Which are valid Microsoft Excel functions?
A
AVERAGE, MAX, and NUM
B
MAX, MIN, and WEEK
C
WEEKDAY, MAX, and CLOSE
D
AVERAGE, MAX, and MIN
8) Which is a prewritten formula that is built into Microsoft Excel?
A
Function
B
Procedure
C
Utility
D
Statement
9) Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
A
IF
B
TODAY
C
NOW
D
COUNT
10) What function adds all of the numbers in a range of cells?
A
Compute
B
Add
C
Calculate
D
Sum
11) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
A
SUM
B
MIN
C
MAX
D
AVERAGE
12) Larry has created a spreadsheet containing student grades. Which function would he use to return the current date and time in cell A1?
A
TODAY
B
NOW
C
COUNT
D
IF
13) Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?
A
=B1:B39
B
=SUM(B1:B39)
C
=$B$1+25
D
=B1+25
14) Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
A
AutoSum
B
Calculate
C
Add
D
Total
15) Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened?
A
CurrentDate
B
Date
C
Weekday
D
Today
*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?