Excel Advanced Question Preview (ID: 16880)


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

John has used four different colors to show the different products his company sells. How will John show which color is used with which product?
a) X axis
b) y axis
c) Legend
d) Chart

John has created multiple charts for each product sold. How will his manager know the name of each chart?
a) X axis
b) Y axis
c) Legend
d) Chart Title

Which chart will best present a comparison of the average family income for three states, with emphasis on the states?
a) Column
b) Line
c) Pie
d) Scatter

If Jake wants to study the relationship between the daily temperature and the amount of fruit sold during a week, what kind of chart should he used?
a) Column
b) Line
c) Pie
d) Scatter

Which chart will BEST represent the percentage of expenses for travel, food, and entertainment, with emphasis on the entertainment expense?
a) Exploded Pie
b) Line
c) Pie
d) XY Scatter

Which chart type BEST represents the thousands of hits on multiple websites due to advertising?
a) Exploded Pie
b) Line
c) Scatter
d) Pie

Which function can an accounting department use in Cell A2 that will result in the current date?
a) Count
b) Count A
c) Day360
d) Now

Which function will result in the total number of entries in the cell range B5 to B14?
a) Count
b) Count A
c) Day360
d) Now

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) Months
b) Oil Prices
c) Stock Names
d) Stock Prices

Which chart type will best represent the percentage of expenses for office supplies, salaries, and travel for a company's total budget?
a) Column
b) Line
c) Pie
d) Scatter

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: 16880 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links