Question 1

Text is any combination of letters and numbers and symbols, such as headings, labels, or explanatory notes.

Accepted Answer

Text can be any combination of letters, numbers, and symbols.

Question 2

Saving a workbook means loading an existing workbook file from a disk into the program window.

Accepted Answer

Saving a workbook means writing the content of the current workbook to a file on disk, while loading means opening a previously saved workbook file into the program window.

Question 3

The cell in the worksheet in which you can type data is called the open cell.

Accepted Answer

The cell in the worksheet in which you can type data is called the active cell.

Question 4

The column letter and row number of the active cell are shaded in red for easy identification.

Accepted Answer

The column letter and row number of the active cell are typically highlighted or shaded in a different color (not specifically red) to indicate the active cell's location, but the standard color is not red; it's usually a darker shade of grey or another neutral color in most spreadsheet programs.

Question 5

You can also close the workbook and leave Excel open by clicking the Close Window button located below the sizing buttons in the status bar.

Accepted Answer

The Close Window button is located at the top right of the workbook window, not in the status bar. The status bar is at the bottom of the Excel window and does not contain window control buttons like Close Window.

Question 6

If a cell is not wide enough to display all the cell's contents, extra text extends into the next cells if there is room.

Accepted Answer

This is called text wrapping and it is a default behavior in Microsoft Excel.

Question 7

The contents of the active cell always appear in the Formula Bar.

Accepted Answer

The Formula Bar displays the contents of the active cell, including formulas or data.

Question 8

When Excel starts, the program window displays a blank workbook titled Book1 , which includes ____ blank worksheets.
A) one
B) two
C) three
D) four

Accepted Answer

By default, Excel starts with three blank worksheets in a new workbook.

Question 9

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.

Accepted Answer

You can clear the active cell using the Clear command in the Ribbon, the Delete or Backspace key on the keyboard, or by selecting Clear in the right-click menu with the mouse.

Question 10

When you use the Find command , new data is substituted for the data found.

Accepted Answer

The Find command only locates data, it does not substitute or replace anything. The user must use the Replace command to substitute or replace data.

Question 11

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

Accepted Answer

The Excel program window does have the same basic parts as all Office programs, including the title bar, Quick Access Toolbar, Ribbon, Backstage view, and status bar.

Question 12

____ appear horizontally and are identified by numbers on the left side of the worksheet window.
A) Columns
B) Rows
C) Headings
D) Cells

Accepted Answer

Rows appear horizontally and are identified by numbers on the left side of the worksheet window.

Question 13

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.

Accepted Answer

Microsoft Office Excel 2010 is actually the spreadsheet software in Microsoft Office 2010, not the presentation program. The presentation program in Microsoft Office 2010 is Microsoft PowerPoint 2010.

Question 14

The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.
A) Name Space
B) Formula Bar
C) Name Pane
D) Name Box

Accepted Answer

The Name Box, located below the Ribbon, displays the cell reference of the active cell. The Formula Bar displays the contents of the active cell, while the Name Pane is used to create, edit, and manage named ranges. The Name Space is not a valid term in Excel.

Question 15

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell's location.

Accepted Answer

The easiest way to change the active cell in a worksheet is to simply click on the cell you want to activate. You do not need to use the Ribbon or type in the cell's location.

Question 16

The Save As command saves an existing workbook on a disk, using its current name and save location.

Accepted Answer

The Save As command is used to save a file to a specific location with a specific name, often used to create a new copy of the file or to save it in a new location, not to save an existing workbook using its current name and save location.

Question 17

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.
A) Columns
B) Rows
C) Cells
D) Headings

Accepted Answer

Columns appear vertically and are identified by letters at the top of the worksheet window.

Question 18

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.

Accepted Answer

The Formula Bar does appear to the right of the Name Box and displays the formula when the cell contains a calculated value.

Question 19

A formula is the intersection of a row and a column.

Accepted Answer

A formula is a combination of arithmetic operators, cell references, values and functions written to get a specific result. It is not an intersection of a row and a column.

Question 20

The name of each worksheet appears in the ____ at the bottom of the worksheet window.
A) sheet box
B) sheet task bar
C) sheet dialog box
D) sheet tab

Accepted Answer

The sheet names appear as tabs at the bottom of the worksheet window, also known as sheet tabs.

Quiz 2: Microsoft Excel Basics