Deck 5: Creating a Worksheet

Question 1

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

Answer 1

False

Question 2

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

Answer 2

False

Question 3

Any numerical data you do not intend to use in a calculation should be entered as a(n) label .

Answer 3

True

Question 4

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

Question 5

Formulas cannot include more than two functions.

Question 6

Labels are used only for worksheet or column titles.

Question 7

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

Question 8

The active cell is the cell you can currently edit or modify, and it is marked with a(n) black outline.

Question 9

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

Question 10

To create an absolute reference, insert a pound sign (#) before the column reference and another pound sign before the row reference.

Question 11

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

Question 12

The Excel workspace is a grid of rows and columns.

Question 13

The default workbook contains a worksheet, titled Worksheet1 .

Question 14

One of the commonly used functions is the function MAXIMUM .

Question 15

A(n) range is a series of cells.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

Which of the following buttons on the formula bar should you click to complete your entry?

A)
B)
C)
D)

Question 22

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

A) input
B) cell
C) field
D) element

Question 23

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

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

Question 24

A cell located in the third row and forth column is named _____.

A) 3D
B) C4
C) D3
D) 4C

Question 25

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

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

Question 26

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

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

Question 27

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

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

Question 28

When using the standard mathematical order of operations _____ is/are performed last.

A) multiplication
B) subtraction
C) addition and subtraction
D) multiplication and division

Question 29

To edit a label after the Enter key has been pressed, you should first click the cell, then click in the _____, type your correction, then press the Enter key to complete your entry.

A) label input bar
B) entry bar
C) formula bar
D) text field

Question 30

It is possible to edit a label inside a cell, but to activate it first _____ the cell.

A) left-click
B) double-click
C) right-click
D) point to

Question 31

All of the following are arithmetic operators used in Excel, except _____.

A) x (multiplication)
B) ^ (exponent)
C) % (percent)
D) + (addition)

Question 32

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

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

Question 33

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

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

Question 34

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

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

Question 35

If the label is too long to fit in the current cell and the cells on the right are not empty, _____.

A) extra cells will be inserted
B) part of the label will be truncated
C) the label will replace the content of the cells
D) none of the above

Question 36

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

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

Question 37

The columns are typically labeled with _____.

A) numbers, starting with 1 as the column farthest to the left
B) letters, starting with A as the column farthest to the right
C) numbers, starting with 1 as the column farthest to the right
D) letters, starting with A as the column farthest to the left

Question 38

The active cell is marked with a _____ outline.

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

Question 39

After you click a cell for a formula, a rectangle of _____ called a marquee appears around that cell.

A) dots
B) dots and dashes
C) blue lines
D) dashes

Question 40

Which of the following should be added before a number if you want to enter a number as a label, for example, as a telephone number?

A) slash
B) double quote
C) apostrophe
D) pound

Question 41

Which of the following is a New sheet button?

A)
B)
C)
D)

Question 42

A collection of worksheets is sometimes called a _____.

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

Question 43

Delete an existing worksheet by right-clicking the worksheet's tab and clicking _____.

A) Cut
B) Remove
C) Cross out
D) Delete

Question 44

Which of the following refers to Column B, Row 2 on the worksheet called Sheet2?

A) Sheet2$B2
B) Sheet2!B2
C) Sheet2&B2
D) Sheet2#B2

Question 45

Functions can have _____ argument(s).

A) only one
B) not more than two
C) as many as needed
D) three or less

Question 46

The Function Arguments dialog box contains a link, _____, that you should click to get help with the arguments.

A) Help
B) F1
C) Function arguments
D) Help on this function

Question 47

After you select a function, you have to specify the _____.

A) arguments
B) parameters
C) inputs
D) data values

Question 48

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

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

Question 49

Excel treats all cells as _____ references, by default.

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

Question 50

Which of the following functions calculates the total of a column or row of cells?

A) TOTAL
B) SUM
C) SUMCOL
D) SUMROW

Question 51

Referring to the accompanying figure, the active cell is cell _____.

A) C9
B) B9
C) A9
D) C10

Question 52

Referring to the accompanying figure, the marquee around one of the cells can be removed by clicking the _____ key.

A) F1
B) Enter
C) Esc
D) Alt

Question 53

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

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

Question 54

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

A) functions
B) subroutines
C) methods
D) template formulas

Question 55

Which of the following is a correct name for the function that calculates an average of values?

A) AVG
B) AVERAGE
C) MEAN
D) AVGVAL

Question 56

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

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

Question 57

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

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

Question 58

The default workbook contains _____ worksheets.

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

Question 59

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When that formula is copied to cell C7, the relative references in the formula change to _____.

A) =B6*C3
B) =B7*C4
C) =B8*C5
D) =B5*C2

Question 60

In the accompanying figure, the original formula =B5*C2 works correctly in cell C5. When it is copied and pasted into cell C8, why do the hash marks appear?

A) The copied formula does not refer to the correct cells and produces a result that is too large to fit in the cell.
B) The copied formula contains a cell which is blank.
C) The copied formula contains a cell with a label.
D) none of the above

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

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.

Question 73

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

Question 74

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

Question 75

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