ACC 255 Final

Which of these is NOT a chart formatting button? A. Chart Titles B. Chart Elements C. Chart Styles D. Chart Filters

A. Chart Titles

On what Ribbon tab can Solver can be found? A. Insert B. Formulas C. Data D. Review

C. Data

How can you explode a pie slice? A. Via the Ribbon B. Right-click the pie slice C. Drag the pie slice D. Via a task pane

C. Drag the pie slice

What is the maximum number of groups that can be viewed simultaneously when splitting a window? A. 1 B. 2 C. 3 D. 4

D. 4

Which of these represents an absolute cell reference? A. $D$7 B. D7 C. $D7 D. D$7

A. $D$7

When using View Side by Side, how many windows can be active at one time? A. 1 B. 2 C. 3 D. 4

A. 1

Which of these is NOT a type of sparkline? A. Bar B. Line C. Column D. Win/Loss

A. Bar

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

A. Disable all macros

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

A. Dollar Sign

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

A. Excel-level protection

What is entered in the range lookup argument of the VLOOKUP function to require an exact match in the lookup table? A. FALSE B. EXACT C. TRUE D. " " (a blank space)

A. False

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

A. Formulas

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

A. Goal Seeker

The IF function is found in the _____ category of the Insert Function dialog box. A. Logical B. Statistical C. Math & Trig D. Financial

A. Logical

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

A. Straight-line depreciation

Which of these is NOT a Sheet option? A. View Titles B. View Headings C. Print Headings D. Print Gridlines

A. View Titles

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

A. column A

What CANNOT be entered in the num_digits argument of the ROUND function? A. The number zero B. A text entry C. A positive number D. A negative number

B. A text entry

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

B. Future Value

The Recommended Charts option is located on the _____ tab of the Ribbon. A. Home B. Insert C. Formulas D. Data

B. Insert

Which of these CANNOT be set from the Print area in Backstage view? A. Orientation B. Print Titles C. Margin Presets D. Paper Size

B. Print Titles

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]

B. Tab

Which of these is NOT a Margin option? A. Normal B. Tall C. Wide D. Narrow

B. Tall

Where are sparklines located? A. Within a chart B. Within a single cell C. Within a range of cells D. Within a cell comment

B. Within a single cell

Which of these is NOT an argument in the VLOOKUP function? A. lookup value B. logical test C. table array D. column index number

B. logical test

How will the mixed cell reference $H8 appear in the new cell if the formula containing the cell reference is dragged one cell to the right? A.$H9 B. $G8 C. $H8 D. $G9

C. $H8

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

C. Alignment

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

C. An up arrow

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

C. Deleting Tables

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

C. Depreciation Functions

Which of these is NOT a Scale to Fit option? A. Width B. Height C. Length D. Scale

C. Length

Which of these is NOT an argument within the IF function? A. Value_If_True B. Logical_Test C. Number D. Value_If_False

C. Number

Which of these is NOT a category of ratios typically examined by businesses? A. Liquidity B. Solvency C. Qualitative D. Profitability

C. Qualitative

What is the first argument in the PV function? A. Type B. Periods C. Rate D. Payment

C. Rate

On what tab is the Insert a Comment option located? A. Insert B. Data C. Review D. View

C. Review

Which of these is NOT an option in the Protect Sheet dialog box? A. Select unlocked cells B. Format rows C. Select locked sheets D. Insert hyperlinks

C. Select locked sheets

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

C. The average value

Which statement is accurate for when the range lookup argument in the VLOOKUP function is TRUE? A. The second column of the table array must be sorted from lowest to highest. B. The second column of the table array must be sorted from highest to lowest. C. The first column of the table array must be sorted from lowest to highest. D. The first column of the table array must be sorted from highest to lowest.

C. The first column of the table array must be sorted from lowest to highest.

Which of these is NOT a possible use of a cell comment? A. To document a formula or value in a cell B. To record a question C. To change a formula and the result displayed within a cell D. To communicate with an online collaborator

C. To change a formula and the result

How does Excel indicate that a cell contains a comment? A. Green shading B. An exclamation point C. A yellow border D. A small red triangle

D. A small red triangle

Interest rates, including the effective interest rate and contract interest rate, are typically expressed in _____ terms. A. weekly B. monthly C. semiannual D. annual

D. Annual

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

D. Calculated Rows

Which of these is NOT a chart element of a column chart? A. Legend B. Titles C. Columns D. Data Range

D. Data Range

