Question 1

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

By default, pressing the RIGHT ARROW key moves the active cell reference one column to the right.

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

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 a range in a function, we separate the beginning and ending cell references with a colon (:). For example, to average the values in cells A1 through A10, the range would be entered as "A1:A10" within the function.

Question 4

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, fixing common typing or spelling mistakes when you complete a text entry. AutoComplete suggests words or phrases that match what you are typing, while AutoFormat automatically formats text as you type. AutoTyping is not a standard feature in most software programs.

Question 5

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 6

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

Accepted Answer

A worksheet is the best choice as it is the individual tab within an Excel file where data can be entered, analyzed, and summarized. The data can also be easily charted and graphed within the worksheet. Workflows are unrelated to Excel and refer to a series of tasks or processes. Documents and presentations can contain Excel data, but do not have the same level of functionality as a worksheet.

Question 7

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

To emphasize certain entries and make the worksheet easier to read and understand, formatting is needed. Formatting includes changing font size and style, highlighting cells, applying borders, and adding color.

Question 8

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 an adjusted cell reference in a copied and pasted formula, as it is adjusted based on its new location. The other answer options (revised, recycled, and retained) do not accurately describe the concept of a relative reference.

Question 9

Combining two or more selected cells into one cell is called ____ cells.
A) merging
B) mixing
C) combining
D) spanning

Accepted Answer

Merging cells combines them into a single cell, with the contents of the selected cells being centered in the resulting merged cell.

Question 10

Pressing the ____ keyboard shortcut key(s) selects cell A1.
A) CTRL+HOME
B) CTRL+END
C) HOME
D) END

Accepted Answer

Pressing the CTRL+HOME keyboard shortcut key(s) selects cell A1.

Question 11

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 12

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 destination area refers to the range of cells where the copied content is being pasted. Therefore, the most suitable option is D. The other options listed are not commonly used terms in the context of copy-pasting cells in Excel.

Question 13

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 implies that the requester needs to provide their requirements, which suggests that they should submit them in a requirements document. A blank document would not provide any information, a test issues document may not be relevant, and a certified document is not necessary for this situation.

Question 14

Which of the following is the Ribbon path to the Cell Styles button?
A) (HOME tab | Styles group)
B) (STYLES tab | Home group)
C) (HOME tab | Format group)
D) (FORMAT tab | Styles group)

Accepted Answer

The Cell Styles button is located in the Styles group on the Home tab of the Ribbon.

Question 15

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

Accepted Answer

Clicking the Enter box completes an entry.

Question 16

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. This is the only option out of the given choices that specifically mentions copying with formatting.

Question 17

What effect does the Comma Style format have on the selected cells?
A) Converts decimals to commas within a cell
B) Converts decimals to commas within merged cells
C) Displays cell contents with two decimal places and commas as thousands separators
D) Allows for substitution of selected characters

Accepted Answer

The Comma Style format displays cell contents with two decimal places and commas as thousands separators, making large numbers easier to read.

Question 18

What effect does the Accounting Number Format have on the selected cells?
A) Converts alphabetic characters to numbers
B) Displays cell contents with two decimal places that align vertically
C) Performs tax calculations
D) Copies the numbers of one cell to another

Accepted Answer

The Accounting Number Format displays cell contents with two decimal places, and also adds a currency symbol if desired. It does not convert alphabetic characters to numbers, perform tax calculations, or copy numbers from one cell to another.

Question 19

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 crucial in creating an effective worksheet as it helps in organizing the data and selecting appropriate formatting options. Without understanding the requirements, the worksheet may not fulfill its intended purpose. The other options, such as font formatting, chart insertion, and entering data, are important steps in creating the worksheet but come after understanding the requirements.

Question 20

You can apply the Bold font style by pressing the ____ keyboard shortcut keys.
A) ALT+B
B) CTRL+B
C) SHIFT+B
D) TAB+B

Accepted Answer

The CTRL+B keyboard shortcut is used to apply the Bold font style in most applications including Microsoft Word, Excel, and PowerPoint.

Quiz 3: Excel 1 Creating a Worksheet and a Chart

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Clicking the ____ box completes an entry.

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

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

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

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

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