Question 1

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type ____.

Accepted Answer

The best choice is to use scientific notation, which represents 6,000,000,000,000,000 as 6 x 10^15. Therefore, the correct choice is D, which represents this number in scientific notation. Choices A, B, and C do not represent the number accurately and may cause confusion or misinterpretation.

Question 2

The ____ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.

Accepted Answer

AutoCorrect is a feature that automatically corrects common spelling and grammatical errors as you type.

Question 3

To enter data in a cell, you must first ____ the cell.

Accepted Answer

You must first select the cell to enter data into it.

Question 4

By default, text is ____ in a cell.

Accepted Answer

By default, text is left-aligned in a cell in Microsoft Excel.

Question 5

When analyzing a problem in designing a worksheet solution, what is the first step?

Accepted Answer

The first step in analyzing a problem in designing a worksheet solution is to define the problem. This involves understanding the purpose of the worksheet, the data that will be used, and the desired output.

Question 6

The ____ is a blinking vertical line that indicates where the next typed character will appear.

Accepted Answer

The insertion point is the blinking vertical line that shows where the next typed character will appear in a document or text box. The scroll box is a feature that allows you to scroll through a long document, the sheet tab is a label at the bottom of a worksheet that identifies the sheet, and the split bar is a feature that allows you to split the worksheet window into two or more separate panes.

Question 7

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.

Accepted Answer

The small black square located in the lower-right corner of the heavy border around the active cell in spreadsheet programs like Microsoft Excel is known as the fill handle. It is used for quickly copying cell contents or filling data.

Question 8

Pressing the ____ key to complete an entry activates the adjacent cell to the right.

Accepted Answer

Pressing the RIGHT ARROW key moves the cursor to the cell to the right, allowing for easy navigation and data entry in Excel.

Question 9

To cancel an entire entry before entering it into the cell, press the ____ key.

Accepted Answer

Pressing the ESC key cancels an entire entry before entering it into the cell.

Question 10

In Excel, a number can contain the characters ____.

Accepted Answer

All of the above characters can be used in Excel numbers. 0-9 are obviously used for the digits in the number, but Excel also allows for math operators like +, -, *, / and parentheses to be included in a number. Additionally, Excel allows for the use of various symbols and formatting options like currency symbols ($), percentage symbols (%), and scientific notation (E or e) in numbers.

Question 11

The cell being copied is called the source area (or copy area).The range of cells receiving the copy is called the ____.

Accepted Answer

The range of cells receiving the copy is commonly referred to as the destination area or paste area. This term is widely used across different spreadsheet applications and is also referred to in Microsoft Excel's documentation. Therefore, choice D is the best answer.

Question 12

____ is/are used to place worksheet, column, and row titles on a worksheet.

Accepted Answer

Text is used to place worksheet, column, and row titles on a worksheet, as it allows for the input of alphanumeric characters to label data.

Question 13

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

Accepted Answer

The Auto Fill Options button is used to choose whether to copy values with formatting. The other options listed (Copy Options, Replace Options, Formatting Options) do not provide this specific functionality.

Question 14

A ____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells, as shown in the accompanying figure.

Accepted Answer

The answer of  A ____ is a series of...

Question 15

The person or persons requesting the worksheet should supply their requirements in a ____ document.

Accepted Answer

The sentence states that the person or persons requesting the worksheet should supply their requirements in a "requirements" document. Therefore, choice C is the best choice. The other options (blank, test issues, certified) are not relevant or mentioned in the sentence.

Question 16

To enter a number as text, precede it with a(n)____.

Accepted Answer

To enter a number as text, it should be preceded by an apostrophe. This will allow the number to be treated as text and not as a numerical value in Excel.

Question 17

Clicking the ____ button completes an entry.

Accepted Answer

Clicking the Enter button completes an entry.

Question 18

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.

Accepted Answer

When entering a range of cells in a function, you should separate the beginning and ending cell references with a colon (:). This is the standard format for specifying a range in Excel.

Question 19

An Excel ____ allows data easily to be summarized and charted.

Accepted Answer

A worksheet is designed for organizing and analyzing data in an Excel file. It allows data to be easily summarized, manipulated, and charted for better analysis and decision-making. A workbook, while important in Excel, refers to the overall file containing one or multiple worksheets. Therefore, A is the best choice for this question.

Question 20

A ____ reference is an adjusted cell reference in a copied and pasted formula.

Accepted Answer

When a formula is copied and pasted to a different cell, the original cell references in the formula are adjusted relative to the new location. This is known as a relative reference. Other answer choices (revised, recycled, and retained) do not accurately describe this concept.

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