Exam 4: Financial Functions, data Tables, and Amortization Schedules

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?

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?

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.

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?

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

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

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?

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

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

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.

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

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.

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.

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

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

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.

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.

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.

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