Microsoft excel 2010
Download
1 / 35

Microsoft Excel 2010 - PowerPoint PPT Presentation


  • 71 Views
  • Uploaded on

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

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

PowerPoint Slideshow about 'Microsoft Excel 2010' - sadie


An Image/Link below is provided (as is) to download presentation

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

Excel notes part i
EXCEL NOTESPart I


Basic vocabulary
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

  • 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
The main purpose of a spreadsheet is to solve problems involving numbers.


Examples
Examples:

Budgets

Statistics

Income Tax

Investments


Possible uses for spreadsheets
POSSIBLE USES FOR SPREADSHEETS


1)To prepare budgets

2)To determine payments to be made on a loan

3)To calculate grades

4)To keep track of work hours and pay


The primary advantage of using a spreadsheet
THE PRIMARY ADVANTAGE OF USING A SPREADSHEET

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


  • A worksheet refers to a computerized spreadsheet.


A collection of related worksheets is called a workbook
A collection of related worksheets is called a workbook.

Worksheet 1

Worksheet 2,

and Worksheet 3


A cell is the intersection of a row and column.


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


For example the cell reference c4

A

B

C

D

1

2

3

4

C4

5

For example, the cell reference C4:


The active cell is the cell ready for data entry it is surrounded by a dark border

A

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


A

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.


The range shown above is identified by b2 c3

A

B

C

D

1

2

B2

C2

3

B3

C3

4

The range shown above is identified byB2:C3


Is this a range why or why not

A

B

C

D

1

2

3

4

Is this a range?Why or why not?


Is this a range why or why not1

A

B

C

D

1

2

3

4

Is this a range?Why or why not?


How would you identify this range

A

B

C

D

1

2

3

4

How would you identify this range?


A2 c2

A

B

C

D

A2:C2

1

2

A2

C2

3

4


Is this a range why or why not2

A

B

C

D

1

2

3

4

Is this a range?Why or why not?


How would you identify this range1

A

B

C

D

1

2

3

4

How would you identify this range?


A2 c4

A

B

C

D

1

2

A2

3

4

C4

A2:C4


Is this a range why or why not3

A

B

C

D

1

2

3

4

Is this a range?Why or why not?


How would you identify this range2

A

B

C

D

1

2

3

4

How would you identify this range?


B2 b2

A

B

C

D

1

2

B2

3

4

B2:B2


Basic vocabulary1
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

  • Workbook

  • Worksheet


Write your name on the top line of the index card.Answer this question:What are the two requirements for a group of cells to be called a range?1.______________________2.______________________


ad