Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
MS Excel Honors #6
Test Description: Review
Instructions: Answer all questions to get your test result.
1) Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
A
Defined Names
B
Formula Auditing
C
Calculation
D
Function Library
2) Which group on the Formulas tab enables a user to specify when a formula is computed?
A
Formula Auditing
B
Function Library
C
Defined Names
D
Calculation
3) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
A
MAX
B
AVERAGE
C
MIN
D
SUM
4) Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
A
AVERAGE
B
MAX
C
SUM
D
MIN
5) Angie is calculating her average sales for the past four months. If she uses =AVERAGE(B1:B4), this is an example of which type of entry?
A
Values
B
Functions
C
Formulas
D
Labels
6) Where is the Insert Function button found in Microsoft Excel?
A
Quick Access Toolbar
B
Formula Bar
C
Status Bar
D
Shortcut Menu
7) What function adds all of the numbers in a range of cells?
A
SUM
B
Add
C
Compute
D
Calculate
8) Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
A
Calculate
B
Add
C
Autosum
D
Total
9) Which is a prewritten formula that is built into Microsoft Excel?
A
Procedure
B
Statement
C
Function
D
Utility
10) Which are valid Microsoft Excel functions?
A
WEEKDAY, MAX, and CLOSE
B
AVERAGE, MAX, and NUM
C
AVERAGE, MAX, and MIN
D
MAX, MIN, and WEEK
11) Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
A
Column
B
Line
C
Bar
D
Pie
12) Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create?
A
Line
B
Pie
C
Column
D
Bar
13) 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?
A
Chart Title
B
Legend
C
Axis
D
Data Label
14) Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include?
A
Data Label
B
Axis
C
Chart Title
D
Legend
15) Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include?
A
Chart Title
B
Plot Area
C
Gridlines
D
Axis Title
16) Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
A
Plot Area
B
Gridlines
C
Chart Title
D
Axis Title
17) John has created a PivotChart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this?
A
Legend Fields
B
Report Filler
C
Axis Fields
D
Values
18) 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?
A
Report Filler
B
Legend Fields
C
Axis Fields
D
Values
19) John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?
A
Line Chart
B
Pivot Chart
C
Embedded Chart
D
Linked Chart
20) John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create?
A
Embedded Chart
B
Linked Chart
C
Pivot Chart
D
Line Chart
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?