Question 1

Figure 1-3 In the accompanying figure, a requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

Accepted Answer

The figure shows a requirements document with sections for needs statement, source of data, summary of calculations, and other special requirements. Therefore, the statement is true.

Question 2

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

Accepted Answer

If a major error is made when typing data into a cell, clicking the Cancel box in the formula bar or pressing the ESC key will erase the entire entry, allowing you to reenter the data from the beginning.

Question 3

Figure 1-2 To the right of the sheet tabs at the bottom of the screen, as shown in the accompanying figure, is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs.

Accepted Answer

The statement is correct.

Question 4

To use the AutoCalculate area, select the range of cells containing the numbers you want to check and then double-click the AutoCalculate area to display the Status Bar Configuration shortcut menu.

Accepted Answer

To use the AutoCalculate area, you simply need to select the range of cells containing the numbers you want to check, and the AutoCalculate result (such as sum, average, etc.) will automatically appear in the status bar at the bottom of the Excel window. You don't need to double-click the AutoCalculate area; instead, you might right-click on the status bar to customize which calculations you want to see.

Question 5

When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area.

Accepted Answer

That is correct. The range of cells receiving the copy is called the destination area or paste area.

Question 6

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

Accepted Answer

When text is longer than the width of a cell or column, Excel displays the overflow characters in adjacent cells to the right. This is known as text wrapping.

Question 7

To identify a cell, specify the row number first, followed by the column letter.

Accepted Answer

To identify a cell in spreadsheets like Microsoft Excel, you specify the column letter first, followed by the row number (e.g., A1, B2).

Question 8

Excel automatically selects the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart, also called the x-axis or category axis.

Accepted Answer

Excel does automatically select the topmost row as the titles for the horizontal axis of a chart.

Question 9

Excel can display characters in only three font colors: black, red, and blue.

Accepted Answer

Excel supports a wide range of font colors, not limited to black, red, and blue, allowing users to choose from a vast color palette for their text.

Question 10

All commands on the Mini toolbar also exist on the Ribbon.

Accepted Answer

All commands on the Mini toolbar are also available on the Ribbon, so it is true that they exist on both.

Question 11

Figure 1-2 In the accompanying figure, mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel.

Accepted Answer

The answer of  Figure 1-2 In the accompanying figure,...

Question 12

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

Accepted Answer

When the Sum button is clicked, Excel automatically assigns the SUM function to each cell in the selected range, regardless of whether it is next to a row of numbers or not.

Question 13

With the range to chart selected, click the Column button on the Ribbon tab to initiate drawing a chart.

Accepted Answer

Clicking the Column button on the Ribbon tab will initiate drawing a chart with the selected range.

Question 14

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

Accepted Answer

This is true, additional worksheets can be added to a workbook as long as the computer has enough memory to handle them.

Question 15

If you save a workbook and then quit Excel, all Excel windows close.

Accepted Answer

When you save a workbook and then quit Excel, all Excel windows close.

Question 16

Figure 1-4 In the accompanying figure, when a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color.

Accepted Answer

When a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color.

Question 17

To use the Name box to select any cell, click the Name box and enter the cell reference of the cell you want to select.

Accepted Answer

This is true, as you can use the Name box in Microsoft Excel to select any cell by entering its cell reference.

Question 18

Text entered in a cell cannot be realigned.

Accepted Answer

Text entered in a cell can be realigned using alignment options such as left, center, right, top, middle, and bottom alignment in spreadsheet programs like Microsoft Excel or Google Sheets.

Question 19

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

Accepted Answer

These entries are all composed of alphanumeric characters which make them text.

Question 20

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

Accepted Answer

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

Quiz 8: Excel: Creating a Worksheet and an Embedded Chart

Figure 1-3 In the accompanying figure, a requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

Figure 1-2 To the right of the sheet tabs at the bottom of the screen, as shown in the accompanying figure, is the tab split box, which can be dragged to increase or decrease the view of the sheet tabs.

To use the AutoCalculate area, select the range of cells containing the numbers you want to check and then double-click the AutoCalculate area to display the Status Bar Configuration shortcut menu.

When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area.

When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right.

To identify a cell, specify the row number first, followed by the column letter.

Excel automatically selects the entries in the topmost row of a chart range as the titles for the horizontal axis of a chart, also called the x-axis or category axis.

Excel can display characters in only three font colors: black, red, and blue.

All commands on the Mini toolbar also exist on the Ribbon.

Figure 1-2 In the accompanying figure, mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel.

If each cell in a selected range is next to a row of numbers, Excel assigns the SUM function to each cell in the selected range when the Sum button is clicked.

With the range to chart selected, click the Column button on the Ribbon tab to initiate drawing a chart.

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

If you save a workbook and then quit Excel, all Excel windows close.

Figure 1-4 In the accompanying figure, when a color is chosen on the Font Color palette, Excel changes the Font Color button on the Formatting toolbar to the chosen color.

To use the Name box to select any cell, click the Name box and enter the cell reference of the cell you want to select.

Text entered in a cell cannot be realigned.

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.