microsoft office excel 2007: basic course 01 - getting started · slide 1 t getting started course...

Microsoft Office Excel 2007: Basic

Course 01 - Getting Started

Cours

e I

LT

Getting started

Course objectives

Identify spreadsheet components

Identify the main components of

Excel

Use the Help feature

Open and navigate workbooks

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Topic A

Topic A: Spreadsheet terminology

Topic B: Exploring the Excel window

Topic C: Getting help

Topic D: Navigating workbooks

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Label

Spreadsheet components

Row

Column ValueActive cell

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Topic B





_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Excel window components

Title bar

Quick Access

toolbar

Ribbon

tabs

Formula bar

Worksheet

Status bar

Ribbon

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

The Cells Styles gallery

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Tabs, groups, and Live Preview

A Ribbon groupThe active tab

Pointing to a font in

the list…

…shows you what your

text will look like.

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Topic C





_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

An Excel Help topic

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

Topic D





_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e ILT

The Open dialog box

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Cours

e I

LT

Course summary

Learned about spreadsheet

components

Identified the main components of the

Excel window

Learned how to access and use Help

Learned how to open and navigate

workbooks

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

_____________________________________________________________________________________

Review Questions:

1. True or False: A workbook consists of rows and columns that intersect to form cells that contain

various kinds of data.

A. True

B. False

2. By default, each workbook contains which of the following?

A. 5 worksheets

B. 1 worksheet

C. 3 worksheets

D. 10 worksheets

3. A bar displays the contents, such as values, formulas, or labels, of the active cell.

A. Ribbon

B. Status

C. Formula

D. Title

4. True or False: An active cell is where the data you enter will appear.

A. True

B. False

5. Pressing tab will:

A. Move one row down

B. Move one row up

C. Move one column to the right

D. Move one column to the left

6. What key combination would you use to get to the last row and last column of data in your

worksheet?

A. Press Ctrl+End

B. Press Alt+End

C. Press Shift+End

D. Press Ctrl+G

7. What key combination would you use to return to cell A1?

A. Press Ctrl+Home

B. Press Alt+Home

C. Press Shift+Home

D. Press Ctrl+G

8. True or False: The only way to navigate to a specific cell that is at the far end of the current

worksheet is by choosing Find & Select, Go To and enter the cell’s location.

A. True

B. False

9. What group in the Home tab do you navigate to for “Find & Select”?

A. Cells

B. Editing

C. Formatting

D. Links

10. The bar is the main location for menus and tools. A. Ribbon

B. Status

C. Formula

D. Title

Answer Key:

1. B

False. A worksheet consists of rows and columns that intersect to form cells that contain various

kinds of data. A workbook consists of multiple worksheets.

2. C

By default, each workbook contains three worksheets.

3. C

A Formula bar displays the contents of the active cell. You use the Formula bar when you want to

make changes in the active cell.

4. A

True. The active cell is the cell you have selected. Data you enter will appear in that cell.

5. C

Pressing tab will move the active cell one column to the right. Shift+tab will move the active cell one

column to the left.

6. A

By pressing the control key and the end key together, you will navigate to the last row and last

column of data in your worksheet.

7. A

By pressing control and home together, you will return to A1.

8. B

False. You can also navigate to a specific cell by pressing Control and G together to open the dialog

box.

9. B

Find & Select can be found in the Home tab in the Editing group.

10. A The Ribbon bar is the main location for menus and tools. Each tab on the Ribbon contains groups, which in turn have buttons or commands.

microsoft office excel 2007: basic course 01 - getting started · slide 1 t getting started course...

Documents