Excel Test Review:

1.                  Put the title of page on the center of a row. ( Merge and Center)

2.                  Make a column title into two layers. For example, Final on the top of Exam and both words are in the same cell.

3.         Bold and center and right justified for any cell

3.                  Currency formatted, ex $5.25 or $100, number of decimal places.

4.                  Choose your own Color (Background and font)

5.                  Calculations. (sum, average, %, +, -, *, /, if)

            Use F4 to fix an address before you drag it down or across.

6.                  Pie chart (How to highlight disconnected area? Ctrl + click)

7.                  Bar  chart .

8.         Goal Seek Tool.

            If data is changed, what will be changed for the result?
If result is changed, what should data be changed?

9.        Show date & time stamp (=now())

10.      Show formula on sheet.

11.      Sort Data.

12.      If statement.