Question 1

Figure 1-2 Excel opens a new workbook with three __________ , as shown in the accompanying figure.
A)shakes
B)names
C)worksheets
D)charts

Accepted Answer

Excel opens a new workbook with three worksheets by default, as shown in the accompanying figure.

Question 2

Figure 1-2 In the accompanying figure, the __________, located by default above the Ribbon, provides easy access to frequently used commands.
A)Mini Toolbar
B)Command Toolbar
C)Easy Toolbar
D)Quick Access Toolbar

Accepted Answer

In the accompanying figure, the Quick Access Toolbar, located by default above the Ribbon, provides easy access to frequently used commands.

Question 3

Which key on the keyboard toggles between Insert mode and Overtype mode?
A)Insert
B)Enter
C)Tab
D)Num Lock

Accepted Answer

The Insert key on the keyboard is used to toggle between Insert mode and Overtype mode. When Insert mode is active, any text that is typed will insert itself at the cursor position and push any existing text to the right. When Overtype mode is active, any text that is typed will overwrite any existing text at the cursor position.

Question 4

When you open an Excel file, the application name (Microsoft Excel)is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n)__________.
A)cell
B)row
C)toolbar
D)ScreenTip

Accepted Answer

The ScreenTip feature in Microsoft Office displays the file name when you hover over the application icon on the taskbar.

Question 5

Figure 1-2 In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.
A)Ribbon
B)Menu bar
C)Home tab
D)live preview

Accepted Answer

The Ribbon, located near the top of the Excel window, is the control center in Excel. It contains all the necessary tools and options to work with Excel documents. The Menu bar and Home tab are part of the Ribbon, while Live Preview is a feature of the Ribbon that provides a preview of the formatting options before applying them.

Question 6

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.
A)Author
B)Subject and author
C)Title
D)Standard

Accepted Answer

Standard properties, such as author, title, and subject, are associated with all Microsoft Office documents. These properties help in organizing, searching, and identifying documents.

Question 7

Figure 1-2 In the accompanying figure, the __________ tab is called the primary tab of the Ribbon.
A)Formulas
B)Review
C)Home
D)page

Accepted Answer

The Home tab is generally considered the primary tab of the Ribbon as it contains the most commonly used commands for formatting, editing, and styling of documents. The other tabs, such as Formulas and Review, contain more specialized commands for specific tasks. The Page tab may refer to a context-specific tab for page layout options but is not a primary tab of the Ribbon.

Question 8

Figure 1-1 In the accompanying figure, the __________ identifies the colors assigned to each bar in the chart on a worksheet.
A)color code
B)identifier
C)explanation
D)legend

Accepted Answer

The legend typically identifies the colors or patterns used in a chart or graph in order to explain what each element represents.

Question 9

The __________ button on the Home tab is the only command that clears both the cell entry and the cell formatting.
A)Delete
B)Clear
C)Erase
D)Redo

Accepted Answer

The Clear button on the Home tab has a drop-down menu of options, including Clear All which clears both the cell entry and cell formatting. The Delete button only removes cell entries, while Erase is not a command in Excel, and Redo is a command for undoing the previous action.

Question 10

Figure 1-2 The commands to insert a chart are located on the __________ tab, as shown in the accompanying figure.
A)Fast Chart
B)Home
C)Quick Chart
D)Insert

Accepted Answer

The commands to insert a chart are located on the Insert tab, as shown in the accompanying figure.

Question 11

How many chart types does Excel offer?
A)5
B)11
C)29
D)50

Accepted Answer

Excel offers 11 different chart types including column, line, pie, bar, area, scatter, radar, combo, sunburst, histogram, and waterfall.

Question 12

Figure 1-2 In the accompanying figure, by using the __________ area on the status bar, you easily can obtain a total, an average, or other information about the numbers in a range.
A)AutoCalculate
B)AutoNumbering
C)CalculateNow
D)FastRange

Accepted Answer

The AutoCalculate area on the status bar provides quick access to commonly needed calculations such as totals and averages without having to use formulas or functions.

Question 13

Which keyboard key moves the insertion point to the beginning of data in a cell?
A)Home
B)Enter
C)Insert
D)Tab

Accepted Answer

The Home key moves the insertion point to the beginning of data in a cell. This is a basic function of the Home key on a keyboard.

Question 14

Combining two or more cells together is called __________ cells.
A)merging
B)mixing
C)combining
D)spanning

Accepted Answer

When you merge cells, you combine two or more cells into one larger cell. This is useful for creating headings or combining data from multiple cells into a single cell.

Question 15

What effect does the Comma Style format have on the selected cells?
A)Converts decimals to commas within a cell
B)Converts decimals to commas within merged cells
C)Causes the cells to display with two decimal places and commas as thousands separators
D)Allows for substitution of selected characters

Accepted Answer

The Comma Style format will cause the selected cells to display with two decimal places and commas as thousands separators.

Question 16

What effect does the Accounting Number Format have on the selected cells?
A)Converts alphabetic characters to numbers
B)Causes cells with two decimal places to align vertically correctly
C)Performs tax calculations
D)Copies the numbers of one cell to another

Accepted Answer

The Accounting Number Format applies a currency symbol, comma separators, and parentheses for negative values. It also aligns cells with two decimal places vertically, making the layout look more professional.

Question 17

Figure 1-2 When you click the __________, located in the upper-left corner of the window as shown in the accompanying figure, Excel displays the Office Button menu.
A)Open
B)Office Button
C)Start
D)all of the above

Accepted Answer

The question specifically mentions that clicking the Office Button, located in the upper-left corner of the window, will display the Office Button menu. The other choices (Open and Start) do not directly relate to displaying the Office Button menu.

Question 18

A(n)__________ chart is drawn on the same worksheet as the data.
A)embedded
B)sketch
C)author-signature
D)cell-outline

Accepted Answer

An embedded chart is a chart that is placed on the same worksheet as the data it represents, allowing for a visual representation of the data directly within the worksheet.

Question 19

Dividing a cell into more than one cell is called __________.
A)splitting
B)merging
C)dividing
D)uncoupling

Accepted Answer

Dividing a cell into more than one cell is called splitting. Merging refers to combining two or more cells into one, dividing refers to the process of a single cell dividing into two, and uncoupling is not a term used in cell division.

Question 20

Figure 1-2 In the accompanying figure, the __________ button and __________ button next to the Help icon are used to minimize and restore the worksheet within the Excel window.
A)Collapse, Expand
B)Minimize, Restore
C)Help, Answer
D)Question, Answer

Accepted Answer

The Minimize and Restore buttons are commonly associated with window management and are used to minimize and restore the worksheet within the Excel window. The Collapse and Expand buttons are not used for this purpose. The Help and Question buttons are also not related to window management.

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

Figure 1-2 Excel opens a new workbook with three __________ , as shown in the accompanying figure.

Figure 1-2 In the accompanying figure, the __________, located by default above the Ribbon, provides easy access to frequently used commands.

Which key on the keyboard toggles between Insert mode and Overtype mode?

When you open an Excel file, the application name (Microsoft Excel) is displayed on a selected button on the taskbar. If you point to this button, the file name also appears in a(n) __________.

Figure 1-2 In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.

Figure 1-2 In the accompanying figure, the __________ tab is called the primary tab of the Ribbon.

Figure 1-1 In the accompanying figure, the __________ identifies the colors assigned to each bar in the chart on a worksheet.

The __________ button on the Home tab is the only command that clears both the cell entry and the cell formatting.

Figure 1-2 The commands to insert a chart are located on the __________ tab, as shown in the accompanying figure.

How many chart types does Excel offer?

Figure 1-2 In the accompanying figure, by using the __________ area on the status bar, you easily can obtain a total, an average, or other information about the numbers in a range.

Which keyboard key moves the insertion point to the beginning of data in a cell?

Combining two or more cells together is called __________ cells.

What effect does the Comma Style format have on the selected cells?

What effect does the Accounting Number Format have on the selected cells?

Figure 1-2 When you click the __________, located in the upper-left corner of the window as shown in the accompanying figure, Excel displays the Office Button menu.

A(n) __________ chart is drawn on the same worksheet as the data.

Dividing a cell into more than one cell is called __________.

Figure 1-2 In the accompanying figure, the button and button next to the Help icon are used to minimize and restore the worksheet within the Excel window.