Microsoft Excel 97/2000/2002/XP

 

1)      Start Excel

a)      Start button, New Office Document, Blank Workbook Icon, OK or

b)      Start button, Programs, Microsoft Excel or

c)      Microsoft Excel icon

2)      Open existing document (Excel, Lotus, QuattroPro, etc.)

a)      Ctrl+O or File menu, Open option or Open icon (2nd icon – yellow folder)

b)      At Look In:, change to the desired drive and/or directory

c)      At Files of Type:, select “All files (*.*)” to display all file types (Excel, Lotus, QuattroPro, etc.)

d)      Select the desired file

e)      Open button or double-click the desired file

3)      Open a new document

a)      Ctrl+N or File menu, New option, Workbook icon, OK, or New icon (1st icon – white paper)

b)      Note:  Templates for Expense Statement, Invoice, and Purchase Order exist under Spreadsheet Solutions tab

4)      Save a document

a)      Ctrl+S or File menu, Save option or Save icon (3rd icon – diskette)

b)      At Look In:, change to the desired drive and/or directory

c)      Provide the desired file name

d)      Save button

5)      Save an existing document with a new file name

a)      F12 or File menu, Save As option

b)      At Look In:, change to the desired drive and/or directory

c)      Provide the desired file name

d)      Save button

6)      Print Preview a document

a)      File menu, Print Preview option or Print Preview icon (5th icon – white paper with magnifiying glass)

7)      Print a document

a)      File menu, Print option, set options, OK or

b)      Ctrl+P, set options or

c)      Print icon (4th icon – printer) sends entire document to printer automatically

8)      Close an open document

a)      File menu, Close option or File menu, Close All option will close all open documents or

b)      Ctrl+F4 or

c)      Ctrl+W or

d)      Excel icon on left of menu bar, Close or

e)      Close icon in second set of icons in top right corner or

f)        Note:  You will be prompted to save any unsaved documents.

9)      Exit Excel

a)      File menu, Exit option or

b)      Alt+F4 or

c)      Excel icon on left end of title bar

d)      Close icon in first set of icons in top right corner

e)      Note:  You will be prompted to save any unsaved open documents.

10)  Selecting a cell

a)      Point and click with mouse on desired cell or

b)      Click in Name Box, type in desired cell address or

c)      Left/Right arrow keys

11)  Selecting multiple cells

a)      Click and drag across multiple cells

b)      Ctrl + click and drag across multiple cells to select additional cells

c)      Shift + click the farthest cell to select in the range

12)  Edit a cell

a)      Double click in the cell or

b)      F2 or

c)      Edit bar containing cell's contents

13)  Shortcut Menu

a)      Right click on the mouse

14)  Change default font

a)      Format menu, Style option , select Modify button

b)      Change size and fact to whatever desired (Times New Roman 12 pt)

15)  Change Margins

a)      File menu, Page Setup option, Margins tab, set desired margins for Left, Right, Top, Bottom

16)  Landscape Orientation

a)      File menu, Page Setup option, Page tab, set orientation to Landscape

17)  Spelling

a)      F7 or Spelling icon (6th icon -- ABC[) or Tools menu, Spelling option

b)      Select the correction or Ignore or Ignore All

18)  Alignment – Left, Right, Center, Full

a)      Align Left icon or Align Right icon or Center icon or

b)      Format menu, Cells option, Alignment tab, select desired alignment(s) or

c)      Shortcut menu, Format Cells option, Alignment tab, select desired alignment(s)

19)  Change Font

a)      Format menu, Cells option, Font tab or Shortcut menu, Format Cells options, Font tab

b)      Select Font Face, Style (Regular, Bold, Italic, Bold Italic), Size, Color, Underline, Double Underline, Strikethrough, Superscript, Subscript

c)      Note:  Formatting toolbar may be used to select the Font Face (Ctrl+Shift+F), Size (Ctrl+Shift+P), and Color

d)      Note:  Keyboard shortcuts

i)        Bold = Ctrl+B

ii)       Underline = Ctrl+U

iii)     Italics = Ctrl+I

20)  Wrap text in a cell

a)      Format menu, Cells option, Alignment tab, select Wrap Text

21)  Shrink text to fit in a cell

a)      Format menu, Cells option, Alignment tab, select Shrink to Fit

22)  Sum function/formula

a)      Select cell where total/sum is to be located

b)      Sum icon (15th icon - 3 )

c)      Automatic range of cells to sum appears

d)      If this is correct, enter or confirm

e)      If this is not correct, select the correct range of cells to sum, enter or confirm

23)  Functions

a)      Function icon (fx) or Insert menu, Functions option, make selections – Office 97/2000

b)      Pull-down arrow on the Sum icon (15th icon - 3), More Functions – Office 2002/XP

24)  Calculate formulas

a)      Calculate all sheets in open workbooks = F9

b)      Calculate the active sheet = Shift + F9

25)  Copying a formula/function to adjacent cells

a)      Select cell to copy

