Question 1

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 2

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

Accepted Answer

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

Question 3

Excel treats all cells as _____ references, by default.

Accepted Answer

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

Question 4

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 5

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

Accepted Answer

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

Question 6

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 
A)  both constants and values 
B)  both values and cell references 
C)  cell references only 
D)  values only

Question 7

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 
A)  fill-and-drag 
B)  drag-and-fill 
C)  drag-and-drop 
D)  drag-and-paste

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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

Question 11

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 12

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 
A)  order 
B)  range 
C)  sequence 
D)  group

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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 
A)  Editing 
B)  Clipboard 
C)  Cells 
D)  Number

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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.

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

Excel treats all cells as _____ references, by default.

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Finalizing a Database

Filters

Exam 5: Creating a Worksheet

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.

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

Excel treats all cells as _____ references, by default.

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

Getting Started With Application Software

Creating a Document

Formatting a Document

Finalizing a Document

Formatting a Worksheet

Finalizing a Worksheet

Creating a Presentation

Finalizing a Presentation

Creating a Database

Finalizing a Database

Filters