Spreadsheet #1 Question Preview (ID: 3189)


Excel Questions. TEACHERS: click here for quick copy question ID numbers.

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) Count
c) Max
d) Min

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) center align
c) merge and center
d) justify

Felix wants to rotate a label in his spreadsheet. Which tab from the format cell dialogue box should he choose?
a) alignment
b) border
c) font
d) number

Which is NOT a valid mathematical operator?
a) +
b) /
c) #
d) *

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")

Which type of data does a Social Security number represent?
a) formula
b) function
c) label
d) value

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) argument
c) circular
d) relative

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) argument
c) circular
d) relative

To make spreadsheet row and/or column titles remain stationary on the screen, which command should be used?
a) filter
b) freeze
c) link
d) sort

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) ascending sort
b) logical sort
c) multiple sort
d) simple sort

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 3189 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links