Spreadsheet #1: Question Preview (ID: 3189)


Below is a preview of the questions contained within the game titled SPREADSHEET #1: Excel Questions .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]


Play games to reveal the correct answers. Click here to play a game and get the answers.

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 the data set above, visit ReviewGameZone.com and enter game ID number: 3189 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

TEACHERS / EDUCATORS
Log In
| Sign Up / Register