Question 1

Boris wants to remove a workbook window from his workplace.What series of clicks can he use to hide it?+B12:D44
A) View tab > Window group > Hide
B) View tab > Window group > Split
C) View tab > Window group > View Side by Side
D) View tab > Window group > Switch Windows > Select a file

Accepted Answer

To hide a workbook window, Boris needs to go to the View tab, find the Window group, and select the Hide option. Additionally, he needs to specify which window to hide. In this case, the window is B12:D44, so he would need to click on that specific window before selecting Hide.

Question 2

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

Accepted Answer

This statement is false. Specifying gridlines to appear on the screen does not automatically make them appear on the printout. To have gridlines appear on the printout, you need to specifically select that option in the print settings.

Question 3

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

Accepted Answer

To ungroup worksheets, right-click any worksheet tab in the group and select Ungroup Sheets option.

Question 4

To enter your name in the lower right corner of a worksheet page, you can _____.
A) Use a button on the Header and Footer Tools Design tab.
B) Type your name in the Header and Footer Elements group.
C) Type your name in the lower right cell of the worksheet.
D) Select the right footer text box and type your name.

Accepted Answer

Selecting the right footer text box and typing your name is the correct method for entering your name in the lower right corner of a worksheet page. Options A and B refer to the header and footer, but do not provide specific instructions on how to enter your name in the lower right corner. Option C suggests typing your name in a specific cell, which would not necessarily be in the lower right corner.

Question 5

A worksheet named Income (2) is most likely which of the following?
A) a deleted worksheet
B) a worksheet with no calculations
C) a repositioned worksheet
D) a copy of another worksheet named Income

Accepted Answer

If a worksheet is named "Income (2)" it indicates that it is a copy of another worksheet named "Income".

Question 6

You can edit a worksheet footer in _____.
A) Page Layout view
B) Normal view
C) Page Break Preview
D) Print Preview

Accepted Answer

You can edit a worksheet footer in Page Layout view, which allows you to see how your document will look when printed and gives you the ability to edit headers and footers directly.

Question 7

To lock certain cells in a worksheet to protect them, select the cells, then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select) Locked check box > OK to close the popup window.Then click on Review tab > Changes group > Protect Sheet.

Accepted Answer

This is the correct process to lock certain cells in a worksheet for protection.

Question 8

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?
A) Icon Sets
B) Color Scales
C) Top/Bottom Rules
D) Highlight Cells Rules

Accepted Answer

X should be selected as "Top/Bottom Rules" to highlight the top 10 items in a range of cells.

Question 9

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file.What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?
A) Click on the select button in Rows to repeat at top area and select a title row.
B) Click on the select button in Columns to repeat at left area and select a title row.
C) Click the check box before Row and column headings under Print.
D) Click the check box before Gridlines under Print.

Accepted Answer

To print a title row at the top of every sheet, Eleanor needs to click on the select button in Rows to repeat at top area and select a title row in step X. This will ensure that the title row is printed at the top of every sheet. The other options (B, C, D) are not relevant to this task.

Question 10

A student wants to round the number 24.7835 entered in cell A2 to two decimal places.Which of these formulas can she use to do so?
A) =ROUND(A5,2)
B) =MROUND(A5,2)
C) =ROUND(A5,2.0)
D) =MROUND(A5,0.2)

Accepted Answer

The correct formula to round a number in a cell to a specified number of decimal places in Excel is =ROUND(cell, number_of_places). In this case, to round the number in cell A2 to two decimal places, the correct formula is =ROUND(A2,2). The reference to A5 in the options is incorrect and seems to be a typo; it should refer to A2 based on the question's context. However, considering the options provided and the intent to round to two decimal places, option A is the correct approach despite the cell reference error. MROUND rounds to the nearest multiple of a specified number, which doesn't directly apply to rounding to a specific number of decimal places as intended here.

Question 11

Carol wants to unhide a workbook window she had hidden earlier.Which of these series of clicks can she press to do so?
A) View tab > Window group > Unhide
B) View tab > Window group > Uncheck box beside Hide > Check box beside Unhide
C) File > Options > Display > Check Show all windows in the Taskbar box
D) Home > Format > Visibility > Hide & Unhide > Hide Sheet

Accepted Answer

To unhide a workbook window, Carol needs to go to the View tab, find the Window group, and click on the Unhide button. This will bring up a dialog box that lists all the hidden workbook windows, and she can select the one she wants to unhide.

Question 12

Which of the following would you use to print only one page of a multipage worksheet?
A) Page Layout tab
B) Formulas tab
C) Backstage view
D) Page Setup dialog box

Accepted Answer

