Question 1

The method of creating formulas based on clicking cells instead of typing the cell reference is called the _____ method.

Accepted Answer

A)  cursor 
B)  pointer 
C)  marker 
D)  click 
A)  cursor 
B)  pointer 
C)  marker 
D)  click

Question 2

In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.

Accepted Answer

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

Question 3

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 starts by saying that a worksheet will always consist of _____.

Accepted Answer

A)  ranges and active cells 
B)  rows and columns 
C)  formulas and calculations 
D)  values and labels 
A)  ranges and active cells 
B)  rows and columns 
C)  formulas and calculations 
D)  values and labels

Question 4

One of the commonly used functions is the function MAXIMUM .

Accepted Answer

A) True 
 B)False

Question 5

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 explains that a _____ contains one or more worksheets.

Accepted Answer

A)  workgroup 
B)  filegroup 
C)  workbook 
D)  sheetbook 
A)  workgroup 
B)  filegroup 
C)  workbook 
D)  sheetbook

Question 6

To delete an existing worksheet right-click anywhere within the worksheet and click Delete.

Accepted Answer

A) True 
 B)False

Question 7

Formulas cannot include more than two functions.

Accepted Answer

A) True 
 B)False

Question 8

The active cell is marked with a _____ outline.

Accepted Answer

A)  black 
B)  green 
C)  blue 
D)  red 
A)  black 
B)  green 
C)  blue 
D)  red

Question 9

A formula that references the cell in which the formula resides is called a _____.

Accepted Answer

A)  recursive reference 
B)  circular reference 
C)  self-reference 
D)  relative reference 
A)  recursive reference 
B)  circular reference 
C)  self-reference 
D)  relative reference

Question 10

Cell references used in formulas can lead to unexpected results when you copy or move the formulas.

Accepted Answer

A) True 
 B)False

Question 11

To select a range of cells for use as arguments in a function, click the upper-left cell and release the mouse button.

Accepted Answer

A) True 
 B)False

Question 12

The Excel workspace is a grid of rows and columns.

Accepted Answer

A) True 
 B)False

Question 13

After you click a cell for a formula, a rectangle of dashes called a(n) ____________________ appears around that cell.

Accepted Answer

The answer of After you click a cell for a...

Question 14

Which of the following is a New sheet button?

Accepted Answer

A)    
B)    
C)    
D)    
A)    
B)    
C)    
D)

Question 15

Labels are used only for worksheet or column titles.

Accepted Answer

A) True 
 B)False

Question 16

A collection of worksheets is called a(n) ____________________.

Accepted Answer

3D workboo

Question 17

The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab.

Accepted Answer

A) True 
 B)False

Question 18

A(n) range is a series of cells.

Accepted Answer

A) True 
 B)False

Question 19

A collection of worksheets is sometimes called a _____.

Accepted Answer

A)  worksheet collection 
B)  3D worksheet collection 
C)  2D workbook 
D)  3D workbook 
A)  worksheet collection 
B)  3D worksheet collection 
C)  2D workbook 
D)  3D workbook

Question 20

Which of the following data should be entered as a label?

Accepted Answer

A)  telephone number 
B)  price 
C)  volume 
D)  distance 
A)  telephone number 
B)  price 
C)  volume 
D)  distance

The method of creating formulas based on clicking cells instead of typing the cell reference is called the _____ method.

In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.

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 starts by saying that a worksheet will always consist of _____.

One of the commonly used functions is the function MAXIMUM .

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 explains that a _____ contains one or more worksheets.

To delete an existing worksheet right-click anywhere within the worksheet and click Delete.

Formulas cannot include more than two functions.

The active cell is marked with a _____ outline.

A formula that references the cell in which the formula resides is called a _____.

Cell references used in formulas can lead to unexpected results when you copy or move the formulas.

To select a range of cells for use as arguments in a function, click the upper-left cell and release the mouse button.

The Excel workspace is a grid of rows and columns.

After you click a cell for a formula, a rectangle of dashes called a(n) ____________________ appears around that cell.

Which of the following is a New sheet button?

Labels are used only for worksheet or column titles.

A collection of worksheets is called a(n) ____________________.

The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab.

A(n) range is a series of cells.

A collection of worksheets is sometimes called a _____.

Which of the following data should be entered as a label?

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

The method of creating formulas based on clicking cells instead of typing the cell reference is called the _____ method.

In some situations, when cell references should not be modified when moved to a new location, a(n) _____ reference should be used.

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 starts by saying that a worksheet will always consist of _____.

One of the commonly used functions is the function MAXIMUM .

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 explains that a _____ contains one or more worksheets.

To delete an existing worksheet right-click anywhere within the worksheet and click Delete.

Formulas cannot include more than two functions.

The active cell is marked with a _____ outline.

A formula that references the cell in which the formula resides is called a _____.

Cell references used in formulas can lead to unexpected results when you copy or move the formulas.

To select a range of cells for use as arguments in a function, click the upper-left cell and release the mouse button.

The Excel workspace is a grid of rows and columns.

After you click a cell for a formula, a rectangle of dashes called a(n) ____________________ appears around that cell.

Which of the following is a New sheet button?

Labels are used only for worksheet or column titles.

A collection of worksheets is called a(n) ____________________.

The Cut, Copy, and Paste buttons are located in the Editing group on the HOME tab.

A(n) range is a series of cells.

A collection of worksheets is sometimes called a _____.

Which of the following data should be entered as a label?

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