Using the shown Microsoft Excel screenshot, respond to the following questions by clicking on the appropriate command.
HINT! This question has five parts, therefore, has six (6) Hop spot items corresponding to six places on the image. The hot spot item with a Green box will correspond to the place you pick on the image. Clicking on the correct spot automatically adds a mark.
Hot Spot Items
Item 1 Assume you want to combine Cells A1:C1, click the command you would use to combine these cells after highlighting them
Item 2 You want to have all the numbers on the range G5:K12 to have one decimal place. Click the command to do this
Item 3 The entries on the range B5:B12 are crossing over to column 'C'. You decide to increase the width of column 'B' by dragging. Click where you would start dragging
Item 4 You want to highlight all of row 2 right up to the end of the worksheet. where would you click?
Item 5 Assume you have now highlighted Row 2, you want to then add a blank row between row 1 and 2, click the command to help you do that
Item 6 You have highlighted the learner names to sort them. Click on the tab to show the ribbon with the sort command?
Item 7 If you were to represent the learners’ marks of all four assessments on a chart which tab on the ribbon will you need to click first to begin the process of building the chart?
Hot Spot Image
16
The Hot Spot items on the image are as follows:
Item 1 - Merge & Center Command
Item 2 - Decrease Decimal Command
Item 3 - Column B Header
Item 4 - Row 2 Header
Item 5 - Insert Command
Item 6 - Data tab
Item 7 - Insert tab