Question 1

The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

Accepted Answer

The Enter and Cancel buttons appear in the formula bar specifically when you are entering or editing data in a cell, not at other times.

Question 2

1A is an example of a cell reference.

Accepted Answer

False

Question 3

To enter data in a cell, the cell must be active.

Accepted Answer

In order to enter data in a cell, it must first be selected or "active." This can be done by clicking on the cell or navigating to it with the arrow keys on the keyboard.

Question 4

In the accompanying figure, the text A1 is located in the ____.
A) name box
B) active cell
C) title bar
D) formula bar

Accepted Answer

The answer of  In the accompanying figure, the text...

Question 5

To select an entire row, click the row heading.

Accepted Answer

Clicking on the row heading will select the entire row in Microsoft Excel.

Question 6

When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a)n ____.
A) one-sided arrow
B) double-sided arrow
C) white plus sign
D) I-beam

Accepted Answer

When you move the mouse pointer over the cells in a worksheet, it typically changes to a white plus sign, indicating the ability to select or interact with the cells.

Question 7

If you choose not to keep the data you have entered, you can press Esc .

Accepted Answer

Pressing the Esc key usually cancels or exits out of the current action or input, including not saving the entered data.

Question 8

Press the down arrow to move to the next screen.

Accepted Answer

The answer of Press the down arrow to move to...

Question 9

Which of the following is NOT true about workbooks?
A) Worksheets are always stored in workbooks.
B) You can only have one Excel workbook open at a time.
C) When working with large amounts of data, you can organize the data into multiple worksheets.
D) When you open a new blank workbook, Sheet1 appears in the worksheet window.

Accepted Answer

You can have multiple Excel workbooks open at the same time.

Question 10

All cells in a range touch each other and form a rectangle.

Accepted Answer

This is true for rectangular ranges in Excel. However, if the range is not a rectangle, then the cells may not touch each other.

Question 11

Excel is an electronic spreadsheet application.

Accepted Answer

Excel is indeed an electronic spreadsheet application developed by Microsoft.

Question 12

By default, Excel includes the Repeat command on the Quick Access Toolbar.

Accepted Answer

The Repeat command is not included by default on the Quick Access Toolbar in Excel; users need to add it manually if desired.

Question 13

When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____.
A) one-sided arrow
B) double-sided arrow
C) white plus sign
D) I-beam

Accepted Answer

When you move the mouse pointer over the formula bar, the mouse pointer changes to an I-beam. This indicates that you can edit the contents of the formula bar by clicking and typing new data.

Question 14

Excel refers to a spreadsheet as a ____.
A) worksheet
B) workbook
C) table
D) database

Accepted Answer

An Excel spreadsheet is known as a worksheet. This is because it is a single document within an Excel file that contains rows, columns, and cells where data is entered, calculated, and analyzed.

Question 15

The AutoComplete feature in Excel corrects common mistakes as you enter data.

Accepted Answer

The AutoComplete feature in Excel helps to quickly fill in repetitive data entries by suggesting text based on previous entries, but it does not correct mistakes.

Question 16

The AutoComplete feature enables you to repeat the same data in a column or row.

Accepted Answer

The AutoComplete feature enables you to quickly enter data that has already been entered in the same column or row.

Question 17

The Ribbon in Excel is similar to the Ribbon used in Word.

Accepted Answer

The Ribbon in Excel and Word are similar in their layout and function, with tabs and commands organized according to different categories.

Question 18

You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

Accepted Answer

Triple-clicking a Ribbon tab does not minimize the Ribbon. However, clicking the arrow button located in the upper-right corner of the Ribbon can minimize it.

Question 19

Excel 2010 uses the Microsoft Office Fluent user interface.

Accepted Answer

Excel 2010 uses the Microsoft Office Fluent user interface, which is also known as the Ribbon interface. The Ribbon organizes commands and features into tabs and groups, making it easier for users to find and use the tools they need.

Question 20

Rows in a worksheet appear vertically and are identified by letters.

Accepted Answer

Rows in a worksheet appear horizontally and are identified by numbers. Columns appear vertically and are identified by letters.

Quiz 18: Getting Started With Excel Essentials