Microsoft Office Tutorials and References
In Depth Information
Verifying Formulas Using Range Finder
5. Total line
a. Cell style — Total
b. Numbers — accounting number format
6. Highest, lowest, and average rows
a. Font style of row titles in range A14:A16 — bold
b. Numbers — currency style with oating dollar sign, comma style for Hours
Worked
7. Percentages in column H
a. Numbers — percentage style with two decimal places
8. Column widths
a. Columns A and B — best t
b. Columns E, F, and I — 10.50 characters
c. Column G — 10.25 characters
d. Column C, D, and H — 7.50 characters
9. Row heights
a. Row 3 — 48.00 points
b. Row 14 — 27.00 points
c. Remaining rows — default
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
To Change the Workbook Theme
Why? The Basis theme includes fonts and colors that provide the worksheet with a professional and subtly colored
appearance. The following steps change the workbook theme to the Basis theme.
1
Display the PAGE
LAYOUT tab.
Tap or click the
Themes button
(PAGE LAYOUT
tab | Themes
group) to display
the Themes gallery
(Figure 2 – 28).
PAGE LAYOUT tab
Themes button
Experiment
Point to several
themes in the
Themes gallery to
see a live preview of
the themes.
Themes gallery
Basis
theme
Why should I change
the theme of a
workbook?
A company or
department may
standardize with
a specic theme so that all of their documents have a similar appearance. Similarly, an individual may want to
have a theme that sets his or her work apart from the work of others. Other office programs, such as Word and
PowerPoint, include the same themes included with Excel, meaning that all of your Microsoft office documents can
share a common theme.
Figure 2 – 28
 
Search JabSto ::




Custom Search