Advance Spreadsheet Review: Question Preview (ID: 12137)

Below is a preview of the questions contained within the game titled ADVANCE SPREADSHEET REVIEW: Obj. 5.01-5.04 .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.

Which chart will BEST represent the percentage of expenses for office supplies, salaries, and travel for a comany\\\'s total budget?
a) Pie
b) Line
c) Stacked bar
d) XY scatter

WHich function can a credit card company use to determine the time that has elapsed since a customer\\\'s payment was received
a) DAYS360
b) Count
c) Now
d) CountA

If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week what
a) line
b) pie
c) stacked bar
d) XY CountA

A stacked bar chart was created to represent the total sales of each employee over a four months ago
a) gridlines
b) chart title
c) data series
d) chart title

Which chart will represent each person\'s contribution to the total household budget over a period of six months?
a) stacked bar
b) pie
c) exploded pie
d) XY scatter

If Jake wants to find out if the size of a fruit has any effect on the total sales for the week of that particular fruit, what chart should he use?
a) XY scatter
b) stacked bar
c) pie
d) column

Which chart will best represent the effect of increasing the frequency of a company's radio advertisements on sales?
a) column
b) stacked bar
c) XY scatter
d) pie

A chart is created that compares the number of units for products A and B sold for three months, Which data appears on the y-axis?
a) Units sold
b) Months
c) Products
d) Sales

When creating a chart to analyze the effect of oil prices on the cost of stocks, which data will appear on the x-axis
a) Oil prices
b) Months
c) Stock prices
d) Stock names

A spreadsheet is created with drop down items that a user can select from. This is an examle of which function?
a) List
b) LookUP
c) Fill Series
d) Count

Play Games with the Questions above at
To play games using the questions from the data set above, visit and enter game ID number: 12137 in the upper right hand corner at or simply click on the link above this text.

Log In
| Sign Up / Register