MS Excel Honors #6 Question Preview (ID: 54175)


Review.

Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
a) Function Library
b) Defined Names
c) Formula Auditing
d) Calculation

Which group on the Formulas tab enables a user to specify when a formula is computed?
a) Function Library
b) Defined Names
c) Formula Auditing
d) Calculation

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) AVERAGE
b) MAX
c) MIN
d) SUM

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

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) Formulas
c) Labels
d) Functions

Where is the Insert Function button found in Microsoft Excel?
a) Quick Access Toolbar
b) Formula Bar
c) Status Bar
d) Shortcut Menu

What function adds all of the numbers in a range of cells?
a) Calculate
b) SUM
c) Compute
d) Add

Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
a) Autosum
b) Add
c) Total
d) Calculate

Which is a prewritten formula that is built into Microsoft Excel?
a) Utility
b) Procedure
c) Function
d) Statement

Which are valid Microsoft Excel functions?
a) AVERAGE, MAX, and NUM
b) MAX, MIN, and WEEK
c) AVERAGE, MAX, and MIN
d) WEEKDAY, MAX, and CLOSE

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a) Bar
b) Column
c) Line
d) Pie

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) Line
d) Pie

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) Axis
b) Chart Title
c) Data Label
d) Legend

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) Data Label
d) Legend

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) Axis Title
b) Chart Title
c) Gridlines
d) Plot Area

Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
a) Axis Title
b) Chart Title
c) Gridlines
d) Plot Area

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) Report Filler
b) Legend Fields
c) Axis Fields
d) Values

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

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?
a) Pivot Chart
b) Line Chart
c) Embedded Chart
d) Linked Chart

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) Pivot Chart
b) Line Chart
c) Embedded Chart
d) Linked Chart

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

TEACHERS / EDUCATORS
Log In
| Sign Up / Register