Deck 12: Creating a Worksheet

Question 1

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

Answer 1

False

Question 2

Labels are used only for worksheet or column titles.

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

Question 6

The default workbook contains a worksheet, titled Worksheet1 .

Question 7

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

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

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

Question 11

The Excel workspace is a grid of rows and columns.

Question 12

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

Question 13

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

Question 14

A(n) range is a series of cells.

Question 15

Formulas cannot include more than two functions.

Question 16

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

Question 17

One of the commonly used functions is the function MAXIMUM .

Question 18

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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 23

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

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

Question 24

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 25

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

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

Question 26

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 27

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

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

Question 28

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 29

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

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

A)
B)
C)
D)

Question 32

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 33

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 34

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

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

Question 35

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

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

Question 36

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

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

Question 37

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 38

The active cell is marked with a _____ outline.

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

Question 39

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 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 correct name for the function that calculates an average of values?

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

Question 42

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 43

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

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

Question 44

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

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

Question 45

The default workbook contains _____ worksheets.

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

Question 46

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

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

Question 47

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

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

Question 48

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 49

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 50

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

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

Question 51

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 52

Functions can have _____ argument(s).

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

Question 53

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

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

Question 54

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

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

Question 55

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 56

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 57

Excel treats all cells as _____ references, by default.

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

Question 58

A collection of worksheets is sometimes called a _____.

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

Question 59

Which of the following is a New sheet button?

A)
B)
C)
D)

Question 60

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 61

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

Question 62

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

Question 63

Case-Based Critical Thinking Questions Case 12-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

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

Question 65

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

Question 66

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

Question 67

Case-Based Critical Thinking Questions Case 12-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 68

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

Question 69

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 70

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

Question 71

Case-Based Critical Thinking Questions Case 12-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 72

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

Question 73

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

Question 74

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

Question 75

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