Excel

IF YOU WANT TO LEARN

MICROSOFT EXCEL…

…YOU BETTER KNOW THESE WORDS

WORKBOOK

•THE ENTIRE EXCEL SPREADSHEET FILE YOU
ARE WORKING IN, IT CAN CONTAIN ONE
OR MORE WORKSHEETS (THINK OF IT AS A
BOOK MADE UP OF MANY SHEETS OF
PAPER)

© Daniel Goldman, 2016

2

WORKSHEET

•A PART/PAGE ON AN EXCEL SPREADSHEET
FILE YOU ARE WORKING IN, (THINK HOW
MANY SHEETS MAKE UP A BOOK)

© Daniel Goldman, 2016

3

CELL

•THE RECTANGULAR FIELDS YOU CAN TYPE
IN ON A SPREADSHEET FORMED WHEN A
COLUMN INTERSECTS WITH A ROW

© Daniel Goldman, 2016

4

This is one cell

CELL LOCATION

•REFERRING TO A RECTANGLE ON A
SPREADSHEET BY NAMING THE COLUMN
AND THEN ROW IN WHICH IT LIES, LIKE IN
THE GAME BATTLESHIP. CELL “A1”

© Daniel Goldman, 2016

5

Cell “A1”

CELL REFERENCE

•REFERS TO A CELL OR A RANGE OF CELLS ON A
WORKSHEET AND CAN BE USED IN A FORMULA
SO THAT EXCEL CAN FIND THE VALUES OR DATA
THAT YOU WANT THAT FORMULA TO
CALCULATE

© Daniel Goldman, 2016

6

Multiple Choice

The selected cell in which data is entered when you begin typing.

• Right Cell

• Active Cell

• Next Cell

Multiple Choice

What is the Active Cell?

• The cell that exercises

• The cell marked in red

• The cell marked with a black X

• The cell where you enter data

Multiple Choice

The file used to store worksheets is called the _________.

• Hard Drive

• Flash Drive

• Workbook

• Sheet Protector

Multiple Choice

What are worksheets______________?

• The pages in your math workbook

• The pages in your student handbook

• The pages of a workbook

• The handouts I give you to work from

Multiple Choice

The intersection of a column and row is called a _____?

• Stop Sign

• Active Cell

• Cell Tables

• Cell

ROW

•THE HORIZONTAL, SIDE-TO-SIDE PARTS OF
A SPREADSHEET DENOTED BY NUMBERS

© Daniel Goldman, 2016

7

COLUMN

•THE VERTICAL, UP/DOWN PARTS OF A
SPREADSHEET DENOTED BY CAPITAL LETTERS

© Daniel Goldman, 2016

8

GRIDLINES

•LIGHT GRAY LINES THAT DIVIDE EACH OF
THE CELLS, ROWS, AND COLUMNS IN A
SPREADSHEET

© Daniel Goldman, 2016

9

MARGIN

•THE EDGE OR BORDER OF SOMETHING.

© Daniel Goldman, 2016

10

PAINTER

•A TOOL THAT ALLOWS YOU TO COPY
ANIMATIONS OR FORMATTING EASILY
FROM ONE OBJECT TO ANOTHER

© Daniel Goldman, 2016

11

QUICK ACCESS TOOLBAR

•AT THE VERY TOP OF THE WINDOW, THIS
TOOLBAR CONTAINS COMMONLY USED ACTION
BUTTONS LIKE QUICK PRINT, SAVE AND UNDO
AND CAN BE CUSTOMIZED BY THE USER TO
INCLUDE MORE BUTTONS

© Daniel Goldman, 2016

12

RIBBON

•THE HORIZONTAL SPACE AT THE TOP OF THE
WINDOW THAT ORGANIZES COMMANDS IN
TABS, AND THEN GROUPS THE COMMANDS
BY TOPIC. IT’S WHERE ALL OF YOUR TABS
AND MENUS ARE.

© Daniel Goldman, 2016

13

FUNCTION

•A FORMULA OR EQUATION USE TO
GENERATE AN ANSWER

© Daniel Goldman, 2016

14

AUTOFILL

•A TOOL WHICH FILLS IN A FIELD OR CELLS
AUTOMATICALLY

© Daniel Goldman, 2016

15

SPARKLINE

•A SMALL GRAPHIC DESIGNED TO GIVE A
QUICK REPRESENTATION OF NUMERICAL
OR STATISTICAL INFORMATION TAKING THE
FORM OF A GRAPH WITHOUT AXES.

© Daniel Goldman, 2016

16

AUTOSUM

•AUTOMATICALLY ADDS UP VALUES IN A
ROW OR COLUMN

© Daniel Goldman, 2016

17

SORT

•TO PUT IN ORDER

© Daniel Goldman, 2016

18

FILTER

•TO REMOVE UNWANTED PIECES OF DATA
FROM VIEW IN A TABLE

© Daniel Goldman, 2016

19

PORTRAIT ORIENTATION

•VERTICAL, UP/DOWN POSITIONING OF A
SHEET

© Daniel Goldman, 2016

20

LANDSCAPE ORIENTATION

•HORIZONTAL, SIDE-TO-SIDE POSITIONING
OF A SHEET

© Daniel Goldman, 2016

21

ABSOLUTE REFERENCE

•A SPREADSHEET CELL THAT DOES NOT
CHANGE REGARDLESS OF ITS ATTRIBUTES.

© Daniel Goldman, 2016

22

RELATIVE REFERENCE

•A SPREADSHEET CELL THAT DOES CHANGE
DEPENDING ON WHAT CHANGES WERE
MADE TO THE SPREADSHEET IT IS LOCATED
ON

© Daniel Goldman, 2016

23