Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Spreadsheet #1
Test Description: Excel questions
Instructions: Answer all questions to get your test result.
1) Daryl uses a spreadsheet program to balance his checkbook and wants to see which month between June and December had the highest expenses. What type of mathematical operator should he use?
A
Average
B
Max
C
Min
D
Count
2) Kelly designed a spreadsheet using columns A-H. She must center the title of her spreadsheet across all of the columns she used. Which alignment will she choose from the toolbar?
A
merge and center
B
center align
C
center
D
justify
3) Felix wants to rotate a label in his spreadsheet. Which tab from the format cell dialogue box should he choose?
A
number
B
border
C
alignment
D
font
4) Which is NOT a valid mathematical operator?
A
*
B
+
C
#
D
/
5) The sales manager wants to know if all the salespersons met their goal of $5000 this month. Which of the following spreadsheet functions would give him/her the answer?
A
=IF(A3>$5000)
B
=A3>$5000
C
=IF(A3,"YES,"NO")
D
=IF(A3>=5000,"YES","NO")
6) Which type of data does a Social Security number represent?
A
value
B
formula
C
function
D
label
7) Joe is going to use fill down to enter the formula =B1/$C$1 into the cells Al:A25. What does the "$" represent in the formula?
A
absolute
B
relative
C
argument
D
circular
8) Pam is going to use fill down to enter the formula =B1/$C$1 into cells A1:A25. What does the "B1" represent in the formula?
A
circular
B
absolute
C
argument
D
relative
9) To make spreadsheet row and/or column titles remain stationary on the screen, which command should be used?
A
sort
B
filter
C
link
D
freeze
10) Ms. Mozingo, the data entry clerk for the school, needs to rank student athletes in descending order by GPA and last name. She is preparing a/an:
A
logical sort
B
ascending sort
C
multiple sort
D
simple sort
*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?