Question 1

The entry 906 West Palm Street would be interpreted by Excel as a number.

Accepted Answer

Excel interprets entries that contain both numbers and non-numeric characters (such as letters and symbols) as text, not as numbers. Therefore, 906 West Palm Street would be interpreted by Excel as text, not as a number.

Question 2

The ____ command is used to locate and work with a subset of data in a worksheet.
A) Template
B) Filter
C) Sort
D) Freeze Panes

Accepted Answer

The filter command is used to locate and work with a subset of data in a worksheet. It allows you to set certain criteria for the data and only show the rows that meet those criteria. This is useful when working with large datasets and you only want to focus on specific information. Templates are used to create a pre-designed format for a document or worksheet. Sort is used to arrange the data in ascending or descending order. Freeze panes is used to keep a certain row or column visible while scrolling through a large worksheet.

Question 3

The cell highlighted with a dark border is called the active cell.

Accepted Answer

The cell highlighted with a dark border is indeed called the active cell.

Question 4

To average the range beginning with B6 and ending with B8, key
A) =B6+B7+B8
B) =B6..B8/3
C) =average(B6:B8)
D) average(B6..B8)

Accepted Answer

The function AVERAGE in Excel is used to calculate the average of a range of cells, which is exactly what is required in this case. Option A simply adds the values, but does not divide by the number of values, giving an incorrect answer. Option B is not a valid Excel function and returns an error. Option D uses the ".." operator which is not recognized in Excel, and also returns an error.

Question 5

The Range command is used in Excel to move to a specific part of a document.

Accepted Answer

The Range command is used to select a range of cells in Excel, not to move to a specific part of the document. To navigate to a specific part of the document, one can use the Scrollbar or Ctrl+G (Go To) command.

Question 6

Cells that are entered as numbers align at the right.

Accepted Answer

This is true. By default, numbers in Excel are aligned at the right of the cell while text and other entries are aligned at the left.

Question 7

In Page Break Preview, dashed lines display automatic page breaks.

Accepted Answer

In Page Break Preview, dashed lines do indeed display automatic page breaks.

Question 8

To scroll through a worksheet,
A) click on the scroll box and drag it
B) click the up and down arrows on the scroll bar
C) click the area above or below the scroll box
D) all of the above

Accepted Answer

All of the above options will allow you to scroll through a worksheet. You can click and drag the scroll box, click the up and down arrows on the scroll bar, or click the area above or below the scroll box.

Question 9

Chart sheets are displayed
A) on the same page as the worksheet
B) on a separate sheet of the worksheet
C) in an entirely new file
D) none of the above

Accepted Answer

Chart sheets are displayed on a separate sheet of the worksheet. They are not on the same page as the worksheet nor in an entirely new file.

Question 10

Select the Sort Descending command to sort a range in alphabetical order from A-Z.

Accepted Answer

To sort a range in alphabetical order from A-Z, the Sort A-Z command (or Sort Ascending command) should be used. The Sort Descending command would sort the range in reverse alphabetical order from Z-A.

Question 11

An intersection of a column and a row is referred to as a/n
A) active cell
B) cell
C) cell pointer
D) function

Accepted Answer

The intersection of a column and a row is referred to as a cell in spreadsheet terminology. An active cell is a currently selected cell, a cell pointer refers to the cursor that indicates the current cell, and a function is a predefined formula that performs specific calculations. None of these terms accurately describe an intersection of a column and a row.

Question 12

To filter a PivotTable, drag the desired filter field to the Report Filter box in the area below the fields on the Pivot Table Field List.

Accepted Answer

This statement is true. You can filter a PivotTable by dragging the desired filter field to the Report Filter box in the area below the fields on the Pivot Table Field List.

Question 13

In Excel , a range is expressed as
A) A1..D5
B) A1:D5
C) A1,A5
D) A1..A5..D1..D5

Accepted Answer

