In the accompanying figure, the Print area box accepts a name or a ____ to print.
  • False
  • Page
  • name
  • range
Data tables must be built in a(n) ____ area of a worksheet.
  • unused
  • one-input
  • False
  • ROUND
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
  • Sheet
  • unprotected
  • Formulas
  • Cell protection
A column border is an unused column with a significantly reduced width.
  • name
  • True
  • range
  • False
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
  • False
  • protect
  • True
  • CTRL
When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.
  • Formulas
  • range
  • True
  • green triangle
Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.
  • violations
  • Data tables
  • unprotected
  • protection
Once you set a print area, Excel will continue to print the specified range, rather than the entire worksheet.
  • Sheet
  • Page
  • True
  • name
Which of the following is the path to the Cell Styles button?
  • (FORMULAS tab | Function Library group)
  • pressing the DELETE key
  • (REVIEW tab | Changes group)
  • (HOME tab | Styles group)
Which of the following is the path to the Protect Sheet button?
  • (HOME tab | Editing group)
  • pressing the DELETE key
  • (REVIEW tab | Changes group)
  • (HOME tab | Styles group)
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
  • Hide
  • False
  • name
  • True
A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.
  • Draft quality
  • annuity
  • Cell protection
  • green triangle
A cell name often is created from column and row titles.
  • True
  • CTRL
  • unused
  • False
An alternative to a one-input data table is a three-input data table.
  • True
  • Page
  • False
  • ROUND
What is the path to the What-If Analysis button?
  • (VIEW tab | Window group)
  • (DATA tab | Data Tools group)
  • (HOME tab | Editing group)
  • (HOME tab | Font group)
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
  • Sheet
  • SHIFT
  • Formulas
  • False
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
  • Format Cells
  • Formulas
  • background formula checking
  • The formula checker
Which of the following is the path to the Financial button and the PMT function?
  • As many as you want
  • (FORMULAS tab | Function Library group)
  • (VIEW tab | Window group)
  • (FORMULAS tab | Defined Names group)
A(n) ____________________ is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.
  • amortization schedule
  • Formulas
  • annuity
  • Hiding
You can add only a maximum of five conditional formats to a range.
  • Format Cells
  • False
  • Sheet
  • Page
You should create worksheets as if you are going to use them only once.
  • Page
  • True
  • name
  • False
To prevent round-off errors, use the ____ function.
  • False
  • True
  • range
  • ROUND
With a(n) ____ data table you can vary the value in one cell.
  • (HOME tab | Styles group)
  • brackets
  • one-input
  • unprotected
Cell ____ can be used to distinguish the different functional parts of a worksheet.
  • Formulas
  • borders
  • True
  • annuity
The ____ function returns the present value of an annuity.
  • False
  • Page
  • PV
  • True
You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.
  • Formulas
  • Sheet
  • True
  • False
Excel is case sensitive with respect to names of cells.
  • name
  • True
  • False
  • range
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
  • (DATA tab | Data Tools group)
  • (HOME tab | Editing group)
  • (HOME tab | Font group)
  • (VIEW tab | Window group)
____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.
  • protection
  • Draft quality
  • Data tables
  • annuity
____ ensures that users do not change values inadvertently that are critical to the worksheet.
  • unprotected
  • protection
  • Cell protection
  • The formula checker
Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
  • violations
  • False
  • protection
  • Format Cells
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
  • The formula checker
  • amortization schedule
  • Format Cells
  • Data tables
The print options available on the Margins tab in the Page Setup dialog box pertain to the way the worksheet will appear in the printed copy or when previewed.
  • cells
  • False
  • protect
  • True
Which of the following is the path to the Borders button?
  • (FORMULAS tab | Function Library group)
  • (HOME tab | Font group)
  • (FORMULAS tab | Defined Names group)
  • (HOME tab | Styles group)
Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.
  • True
  • Hide
  • name
  • Page
Names are ____ to the workbook.
  • Hiding
  • ROUND
  • absolute
  • global
____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.
  • False
  • protection
  • SHIFT
  • Hiding
To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.
  • Hide
  • name
  • True
  • protect
You can delete a data table by selecting the data table and then ____.
  • (HOME tab | Editing group)
  • (REVIEW tab | Changes group)
  • pressing the DELETE key
  • False
When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.
  • True
  • Page
  • Sheet
  • Hide
Which of the following is the path to the Fill button?
  • (HOME tab | Editing group)
  • (HOME tab | Font group)
  • (FORMULAS tab | Function Library group)
  • As many as you want
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
  • False
  • cells
  • CTRL
  • True
You use a(n) ____ to automate data analyses.
  • data table
  • Data tables
  • global
  • Draft quality
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
  • False
  • data table
  • Format Cells
  • password
You can double-tap or double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.
  • SHIFT
  • Formulas
  • Page
  • True
Which of the following is the path to the Name Manager button?
  • (DATA tab | Data Tools group)
  • (FORMULAS tab | Defined Names group)
  • (FORMULAS tab | Function Library group)
  • pressing the DELETE key
A cell ____ often is created from column or row titles.
  • name
  • unused
  • True
  • False
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.
  • False
  • Page
  • name
  • True
If you enter a formula using Point mode and tap and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.
  • CTRL
  • True
  • Sheet
  • Page
0:0:1



Answered

Not Answered

Not Visited
Correct : 0
Incorrect : 0