Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?

Which group on the Formulas tab enables a user to specify when a formula is computed?

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?

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?

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?

Where is the Insert Function button found in Microsoft Excel?

What function adds all of the numbers in a range of cells?

Which command on the Home Tab displays the total of the selected cells directly after the selected cells?

Which is a prewritten formula that is built into Microsoft Excel?

Which are valid Microsoft Excel functions?

Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?

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?

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?

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?

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?

Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?

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?

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?

John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?

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?

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map