b)      Point to bottom right corner of cell until you see "crosshair" mouse pointer

c)      Click and drag the "fill handle" to adjacent cells

26)  Center a cell's contents across columns

a)      Select columns to center across

b)      Merge and Center icon (ί a ΰ icon)

27)  Autoformat the worksheet body

a)      Select range to format

b)      Format menu, Autoformat option, select table format, OK.

28)  Undo mistakes

a)      Undo Typing icon (11th icon – left pointing arrow) or

b)      Edit menu, Undo Typing option or

c)      Ctrl+Z

29)  Redo mistakes

a)      Redo Typing icon (12th icon – right pointing arrow) or

b)      Edit menu, Repeat Typing option or

c)      Ctrl+Y

30)  Copy selected text

a)      Ctrl+C or Edit menu, Copy option or Copy icon (8th icon – 2 white papers) or Shortcut menu, Copy option

31)  Cut selected text

a)      Ctrl+X or Edit menu, Cut option or Cut icon (7th icon – scissors) or Shortcut menu, Cut option

32)  Paste text

a)      Ctrl+V or Edit menu, Paste option or Past icon (9th icon – clipboard with white paper) or Shortcut menu, Paste option

33)  Moving selected text

a)      Cut text from old location, then Paste text at new location or

34)  Find and Replace text

a)      Edit menu, Find (Ctrl+F) or Replace (Ctrl+H) option

b)      Find tab (finding without replacing), key in text to find or

c)      Replace tab (finding with replacing), key in text to find and text to replace with

35)  Go to

a)      F5 or Ctrl + G or Edit menu, Go To, select Go To What (e.g. Page), and enter the desired selection or

b)      Double-click the Page/Section indicator on the Status bar

36)  Indent a cell

a)      Format menu, Cells option, Alignment tab, set the desired indentation(s) or Increase Indent icon

37)  Unindent a cell

a)      Format menu, Cells option, Alignment tab, set the desired indentation(s) back to 0" or Decrease Indent icon

38)  Switch between/among multiple open documents

a)      Window menu, select the numbered open document

39)  Page Break

a)      Insert menu, Page Break option

40)  Page Numbers

a)      File menu, Page Setup option, Header/Footer tab, select Custom Header/Footer, select Section, select Page Number icon (#)

41)  Insert a tab

a)      Tab = Ctrl + Alt + Tab

42)  Date and/or Time

a)      Function icon (fx) or Insert menu, Functions option, select Date & Time category – Office 97/2000

b)      Pull-down arrow on the Sum icon (15th icon - 3), More Functions, Date & Time category – Office 2002/XP

c)      NOW function provides Date and Time

d)      TODAY function provides Date only

e)      Current Date = Ctrl + ;

f)        Current Time = Ctrl + Shift + :

43)  Switching Views

a)      View menu, Normal or Page Break Preview

44)  Headers and Footers

a)      File menu, Page Setup option, Header and Footer tab, select Custom Header/Footer, select Section, key in the header/footer text

b)      Icons for Page Number, Date, and Time provided

c)      OK button when finished

45)  AutoCorrect options

a)      Tools menu, AutoCorrect option, add/remove corrections as needed

46)  Options

a)      Tools menu, Options option, examine each tab's contents carefully

47)  Macros

a)      Tools menu, Macro option, Record New Macro option, enter the key (e.g. R) to be combined with Ctrl+, OK buttion, any action performed at this point will be recorded as part of the macro -- when finished recording, press the stop record  button on the Macro toolbar or Tools menu, Macro option, Stop Recording option

b)      To execute the macro, press the key combination (e.g. Ctrl+R) or Alt+F8 or Tools menu, Macro option, Macros option, select the name of the macro, Run button

48)  View Toolbars

a)      View menu, Toolbars option, select desired toolbar

b)      Toolbars may be moved by clicking 'n dragging the unused gray space on the toolbar

49)  Draw a horizontal/vertical line

a)      Drawing Toolbar select the slanted line icon, click 'n drag the mouse pointer to draw a horizontal/vertical line

b)      Drawing Toolbar may also be used to draw other shapes

50)  Sort cells/rows

a)      Select area to be sorted

b)      Sort Ascending icon (AZ9), or Data menu, Sort option, respond to dialog box when prompted

51)  Filter

a)      Data menu, Filter option, AutoFilter

52)  Subtotal

a)      Data menu, Subtotal option, respond to dialog box when prompted

53)  Hyperlink

a)      Ctrl+K or Insert menu, Hyperlink option, type http://www.abac.edu as the URL or Insert Hyperlink icon (13th icon - globe with circular link) -- clicking on this link will load the address in Netscape

 

Order of Mathematical Operations

(**Please Excuse My Dear Aunt Sally**)

Parenthesis ()

Exponents ^

Multiplication *

Division /

Addition +

Subtraction -

 

Absolute (e.g., A1) vs. Relative Address Referencing (e.g., $A$1) vs. Mixed Referece (e.g., $A1, A$1)