§
Formatting
o
Alignment of cell contents (right, center, left)
o
Using the cell formatting dialog box.
o
Formatting cells (percent, currency, decimal places, font, text wrap,
fill, etc.)
o
Using the Merge and Center icon
o
Adding background color to cells, columns, and rows.
o
Adding borders to cells
o
Increasing or decreasing decimal places
o
The difference between Currency and Accounting formats
o
Renaming and adding colors to worksheet tabs.
§
Formulas
(Hint: page 47 in the textbook has sample formulas. You can
bring a copy to the exam.)
o
Copying and pasting formulas
o
Using Relative, Mixed and Absolute cell references in formulas. You need
to know which is which.
o
Writing complex formulas involving more than one calculation.
o
Writing formulas that refer to cells in other worksheets.
o
Write a formula to find percents. Hint: Divide by an absolute cell
reference.
§
Advanced Tasks
o
Using the AutoSum function
o
Using the IF function
o
Using the VLookUP function.
o
Sorting a data table
o
Creating (and showing) a comment.
Charts and Graphs:
§
Selecting labels and data in multiple rows or columns.
o
Select a row or column, then press the Ctrl key to select more
rows/columns.
o
Remember, data and labels can be in columns or rows. The homework used
rows. The test may ask you to accent columns.
o
Remember to include both labels and data.
o
Remember that the rows or columns that you select must all contain the
same number of cells.
§
Building a chart using the Chart Wizard
§
Changing appearance
o
Move legend
o
Change colors. background, font, etc
o
Edit title
Chart Hint:
Using the Chart Data file, could you create a bar chart showing the
total revenue for each of the five types of beverage? You need to accentuate
data in two columns before building the chart. Could you build a pie chart?