Question 1

A(n)____________________ is a collection of text and numbers laid out in a rectangular grid.

Accepted Answer

The answer of A(n)____________________ is a collection of text and...

Question 2

Each worksheet has a(n)____________________ that identifies the name of the worksheet.

Accepted Answer

The answer of Each worksheet has a(n)____________________ that identifies the...

Question 3

Sam is happy with the results of the formula.All of a sudden he realizes that the cell that once displayed the result is now displaying the formula and all of the columns are wider.He must have ____.

Accepted Answer

The most likely reason for the sudden change in the display would be that Sam accidentally switched to formula view by pressing Ctrl + `. This view shows formulas instead of their results in cells, and also makes all the columns wider to accommodate the longer formula display.

Question 4

To activate the AutoSum feature,Sam clicks ____.

Accepted Answer

The AutoSum feature is typically activated by clicking in the cell below the group of cells you want to add, as it automatically suggests a sum formula for the cells above.

Question 5

A text string contains a string of text ____________________.

Accepted Answer

The answer of A text string contains a string of...

Question 6

Sam now wants to find out how much money he will make on his largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.

Accepted Answer

To find out the total money made on the largest order, we need to multiply the number of items ordered (E4) and the price per item (E5). Therefore, the appropriate formula would be E4 * E5. Option A (E4 + E5) would give us the total number of items plus the price per item, which is not helpful in finding the total money made. Option B (E5/E4) would give us the price per item divided by the number of items, which is not what we need. Option D (E4^E5) would give us E4 raised to the power of E5, which is unrelated to the question.

Question 7

A(n)____________________ sheet reminds you why you created a workbook and what it contains.

Accepted Answer

The answer of A(n)____________________ sheet reminds you why you created...

Question 8

The cell reference for the active cell appears in the ____________________ located in the upper-left corner of the worksheet.

Accepted Answer

The answer of The cell reference for the active cell...

Question 9

The ____________________ sheet has a white sheet tab.

Accepted Answer

The answer of The ____________________ sheet has a white sheet...

Question 10

A worksheet displays the contents of the spreadsheet laid out in a grid of rows and ____________________.

Accepted Answer

The answer of A worksheet displays the contents of the...

Question 11

The ____________________ is a set of predefined rules used to determine the sequence in which operators are applied in a calculation.

Accepted Answer

The answer of The ____________________ is a set of predefined...

Question 12

The newly inserted column has the same width as ____.

Accepted Answer

The answer of The newly inserted column has the same...

Question 13

Case-Based Critical Thinking Questions
Case 1-2
Sam is a distributor of ceramics.He uses Excel 2010 to record his inventory and order forms.Sam's worksheet for his company's monthly orders needs to display summary information including total number of items ordered,and the amount of revenue generated from those orders.
-First Sam will add the number of orders.He chooses to use the ____ function from the AutoSum feature.

Accepted Answer

The SUM function from the AutoSum feature is the best choice as it allows Sam to easily add up the values in a range of cells, which is what he needs to do to determine the total number of items ordered.

Question 14

Each cell is identified by a cell ____________________,which is its column and row location.

Accepted Answer

The answer of Each cell is identified by a cell...

Question 15

The ____________________ bar displays the contents of an active cell.

Accepted Answer

The answer of The ____________________ bar displays the contents of...

Question 16

A(n)____________________ includes a series of questions that help you think about the purpose of the workbook and how to achieve your desired results.

Accepted Answer

The answer of A(n)____________________ includes a series of questions that...

Question 17

Sam decides to rename his worksheet "Sam's Ceramic Business Worksheet" but he is unable to complete the word Worksheet because ____.

Accepted Answer

Excel only allows for 31 characters in a sheet name, therefore Sam is unable to complete the word "Worksheet" within the character limit.

Question 18

____________________ data include any number of letters,symbols,numbers,and spaces in a cell.

Accepted Answer

The answer of ____________________ data include any number of letters,symbols,numbers,and...

Question 19

A ____________________ provides a visual representation of spreadsheet data.

Accepted Answer

The answer of A ____________________ provides a visual representation of...

Question 20

Roger notices that the Dog Name column is too wide and he could use that extra space for other columns so he ____.

Accepted Answer

Double-clicking the border of a column header in Excel will automatically resize the column to fit the longest entry.

Quiz 1: Getting Started With Excel