Question 1

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.
A) ALT
B) ESC
C) CTRL
D) TAB

Accepted Answer

To erase an entire entry in a cell and then reenter the data from the beginning, press the ESC key. This will clear the cell's contents and allow you to start fresh with new data.

Question 2

Which of the following is the Ribbon path to the Cell Styles button?
A) (HOME tab | Styles group)
B) (STYLES tab | Home group)
C) (HOME tab | Format group)
D) (FORMAT tab | Styles group)

Accepted Answer

The Cell Styles button is located in the Styles group under the HOME tab in the ribbon.

Question 3

Press ____ to select the entire worksheet.
A) F1
B) CTRL+A
C) ALT+A
D) F4

Accepted Answer

CTRL+A is the keyboard shortcut used to select the entire worksheet. F1 is used to open the help dialog box, ALT+A is used to open the Data tab, and F4 is used to repeat the last action.

Question 4

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

Accepted Answer

The Accounting Number Format displays cell contents with two decimal places that align vertically and adds a currency symbol and parentheses around negative numbers.

Question 5

Pressing the ____ keyboard shortcut key(s) selects cell A1.
A) CTRL+HOME
B) CTRL+END
C) HOME
D) END

Accepted Answer

Pressing CTRL+HOME takes the user to the top-left cell of the worksheet, which is A1.

Question 6

Combining two or more selected cells into one cell is called ____ cells.
A) merging
B) mixing
C) combining
D) spanning

Accepted Answer

Merging cells is the process of combining two or more selected cells into a single cell. This is commonly used in formatting tables or creating a more visually appealing layout. Mixing, combining, and spanning are not commonly used terms for this action in spreadsheet software.

Question 7

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

Accepted Answer

The answer of How many chart types does Excel offer?
A)...

Question 8

Excel remembers the last ____ actions you have completed.
A) 25
B) 50
C) 75
D) 100

Accepted Answer

Excel remembers the last 100 actions you have completed, which can be useful for undoing mistakes or repeating actions.

Question 9

Which of the following keys 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.

Question 10

The ____ button allows you to erase recent cell entries.
A) Undo
B) Cell Style
C) Bold
D) Increase Decimal

Accepted Answer

The Undo button allows you to undo the most recent action, which includes erasing recent cell entries. The other options listed do not have anything to do with erasing cell entries.

Question 11

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
A) ALT+B
B) CTRL+B
C) SHIFT+B
D) TAB+B

Accepted Answer

The correct keyboard shortcut to apply Bold font style is CTRL+B.

Question 12

____ properties are associated with all Microsoft Office files and include author, title, and subject.
A) Automatic
B) Hidden
C) Replacement
D) Standard

Accepted Answer

Standard properties are associated with all Microsoft Office files and include author, title, and subject.

Question 13

Which of the following keys moves the insertion point to the end of data in a cell?
A) HOME
B) DELETE
C) END
D) BACKSPACE

Accepted Answer

The END key moves the insertion point to the end of data in a cell. The HOME key moves the insertion point to the beginning of the data in a cell. The DELETE key removes the character to the right of the insertion point. The BACKSPACE key removes the character to the left of the insertion point.

Question 14

If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.
A) ACCESS
B) TOOLS
C) EXIT
D) FILE

Accepted Answer

The correct choice is FILE, as it is the option on the ribbon that opens the Backstage view. The other choices (ACCESS, TOOLS, and EXIT) do not open the Backstage view.

Question 15

You use ____ to view an XPS file.
A) Adobe Reader
B) Backstage View
C) Microsoft PowerView
D) XPS Viewer

Accepted Answer

XPS Viewer is a program developed by Microsoft that allows users to view XPS files on their computer. Adobe Reader, Backstage View, and Microsoft PowerView are not specific programs designed for viewing XPS files.

Question 16

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.
A) AutoFormat
B) AutoComplete
C) AutoFunction
D) AutoCalculate

Accepted Answer

The AutoCalculate area on the status bar includes six commands and displays the result of the associated calculation on the right side of the menu.

Question 17

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.
A) exploded
B) outer
C) offset
D) rasterized

Accepted Answer

A pie chart with one or more slices offset is commonly called an "exploded" pie chart. This term refers to the fact that the slices appear to have exploded away from the center of the chart, creating more space and visual separation between them.

Question 18

Which of the following keys toggles between Insert mode and Overtype mode?
A) INSERT
B) ENTER
C) TAB
D) ALT

Accepted Answer

The INSERT key toggles between Insert mode and Overtype mode.

Question 19

The date you change a file is an example of a(n) ____ property.
A) automatically updated
B) baseline
C) standard
D) indexed

Accepted Answer

The date a file is changed is automatically updated by the operating system and is not a set standard or baseline. It is also not indexed, as indexing usually refers to the organization of data for efficient searching, rather than a property of a single file.

Question 20

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) Displays cell contents with two decimal places and commas as thousands separators
D) Allows for substitution of selected characters

Accepted Answer

The Comma Style format displays cell contents with two decimal places and commas as thousands separators. This is useful for financial data or other large numbers where it is important to quickly visualize the magnitude of the value.

Quiz 2: Creating a Worksheet and a Chart

To erase an entire entry in a cell and then reenter the data from the beginning, press the ____ key.

Which of the following is the Ribbon path to the Cell Styles button?

Press ____ to select the entire worksheet.

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

Pressing the ____ keyboard shortcut key(s) selects cell A1.

Combining two or more selected cells into one cell is called ____ cells.

How many chart types does Excel offer?

Excel remembers the last ____ actions you have completed.

Which of the following keys moves the insertion point to the beginning of data in a cell?

The ____ button allows you to erase recent cell entries.

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.

____ properties are associated with all Microsoft Office files and include author, title, and subject.

Which of the following keys moves the insertion point to the end of data in a cell?

If you wish to sign out of your Microsoft account, tap or click ____ on the ribbon to open the Backstage view and then tap or click the Account tab to display the Account gallery, and tap or click the Sign out link.

You use ____ to view an XPS file.

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart.

Which of the following keys toggles between Insert mode and Overtype mode?

The date you change a file is an example of a(n) ____ property.

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