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

Question 1

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

Answer 1

A

Question 2

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

Answer 2

False

Question 3

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

Answer 3

C

Question 4

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.

Question 5

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.

Question 6

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)

Question 7

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.

Question 8

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

Question 9

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.

Question 10

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.

Question 11

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

A) Save As dialog box
B) Home tab
C) Name box
D) Active cell

Question 12

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

Question 13

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

A) icon sets
B) themes
C) Top/Bottom Rules
D) Highlight Cells Rules

Question 14

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.

Question 15

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.

Question 16

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.

Question 17

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

Question 18

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.

Question 19

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

Question 20

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