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

English 31 Public

Functions, Formulas, and Charts

Study Slideshow

#Microsoft Excel

Looking at the image, is E identifying the primary or secondary axis?

secondary

15

Which letter is an example of conditional formatting data bars?

F

15

Which letter is an example of Sparklines in trendline form?

G

15

To copy a formula down a column, click the cell and then pull this.

Fill handle

10

To fill with "formatting only" what must you do AFTER you pull the fill handle down?

Use the autofill options button that pops up and say "fill formatting only"

15

If you type Quarter 1 and pull the fill handle over, what happens?

It makes Quarter 2, Quarter 3, etc.

10

In this, what does the ZERO represent? =ROUND(K9,0)

The number of decimal places

20

When using a MAX function, what goes in the parenthesis?

The RANGE to find the highest number of with COLON - Example A5:A10

15

Which function is used to find the lowest number in a range?

MIN function

10

What does the TODAY function use in the parenthesis?

nothing - Example =TODAY()

15

To create a running total, use this tool, which pops up when you highlight a range

Quick Analysis

25

What is an ABSOLUTE REFERENCE to cell B15?

$B$15

20

Inside the parenthesis of an IF function, what is the first item in the parenthesis?

logical test that compares (like A5>100)

20

This feature is used to calculate how you can get to a number by changing a specific cell

Goal Seek

20

If you press the + Chart Elements button when on a chart, how can you remove the legend?

Uncheck Legend

10

To modify data labels to show both a percentage and labels, use this

Task Pane (options at right in task pane)

15