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
=$B3+$B4
B
=B4+B5
C
=B3+B4
D
=B$4+B$5
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
=(D5:D17)SUM
B
SUM(D5:D17)
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
Find what
B
Directory
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
=COUNT(B4:B15)
C
NUMBER(B4:B15)
D
=NUMBER(B4)
6) In a PMT function, the argument indicated by FV refers to ___.
A
past value
B
fixed value
C
future value
D
favorite value
7) The ___ function returns the current date and time based on the computer's date and times settings
A
WHEN()
B
DATE()
C
CURRENT()
D
NOW()
8) The ___ function repeats the text in the specified cell a specified number of times
A
AGAIN
B
REPT
C
MIRROR
D
OVER
9) Sam needs to find the average of a range of numbers. What would be an example of a formula written correctly?
A
=AVG(E4,E9)
B
+AVERAGE(E4:E9)
C
=AVG(E4:E9)
D
=AVERAGE(E4:E9)
10) Sam needs to round some figures in a worksheet. The Round funtion is considered to be a ___function.
A
date and time
B
mathematical
C
financial
D
statistical
*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?