Excel Module 04

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?

=ROUND(A5,2)

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

Backstage view

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?

Click on the select button in Rows to repeat at top area and select a title row.

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

False

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

False

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.

False

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Highlight Cells Rules

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?

Open the workbook, make changes, and then save it using a different name.

Where do you rename a workbook and adjust its save location?

Save As dialog box

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

Sheet tab > Home tab > Cells group > Format > Visibility > Hide & Unhide > Hide 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?

Top/Bottom Rules

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.

True

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.

True

One can create a one-variable data table in Excel to test a series of values for a single input cell and see the influence of these values on the result of a related formula.

True

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.

True

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

True

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.

True

While creating a two-variable data table in Excel, you need to enter two ranges of possible input values, one in a row and another in a column.

True

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

View tab > Window group > Hide

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

View tab > Window group > Unhide