Excel for Accounting-Midterm

When using Find and Replace to locate a cell format, which of these CANNOT be used to populate the format within the Find row?

Copying a previously changed cell format that was originally part of the worksheet

T/F: A bank reconciliation contains both an add and a deduct section within each of its three sides.

False

T/F: A circular reference will not prevent Excel from displaying the result of the formula in which it appears.

False

T/F: A hidden row will appear when the worksheet is printed.

False

T/F: A relative cell reference in a formula will not change when the formula is copied to another cell.

False

T/F: All vertical alignment options are accessed directly on the Ribbon.

False

T/F: By default, text entries are right-aligned and number entries are left-aligned

False

T/F: CONCATENATE is used to divide a single cell entry across multiple cells.

False

T/F: Conditional formatting is not retained when a copy of a worksheet is created.

False

T/F: Conditional formatting should be used carefully, as it cannot be removed once applied.

False

T/F: Data used to create a PivotTable must be contained within a table.

False

T/F: Drag and drop cannot be used to import data to a worksheet.

False

T/F: If the cell to the right of a long text entry is in use, the long text entry will cover the contents of this adjacent cell.

False

T/F: Neither row A nor column 1 can be hidden.

False

T/F: Print Preview can be accessed via the Home tab.

False

T/F: The AutoSum button can be used only to create formulas with SUM.

False

T/F: The Merge & Center command can be used to merge individual rows of data simultaneously.

False

T/F: The Undo button can be used to reverse every action in Excel.

False

T/F: The only way to filter PivotTable data is via a slicer.

False

T/F: When entering the date or time in a header, the appropriate code cannot be entered via a selection on the Ribbon; it must be typed out.

False

T/F: When using drag and drop, a menu of options appears.

False

T/F: When you use the Enter button on the Formula Bar to complete a cell entry, the highlight moves one row down.

False

T/F: With Find and Replace, each instance of the item entered in the Find box must be replaced individually.

False

T/F: You must double-click Format Painter in order to apply formatting to a cell.

False

T/F: You must use capital letters when typing cell references in formulas.

False

What can Format Painter copy?

Formatting

The cell styles option appears on the _____ tab of the Ribbon.

Home

When a new formula is entered into a cell that already contains a formula, what happens to the original formula?

It is deleted

The acronym LIFO stands for:

Last in, first out

When a merge command is applied, the new merged cell takes on the name of which former cell?

The cell formerly located in the top left of the merged area

Which statement best describes the impact on relative cell references in a formula being copied and pasted?

The cell references will update based on the distance between the location of the original formula and the new formula

When a formula is selected for editing, what happens to the cell references in the formula so they can be tracked to their respective locations within the worksheet?

They are color-coded

T/F: A .csv file is referred to as a comma-delimited file.

True

T/F: A formula can be edited in the Formula Bar or by double-clicking the formula cell

True

T/F: A function is a prewritten formula built into Excel.

True

T/F: A negative number can be indicated through the use of a minus sign or parentheses.

True

T/F: AutoFill copies a formula from one cell to another.

True

T/F: Both the header and footer areas of a worksheet are separated into three sections.

True

T/F: By default, when a cell reference is first included in a formula (so that only the column and row references are included), it is displayed as a relative cell reference.

True

T/F: Find and Replace can be used to replace both cell contents and cell formats.

True

T/F: Flash fill provides suggestions for cell entries based on previously entered data.

True

T/F: The Arrange All option can be used to display two windows side by side.

True

T/F: The Paste option can be executed from the Ribbon or via a keyboard shortcut.

True

T/F: The Quick Access toolbar can be customized to include options such as Quick Print.

True

T/F: The deletion of a worksheet cannot be reversed with Undo.

True

T/F: The most recently selected border option is displayed on the Border button on the Ribbon.

True

T/F: The two orientation options are portrait and landscape.

True

T/F: The weighted average inventory method results in inventory costs that fall between those arrived at through the use of LIFO and FIFO.

True

T/F: Using [Tab] to complete a cell entry moves the active cell one column to the right.

True

T/F: When a PivotChart is updated, the associated PivotTable is also automatically updated.

True

T/F: When a circular reference is included within a formula, a warning message is displayed.

True

T/F: When a rotation option is applied, row height automatically adjusts to fit the rotated cell entry.

True

T/F: When you delete cells, you must indicate how surrounding cells should shift.

True

T/F: You can create multiple rules with the Conditional Formatting Rules Manager.

True

T/F:When an amount is changed within a cell that is referenced in a formula, the result of the formula updates accordingly.

True

Which of these CANNOT be used to move the contents of one cell to another location?

Undo and Redo

When would you NOT use the Options button on the Replace tab in the Find and Replace window?

When replacing specific cell contents

How is a line break applied?

[Alt]+[Enter]

What does a single bottom border within a financial statement indicate?

a calculation is being performed on the figures above the border

Which of these CANNOT be used to insert external data in a worksheet? a. format painter b. copy and paste c. drag and drop d. importing a file

a. format painter

Which of these does NOT appear in a slicer? a. label filters b. field name c. multi-select button d. clear filter button

a. label filters

Which of these is NOT an option associated with the AutoFill button? a. paste cells b. copy cells c. fill formatting only d. fill without formatting

a. paste cells

Which of these is NOT a footer section? a. top b. left c. right d. center

a. top

The Increase Indent button is displayed within which group on the Home tab?

alignment

Which of these formulas contains a nested function? a. =MAX(A1:C7) b. =CONCATENATE(LEFT(A6, 2), " item") c. =MIN(D8:R13)+SUM(A3, A7) d. =AVERAGE(45, C2:E2)*20

b. =CONCATENATE(LEFT(A6, 2), " item")

Which of these is NOT an operator that can be used within a formula? a. * b. @ c. ) d. /

b. @

Which of these options is NOT available on the Merge & Center menu on the Ribbon? a. merge & center b. center c. merge across d. unmerge cells

b. center

Which of these options does NOT appear on the Fill Color menu? a. theme colors b. gradient colors c. standard colors b. more colors

b. gradient

Although each of these functions can be accessed via the AutoSum menu (under More Functions), which one IS NOT listed on the AutoSum menu itself? a. average b. left c. max d. min

b. left

For which of these functions must the Character Start Number be identified? a. LEFT B. MID C. RIGHT D. CONCATENATE

b. mid

Which items appear on the bank side of a bank reconciliation? a. Note receivable collected by bank b. outstanding checks c. NSF checks d. Bank charges

b. outstanding checks

Which action CANNOT be taken from the Home tab? a. bold b. right-dragging c. italic d. underline

b. right-dragging

When right-clicking to insert cells, which option does NOT appear? a. entire column b. shift cells up c. shift cells right d. entire row

b. shift cells up

Which of these is NOT a conditional formatting rule type in the New Formatting Rule dialog box? a. Format only cells that contain b. Format only top- or bottom-ranked values c. Format only unique or duplicate values d. Format only text entries

c. Format only text entries

The Conditional Formatting Rules Manager allows for all of the following to be done to conditional formatting rules EXCEPT: a. creating b. editing c. combining d. deleting

c. combining

When using Arrange All, windows can be oriented in each way EXCEPT: a. vertically b. tiled c. diagonally d. cascade

c. diagonally

Which of these is NOT a location where a PivotChart may be filtered? a. AutoFilter buttons on the chart b. AutoFilter buttons on the associated PivotTable c. Formulas Tab d. associated slicers

c. formulas tab

Which of these actions CANNOT be reversed with Undo? a. italic b. paste c. save d. bold

c. save

Which of these is NOT a conditional formatting option? a. data bars b. color scales c. slicers d. icon sets

c. slicers

Which of these is a correctly written cell reference? a. 2C b. 34 c. 34 d. D7

d. D7

Which key CANNOT be used to complete an entry and move to a new cell? a. enter b. tab c. Ai d. esc

d. Esc

Which of these is NOT an area displayed in the PivotTable Fields task pane? a. filters b. rows c. values d. axis

d. axis

Which items can appear on either side (bank and book) of a bank reconciliation? a. NSF checks b. deposits in transit c. outstanding checks d. errors

d. errors

Which of these is NOT displayed for a range by default within the status bar? a. average b. count (of values) c. sum d. maximum

d. maximum

Under which tab is the Insert Function button located?

formulas

Which element of a worksheet tab CANNOT be changed?

height

Long text entries:

initially extend beyond the right border of the cell in which they are entered

When the Increase Indent command is applied, the cell entry:

is indented from the right or left edge of the cell, depending on the type of entry

Which of these is NOT a horizontal alignment option? a. middle b. left c. right d. center

middle

The Quick Print button can be added to:

the quick access toolbar

Which of these is NOT displayed in Backstage view?

the ribbon

A circular reference occurs when a formula refers:

to both its own cell and to another formula that refers to the cell in which the original formula is written

T/F: A PivotTable is a summary of worksheet data that can be arranged in a variety of ways.

true

T/F: If you do not see your desired Quick Style in the cell styles menu, you can create a custom style.

true

The Redo button becomes visible only after doing what?

using undo

Which tab appears when a section of the header is activated? a. formulas b. design c. data d. references

. design

The formula =H3+J4 in cell A1 is copied to cell A2. How will the formula appear in cell A2?

=H4+J5

T/F: A cell entry can only be indented if it is left-aligned.

A cell entry can only be indented if it is left-aligned.

Which of these will NOT result in only a portion of a worksheet being printed?

Changing the orientation from the ribbon

How can you open the Office Clipboard?

Click the dialog box launcher in the clipboard group