Question 1

Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority .

Accepted Answer

A) True 
 B)False

Question 2

Any text entered into a cell of the worksheet is called a(n)  _____.

Accepted Answer

A)   label
B)   value
C)   entry
D)   string

Question 3

You can build complex formulas using arithmetic operators, parentheses, and a mixture of _____.

Accepted Answer

A)   both constants and values
B)   both values and cell references
C)   cell references only
D)   values only

Question 4

After you have pressed the Enter key, you cannot edit the value entered into the cell.

Accepted Answer

A) True 
 B)False

Question 5

Excel treats all cells as _____ references, by default.

Accepted Answer

A)   absolute
B)   fixed
C)   corresponding
D)   relative D

Question 6

Which of the following signs is used when creating an absolute reference?

Accepted Answer

A)   #
B)   @
C)   $
D)   & C

Question 7

A(n) ____________________ is any text entered into a cell of a worksheet.

Accepted Answer

The answer of A(n) ____________________ is any text entered into...

Question 8

Referring to the accompanying figure, the _____ group contains the button used to paste a formula into a new cell.

Accepted Answer

A)   Editing
B)   Clipboard
C)   Cells
D)   Number

Question 9

If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.

Accepted Answer

A) True 
 B)False

Question 10

Case-Based Critical Thinking Questions Case 5-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan then shows James how to select a(n)  _____, which is a series of cells.

Accepted Answer

A)   order
B)   range
C)   sequence
D)   group

Question 11

The letter "X" is used for multiplication in Excel.

Accepted Answer

A) True 
 B)False

Question 12

Excel worksheets are saved in a(n)  _____-dimensional workbook

Accepted Answer

A)   three
B)   two
C)   one
D)   multi

Question 13

Excel includes more than 250 functions from which you can choose.

Accepted Answer

A) True 
 B)False

Question 14

Excel includes more than _____ functions from which you can choose.

Accepted Answer

A)   1000
B)   500
C)   250
D)   750

Question 15

When specifying a range, use a _____ to separate the first and last cells.

Accepted Answer

A)   semicolon
B)   dash
C)   slash
D)   colon

Question 16

Microsoft Excel is text and data processing software and is not suited for working with formulas.

Accepted Answer

A) True 
 B)False

Question 17

A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.

Accepted Answer

The answer of A cell reference that changes when a...

Question 18

It is important to distinguish between a value and a label when entering information into an Excel worksheet. Please describe both a label and a value.

Accepted Answer

- A label is any text entered into a cell of the worksheet. You can use labels for a worksheet title, to describe the numbers you've entered in other cells, and for text data, such as the names of people or cities. Any numerical data you do not intend to use in a calculation should be entered as a label. This data might be a telephone number, a Social Security number, or a street address.
- A value is a number that you intend to use in a calculation and that is entered into a cell of a worksheet. Cells containing values can be used in formulas to calculate results.

Question 19

Values and labels can be entered automatically using the fill handle and a technique called _____.

Accepted Answer

A)   fill-and-drag
B)   drag-and-fill
C)   drag-and-drop
D)   drag-and-paste

Question 20

A(n) ____________________ consists of values or cell references used to calculate the result of the function.

Accepted Answer

The answer of A(n) ____________________ consists of values or cell...

Exam 5: Creating a Worksheet

Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority .

Correct Answer
verified

Any text entered into a cell of the worksheet is called a(n) _____.

Correct Answer
verified

You can build complex formulas using arithmetic operators, parentheses, and a mixture of _____.

Correct Answer
verified

After you have pressed the Enter key, you cannot edit the value entered into the cell.

Correct Answer
verified

Excel treats all cells as _____ references, by default.

Correct Answer
verified
D

Which of the following signs is used when creating an absolute reference?

Correct Answer
verified
C

A(n) ____________________ is any text entered into a cell of a worksheet.

Correct Answer
verified

Referring to the accompanying figure, the _____ group contains the button used to paste a formula into a new cell.

Correct Answer
verified

If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.

Correct Answer
verified

Case-Based Critical Thinking Questions Case 5-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan then shows James how to select a(n) _____, which is a series of cells.

Correct Answer
verified

The letter "X" is used for multiplication in Excel.

Correct Answer
verified

Excel worksheets are saved in a(n) _____-dimensional workbook

Correct Answer
verified

Excel includes more than 250 functions from which you can choose.

Correct Answer
verified

Excel includes more than _____ functions from which you can choose.

Correct Answer
verified

When specifying a range, use a _____ to separate the first and last cells.

Correct Answer
verified

Microsoft Excel is text and data processing software and is not suited for working with formulas.

Correct Answer
verified

A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.

Correct Answer
verified

It is important to distinguish between a value and a label when entering information into an Excel worksheet. Please describe both a label and a value.

Values and labels can be entered automatically using the fill handle and a technique called _____.

Correct Answer
verified

A(n) ____________________ consists of values or cell references used to calculate the result of the function.

Correct Answer
verified

Exam 5: Creating a Worksheet

Excel calculates results using the standard mathematical order of operations, referred to as mathematical priority .

Correct AnswerverifiedShow Answer

Any text entered into a cell of the worksheet is called a(n) _____.

Correct AnswerverifiedShow Answer

You can build complex formulas using arithmetic operators, parentheses, and a mixture of _____.

Correct AnswerverifiedShow Answer

After you have pressed the Enter key, you cannot edit the value entered into the cell.

Correct AnswerverifiedShow Answer

Excel treats all cells as _____ references, by default.

Correct AnswerverifiedD

Which of the following signs is used when creating an absolute reference?

Correct AnswerverifiedC

A(n) ____________________ is any text entered into a cell of a worksheet.

Correct AnswerverifiedShow Answer

Referring to the accompanying figure, the _____ group contains the button used to paste a formula into a new cell.

Correct AnswerverifiedShow Answer

If the cell references should not be modified when moved to a new location, you should use a(n) relative reference.

Correct AnswerverifiedShow Answer

Case-Based Critical Thinking Questions Case 5-1 Ethan is teaching his younger brother James the basics of Microsoft Excel. Please answer the following questions. Ethan then shows James how to select a(n) _____, which is a series of cells.

Correct AnswerverifiedShow Answer

The letter "X" is used for multiplication in Excel.

Correct AnswerverifiedShow Answer

Excel worksheets are saved in a(n) _____-dimensional workbook

Correct AnswerverifiedShow Answer

Excel includes more than 250 functions from which you can choose.

Correct AnswerverifiedShow Answer

Excel includes more than _____ functions from which you can choose.

Correct AnswerverifiedShow Answer

When specifying a range, use a _____ to separate the first and last cells.

Correct AnswerverifiedShow Answer

Microsoft Excel is text and data processing software and is not suited for working with formulas.

Correct AnswerverifiedShow Answer

A cell reference that changes when a formula is copied or moved is called a(n) ____________________ reference.

Correct AnswerverifiedShow Answer

It is important to distinguish between a value and a label when entering information into an Excel worksheet. Please describe both a label and a value.

Values and labels can be entered automatically using the fill handle and a technique called _____.

Correct AnswerverifiedShow Answer

A(n) ____________________ consists of values or cell references used to calculate the result of the function.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
D

Correct Answer
verified
C

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified