Question 1

In the acsampanying figure, the Print area box accepts a name or a ____ to print.
A) range
B) file
C) worksheet
D) tab

Accepted Answer

The answer of  In the acsampanying figure, the Print...

Question 2

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
A) Hide Sheet
B) Hide Rows and salumns
C) Hide Workbook
D) Hide

Accepted Answer

The answer of To prevent sensitive data from being seen...

Question 3

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left sarner of the cell assigned the formula.
A) blue square
B) red circle
C) green triangle
D) green diamond

Accepted Answer

Excel displays a small green triangle in the upper-left corner of a cell to indicate a potential error when background formula checking is enabled.

Question 4

Which of the following is the path to the Protect Sheet button?
A) (VIEW tab | Protect Sheet group)
B) (HOME tab | Protection group)
C) (REVIEW tab | Changes group)
D) (VIEW tab | Protect group)

Accepted Answer

The answer of Which of the following is the path...

Question 5

To prevent round-off errors, use the ____ function.
A) RAND
B) ROUND
C) RADIANS
D) ROMAN

Accepted Answer

The ROUND function is used to round a number to a specified number of decimal places or to the nearest whole number. It can be used to prevent round-off errors that can occur when working with calculations involving decimal numbers. The other options (RAND, RADIANS, and ROMAN) are not relevant for preventing round-off errors.

Question 6

To select nonsantiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
A) ALT
B) F3
C) CTRL
D) F10

Accepted Answer

The CTRL key is used to select noncontiguous ranges in Excel. After selecting the first range, holding down the CTRL key allows you to select additional ranges.

Question 7

In a process called ____, Excel santinually reviews the workbook for errors in formulas as you create or manipulate it.
A) background formula checking
B) workbook formula checking
C) foreground formula checking
D) background function checking

Accepted Answer

Excel uses background formula checking to continuously review the workbook for errors in formulas as you create or manipulate it.

Question 8

Rather than manually setting a print area each time you want to print a range, you can ____ the range.
A) lock
B) manipulate
C) name
D) validate

Accepted Answer

Naming the range allows you to easily refer to it when selecting a print area or performing other actions in Excel.

Question 9

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
A) locked
B) indexed
C) unprotected
D) hybrid

Accepted Answer

If cells are left unprotected, another worksheet user will be able to manipulate them.

Question 10

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that santain text or formulas.
A) hide
B) protect
C) sade
D) delete

Accepted Answer

Protecting cells prevents users from making changes to them, ensuring that important data or formulas remain intact.

Question 11

Cell ____ can be used to distinguish the different functional parts of a worksheet.
A) ranges
B) values
C) indices
D) borders

Accepted Answer

The answer of Cell ____ can be used to distinguish...

Question 12

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
A) Page
B) Sheet
C) Margins
D) Header/Footer

Accepted Answer

The answer of You can set up a worksheet to...

Question 13

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
A) Paste Options
B) Insert samment
C) Format Cells
D) Filter

Accepted Answer

The "Format Cells" option allows you to add and format borders for a selected range in spreadsheet applications.

Question 14

To hide an entire workbook on an unattended samputer, click the Hide button on the ____.
A) (HOME tab | View group)
B) (VIEW tab | Workbook Views group)
C) (VIEW tab | Window group)
D) (HOME tab | Display group)

Accepted Answer

The Hide button for hiding an entire workbook is located under the VIEW tab in the Window group.

Question 15

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.
A) General
B) Formulas
C) Proofing
D) Advanced

Accepted Answer

The answer of You can choose which rules you want...

Question 16

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
A) repetitiveness
B) brevity
C) violations
D) sansistency

Accepted Answer

Excel's formula checker checks for rule violations, ensuring that formulas adhere to certain rules and guidelines.

Question 17

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.
A) password
B) authorized user
C) manager acsaunt
D) administrative acsaunt

Accepted Answer

A password is used to protect a worksheet, preventing unauthorized users from changing its protection status.

Question 18

If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu santains sammands from which you can choose.
A) cell boundary
B) Error Checking button
C) fill handle
D) Trace Error button

Accepted Answer

The Trace Error button in Excel displays a menu that identifies the error and provides commands to help resolve it.

Question 19

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
A) Margins
B) Header/Footer
C) Page
D) Sheet

Accepted Answer

The option to scale a worksheet to fit on one page is found under the Page tab in the Page Setup dialog box. The Margins and Header/Footer tabs do not have this option, and while the Sheet tab does have a scaling option, it does not include the option to fit on one page.

Question 20

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.
A) Print titles
B) Black and white
C) Gridlines
D) Draft quality

Accepted Answer

The "Draft quality" check box speeds up printing by ignoring formatting and not printing most graphics. The other options may affect the appearance of the printed document but they do not speed up printing.

Quiz 15: Financial Functions, Data Tables, and Amortization Schedules Question

In the acsampanying figure, the Print area box accepts a name or a ____ to print.

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left sarner of the cell assigned the formula.

Which of the following is the path to the Protect Sheet button?

To prevent round-off errors, use the ____ function.

To select nonsantiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.

In a process called ____, Excel santinually reviews the workbook for errors in formulas as you create or manipulate it.

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that santain text or formulas.

Cell ____ can be used to distinguish the different functional parts of a worksheet.

You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.

You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.

To hide an entire workbook on an unattended samputer, click the Hide button on the ____.

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.

You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.

If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu santains sammands from which you can choose.

You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.