Excel Module 2 Training

Apply the Accounting number format, using the dollar sign ($) and two decimal places to the cell range B5:B16

1) Select cells in range 2) In the number group under "custom" bar, click the accounting number format ($) button

create a custom cell style names Column Header based on the formatting in cell A3. Add Bold formatting to the new cell style; remove the existing border setting in the style

1) click cell A3 2) click cell styles 3) click new cells style 4) type column header in style name box 5) click format button 6) click bold in font style list 7) click ok 8) click border check to deselect it 9) click ok

use the format painter to apply the formatting from cell B11 to the range B12:B19

1) click cell b11 2) in the clipboard group in ribbon, click the format painter button 3) select B12:B19

insertimageinbackground

1) click page layout tab 2) click background button 3) click from a file 4) click file -> ok

set row 3 as print titles for the worksheet

1) click page layout tab 2) click print titles 3) clock the rows to repeat at top box 4) click row 5) click ok

add the sheet name header element to the center header section and add the text Last Viewed_ followed by the current date header element to the right header section. Click cell A4 to deselect the header when you are finished

1) on status bar on bottom right hand corner, click layout button 2) click the center section of the header placeholder, which contains the text "add header" 3) click header and footer tools DESIGN tab 4) click sheet name button 5) click the right header section 6) type Last Viewed_ in the right header section 7) in the header footer elements group, click the current date button 8) deselect cell

Apply the 03/14/12 Date number format to cell D4.

1) select cell d4 2) in number group on ribbon, click dialog box launcher button (downward right arrow) 3) click date in category, in type list click 03/14/12 --> ok

For range B4:B15, create a New conditional formatting rule that formats the top five values in the range with a Blue, Accent 5 cell background color (9th column, 1st row in the background color palette)

1) select range 2) click conditional formatting --> new rule 3) select rule format only top or bottom ranked values 4) type 5 in value box 5) click format 6) click fill tab 7) click color

enter the conditional formatting rule for range B5:B16 to highlight cells whose values is less than $25,000. Use the same cell formatting as in the original rule.

1) select range 2) click conditional formatting -> manage rules 3) click edit rule 4) in edit formatting rule dialog box, under format only cells with, click the greater than arrow 5) click less than -> ok

highlight cells in the range B4:B15 whose value is less than $50,000 using Yellow Fill with Dark Yellow Text (Font color: RGB 156, 87, 0 & Fill Color: RGB 255, 235, 256)

1) select range 2) click conditional formatting button 3) click highlight cell rules 4) click less than button 5) type 50000 in box 6) click format cells arrow 7) click yellow fill with dark yellow text 8) click ok

apply the currency number format, using the $ symbol and showing two decimal places, to range C4:C15

1) select range 2) click currency in toolbar instead of accounting or dollar sign below

set the print area as range b3:G17

1) select range 2) click page layout tab 3) click print area button -> set print area