Excel 3&4 Review Game | Baamboozle - Baamboozle | The Most Fun Classroom Games!

English 31 Public

Functions, Formulas, and Charts

Study Slideshow

#Microsoft Excel

What does the button look like on the chart to apply a chart style?

Paint Brush

15

If you want both a Clustered Column AND a Line chart in one, you create this type of chart

Combination

15

To change the text direction of an axis title, where can you rotate the title?

Format Axis Title in the task pane for Text Direction

20

To define 20.0 as the Major units and 5.0 as the Minor units for a secondary axis,

Axis Options in task pane - UNITS (not Bounds - that the high and low)

20

To remove an entire data series from a chart (like take off 2017's number), use which button on Design tab?

Uncheck it in Select Data

20

How do you insert a trendline in a CHART?

Use the Chart Elements button (+)

20

To modify a fill color on a shape, simply use this button on the Home tab

Paint Bucket

10

To add Solid Fill Red Data Bars to a range, what tab has the Conditional Formatting button?

Home

10

To insert a Sparkline into a group of cells, go to what tab?

Insert

15

To insert high or low point markers into a sparkline, check this in what GROUP on the Design tab?

Show

20

Goal Seek is located in what command on the Data tab?

What-if Analysis

20

$B$2 is an example of what kind of cell reference?

Absolute

15

B$2 is an example of what kind of cell reference?

Mixed (the row 2 would stay put, but B would move since only one $)

15

What function would you use to calculate the arithmetic mean of a range?

AVERAGE

15

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have this applied:

Conditional Formatting (with Data Bars)

15