CTS Quiz 7

Nisha wants to set rows 1 and 2 so that they remain visible as she scrolls through the worksheet. After clicking in row 3, which option should she select on the View tab?

Freeze Panes

Boris is displaying two instances of the same workbook and wants to remove one. Which button should he click on the View tab?

Hide

A _____ is a specially formatted word, phrase, or graphic that, when clicked, displays a webpage.

Hyperlink

In one workbook, Tim wants to include a link to another workbook. Which of the following dialog boxes should he use to add the link?

Insert Hyperlink dialog box

Cedric wants to print one page of worksheet data on two pages. Which of the following can he do?

Insert a page break.

Amelia wants to insert a hyperlink to an e-mail address. Which part of the Insert Hyperlink dialog box should she use to indicate she wants to insert an email hyperlink?

Link to list

Ariana wants to compare data on different worksheets in a workbook named Financials. Which of the following buttons can she use on the View tab to open an instance of the Financials workbook?

New Window

Igor needs a wider left margin in his worksheet. Which of the following can he do to change the margin?

On the Margins tab of the Page Setup dialog box, change the number in the Left box.

Fran is working in Page Break Preview and wants to delete a page break in row 24, but not any others. After clicking in row 25, which option should she select in the Breaks button list?

Remove Page Break

In cell A5, Jiang inserted a hyperlink to a webpage, but now does not want to link to the webpage when she clicks the cell. How should she make this change in cell A5?

Right-click the cell, then click Remove Hyperlink on the shortcut menu.

Michelle finished a 5 kilometer run in 180th position. The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race. The top 15 finishers are listed in rows 2 to 16. Michelle wants to compare her time against theirs. How can she do so?

Select row 17 and click View tab > Window group > Split.

Dante uses a worksheet to list sales data from five stores he manages. The worksheet includes a column named Product Type, and Dante wants to calculate subtotals for each product type. What must he do before using the Subtotal feature?

Sort the data in the Product Type column.,

Carol wants to redisplay a workbook window she had hidden earlier. Which button should she click on the View tab?

Unhide

Which of the following can be the target of a hyperlink in Excel?

Worksheet in the current workbook

Helga wants to reset page breaks in a worksheet to display only automatic page breaks. Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

X- Page Break Preview, Y- Breaks

A _____ is a section of columns or rows that you can freeze and unfreeze.

pan

A _____ is a set of display or print settings that you can name and save, and then access later.

view

Which tab and button do you use to edit document properties ?

File tab, Info Button

Alba wants to display a picture as the worksheet background. Which of the following buttons on the Page Layout tab should she use?

Background

When you right-click a cell containing a hyperlink, which of the following commands should you select to remove cell contents along with the hyperlink?

Clear Contents

Miguel wants to remove the outline from a worksheet containing grouped data. What does he need to do?

Clear the outline.

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Click Custom Views and double-click on the display settings she wants to see.

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can she do after selecting the worksheet for this purpose?

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.

How can you remove the split panes from a worksheet?

Click the View tab, and then click the Split button in the Windows group.

Which of the following items does the Document Inspector check for sensitive information?

Document properties

Calista wants to provide additional information about a hyperlink she is creating. Which of the following can she do?

Add a ScreenTip.

Han has four workbooks open, with one maximized on the desktop. Which button can he click on the View tab to display a different workbook?

Switch Windows

Al wants to compare data in two worksheets of two different workbooks quickly by scrolling through both at the same time. Which of these should he click after turning on View Side by Side on the View Tab in the Windows group?

Synchronous Scrolling

Myra right-clicks the Benefits sheet tab then clicks Hide on the shortcut menu. What is the result

The Benefits worksheet is hidden