Excel Ch 6, 8, 10

True

A structure reference includes both brackets and the at symbol(@). True or false

True

A structure reference is one that uses standard cell references, such as A1. True or false

False

A table can be created only if data has already been entered in a list within Excel. True or false

True

A table can include both a header row and a total row. True or false

False

A worksheet window can be split only horizontally not vertically. True False

False

All worksheet cells are unlocked by default. True or False

Name record save run

Arrange the macro-recording steps in the order of completion. a) 1 Naming a macro b) 2 Recording macro steps c) 3 Saving a macro d) 4 Running a macro

True

AutoFilter buttons allow you to sort and filter data in a table. True or false

Select locked cells

By default what does Excel allow users to do in a protected worksheet? a) Format cells b) Select locked cells c) Insert rows d) Delete columns

False

Cell references CANNOT be used with PV and FV functions. True or False

True

Excel tables allow calculated columns and filtering. True or false

Depreciation functions

Features specific to tables include each of these EXCEPT: A. Automatic expansion B. Calculated columns C. Depreciation functions D. Table Styles

Future Value

For a bond which formula argument represents a payment and requires the inclusion of a negative sign before the argument to reverse its sign within financial formulas? a) Rate b) Future Value c) Present Value d) Periods

To determine optimal net income by adjusting units sold

For which circumstance would you use Goal Seek? a) To determine optimal sales levels by adjusting expense and purchase variables b) To determine optimal net income by adjusting units sold c) To determine optimal total expenses by adjusting units sold and products developed d) To determine optimal asset purchase levels by adjusting sales and expense levels

False

Gridlines are set to print by default. True False

12

How many payments will a bond with semiannual payments made over six years have? __________

False

In the PMT PV and FV functions the interest rate argument is always expressed in annual terms. True or False

Annual

Interest rates including the effective interest rate and contract interest rate, are typically expressed in ___ terms. a) weekly b) monthly c) semiannual d) annual

True

Macro names CANNOT include spaces. True or False

column headers

Macros CANNOT be assigned to _____. a) shortcut keys b) custom buttons c) graphics d) column headers

Column E becomes a calculated column and the sum function is automatically copied to all four table rows

Musheer created a table showing the quarterly sales for each of his four stores. What happens when he creates an AutoSum function in cell E3? a) Nothing, because column E is not part of the table. b) Column E becomes a calculated column, and the Sum function is automatically copied to all four table rows. c) The Sum function is automatically copied to all four table rows. Column E remains independent from the table. d) The Sum function is automatically copied to all table rows and columns.

True

Records in a table that do not meet applied filtering criteria are hidden from view. True or false

True

Solver can adjust multiple variables simultaneously. True False

The average value

Solver can be set to determine a solution for each of these EXCEPT: a) The maximum value b) The minimum value c) The average value d) A specific value

Deleting tables

Structured reference allow formulas to adjust automatically when each of these actions EXCEPT _________ is taken. A. renaming tables B. editing column heading C. deleting tables D. deleting columns

False

Synchronous scrolling works only when two windows for a single worksheet are viewed side by side. True False

False

Table column headings can include any special characters, such as the pound sign or brackets. True or false

cell location

Tables cannot be filtered by _____. a) text color b) cell fill color c) cell contents d) cell location

He can't

Tariq forgot the password to unlock his workbook. How can he recover it? a) Press [Ctrl]+[P] while the opening the file to show the password hint. b) He can't. c) Remove the Marked as Final designation. d) Issue the Save As command, which removes the password requirement

Split

Ted wants to view two sections of this workbook simultaneously and be able to scroll through each. What tool should he use? a) Page Setup b) Split c) Freeze Panes d) Page Layout

True

The Adjust Margins option is used to change the appearance of a printed worksheet. True False

True

The Freeze Panes option can freeze columns and rows simultaneously. True False

True

The Protect Sheet command can be accessed on the Review and Home tabs. True or False

False

The Quick Analysis button provides access to features not included on the Ribbon. True or false

True

The [Tab] key can be used to move through unlocked cells in a worksheet. True or False

True

The factor variable in a double-declining balance function is optional. True or false

False

The number 1 represents the default entry for the type argument in PMT PV and FV functions. True or False

Design

The table style option appears under the ________tab of the Ribbon. A. Page Layout B. Review C. View D. Design

An up arrow

What AutoFilter button image indicates that a list is sorted from lowest to highest? A. A filter B. A down arrow C. An up arrow D. A pyramid

Blank spaces

What CANNOT be included in a macro name? a) Capital letters b) Numbers c) Underscores d) Blank spaces

Salvage Value

What argument in the double-declining balance depreciation function may equal zero? a) Cost b) Salvage Value c) Useful Life d) Period

Present Value

What argument is optional for the FV function? a) Rate b) Periods c) Payment d) Present Value

Period

What argument is used for the SYD and DDB functions but not SLN? a) Cost b) Salvage Value c) Useful Life d) Period

Stop Recording

What button appears on the status bar when a macro is being recorded? a) Stop Recording b) Record Macro c) Pause Recording d) Delete Recording

Variable

What element is adjusted when using Goal Seek? a) formula b) description of the goal c) variable d) constraint

Filter

What feature allows you to display only rows that meet certain criteria in a table? a) Filter b) Calculated Columns c) Sort d) Quick Analysis

filter

What feature allows you to display only rows that meet certain criteria in a table? a) Filter b) Calculated Columns c) Sort d) Quick Analysis;

Gridlines

What has been added to the first image to create the second image? a) Gridlines b) Headings c) Margins d) Scale to Fit

Total value of other bonds issued by the company

What information is not necessary to complete a bond amortization schedule? a) Face value b) Life of the bond c) Frequency of interest payments d) Total value of other bonds issued by the company

They must contain at least seven characters

What is NOT a rule for table column headings? a) Each one must be unique. b) They must contain at least seven characters. c) Each column can contain only one piece of information. d) Certain special characters cannot be used in headings

Total assets

What is NOT an element of a CVP analysis? a) Total assets b) Variable cost c) Fixed cost d) Unit sales

One that remains visible on the screen when you scroll

What is a frozen row? a) One that can be viewed in two locations on the screen b) One that restricts data entry c) One that is hidden from view d) One that remains visible on the screen when you scroll

A method that leads to more depreciation during the early years of an asset's useful life than in the later years

What is an accelerated depreciation method? a) A method that leads to depreciation during years one and two only b) A method that is calculated more easily than other methods c) A method that leads to more depreciation over the life of the asset than would otherwise be recorded d) A method that leads to more depreciation during the early years of an asset's useful life than in the later years

face value + unamortized premium

What is equal to the carrying value of a bond? a) face value - unamortized premium b) face value + unamortized premium c) face value - unamortized premium d) face value - unamortized premium + unamortized discount

Disable all macros with notification

What is the default macro security level? a) Enable all macros b) Disable all macros except digitally signed macros c) Disable all macros with notification d) Disable all macros without notification

Rate

What is the first argument in the PV function? a) Type b) Periods c) Rate d) Payment

4

What is the maximum number of groups that can be viewed simultaneously when splitting a window? a) 1 b) 2 c) 3 d) 4

Type

What is the optional argument for PMT, PV, and FV functions? a) Rate b) Periods c) Payment d) Type

To limit a cell's possible range of values

What is the purpose of the constraints within Solver? a) To identify the final value you are seeking within a single cell b) To limit a cell's possible range of values c) To indicate the cells that should be modified to identify a solution d) To indicate the number of cells that can be modified

Max- Min- and Specific Value

What objectives are available with Solver? a) Max- Set Cell- and Average b) Min- Specific Value- and Average c) Specific Value- Average- and Set Cell d) Max- Min- and Specific Value

Rate and periods

What two arguments are required for the PMT PV and FV functions? a) Rate and periods b) Payment and type c) Future value and rate d) Type and present value

save the workbook

When a workbook is protected, you can still _____. a) delete worksheets b) save the workbook c) rename worksheet tabs d) move worksheets

Divide the rate by 12

When determining the present value of a bond with an interest rate of 8%, how do you modify the rate argument to account for monthly interest payment? a) Divide the rate by 12. b) Multiply the rate by 12. c) Divide the rate by 2. d) Multiply the rate by 2.

False

When protecting a worksheet, you must create a password. True or False

Formulas

When the Hidden option on the Protection tab of the Format Cells dialog box is checked what is NOT displayed in the worksheet? a) Formulas b) Labels c) Values d) Formula Results

Tab

When the right-most cell of the last data row in a table is active, tapping _________ creates a new row at the bottom of the table. A. Ctrl B. Tab C. Alt D. Shift

Column A

When using Freeze Panes to freeze only rows the active cell must be located in: a) column A b) column B c) column C d) column D

1

When using View Side by Side how many windows can be active at one time? a) 1 b) 2 c) 3 d) 4

False

When viewing a worksheet in multiple windows changes made in one window are not reflected in the other window. True False

Splitting

Which Excel feature is useful for examining two nonadjacent sets of data? a) Headings b) Gridlines c) Freezing d) Splitting

Default conditional formatting

Which feature is NOT specific to Excel tables? a) Automatic expansion b) Calculated columns c) Default conditional formatting d) Filtering

PMT

Which function is most useful in determining the monthly payments to be made on a bond? a) IF b) PMT c) PV d) FV

D

Which letter is identifying the banded rows? Answer: __________

Print Titles

Which of these CANNOT be set from the Print area in Backstage view? a) Orientation b) Print Titles c) Margin Presets d) Paper Size

Page layout tab

Which of these CANNOT be used to run a macro? a) Shortcut keys b) Custom buttons c) Quick Access toolbar d) Page Layout tab

Tall

Which of these is NOT a Margin option? a) Normal b) Tall c) Wide d) Narrow

Length

Which of these is NOT a Scale to Fit option? a) Width b) Height c) Length d) Scale

