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
Count
B
Min
C
Max
D
Average
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
center
B
justify
C
merge and center
D
center align
3) Felix wants to rotate a label in his spreadsheet. Which tab from the format cell dialogue box should he choose?
A
alignment
B
number
C
border
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
=A3>$5000
B
=IF(A3,"YES,"NO")
C
=IF(A3>$5000)
D
=IF(A3>=5000,"YES","NO")
6) Which type of data does a Social Security number represent?
A
function
B
value
C
label
D
formula
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
relative
B
circular
C
absolute
D
argument
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
absolute
B
circular
C
argument
D
relative
9) To make spreadsheet row and/or column titles remain stationary on the screen, which command should be used?
A
link
B
sort
C
filter
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
simple sort
C
ascending sort
D
multiple 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?