Question 1

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.
A)Ribbon
B)Clipboard
C)Folder
D)File

Accepted Answer

The Clipboard is a temporary storage area in the computer's memory where copied items are stored until they are pasted into a new location. The Ribbon is a user interface element in Microsoft Office applications that contains commands and tools. Folder and File are not relevant to the copy function.

Question 2

Which of the following Auto Fill Options menu options is the same as the Fill Series option?
A)Fill Months
B)Fill Without Formatting
C)Fill Formatting Only
D)Copy Cells

Accepted Answer

Fill Months option allows you to fill the selected cells with the months of the year, which is not the same as Fill Series. Fill Without Formatting and Fill Formatting Only options do not relate to Fill Series either. Copy Cells option copies the selected cells without any filling or auto-complete option, which is also not the same as Fill Series. Therefore, the best choice that is similar to Fill Series is Fill Months.

Question 3

Which of the following patterns extends the fill series to 575,550,525?
A)650,600
B)625,600
C)560,580
D)500,475

Accepted Answer

To get from 600 to 575, you subtract 25. To get from 575 to 550, you subtract 25 again. This pattern of subtracting 25 from each term would continue to get to the next term of the series. Therefore, we need to look for a pattern that subtracts 25 from the previous term. The only choice that fits this pattern is B, where subtracting 25 from 625 gives 600, and subtracting 25 from 600 gives 575. So the next term after 600 would be 575, and the term after that would be 550, which completes the fill series.

Question 4

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.
A)45
B)90
C)0
D)125

Accepted Answer

When you first enter text in a cell, its angle is 0 degrees and it reads from left to right.

Question 5

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.
A)Position
B)Orientation
C)Slope
D)Incline

Accepted Answer

The Orientation area of the Format Cells dialog box controls the angle or orientation of the text within the cell. Entering 90 degrees in this field will rotate the text 90 degrees clockwise, causing it to appear vertically and read from bottom to top within the cell.

Question 6

Which of the following cell contents is extended to Qtr3,Qtr4,and Qtr1 by dragging the fill handle?
A)Quarter 1
B)Qtr1
C)Qtr2
D)Quarter4

Accepted Answer

The answer of Which of the following cell contents is...

Question 7

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.
A)logical
B)constant
C)consistent
D)calculated

Accepted Answer

Using constant values in formulas can lead to errors in calculations and make it difficult to update the worksheet later on. Using cell references allows for easy updates and changes to the data being used in the formula.

Question 8

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.
A)button
B)check box
C)option button
D)Dialog Box Launcher

Accepted Answer

The Dialog Box Launcher is a small arrow in the bottom right corner of the Font, Alignment, Number, or Border sections in the Home tab of the Ribbon. Clicking on this arrow opens a dialog box with more advanced formatting options, including the Alignment sheet.

Question 9

The ____ Auto Fill Option that fills the destination area using the format of the source area;no content is filled.
A)Copy Cells
B)Fill Formatting Only
C)Fill Without Formatting
D)none of the above

Accepted Answer

The option "Fill Formatting Only" is the correct choice as it fills only the format of the source area without filling any content. This is useful when you want to apply the same formatting to a different set of data without changing the content. The other options, "Copy Cells" and "Fill Without Formatting", do not match the described behavior.

Question 10

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.
A)View
B)Preview
C)Display
D)Zoom

Accepted Answer

The Zoom slider on the status bar allows users to adjust the display size of the worksheet, making entries more readable without having to adjust the size of individual cells.

Question 11

____ text often provides a strong visual appeal.
A)Launched
B)Tiny
C)Logical
D)Rotated

Accepted Answer

The answer of ____ text often provides a strong visual...

Question 12

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.
A)Alignment
B)Left and Right
C)Center
D)Position

Accepted Answer

The Alignment sheet in the Format Cells dialog box allows you to position data in a cell by centering it or aligning it to the left or right. The Position sheet is not a valid option, as it is not available in the Format Cells dialog box.

Question 13

Using the mouse to move or copy cells is called ____.
A)drop and drag
B)drag and drop
C)drag and copy
D)drag and paste

Accepted Answer

The correct terminology is "drag and drop" when using the mouse to move or copy cells in a spreadsheet program like Microsoft Excel. The term "drop and drag" and "drag and copy" are not commonly used or recognized. And "drag and paste" is not a valid term as "pasting" refers to a separate action that occurs after dragging or copying cells.

Question 14

-In the accompanying figure,the split double arrow mouse pointer ____.
A)indicates a hidden column
B)allows text to be entered at that location
C)is the result of moving the mouse pointer to the boundary between column heading A and column heading B
D)indicates the proposed width of column A

Accepted Answer

The split double arrow mouse pointer appears when the mouse is moved to the boundary between two column headings, indicating that you can adjust the column width by dragging the boundary.

Question 15

Which of the following is the path to the Insert Cells arrow?
A)(HOME tab | Editing group)
B)(HOME tab | Number group)
C)(HOME tab | Cells group)
D)(HOME tab | Inserting group)

Accepted Answer

The Insert Cells arrow can be found in the Cells group of the HOME tab in Microsoft Excel.

Question 16

Which of the following is the path to the Increase or Decrease Indent button?
A)(HOME tab | Clipboard group)
B)(HOME tab | Editing group)
C)(HOME tab | Alignment group)
D)(HOME tab | Number group)

Accepted Answer

The Increase or Decrease Indent button is located in the Alignment group on the HOME tab of the Microsoft Word Ribbon.

Question 17

Which of the following is an extension of the fill pattern Sunday,Tuesday?
A)Wednesday,Thursday,Saturday
B)Thursday,Saturday,Monday
C)Saturday,Sunday,Monday
D)Monday,Wednesday,Friday

Accepted Answer

The pattern is skipping one day between each day mentioned. Starting from Sunday, skipping Monday to Tuesday, then skipping two days to Thursday, then skipping two days to Saturday, and finally skipping two days to Monday.

Question 18

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.
A)ENTER
B)ALT
C)CTRL
D)SHIFT

Accepted Answer

Pressing the ENTER key after selecting a range of cells to copy and then selecting a nonadjacent location to paste them into is an alternative to clicking the Paste button.

Question 19

Cell references in a formula are called ____.
A)assumptions
B)comments
C)numbers
D)content

Accepted Answer

Cell references in a formula are called assumptions. They are the values that the formula is based on and can be changed to see how the formula reacts to different inputs.

Question 20

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
A)two
B)three
C)four
D)five

Accepted Answer

The Increase Indent button indents the contents of a cell to the right by two spaces each time you click it.

Quiz 9: Excel: Working With Large Worksheets, Charting, and What-If Analysis

The Copy button copies the contents and format of the source area to the Office ____,a temporary storage area in the computer's memory.

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

Which of the following patterns extends the fill series to 575,550,525?

When you first enter text,its angle is ____ degrees,and it reads from left to right in a cell.

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box,the text will appear vertically and read from bottom to top in the cell.

Which of the following cell contents is extended to Qtr3,Qtr4,and Qtr1 by dragging the fill handle?

When you set up a worksheet,you should use cell references in formulas whenever possible,rather than ____ values.

To open the Format Cells dialog box with the Alignment sheet active,tap or click the Alignment Settings ____.

The ____ Auto Fill Option that fills the destination area using the format of the source area;no content is filled.

After shrinking entries to fit in cells,consider using the ____ slider on the status bar to make the entries more readable.

____ text often provides a strong visual appeal.

You use the ____ sheet in the Format Cells dialog box to position data in a cell by centering it,for example.

Using the mouse to move or copy cells is called ____.

-In the accompanying figure,the split double arrow mouse pointer ____.

Which of the following is the path to the Insert Cells arrow?

Which of the following is the path to the Increase or Decrease Indent button?

Which of the following is an extension of the fill pattern Sunday,Tuesday?

In the context of copying a range of cells to a nonadjacent location,an alternative to clicking the Paste button is to press the ____ key.

Cell references in a formula are called ____.

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.