Creating Spreadsheets and Charts in Microsoft Office Excel 2007 for Windows: Visual QuickProject Guide

index

= (equal sign), formulas, 45

A

Above Chart command, 90

Accounting Number Format button, 71

active cells, 5

addresses, budget worksheets, 25

alignment, formatting worksheets, 75, 84

Alignment group

Center button, 75

Increase Indent button, 76

Auto Fill Options button, 40

AutoComplete feature, 44

AutoFit feature, 73

AutoSum button, 35

B

Bold shortcut keys, 84

borders, formatting worksheets, 77–78, 84

Browse Folders button, 21

budget worksheets, 23

calculations

differences, 33, 45

net income, 37

percent differences, 34, 45

cells

activating, 27, 44

fill handles, 40–42, 46

columns

entering headings, 29

making wider, 30, 44

entering information, 26

formulas

Copy and Paste commands, 39, 45

copying, 38

naming, 24, 44

references, 25

rows

AutoComplete ...