Basics of Excel | Baamboozle - Baamboozle | The Most Fun Classroom Games!

English 45 Public

Microsoft Excel

Study Slideshow

What cell is the active cell?

E1

5

What feature is used in cell E4?

wrap text

15

What feature has been applied in cell G4?

rotation

10

To modify the 750.00 to not have decimals, press what button twice?

Decrease decimal

15

What number format is used in cell G4, where the dollar sign is far left?

Accounting format

10

What number format is used in cell G12, where the dollar sign is hugging the number?

Currency format

15

What is wrong with cell A11? ####

The column is too skinny for the numbers

10

A formula is in cell E3. How do you quickly copy it down the column?

Click the cell and use the fill handle (notch - plus sign - drag)

15

A pattern started in column D and this popped up. What feature does that represent?

Flash fill

20

What date format is used in Column A?

Short date

15

Which group on the Home tab is where you locate the borders button?

Font

15

To autofit a column, double click where?

On the line between the two column letters (right of the column)

10

To autofit a column, you can use this button on the Home tab.

Format

15

What is the function to add up numbers in A3 to A7?

=SUM(A3:A7)

15

What is the function to count how many cells have numbers in A3 to A7?

=COUNT(A3:A7)

15

All math - functions and formulas - begin with this

Equals sign =

10