Review Game Zone
Games
Test
Preview
Back
Match it!
Match it! Select the correct answer from the pull down...Good luck!
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
John would like to display the count of employee last names on the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Where is the Insert Function button found in Microsoft Excel?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Which group on the Formulas tab enables a user to specify when a formula is computed?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
What function adds all of the numbers in a range of cells?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Which are valid Microsoft Excel functions?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
Formula Bar
Values
AVERAGE, MAX, and MIN
Calculation
SUM
Plot Area
Column
Chart Title
Check it!