{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

UsingMicrosoftExcel

# UsingMicrosoftExcel - Using Microsoft Excel Charles S Saxon...

This preview shows pages 1–7. Sign up to view the full content.

Using Microsoft Excel Charles S. Saxon Eastern Michigan University

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Spreadsheet Cells A spreadsheet is a two-dimensional array of cells Cells can contain data or formulas There are two cell reference styles: A1 R1C1 In the A1 style rows are specified by numbers and columns are specified by letters
Excel Spreadsheet Cell data is either a number or a string A formula begins with an equal sign (=) A formula can contain operators and operands Sheet name Cell named A1 or R1C1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Formulas Formulas can contain: constants, cell references, parentheses ( ), arithmetic operators [ + - * / ], functions Example: =7*SUM(A1:A2) Data in cell A1 12 Formula in cell A3 =A1+A2 Formula bar
Multiple Sheets Use an exclamation point (!) to separate the sheet name from the cell name when referring to cells on other sheets Example: =Sheet1 ! A1 / 5 Sheet1 ! A3 Sheet2 ! A3 The sum of values from Sheet1 and Sheet2

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
First Quarter Results Gross is sales – cost Tax is 40% of gross Net is gross – tax =B2-B3 =C4*0.4 =D4-D5
This is the end of the preview. Sign up to access the rest of the document.
• Fall '07
• Wu
• Eastern Michigan University, Charles S. Saxon Eastern Michigan University, A1 style rows, cell reference styles, Press Paste

{[ snackBarMessage ]}

### Page1 / 13

UsingMicrosoftExcel - Using Microsoft Excel Charles S Saxon...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online