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

0%

0 0 0

Identify the yellow box.

Formula bar

To click and drag to select two areas on the sheet that are non-adjacent, select the first and hold this before selecting the rest.

Control

Double click the mouse in which spot to autofit?

Yellow arrow (between G and H)

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

Currency format

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

=SUM(A3:A7)

If you do not want to delete a column but do not need to see it all the time, just do this.

Hide it

Identify the white box.

Autosum

What does NON-ADJACENT cells mean?

Cells that aren't all touching - like A1 and C1 (because B1 is between)

Identify the orange box.

Wrap text in the cell

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

Flash fill

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

Format

Function or formula? =D500-D499

Formula (like a number sentence!)

The tabs at the bottom of the page in a workbook represent these.

Sheets

If the answer to a math problem is in parenthesis, what does that mean?

It's a negative number answer

In a function, the parenthesis generally should contain this:

Cell Range (example A5:A10)

Function or formula? =D5-B3

Formula

B5 is an example of a:

Cell Reference

What cell is the active cell?

E1

Function or formula? =SUM(B7:B10)

Function (it has a name!)

Function or formula? =AVERAGE(B22:B34)

Function (it has a name!)

To autofit a column, double click where?

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

What feature has been applied in cell G4?

rotation

1, 2, 3 are examples of these in a spreadsheet.

Rows

If you want to insert a new row below row 9, where should you be clicked when you insert sheet rows?

On Row 10 (it inserts above)

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)

When button can be pressed to access the Flash Fill option?

White box with down arrow icon (Pink box)

To add a cell reference to another cell, just type equals and then what?

The cell reference - example --> =A5

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

Accounting format

Identify the red box.

Name box

A10:A100 is an example of a:

Cell Range

What feature is used in cell E4?

wrap text

What date format is used in Column A?

Short date

All math - functions and formulas - begin with this

Equals sign =

What is wrong with cell A11? ####

The column is too skinny for the numbers

To multiply, use this arithmetic operator.

Asterisk *

Which box is used to modify the number format to Currency?

Blue box (General drop down, Number group)

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

=COUNT(A3:A7)

To clear the contents of a group of cells, press this keyboard button.

Delete

To divide, use this arithmetic operator.

Slash /

Formula or function? =(B5+B6)*100

Formula (no "name" or word!)

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

Font

Keystroke to return to the top, cell A1

Control+Home

When button can be pressed to access the Column Width dialog box?

Format (green box)

A, B, C are examples of these in a spreadsheet.

Columns

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

Decrease decimal