Bcis:microsoft Excel

Front 1

You need a new workbook. How do you create one?

Back 1

Click the office button and select new blank workbook

Front 2

T or F: The name box shows you the contents of the active cell

Back 2

False

Front 3

T or F: In a new worksheet, you must start by typing in cell A1

Back 3

False

Front 4

T or F: There are three (3) worksheet with every new workbook

Back 4

True

Front 5

What is an Excel file called?

Back 5

Workbook

Front 6

Why is it a good idea to rename sheet tabs?

Back 6

Easy to reconize

Front 7

Column headings are indicated by ______; row headings are indicated by ________.

Back 7

1. Letters
2. Numbers

Front 8

Define a cell

Back 8

Interstion of a row and coloum

Front 9

Define cell reference

Back 9

Column letter and row number that indifices a indivual cell

Front 10

Define name box

Back 10

Indentifes the active cell

Front 11

Describe the active cell

Back 11

Dark outline = letter orange

Front 12

2 Ex, when you might use different sheets in workbook

Back 12

1. Basketball plays
2. Christmas shoping

Front 13

What does ###### mean?

Back 13

To small and norrow

Front 14

3 Ex to use Excel

Back 14

1. Plays, Grade book, treashrey for the church

Front 15

Why is it a good idea to enter titles at the top of each column?

Back 15

Easy to understand your Data

Front 16

Excel aligns text to the ________, dates and values to the ________.

Back 16

1. Left
2. Right

Front 17

What happends to a fraction entered without a whole number?

Back 17

Change to a date

Front 18

How does Excel interpret a number enclosed in parentheses?

Back 18

As a negitave

Front 19

How does AutoComplete save time?

Back 19

Fills in your cell

Front 20

What does it mean when some of the commands on the ribbon are grey?

Back 20

Edit Mode

Front 21

Is formatting applied to the data or the cell?

Back 21

The cell

Front 22

New columns enter to the _____ of the active cell; new rows enter ___ the active cell

Back 22

1. Left
2. Above

Front 23

What do you type to start a formula?

Back 23

Equal sign

Front 24

What is a function?

Back 24

Pro button formula

Front 25

How can you see the formula in a cell?

Back 25

Formula Bar

Front 26

How does Excel evaluate an expression?

Back 26

Premdas (Order of operation)

Front 27

What does the SUM function do?

Back 27

Add all functions in a range

Front 28

Define argument

Back 28

Value that is used by the function

Front 29

What is the benefit of using cell referneces in formulas instead of values?

Back 29

Change value that reference fomula will update

Front 30

Which punctuation indicates a range?

Back 30

Column

Front 31

What allows you to easli copy formulas?

Back 31

Fill handle

Front 32

What is an absolute cell reference?

Back 32

Fix recerence (does not change)

Front 33

Explain the differnece between relative and absolute cell reference?

Back 33

1. Relative = Change
2. Absolute = Not change

Front 34

2 ways to enter cell references into formulas

Back 34

1. Type
2. Click (more reliable)

Front 35

What is the keyboard shortcut to display formulas?

Back 35

CTRL +' (Grave') [T]

Front 36

What does the AVERAGE function do?

Back 36

Mean value in a range

Front 37

What does the MIN function do?

Back 37

Lowest value in a rang

Front 38

What does the MAX function do?

Back 38

Greatest value in a range

Front 39

What is the difference between a formula and a function?

Back 39

1. Formula =-Figure out myself
2. Function = pre written (computer got it)

Front 40

What is PEMDAS?

Back 40

Oder of Operations
P = ()
E = 2
M =*
D = /
A =+
S = -