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
Formula Auditing
B
Function Library
C
Defined Names
D
Calculation
2) Where is the Insert Function button found in Microsoft Excel?
A
Formula bar
B
Shortcut menu
C
Status bar
D
Quick Access Toolbar
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
AVERAGE
B
SUM
C
MIN
D
MAX
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
Formula Auditing
B
Calculation
C
Defined Names
D
Function Library
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
Functions
B
Values
C
Formulas
D
Labels
6) Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?
A
Formula Auditing
B
Defined Names
C
Function Library
D
Calculation
7) Which are valid Microsoft Excel functions?
A
WEEKDAY, MAX, and CLOSE
B
MAX, MIN, and WEEK
C
AVERAGE, MAX, and MIN
D
AVERAGE, MAX, and NUM
8) Which is a prewritten formula that is built into Microsoft Excel?
A
Procedure
B
Statement
C
Utility
D
Function
9) Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
A
NOW
B
COUNT
C
IF
D
TODAY
10) What function adds all of the numbers in a range of cells?
A
Add
B
Sum
C
Compute
D
Calculate
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
MIN
B
AVERAGE
C
MAX
D
SUM
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
COUNT
B
NOW
C
TODAY
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+25
B
=SUM(B1:B39)
C
=$B$1+25
D
=B1:B39
14) Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
A
Calculate
B
AutoSum
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
Date
B
CurrentDate
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?