Question 1

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.
A) workgroup
B) filegroup
C) workbook
D) sheetbook

Accepted Answer

A workbook contains one or more worksheets. The other options (A, B, and D) are not correct terminology used in Microsoft Excel.

Question 2

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 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 then shows James how to select a(n) _____, which is a series of cells.
A) order
B) range
C) sequence
D) group

Accepted Answer

The term used in Microsoft Excel to refer to a series of cells is a "range."

Question 4

Using formulas is a basic part of Microsoft Excel. Please describe a formula and a cell reference and how they interact.

Accepted Answer

The answer of Using formulas is a basic part of...

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 starts by saying that a worksheet will always consist of _____.
A) ranges and active cells
B) rows and columns
C) formulas and calculations
D) values and labels

Accepted Answer

A worksheet in Microsoft Excel will always consist of rows and columns that create cells where data can be entered and manipulated. While ranges and active cells, formulas and calculations, and values and labels are all important components of Excel, they are not fundamental features that every worksheet will necessarily include.

Question 6

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 7

A cell ____________________ is the column and row location of a cell.

Accepted Answer

The answer of A cell ____________________ is the column and...

Question 8

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 9

To edit a label after you've pressed the Enter key, click the cell, then click in the ____________________ bar.

Accepted Answer

The answer of To edit a label after you've pressed...

Question 10

A worksheet ____________________ is the rectangle formed by the intersection of a column and row.

Accepted Answer

The answer of A worksheet ____________________ is the rectangle formed...

Question 11

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

Accepted Answer

The answer of A collection of worksheets is called a(n)...

Question 12

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

The answer of It is important to distinguish between a...

Question 13

The ____________________ cell is the cell you can currently edit or modify.

Accepted Answer

The answer of The ____________________ cell is the cell you...

Question 14

In addition to writing your own formulas, you can use predefined formulas called ____________________.

Accepted Answer

The answer of In addition to writing your own formulas,...

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

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