Excel for Accounting Midterm
What can Format Painter copy? A. Values B. Formulas C. Text D. Formatting
D
When using Find and Replace to locate a cell format, which of these CANNOT be used to populate the format within the Find now? A. Copying an existing cell forma within the worksheet B. Manually selecting the number type from a variety of options C. Manually selecting the font size and type from a variety of options. D. Copying a previously changed cell format that was originally part of the worksheet.
D
When would you NOT use the Option button on the Replace tab in the Find and Replace window? A. When locating cell contents within a specific cell formats B. When replacing specific cell formats C. When locating cell contents with a specific case D. When replacing specific cell contents
D
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
Which of these in NOT displayed for a range by default within the status bar? A. Average B. Count (of values) C. Sum D. Maximum
D
Which of these is NOT a conditional formatting rule type in the New Formatting Rule dialog box? A. Format only cell that contain B. Format only top or bottom-ranked values C. Format only unique or duplicate values D. Format only text entries
D
Which of these is NOT an area displayed in the PivotTable Fields task pane? A. Filters B. Rows C. Values D. Axis
D
Which of these is a correctly written cell reference? A. 2C B. 34 C. AG D. D7
D
Which of these will NOT result in only a portion of a worksheet being printed? A. Setting the print are from the Ribbon B. Choosing Print Selection in Backstage view C. Selecting only certain pages to print in Backstage view D. Changing the orientation from the Ribbon
D
which key CANNOT be used to complete an entry and move to a new cell? A. Enter B. Tab C. Arrow Key D. Esc.
D
A bank reconciliation contains both an "add" and "deduct" section within each of its three sides. True or fale
False
A cell entry can only be indented if it is left-aligned True or False
False
A circular reference will not prevent excel from displaying the result of the formula in which it appears. True or false
False
A hidden row will appear when the worksheet is printed. True or False
False
A relative cell reference in a formula will not change when the formula is copied. True or false
False
All vertical alignment options are accessed directly on the Ribbon. True or False
False
By default, text entries are right-aligned and number entries are left-aligned. True or False
False
CONCATENATE is used to divide a single cell entry across multiple cells. True or false
False
Conditional formatting is not retained when a copy of a worksheet is created. True or false
False
Conditional formatting should be used carefully, as it cannot be removed once applied. True or False
False
Data used to create a PivotTable must be contained within a table. True or False
False
Drag and drop cannot be used to import data or a worksheet. True or false
False
Find and Replace can be used to replace both cell content and cell formats. True or false
False
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. True or false
False
Neither row A nor column 1 can be hidden. True or False
False
Print Preview can be accessed via the Home tab. True or false
False
The AutoSum button can be used only to create formulas with SUM. True or False
False
The Merge & Center command can be used to merge individual rows of data simultaneously. True or False
False
The Undo button can be used to reverse every action in Excel. True or false
False
The only way to filter PivotTable data is via a slicer. True or False
False
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. True or false
False
When using drag and drop, a menu of options appears. True or false
False
When you delete cells, you must indicate how surrounding cells should shift. True or False
False
When you use the Enter button on the Formula Bar to complete a cell entry , the highlight moves one row down. True or false
False
With Find and Replace, each instance of the item entered in the Find box must be replaced individually. True or false
False
You must double-click Format Painter in order to apply formatting to a cell. True or false
False
You must use capital letters when typing cell references in formulas. True or False
False
A .csv file is referred to as a comma-delimited file. True or false
True
A PivotTable is a summary of worksheet data that can be arranged in a variety of ways. True or False
True
A formula can be edited in the Formula Bar or by double-clicking the formula cell. True or false
True
A function is a pre-written formula built into Excel. True or False
True
A negative number can be indicated through the use of a minus sign or parentheses. True or false
True
AutoFill copies a formula from one cell to another. True or False
True
Both the header and footer areas of a worksheet are separate into three sections. True or false
True
By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference. True or false
True
Flash fill provides suggestions for cell entries based on previously entered data. True or False
True
If you don't see your desired Quick Style in the cell styles menu, you can create a custom style. True or False
True
The Arrange All option can be used to display two windows side by side. True or fale
True
The Paste option can be executed from the Ribbon or via a keyboard shortcut. True or false
True
The Quick Access toolbar can be customized to include options such as Quick Print True or false
True
The deletion of a worksheet cannot be reversed with Undo. True or False
True
The most recently selected border option is displayed on the Border button on the Ribbon. True or False
True
The two orientation options are portrait and landscape. True or False
True
The weighted average inventory method results in inventory cost that fall between those arrived at through the use of LIFO and FIFO. True or False
True
Using tab to complete a cell entry moves the active cell one column to the right. True or false
True
When a PivotChart is updated, the associated PivotTable is also automatically updated. True or False
True
When a circular reference is included within a formula, a warning message is displayed. True or false
True
When a rotation option is applied, row height automatically adjusts to fit the rotated cell entry. True or False
True
When an amount is changed within a cell that is referenced in a formula, the result of the formula updates accordingly. True or false
True
You can create multiple rules with the Conditional Formatting Rules Manager. True or false
True
The Quick Print button can be added to: A. the Quick Access toolbar B. the Home tab C. Backstage view D. an individual cell within the worksheet
A
The acronym LIFO stands for: A. Last in, first out B. Last in, function off C. Least in, first out D. Least in, function off
A
The cell styles option appears on the _________ tab of the Ribbon. A. Home B. Insert C. Data D. View
A
The formula =H3+J4 in cell A1 is copied to cell A2. How will the formula appear in cell A2? A. =H4+J5 B. =I3+K4 C. =H4+J4 D. =I3+J5
A
When a merge command is applied, the new merged cell takes on the name of which former cell? A. The cell formerly located in the top left of the merged area. B. The cell formerly located in the top right of the merged area. C. The cell formerly located in the bottom left of the merged area. D. The cell formerly located in the bottom right of the merged area.
A
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
Which of these CANNOT be used to move the contents of one cell to another location? A. Undo and Redo B. Cut and Paste C. Drag and drop C. Right-dragging
A
Which of these does NOT appear in a slicer? A. Label filters B. Field name C. Multi-Select button D. Clear Filter button
A
Which of these is NOT a footer section? A. Top B. Left C. Right D. Center
A
Which of these is NOT a horizontal alignment option? A. Middle B. Left C. Right D. Center
A
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
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
For which of these functions must the Character Start Number be identified? A. Left B. MID C. Right D. CONCATENATE
B
Long text entries: A. cannot be made to fit within a single column B. initially extend beyond the right border of the cell in which they are entered. C. will always cover the contents of the cell to the right. D. must be shortened before complete the entry.
B
The Redo button becomes visible only after doing what? A. Pasting cell content B. Using Undo C. Copying cell contents D. Typing a number within a cell
B
When a new formula is entered into a cell that already contains a formula, what happens to the original formula? A. It is retained, while the new formula is disregarded. B. It is deleted C. It is added to the beginning of the new formula D. It is added to the end of the new formula
B
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
When the Increase Indent command is applied, the cell entry: A. is always indented from the right edge of the cell. B. is indented from the right or left edge of the cell, depending on the type of entry. C. is always indented from the left edge of the cell. D. None of these; the user chooses how to indent.
B
Which action CANNOT be taken from the Home tab? A. Bold B. Right-dragging C. Italic D. Underline
B
Which element of a worksheet tab CANNOT be changed? A. Name B. Height C. Location D. Color
B
Which items appear on the bank side of a bank reconciliation? A. Notes receivable collected by bank B. Outstanding checks C. NSF checks D. Bank charges
B
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
Which of these is NOT an operator that can be used within a formula? A. * B. @ C. ) D. /
B
Which of these is NOT displayed in Backstage view? A. Print Preview B. The Ribbon C. The Print button D. Print Settings
B
Which of these options does NOT appear on the Fill Color menu? A. Theme Colors B. Gradient Colors C. Standard Colors D. More Colors
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
Which tab appears when a section of the header is activated? A. Formulas B. Design C. Data D. References
B
A circular reference occurs when a formula refers: A. to its own cell. B. to another formula that refers to the cell in which the original formula is written. C. to both its own cell and to another formula that refers to the cell in which the original formula is written. D. None of these options
C
How can you open the Office Clipboard? A. Copy a cell or range B. Paste a cell or range C. Click the dialog box launcher in the Clipboard group D. Click the dialog box launcher in the Font group
C
How is a line break applied? A. Ctrl + Enter B. Ctrl + Shift C. Alt + Enter D. Alt + Shift
C
The Conditional Formatting Rule Manager allows for all of the following to be done to conditional formatting rules EXEPT: A. Creating B. Editing C. Combining D. Deleting
C
The Increase Indent button is displayed within which group on the Home tab? A. Clipboard B Font C. Alignment D. Number
C
Under Which tab is the Insert Function button located? A. Home B. Insert C. Formulas D. Data
C
What does a single bottom border withing a financial statement indicates? A. The move figures is the final figure within the statement. B. The above figure should be examined closely by management. C. A calculation is being performed on the figures above the border. D. The below figure is the final figure within the statement.
C
When a formula is selected for editing, what happens to the cell references in the formula so they can be tracked to their respective location with in the worksheet? A. Their size is altered B. They appear in bold C. They are color-coded D. They are italicized
C
When using Arrange All, windows can be oriented in each way EXCEPT: A. Vertically B. Tiled C. Diagonally D. Cascade
C
Which of these actions CANNOT be reversed with Undo? A. Italic B. Paste C. Save D. Bold
C
Which of these is NOT a conditional formatting option? A. Data bars B. Color scales C. Slicers D. Icon sets
C
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. Formula tab D. Associated slicers
C
Which statement best describes the impact on relative cell reference in a formula being copied and pasted? A. The cell reference appears identical to those within the copied formula. B. Only the portion of the cell references (letter) may change in the copied formula. C. The cell reference will update based on the distance between the location of the original formula and the new formula. D. Only the row portion of the cell references (number) may change in the copied formula
C
