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