Question 1

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

Accepted Answer

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

Question 2

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.

Accepted Answer

To access the Backstage view in Microsoft applications, we need to click on the File option on the ribbon. Therefore, the best choice is D) FILE.

Question 3

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.

Accepted Answer

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

Question 4

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

Accepted Answer

The Comma Style format displays cell contents with two decimal places and commas as thousands separators.

Question 5

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

Accepted Answer

The process of combining two or more selected cells into one cell is called "merging." This is commonly used in spreadsheet programs like Excel to create larger cells that span multiple columns or rows. "Mixing" and "combining" may also be used to describe this process, but "merging" is the most widely accepted term. "Spanning" refers to a cell or range of cells that covers a specific area, but does not necessarily involve combining multiple cells into one.

Question 6

Press ____ to select the entire worksheet.

Accepted Answer

CTRL+A is the shortcut to select the entire worksheet. A, C, and D are incorrect options.

Question 7

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

Accepted Answer

The date a file is changed is automatically updated, making it an example of an automatically updated property. This information can be useful in determining the age and relevance of the file.

Question 8

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

Accepted Answer

Pressing the ESC key will clear the entire entry in a cell and allow the user to start again from the beginning. The other keys listed (ALT, CTRL, TAB) do not have this function.

Question 9

How many chart types does Excel offer?

Accepted Answer

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

Question 10

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

Accepted Answer

An exploded pie chart is one where one or more slices are separated from the rest of the chart for emphasis or clarity. This is also commonly referred to as a "3D pie chart" or "detached slice pie chart."

Question 11

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

Accepted Answer

The Cell Styles button is located in the Styles group of the HOME tab in the Ribbon. Therefore, the correct path is (HOME tab | Styles group).

Question 12

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

Accepted Answer

The INSERT key toggles between Insert mode and Overtype mode in most text editors and word processors.

Question 13

You use ____ to view an XPS file.

Accepted Answer

XPS Viewer is the specific application designed by Microsoft to view XPS (XML Paper Specification) files. Other applications, such as Adobe Reader, may be able to display XPS files, but XPS Viewer is the best choice for guaranteed compatibility and optimal viewing experience.

Question 14

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

Accepted Answer

The HOME key moves the insertion point to the beginning of data in a cell.

Question 15

The ____ button allows you to erase recent cell entries.

Accepted Answer

The Undo button allows you to erase recent cell entries by undoing the last action you performed, including typing in a cell. The other choices do not specifically relate to erasing recent cell entries.

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

CTRL+HOME shortcut key selects cell A1.

Question 18

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

Accepted Answer

The END key is used to move the insertion point to the end of data within a cell.

Question 19

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

Accepted Answer

The Accounting Number Format displays cell contents with two decimal places that align vertically, making it easier to read and compare numbers in a table or spreadsheet.

Question 20

Excel remembers the last ____ actions you have completed.

Accepted Answer

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

Quiz 12: Excel: Creating a Worksheet and a Chart