Backstage view, accessible via the File tab in Microsoft Excel, allows users to manage files and data about files, such as printing options, including the ability to select specific pages for printing.

Question 13

To unprotect a workbook, open the Excel file, then click on Review > Unprotected Sheet, then enter the password for the unprotected sheet and click OK.

Accepted Answer

The answer of To unprotect a workbook, open the Excel...

Question 14

Myra wants to hide a worksheet to remove it from view.Which of these series of clicks will help her do so?
A) Sheet tab > Window group > Hide
B) Sheet tab > Window group > Freeze Panes > Hide
C) Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Sheet
D) Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide Rows

Accepted Answer

Myra can hide a worksheet by selecting the sheet tab, then going to the Home tab, Cells group, Format, and Visibility. From there, she can choose to hide the sheet. Option A may not be available depending on the version of Excel being used. Option B refers to freezing panes, which is a different function. Option D only hides rows, not the entire worksheet.

Question 15

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?
A) Leave the workbook closed.
B) Open the workbook, change the first worksheet, and save it using the Save command.
C) Open the workbook, make changes, and then save it using the same name.
D) Open the workbook, make changes, and then save it using a different name.

Accepted Answer

By saving the workbook with a different name, you create a copy of the original version that you can make changes to without affecting the original. This ensures that the original version is preserved.

Question 16

Ina wants to protect a worksheet with a password to allow changes by other users in only selected elements.To do so, she can first unlock editable cells, then click Review tab > Protect Sheet > Allow all users of this worksheet to list > Select the elements you want people to be able to change > OK.

Accepted Answer

This is the correct process to protect a worksheet with a password and allow changes by other users in selected elements.

Question 17

To share a protected workbook, place it on a network location, then click Review > Share Workbook > Editing tab > (Select) Allow changes by more than one user > Advanced tab > (Select) options for tracking and updating changes > OK > File > Save As > Share.

Accepted Answer

The described steps are for older versions of Excel. In newer versions, such as Excel for Microsoft 365, sharing a workbook is done by clicking on Share in the upper right corner, inviting people to collaborate, or by saving the workbook to OneDrive or SharePoint and then sharing a link. The "Share Workbook" feature described has been deprecated.

Question 18

To unprotect a workbook, open the Excel file, then click on File > Info > Protect Workbook > Encrypt with Password > OK.

Accepted Answer

The answer of To unprotect a workbook, open the Excel...

Question 19

Kai wants to hide a worksheet with a password to prevent other users from viewing it.To do so, he can Click Review > Protect Workbook > Enter a password in the Password box > OK.He can then retype the password to confirm it, and then click OK.

Accepted Answer

This is the correct method to protect a workbook with a password.

Question 20

Which of the following methods copies an existing worksheet within the same workbook?
A) Drag its sheet tab to a new location.
B) Press and hold CTRL and drag its sheet tab to a new location.
C) Press and hold SHIFT and drag its sheet tab to a new location.
D) Press and hold ALT and drag its sheet tab to a new location.

Accepted Answer

Press and hold CTRL and drag its sheet tab to a new location will create a copy of the worksheet within the same workbook.

Quiz 8: Excel

Boris wants to remove a workbook window from his workplace.What series of clicks can he use to hide it?+B12:D44

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

To enter your name in the lower right corner of a worksheet page, you can _____.

A worksheet named Income (2) is most likely which of the following?

You can edit a worksheet footer in _____.

To lock certain cells in a worksheet to protect them, select the cells, then click Home tab > Alignment group > Format Cells popup window > Protection tab > (select) Locked check box > OK to close the popup window.Then click on Review tab > Changes group > Protect Sheet.

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select) Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file.What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

A student wants to round the number 24.7835 entered in cell A2 to two decimal places.Which of these formulas can she use to do so?

Carol wants to unhide a workbook window she had hidden earlier.Which of these series of clicks can she press to do so?

Which of the following would you use to print only one page of a multipage worksheet?

To unprotect a workbook, open the Excel file, then click on Review > Unprotected Sheet, then enter the password for the unprotected sheet and click OK.

Myra wants to hide a worksheet to remove it from view.Which of these series of clicks will help her do so?

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

To share a protected workbook, place it on a network location, then click Review > Share Workbook > Editing tab > (Select) Allow changes by more than one user > Advanced tab > (Select) options for tracking and updating changes > OK > File > Save As > Share.

To unprotect a workbook, open the Excel file, then click on File > Info > Protect Workbook > Encrypt with Password > OK.

Kai wants to hide a worksheet with a password to prevent other users from viewing it.To do so, he can Click Review > Protect Workbook > Enter a password in the Password box > OK.He can then retype the password to confirm it, and then click OK.

Which of the following methods copies an existing worksheet within the same workbook?