FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Creating a Worksheet

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 2

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

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

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

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

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

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.

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

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

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

Excel treats all cells as _____ references, by default.

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

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

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

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.

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

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

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

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