§
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. =C4 is Relative =$C$4 is Absolute. =$C4 and =C$4 are Mixed. The
variable following the dollar sign does not change when the formula is copied.
o
Writing complex formulas involving more than one
calculation.
o
Writing formulas that refer to cells in other
worksheets. Example =sheet2!C4
o
Write a formula to find percents, =Part/Total. In the
Sales Forecast and payroll assignments we divided by an absolute cell
reference.
§
Advanced
Tasks
o
Using the AutoSum function.
o
Understanding ranges and range notation. Example F1:G4
o
Using the IF function. The format is an equation then
a choice of 2 options to display in the cell, =IF(C4<50,25,100)
o
Using the VLOOKUP function. The format is a cell
reference, then a range reference and then a number. =VLOOKUP(C4,A8:E12,3)
o
Sorting a data table. A-Z icon or Data menu.
o
Creating (and showing) a comment. Insert Menu.
o
Creating Data Validation lists.
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, Change colors, background, and font,
Edit title, etc.