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
Calculation
B
Function Library
C
Defined Names
D
Formula Auditing
2) Which group on the Formulas tab enables a user to specify when a formula is computed?
A
Function Library
B
Calculation
C
Defined Names
D
Formula Auditing
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
SUM
C
AVERAGE
D
MIN
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
MIN
D
SUM
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
Labels
D
Formulas
6) Where is the Insert Function button found in Microsoft Excel?
A
Quick Access Toolbar
B
Shortcut Menu
C
Formula Bar
D
Status Bar
7) What function adds all of the numbers in a range of cells?
A
Add
B
SUM
C
Calculate
D
Compute
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
Statement
B
Utility
C
Function
D
Procedure
10) Which are valid Microsoft Excel functions?
A
WEEKDAY, MAX, and CLOSE
B
AVERAGE, MAX, and MIN
C
MAX, MIN, and WEEK
D
AVERAGE, MAX, and NUM
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
Pie
B
Column
C
Bar
D
Line
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
Bar
B
Column
C
Pie
D
Line
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
Axis
C
Data Label
D
Legend
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
Axis
B
Chart Title
C
Legend
D
Data Label
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
Plot Area
B
Gridlines
C
Chart Title
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
Chart Title
C
Axis Title
D
Gridlines
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
Axis Fields
B
Values
C
Report Filler
D
Legend Fields
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
Axis Fields
B
Values
C
Report Filler
D
Legend Fields
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
Embedded Chart
C
Linked Chart
D
Pivot 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
Linked Chart
B
Embedded Chart
C
Line Chart
D
Pivot 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?