Question 1

The first step in creating an effective worksheet is to make sure you ____.
A) apply font formatting
B) understand what is required
C) insert a chart
D) enter the data

Accepted Answer

Understanding what is required is the most important step in creating an effective worksheet. This includes identifying the purpose of the worksheet, determining the necessary data and information, and deciding how to organize and present the information. Once this is done, then the other steps such as entering the data and formatting can be done more effectively.

Question 2

____ is/are used to place worksheet, column, and row titles on a worksheet.
A) Color
B) Text
C) Links
D) Tabs

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 3

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.
A) quotation mark (")
B) colon (:)
C) plus (+)
D) equal sign (=)

Accepted Answer

The equal sign (=) preceding a formula alerts Excel that you are entering a formula or function and not text.

Question 4

The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
A) Copy Options
B) Replace Options
C) Formatting Options
D) Auto Fill Options

Accepted Answer

The Auto Fill Options button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. The other options listed are not specific to copying with formatting.

Question 5

By default, text is ____ in a cell.
A) left-aligned
B) centered
C) justified
D) right-aligned

Accepted Answer

By default, text is left-aligned in a cell. This means that the text is aligned to the left side of the cell and any extra space is added to the right side of the text. This is the most common and easiest format to work with as it allows for quick and easy reading of the data in the cell.

Question 6

An Excel ____ allows data to be summarized and charted easily.
A) worksheet
B) workflow
C) document
D) presentation

Accepted Answer

A worksheet in Excel allows for data to be organized into rows and columns, making it easy to summarize and chart the data using built-in functions and tools. Workflows, documents, and presentations are not specifically designed for data organization and analysis like an Excel worksheet.

Question 7

A ____ reference is an adjusted cell reference in a copied and pasted formula.
A) revised
B) relative
C) recycled
D) retained

Accepted Answer

A relative reference is adjusted in a copied and pasted formula based on its new location. The other choices do not accurately describe this type of reference.

Question 8

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
A) AutoComplete
B) AutoCorrect
C) AutoFormat
D) AutoTyping

Accepted Answer

AutoCorrect is the feature that works behind the scenes to fix common typing or spelling mistakes. AutoComplete suggests or completes words or phrases as you type, AutoFormat automatically formats text as you type, and AutoTyping is not a feature in most word processing programs.

Question 9

Clicking the ____ box completes an entry.
A) Cancel
B) Formula
C) Enter
D) Tab

Accepted Answer

Clicking the "Enter" key or the "Enter" button on the screen completes an entry in most software programs. Option A cancels the entry, option B opens the formula bar, and option D moves the cursor to the next cell in the row.

Question 10

The range of cells receiving copied content is called the ____ area.
A) fill
B) range
C) location
D) paste

Accepted Answer

The range of cells receiving copied content is referred to as the "paste" area, as this is where the content is pasted into.

Question 11

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
A) semi-colon (;)
B) colon (:)
C) period (.)
D) none of the above

Accepted Answer

To enter the correct range in a function, you can use a colon (:), which separates the beginning and ending cell references. For example, if you wanted to sum the values in cells A1 to A10, you would enter "=SUM(A1:A10)" in the formula bar.

Question 12

Pressing the ____ key to complete an entry activates the adjacent cell to the right.
A) RIGHT ARROW
B) LEFT ARROW
C) UP ARROW
D) DOWN ARROW

Accepted Answer

Pressing the RIGHT ARROW key moves the cursor to the cell to the right, completing the current entry and allowing the user to input data into the next cell.

Question 13

To enter data in a cell, you must first select the ____.
A) row
B) worksheet
C) column
D) cell

Accepted Answer

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

Question 14

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
A) save
B) print
C) format
D) clear

Accepted Answer

Formatting a worksheet involves changing the appearance of a worksheet to make it easier to read and understand. This can include adding bold or italic fonts, colors, borders, and shading to emphasize certain entries. Saving and printing do not impact the appearance of the worksheet, and clearing would remove any formatting that had already been applied.

Question 15

The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.
A) selection handle
B) sizing handle
C) fill handle
D) copy handle

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 16

-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.
A) range
B) bunch
C) nearby cell
D) neighbor

Accepted Answer

A range in spreadsheet terminology refers to a series of two or more adjacent cells in a column or row or a rectangular group of cells.

Question 17

In Excel, a number can contain the characters ____.
A) 0 1 2 3 4 5 6 7 8 9
B) + - ( ) , /
C) . $ % E e
D) all of the above

Accepted Answer

A number in Excel can contain any of the characters 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 for numeric values, +, -, (, ), / for arithmetic operations, . for decimal points, $ for currency symbols, % for percentage values, and E or e for scientific notation. Therefore, all of the choices are correct.

Question 18

The range of cells receiving the content of copied cells is called the ____.
A) receiver cell
B) final cell
C) receiving range
D) destination area

Accepted Answer

The term commonly used for the range of cells where the copied content is pasted is destination area, making option D the correct answer. The other options, receiver cell, final cell, and receiving range are not commonly used terms in this context.

Question 19

The ____ is a blinking vertical line that indicates where the next typed character will appear.
A) scroll box
B) sheet tab
C) insertion point
D) split bar

Accepted Answer

The insertion point is the blinking vertical line that indicates where the next typed character will appear in a document or text field. The scroll box is a visual indicator that is used to navigate through a document or web page, the sheet tab is a visual indicator used to switch between worksheets in a spreadsheet program, and the split bar is a line that separates two sections of a window and allows the user to resize each section independently. None of these options are related to the insertion point.

Question 20

The person or persons requesting the worksheet should supply their requirements in a ____ document.
A) blank
B) test issues
C) requirements
D) certified

Accepted Answer

The sentence clearly states that the worksheet requirements should be supplied in a "requirements document." Therefore, the best choice would be option C. Options A, B, and D are all incorrect because they do not relate to the specific type of document being requested in the sentence.

Quiz 2: Creating a Worksheet and a Chart

The first step in creating an effective worksheet is to make sure you ____.

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

The ____ preceding a formula alerts Excel that you are entering a formula or function and not text.

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

By default, text is ____ in a cell.

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

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

The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

Clicking the ____ box completes an entry.

The range of cells receiving copied content is called the ____ area.

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

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

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

You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

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

-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.

In Excel, a number can contain the characters ____.

The range of cells receiving the content of copied cells is called the ____.

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

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