Chapter 8 Quiz
You are giving a presentation of your sales for the year across all regions and by all months. Why are you considering using outlining? -Outlining Provides an "outline" of only the data you want to display by removing the ribbon. -Outlining lets you add borders to the cells you want to highlight by a simple one-click operation -Outlining allows you to work within hidden cells, such as updating the latest sales figures for the month -Outlining can collapse the spreadsheet into, for example, only quarterly totals to make the spreadsheet easier to read
Outlining can collapse the spreadsheet into, for example, only quarterly totals to make the spreadsheet easier to read
If you want to have a vertical split, where will you place your cursor before selecting Split on the View tab of the ribbon? -on the active cell in the left column where you want the split to start -on an active cell anywhere in the column where you want the split to start -on the active cell in the first row where you want the split to start -on the active cell in the right column where you want the split to start
on the active cell in the first row where you want the split to start
You want to keep columns A and B visible while you scroll through your other worksheet data. How will you do this? -Position the active cell as B1, to to Freeze Panes on the View tab of the ribbon, and then select Freeze Top Row -Position the active cell as C1, go to Freeze Panes on the View tab of the ribbon, and then select Freeze First Column -Position the active cell as B1, go to the Freeze Panes on the View tab of the ribbon, and then select Freeze Panes -Position the active cell as C1, go to Freeze Panes on the View tab of the ribbon and then select Freeze Panes
Position the active cell as C1, go to Freeze Panes on the View tab of the ribbon and then select Freeze Panes
Jake has a worksheet with many columns of data. He wants to see different parts of a list at the same time. Which action would be best for him to take? -Split Horizontally -Scroll through the list -Split Vertically and Horizontally -Split Vertically
Split Vertically