Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Reveiw -3
Test Description: Excel Reveiw
Instructions: Answer all questions to get your test result.
1) If you were using relative cell references, the formula =A3+A4 would changed to ___ when copied from cell A5 to cell B5.
A
=B$4+B$5
B
=$B3+$B4
C
=B4+B5
D
=B3+B4
2) The Sum button is located in the __group on the Home tab of the Ribbon.
A
Editing
B
Commands
C
Formulas
D
Data
3) The SUM function that adds the numbers in the range D5:D17 is ___.
A
SUM(D5:D17)
B
(D5:D17)SUM
C
=SUM(D5:D17)
D
=(D5:D17)SUM
4) You can used the Insert Function dialog box to find a specific function. In the ___ box, type a brief description of what you want to do. Then click Go.
A
Directory
B
Find what
C
Go to
D
Search for a function
5) An example of the function that returns the number of cells in a range of cells that contain data is ___.
A
=COUNT(B4)
B
=NUMBER(B4)
C
=COUNT(B4:B15)
D
NUMBER(B4:B15)
6) In a PMT function, the argument indicated by FV refers to ___.
A
favorite value
B
past value
C
fixed value
D
future value
7) The ___ function returns the current date and time based on the computer's date and times settings
A
DATE()
B
WHEN()
C
NOW()
D
CURRENT()
8) The ___ function repeats the text in the specified cell a specified number of times
A
MIRROR
B
AGAIN
C
OVER
D
REPT
9) Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
A
=AVERAGE(E4:E9)
B
=AVG(E4:E9)
C
+AVERAGE(E4:E9)
D
=AVG(E4,E9)
10) Sam needs to round some figures in a worksheet. The Round funtion is considered to be a ___function.
A
financial
B
date and time
C
statistical
D
mathematical
*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?