A range in Excel is expressed as a combination of the first cell and the last cell in the range, separated by a colon. Therefore, option B, A1:D5, is the correct way to express a range from cell A1 to cell D5.

Question 14

The ____ function is entered to determine the number of reservations made for 8 p.m. on Friday night.
A) COUNT
B) MIN
C) MAX
D) SUM

Accepted Answer

The COUNT function is used to determine the number of rows in a column that contain a numerical value. In this case, the COUNT function can be used to count the number of reservations made for 8 p.m. on Friday night, which will give us the exact number of reservations.

Question 15

In a spreadsheet that contains a large amount of data, use the ____ command to summarize and rearrange data to answer specific questions, such as which course generated the greatest enrollment for which semester and for which instructor.
A) Filter
B) Mail Merge
C) PivotTable
D) Sort

Accepted Answer

The PivotTable command is specifically designed to summarize and rearrange data based on specific questions or criteria. It allows users to easily manipulate and analyze large amounts of data, making it the best choice for answering questions such as which course generated the greatest enrollment for which semester and instructor. The Filter and Sort commands are useful for organizing and manipulating data, but they do not have the same level of functionality as PivotTable. Mail Merge is a feature that allows users to create and customize documents, but it is not related to summarizing and rearranging data within a spreadsheet.

Question 16

Which of the following formulas displays E5 as an absolute cell reference?
A) =A2*E5*
B) =A2*$.E5
C) =A2*$E*5
D) =A2*$E$5

Accepted Answer

The $ symbol is used to make a cell reference absolute. "$E$5" indicates that both the column letter "E" and the row number "5" are absolute, meaning they will not change if the formula is copied to another cell.

Question 17

The entry of a Social Security number (555-55-5555) would be interpreted by Excel as text.

Accepted Answer

Excel follows a general rule that if a number is entered in a cell that is formatted as text, then it will be interpreted as text. Therefore, the Social Security number (555-55-5555) would be interpreted as text in Excel as long as the cell is formatted as text.

Question 18

Columns include information arranged horizontally.

Accepted Answer

Columns include information arranged vertically, while rows include information arranged horizontally.

Question 19

If a cell displays with ####, the
A) entry has been keyed incorrectly
B) cell must be formatted correctly
C) cell is not wide enough for the entry
D) cell is too wide for the entry.

Accepted Answer

The pound signs ("####") indicate that the cell is not wide enough to display the entire number or text that has been entered. Widening the column should resolve the issue.

Question 20

A spreadsheet assists a user in managing numeric information and creating charts.

Accepted Answer

A spreadsheet program allows users to enter and organize data in a table format, perform calculations and analysis on that data, and generate charts and graphs based on the information entered.

Quiz 3: Spreadsheets With Excel

The entry 906 West Palm Street would be interpreted by Excel as a number.

The ____ command is used to locate and work with a subset of data in a worksheet.

The cell highlighted with a dark border is called the active cell.

To average the range beginning with B6 and ending with B8, key

The Range command is used in Excel to move to a specific part of a document.

Cells that are entered as numbers align at the right.

In Page Break Preview, dashed lines display automatic page breaks.

To scroll through a worksheet,

Chart sheets are displayed

Select the Sort Descending command to sort a range in alphabetical order from A-Z.

An intersection of a column and a row is referred to as a/n

To filter a PivotTable, drag the desired filter field to the Report Filter box in the area below the fields on the Pivot Table Field List.

In Excel , a range is expressed as

The ____ function is entered to determine the number of reservations made for 8 p.m. on Friday night.

In a spreadsheet that contains a large amount of data, use the ____ command to summarize and rearrange data to answer specific questions, such as which course generated the greatest enrollment for which semester and for which instructor.

Which of the following formulas displays E5 as an absolute cell reference?

The entry of a Social Security number (555-55-5555) would be interpreted by Excel as text.

Columns include information arranged horizontally.

If a cell displays with ####, the

A spreadsheet assists a user in managing numeric information and creating charts.