Formative Assessment 13 US 116937

• Open the workbook Bathini Expense Form
• If necessary, adjust the Zoom control so that you can see all the data
• Select column A and column N
• From the Format menu, select Column then Width and set it to 1
• Resize rows 1, 8, and 26 to 10
• Change the height of row 7 to 27 and change the vertical alignment to Top
• Draw a dark blue border around B8:N26
• Draw a thin dashed line border on the bottom of cells D10:M10
• Select D22:D25 and change the colour to pale orange and 25% Gray pattern with Pale Yellow colouring
• Click OK
• Click in cell M24 then change the colour and pattern as follows: Select the Indigo colour chip. Click the arrow on the Pattern box and select the 50% Gray pattern with Pale Blue colouring
• Select the Black colour chip and a thick line weight then click the Outline button
• Click OK
• Change the Font Colour of M24 to White and apply Bold
• Save and close the workbook

send in your work

Open your Practice workbook and go to your budget

• Improve the presentation – add borders, shading, change number format, font styles and so on
• Save and the Practice workbook

send in your work