Formative Assessment 14 US 116937

• Select column A and then select the Format, Cells menu. Click the alignment tab. Select the Centre option and click OK. See how your cell contents are arranged in the centre of the cells. Now select the Right option and click OK. The contents of the cells will be aligned to the right. While your column is still selected, click the Left option and OK. The contents of the cell will be aligned to the left.
• Select Column A and click the left align button on the formatting toolbar. See how the text automatically aligns to the left. Now click the centre button and the right align button to see the text centre and then align to the right.
• In cell A7 type My Journal. Select cells A7 to D7 and click on the Merge and Centre button of the formatting toolbar. See how the text is centred in the row.
• In cell A9 type My Year 2000 Journal. Select cells A9 to E9 and click on format, cells. Click on the alignment tab and then select Centre across selection. The text will be centred in the row.
• Select cells A3 to D3, choose the Edit menu and select the delete command in the dialogue box. Choose the shift cells up option and click OK. Watch how the cells shift up. Now select cells A1 to D1 and press the delete key on the keyboard.
• Your last two actions were to delete the entire row 1 and to delete row 3. Click the Undo command on the toolbar and watch Excel undo the very last action. Click on the arrow box next to the Undo button to see a list of your last actions that can still be undone. Click on clear and Excel will undo the clear action.
• Click on the Redo button once and row 1 will be cleared again. Click on the arrow next to the Redo button to see a list of actions you can redo. Click on the first one, delete and Excel will delete row 3 again.
• Undo the last two actions again.
• Click in cell A3 and type 1250. Notice how the old numbers are replaced by the new numbers.
• In cell A1 type 158, then press the backspace key once and type a 9. The figure now reads 159.
• Double click cell B1 now. Use the arrows to move back in the cell and then delete the s of Mrs, so that the name now reads Mr B. Otto.

send in your work