Given the following screenshot taken from a workbook in Microsoft Excel.
(a) You want to create space to add column headings for the main data in the range E3:K11. Assume you have already selected Rows 3 and 4. Please click on the command you will use to add the two blank rows.
(b) Click on the command you would use to centre the heading “Grade 10 History assessments” across columns E to K.
(c) Looking at the list of learners, their name details are extending beyond column boundaries: As can be seen on the list in columns B and F, with the names appearing to be truncated in F because of entries in the G column. One method to increase column width would be to start off by selecting a command in the ribbon. Assume you have placed your cursor in the right position, and click on the command in the ribbon to begin the process of increasing the column width.
(d) If You want to sort the list of learner names in column F, click on the tab that will show the command to help you sort the list.
Hot Spot Items
Item 1 Please click on the command you will use to add the two blank rows
Item 2 Click on the command you would use to centre the heading “Grade 10 History assessments” across columns E to K.
Item 3 Click on the command in the ribbon to begin the process of increasing the column width
Item 4 Click on the tab that will show the command to help you sort the list.
Hot Spot Image
1