1 / 35

Microsoft Excel 2010 - PowerPoint PPT Presentation

Microsoft Excel 2010. EXCEL NOTES Part I. Basic Vocabulary. Active cell Active worksheet Adjacent range Cell Cell reference Column Formula Formula bar Landscape orientation Name Box. Nonadjacent range Portrait orientation Range Range reference Row Sheet tab Spreadsheet

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Microsoft Excel 2010

EXCEL NOTESPart I

• Active cell

• Active worksheet

• Cell

• Cell reference

• Column

• Formula

• Formula bar

• Landscape orientation

• Name Box

• Portrait orientation

• Range

• Range reference

• Row

• Sheet tab

• Workbook

• Worksheet

• A spreadsheet is a grid of rows and columns containing numbers, text and formulas.

The main purpose of a spreadsheet is to solve problems involving numbers.

Budgets

Statistics

Income Tax

Investments

2)To determine payments to be made on a loan

4)To keep track of work hours and pay

The ability to complete complex and repetitious calculations accurately, quickly, and easily

• A worksheet refers to a computerized spreadsheet.

Worksheet 1

Worksheet 2,

and Worksheet 3

A cell is the intersection of a row and column.

The cell is identified by acell reference(the column letter and row number).

B

C

D

1

2

3

4

C4

5

For example, the cell reference C4:

B

C

D

1

2

3

The active cell is the cell ready for data entry. It is surrounded by a darkborder.

The name box shows the cell reference

B

C

D

1

2

B2

C2

3

B3

C3

4

• A range of cells is a selected group of cells in which all cells touch each other and form a rectangle.

The rangeis identified by the cell in the upper left corner and cell in the lower right corner, separated by a colon.

B

C

D

1

2

B2

C2

3

B3

C3

4

The range shown above is identified byB2:C3

B

C

D

1

2

3

4

Is this a range?Why or why not?

B

C

D

1

2

3

4

Is this a range?Why or why not?

B

C

D

1

2

3

4

How would you identify this range?

B

C

D

A2:C2

1

2

A2

C2

3

4

B

C

D

1

2

3

4

Is this a range?Why or why not?

B

C

D

1

2

3

4

How would you identify this range?

B

C

D

1

2

A2

3

4

C4

A2:C4

B

C

D

1

2

3

4

Is this a range?Why or why not?

B

C

D

1

2

3

4

How would you identify this range?

B

C

D

1

2

B2

3

4

B2:B2

• Active cell

• Active worksheet

• Cell

• Cell reference

• Column

• Formula

• Formula bar

• Landscape orientation

• Name Box

• Portrait orientation

• Range

• Range reference

• Row

• Sheet tab