Weighted average

Which of these is NOT a depreciation method? a) Straight-line b) Sum of the years' digits c) Weighted average d) Double-declining balance

Calculated Rows

Which of these is NOT a table style option available on the Ribbon? A. Header Row B. Total Row C. Banded Columns D. Calculated Rows

Straight-line depreciation

Which of these is NOT an accelerated depreciation method? A. Straight-line depreciation B. Sum of the years' digit depreciation C. Double-declining balance depreciation D. Triple-declining balance depreciation

Excel-level protection

Which of these is NOT an available level of protection in Excel? a) Excel-level protection b) Workbook-level protection c) Worksheet-level protection d) Cell-level protection

Disable all macros

Which of these is NOT an available level of security in Excel? a) Disable all macros b) Disable all macros except digitally signed macros c) Disable all macros with notification d) Disable all macros without notification

Alignment

Which of these is NOT available via the Quick Analysis button menu? A. Formatting B. Chart C. Alignment D. Sparklines

Factor

Which of these is NOT required when using depreciation functions (SLN, SYD, or DDB)? A. Cost B. Salvage Value C. Useful Life D. Factor

Cost

Which of these is not an estimate used to determine depreciation expense? a) Cost b) Salvage value c) Useful life d) Residual value

Dollar sign ($)

Which special character can be used in a table header? A. Dollar sign ($) B. At symbol (@) C. Pound sign (#) D. Single quotes (')

They report on the results of operations to outside parties.

Which statement about budgets is incorrect? a) They determine the cash required for future operations. b) They determine the maximum amount that should be spent on expenses. c) They determine the merchandise purchases required to achieve various sales levels. d)They report on the results of operations to outside parties.

All worksheet cells are locked by default

Which statement about locking and unlocking cells is true? a) A cell that has been locked cannot be unlocked. b) You cannot lock or unlock a range of cells simultaneously. c) Worksheet protection is not required to prevent users from unlocking cells. d) All worksheet cells are locked by default.

You can apply settings for margins and page orientation to multiple worksheets simultaneously prior to printing

Which statement about printing in Excel is accurate? a) You must select the desired tabs to print multiple worksheets simultaneously. b) With Quick Print the entire workbook is printed. c) You can apply settings for margins and page orientation to multiple worksheets simultaneously prior to printing. d) The Print Entire Workbook command is available from the Ribbon only.

They are associated with Excel tables but not standard worksheet data

Which statement about structured references is true? a) You must enter them into the worksheet before creating a table. b) Structured references modify the result of the formula in the cell they are applied. c) Symbols such as + and - are not used. d) They are associated with Excel tables but not standard worksheet data.

The windows cannot be scrolled independently

Which statement about viewing a single worksheet in two windows is incorrect? a) When more than two windows are open and you click View Side by Side a menu appears so you can choose the second window to view. b) The active window displays a brighter filename than the nonactive window. c) The windows display numbers next to the file names. d) The windows cannot be scrolled independently

A filter can apply a single criterion only

Which statement is incorrect regarding filters? a) Records not meeting the criteria of a filter are hidden. b) When a filter is applied the AutoFilter button in the associated column heading displays a filter icon. c) A filter can apply a single criterion only. d) The AutoFilter button ScreenTip indicates the current filter setting.

Since table data cannot be modified the re-create button stays active so you can easily start over

Which statement is incorrect regarding tables? a) You can convert a worksheet list into a table. b) Since table data cannot be modified, the Re-create button stays active so you can easily start over. c) If the table range Excel proposes isn't correct, just change it before creating the table. d) Table formatting can be applied and changed after the table has been created.

It can be used to convert standard worksheet data into a table

Which statement regarding Quick Analysis is accurate? a) It cannot be used to apply formatting to tables. b) It only contains options that cannot be found on the Ribbon. c) It does not afford the opportunity to preview the impact of potential changes. d) It can be used to convert standard worksheet data into a table.

Goal seek

Which what-if-analysis tool is best suited for arriving at a desired figure by adjusting a single variable? a) Goal Seek b) Solver c) Scenario Manager d) Data Tables

You want every page of a printed worksheet to include them

Why set title rows? a) They help you keep track of different worksheets in the workbook. b) They are preformatted to align with common financial statements. c) They help you visualize the printout from Page Layout view. d) You want every page of a printed worksheet to include them.

Excel does not automatically include areas after blanks in a table

Why should you NOT include blank rows in the data that will be converted to a table? a) Excel does not automatically include areas after blanks in a table. b) Blank rows result in additional header rows within a table. c) Blank rows result in multiple total rows within a table. d) Blank rows prevent tables from being created.

You want to analyze table data in different ways such as from largest to smallest amounts

Why sort table data? a) You want to display only the table rows that meet certain criteria such as after a certain date. b) You want to analyze table data in different ways such as from largest to smallest amounts. c) You can filter by two criteria such as region and salesperson. d) You need to convert the worksheet data to table data.

False

You can set the Print Titles option from the Print menu in Backstage view. True False