The table styles option appears under the _____ tab of the Ribbon. A. Page Layout B. Review C. View D. Design

D. Design

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

D. Factor

What is the final column in the payroll register? A. Regular Hours B. Check Number C. Total Earnings D. Net Pay

D. Net Pay

Which of these CANNOT be used to run a macro? A. Shortcut keys B. Custom buttons C. Quick Access toolbar D. Page Layout tab

D. Page Layout tab

Which of these does NOT appear in a standard payroll register? A. Net Pay B. Overtime Hours Worked C. Pay Date D. State Withholding Allowances

D. State Withholding Allowances

What is the optional argument for PMT, PV, and FV functions? A. Rate B. Periods C. Payment D. Type

D. Type

On what tab is the Record Macro option found? A. Insert B. Formulas C. Data D. View

D. View

T/F. A structured reference is one that uses standard cell references, such as A1.

False

T/F. A table can be created only if data has already been entered in a list within Excel.

False

T/F. A worksheet window can be split only horizontally, not vertically.

False

T/F. All worksheet cells are unlocked by default.

False

T/F. Although you can move an embedded chart on its worksheet, you cannot change its size after it's been created.

False

T/F. An exploded pie slice is not visible within a pie chart.

False

T/F. Cell comments are always visible in a worksheet.

False

T/F. Cell references CANNOT be used with PV and FV functions.

False

T/F. Gridlines are set not to display by default.

False

T/F. In the PMT, PV, and FV functions, the interest rate argument is always expressed in annual terms.

False

T/F. Pie charts are good for showing the progression o data over time.

False

T/F. Synchronous scrolling works only when two windows for a single worksheet are viewed side by side.

False

T/F. Table column headings can include any special characters, such as the pound sign or brackets.

False

T/F. The Adjust Margins option is used to change the appearance of a printed worksheet.

False

T/F. The Print Area option is located on View tab of the Ribbon.

False

T/F. The Quick Analysis button provides access to features not included on the Ribbon.

False

T/F. The VLOOKUP and HLOOKUP functions must be used together to work properly.

False

T/F. The Value_IF_False argument is optional in the IF function.

False

T/F. The number 1 represents the default entry for the type argument in PMT, PV, and FV functions.

False

T/F. When a formula is copied, any absolute cell reference in it will change based on the distance between the original and the copied formula.

False

T/F. When protecting a worksheet, you must create a password.

False

T/F. When viewing a worksheet in multiple windows, changes made in one window are not reflected in the other window.

False

T/F. You can set the Print Titles option from the Print menu in Backstage view.

False

T/F. A 2-D chart cannot be rotated.

True

T/F. A mixed cell reference contains a dollar sign in front of the column or row reference, but not both.

True

T/F. A nested IF function contains at least two standard IF functions.

True

T/F. A structured reference includes both brackets and the at symbol.

True

T/F. A table can include both a header row an a total row.

True

T/F. AutoFilter buttons allow you to sort and filter data in a table.

True

T/F. Chart and axis titles display in a new chart when included in the selected data range.

True

T/F. Excel tables allow calculated columns and filtering.

True

T/F. In Excel 2016, the Windows protection option has been disabled.

True

T/F. In Landscape orientation, the page width is longer than the page height.

True

T/F. Macro names CANNOT include spaces.

True

T/F. Records in a table that do not meet applied filtering criteria are hidden from view.

True

T/F. Solver can adjust multiple variables simultaneously.

True

T/F. Sparklines can be thought of as miniature charts appearing in a single cell.

True

T/F. The Freeze Panes option can freeze columns and rows simultaneously.

True

T/F. The Insert Comment command changes to Edit Comment when the selected cell contains a comment.

True

T/F. The Logical_Test must be entered as the first argument in an IF function.

True

T/F. The PMT, PV, and FV functions are displayed in the Financial section of the Insert Function dialog box.

True

T/F. The Protect Sheet commence can be accessed on the Review and Home tabs.

True

T/F. The ROUND function requires the insertion of two arguments in a formula.

True

T/F. The factor variable in a double-declining balance function is optional.

True

T/F. The lookup table must be established before the HLOOKUP function can provide a result.

True

T/F. The range lookup argument in the VLOOKUP function is optional.

True

T/F. When you first create a chart, you can embed it in the current worksheet or place it on a separate worksheet.

True

T/F. You can modify the range of data included in a chart after the chart is created via the Select Data Source dialog box.

True

T/F. You can use F4 to toggle the dollar sign in front of the column or row reference, but not both.

True