Lesson on Excel

Question 1

What is an “What if Analysis”

Answer 1

lets you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values

Question 2

Where is the ribbon located on Excel?

Answer 2

On the top

Question 3

What group exists only on Excel and not Word?

Answer 3

Numbers Group

Question 4

What does the Namebox show?

Answer 4

The Current Cell

Question 5

By default you start with one Sheet, you click the ___ to add more

Answer 5

the + button

Question 6

What is another name for a Spreadsheet?

Answer 6

Worksheet

Question 7

What is a Chartsheet

Answer 7

a chartsheet is a worksheet that only contains a chart.

Question 8

What is a workbook?

Answer 8

A collection of worksheets/spreadsheets.

Question 9

How can you tell which is the active sheet?

Answer 9

The one that is highlighted and shown in the number box

Question 10

What does Ctrl + Home do in Excel?

Answer 10

Brings you to Cell A1

Question 11

What does Ctrl + End do in Excel?

Answer 11

Brings you to last cell in worksheet containing data

Question 12

What does Shift + Enter in Excel

Answer 12

Goes up a row

Question 13

What does Tab do?

Answer 13

Goes a column to the right

Question 14

What does Shift + Tab do?

Answer 14

Goes a column to the left

Question 15

What does Page Up/Down do?

Answer 15

Up or Down One Screen

Question 16

What does Ctrl + Page Up/Down do?

Answer 16

Moves the active cell to the previous or next sheet in the workbook

Question 17

What does Enter on Excel?

Answer 17

Moves the active cell down one row or to the start of the next row of data

Question 18

What does Home do?

Answer 18

To column A of the current row?

Question 19

What does Alt + Enter do?

Answer 19

Allows you enter another line within same cell

Question 20

How do you re-fit row or column of cells?

Answer 20

To fit the cell, expand the cell then double click in between the column/row headings

Question 21

What are three types of data in Excel?

Answer 21

Text Data, Number Data, Date and Time Data

Question 22

What is Text Data?

Answer 22

1. A text string

2. A combination of alphanumeric characters of words and string

Question 23

A group of cells is called a

Answer 23

cell range

Question 24

An adjacent range is a

Answer 24

single rectangular block of cells

Question 25

A non-adjacent range consists of

Answer 25

2+ distinct adjacent ranges

Question 26

A range reference indicates the

Answer 26

location and size of a cell range (ie. F3:I5;J4:J5)

Question 27

An adjacent block is highlighted using ____ and the non-adjacent nearby can be added with ____.

Answer 27

Shift, Ctrl

Question 28

____ is an expression that returns a value

Answer 28

Formula

Question 29

Use F2 to enter ____

Answer 29

Edit Mode

Question 30

____ are used to simply formulas

Answer 30

Functions

Question 31

You can reverse things by clicking the ___

Answer 31

undo button

Question 32

Ctrl + ` goes to

Answer 32

Formula View

Question 33

What is a benefit of a properly formatted workbook?

Answer 33

Easier to read

Question 34

The default theme of Excel is ____.

Answer 34

Office Theme

Question 35

Live preview allows you to: ___________

Answer 35

Live preview allows you to preview changes to your document before you commit to finalizing those changes. Live Preview comes into effect when, for example, you highlight text and open the font drop-down menu.

Question 36

Why is (32) more preferred than -32, at least for accountants?

Answer 36

When going down with a pencil, it is harder to turn -'s into +'s with brackets.

Question 37

To format a cell, first do what?

Answer 37

Select

Question 38

Dates and times in Excel appear as _____:

Answer 38

Text

Question 39

T/F: Combining different cells is called aligning?

Answer 39

False it is merging

Question 40

T/F: Text is oriented from left to right horizontally by default?

Answer 40

True

Question 41

T/F: A style is a collection of formatting?

Answer 41

True

Question 42

T/F: Excel has built-in styles?

Answer 42

True

Question 43

What is the difference between a serif font and a sans serif?

Answer 43

A Serif Font has Serifs (Edges)

Question 44

What is the general number format?

Answer 44

The default number format

Question 45

Why are dates right aligned within a worksheet by default?

Answer 45

Excel store dates and times as Numeric Values.

Question 46

The range A1:C5 is merged into a single cell, what is it’s reference?

Answer 46

A1

Question 47

Where can you access all of the stored font options for cells?

Answer 47

Cells > Format Cells > Font

Question 48

T/F: A relative ref is a cell ref that changes when it is copy and pasted in a new location?

Answer 48

True

Question 49

T/F: Functions are organized in the function library list?

Answer 49

True

Question 50

__ allows you to change things into absolute with the $ signs.

Answer 50

F4