UsingMicrosoftExcel - Using Microsoft Excel Charles S....

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

View Full Document Right Arrow Icon
Using Microsoft Excel Charles S. Saxon Eastern Michigan University
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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
Background image of page 5

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

View Full DocumentRight Arrow Icon
First Quarter Results Gross is sales – cost Tax is 40% of gross Net is gross – tax =B2-B3 =C4*0.4 =D4-D5
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/12/2009 for the course IS 215 taught by Professor Wu during the Fall '07 term at Eastern Michigan University.

Page1 / 13

UsingMicrosoftExcel - Using Microsoft Excel Charles S....

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online