Deck 7: Create Workbooks With Excel 2013

Question 1

The Merge & Center button is in the ________ group on the Home tab.

A) Font
B) Alignment
C) Number
D) Cells

Answer 1

B

Question 2

In a workbook, pages are referred to as ________.

A) subworkbooks
B) worksheets
C) pages
D) gridsheets

Answer 2

B

Question 3

When a formula is in an active cell, the underlying formula is visible in the ________.

A) Name Box
B) worksheet
C) formula bar
D) status bar

Answer 3

C

Question 4

When a range is selected, the name box displays the cell address of ________.

A) the first cell in the range
B) the last cell in the range
C) all cells in the range
D) none of the cells in the range

Question 5

When Excel opens, a new blank ________ is displayed.

A) presentation
B) document
C) workbook
D) database

Question 6

When identifying a cell as B5, you are using its ________.

A) worksheet address
B) grid address
C) workbook address
D) cell address

Question 7

If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is ________.

A) wrapped
B) truncated
C) hidden
D) deleted

Question 8

Which cells are included in the notation A1:D1?

A) A1, B1, and C1
B) B1, C1, and D1
C) A1 and D1
D) A1, B1, C1, and D1

Question 9

Placing content in a cell can be done by pressing the Enter key or by clicking the ________.

A) Cancel button
B) Enter button
C) Esc key
D) column header

Question 10

When a cell is active, its column and row headings are ________.

A) flashing
B) hidden
C) bolded
D) shaded

Question 11

Which symbol inserted between two cell addresses indicates a range?

A) colon
B) semi-colon
C) period
D) comma

Question 12

The cell content shown in the formula bar is referred to as the ________ value.

A) displayed
B) actual
C) underlying
D) hidden

Question 13

An underlying value that does mathematical calculations on numeric values in a worksheet is ________.

A) the Formula AutoComplete
B) a formula
C) a text value
D) a cell address

Question 14

Two or more adjacent cells in a worksheet are a(n) ________.

A) unit
B) group
C) range
D) array

Question 15

The bar, located below the Ribbon, that displays the active cell's content is the ________.

A) formula bar
B) name bar
C) data bar
D) display bar

Question 16

A cell that is outlined in green and has data typed in it is the ________ cell.

A) home
B) active
C) fill
D) selected

Question 17

The ________ displays a list of functions that match the first letter typed.

A) Formula AutoComplete feature
B) edit feature
C) Quick Access Toolbar
D) formula bar

Question 18

The symbol on the Enter button is a(n) ________.

A) right arrow
B) left arrow
C) x
D) checkmark

Question 19

In Excel the term worksheet and ________ mean the same thing.

A) spreadsheet
B) datasheet
C) reference sheet
D) workbook

Question 20

When a cell is part of an active function, it is ________.

A) surrounded by a solid border
B) highlighted
C) surrounded by a moving border
D) preceded by an Options button

Question 21

The ________ button inserts a function that sums selected cells.

A) AutoAdd
B) AutoSum
C) AutoCalculate
D) Fill

Question 22

Pressing ________ makes A1 the active cell.

A) Home
B) Ctrl + Home
C) Ctrl + Left Arrow
D) Ctrl + Right Arrow

Question 23

Which term is used to refer to automatic adjustment of cell references in a copied formula?

A) associative cell reference
B) absolute cell reference
C) relative cell reference
D) positional cell reference

Question 24

Which is NOT an option in the Auto Fill Options menu?

A) Copy Cells
B) Fill Series
C) Paste Cells
D) Fill Format Only

Question 25

Which is an example of an Excel function?

A) =D6 + D7 + D8
B) =D7/D20
C) =SUM(D6:D8)
D) =D5*100

Question 26

Placeholders for predefined headers and footers begin with ________.

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

Question 27

After the fill handle is used to copy cell content, the ________ button appears to the right of the selected cells.

A) Auto Fill Options
B) Fill Handle Options
C) Quick Copy Options
D) Quick Fill Options

Question 28

Which feature displays the formatting of the style moused over in the Cell Styles gallery on the selected cells in the worksheet?

A) Print Preview
B) Display Preview
C) Live Preview
D) Layout Preview

Question 29

Non-adjacent cells can be selected in a worksheet by holding down the ________ key.

A) Alt
B) Home
C) Ctrl
D) Shift

Question 30

The ________ option in the Spelling dialog box inserts a word identified as misspelled into the Office dictionary.

A) AutoCorrect
B) Change
C) Change All
D) Add to Dictionary

Question 31

When no cells are selected and the AutoSum button is clicked, Excel first looks ________ the active cell for a suitable range to sum.

A) above
B) below
C) to the right of
D) to the left of

Question 32

Themed Cell Styles is an option in the ________.

A) Conditional Formatting gallery
B) Cell Styles gallery
C) Format gallery
D) Format as Table gallery

Question 33

Which cells are included in the sum calculated by the function =SUM(D5:G5)?

A) D5, E5, and F5
B) E5, F5, and G5
C) E5 and F5
D) D5, E5, F5, and G5

Question 34

Headers and footers are visible in the ________ view.

A) Normal
B) Page Layout
C) Page Break Preview
D) Full Screen

Question 35

When a row is inserted into a worksheet, the ________ of the row above is applied to the inserted row.

A) text value
B) formatting
C) numeric value
D) formula

Question 36

Options to insert a field (e.g., a filename) into a header or footer are in the ________ group of the Design contextual tab.

A) Header & Footer
B) Header & Footer Elements
C) Navigation
D) Options

Question 37

When the Center on page Horizontally option is checked on the Margins tab of the Page Setup dialog box, the worksheet cells with content are ________.

A) centered between the left and right margins
B) centered between the top and bottom margins
C) centered between the left and right edges of the printed page
D) centered between the top and bottom edges of the printed page

Question 38

Which number format adds commas where appropriate and displays two decimals?

A) Currency
B) Comma
C) General
D) Percentage

Question 39

Number formats can be adjusted with options in the Styles and ________ groups on the Home tab.

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

Question 40

Select the ________ option from the Auto Fill Options menu to keep numeric values unchanged when using the fill handle.

A) Copy Cells
B) Fill Series
C) Fill Format Only
D) Fill Without Formatting

Question 41

When a range is selected, a thick green line surrounds the range, and all cells except the first cell are shaded.

Question 42

When the first entry in a cell is an equal sign, clicking another cell automatically enters that cell's address after the equal sign as part of the formula being created.

Question 43

When the numeric value in a cell changes, any formula or function in the worksheet containing that cell reference is automatically recalculated.

Question 44

When formulas are displayed in a worksheet, what happens?

A) Column width is increased.
B) Row height is increased.
C) Left and right margins are decreased.
D) Top and bottom margins are decreased.

Question 45

Labels are text data values entered at the top of a column or the beginning of a row to clarify the data in the worksheet.

Question 46

Double -clicking on a cell displays the shortcut menu and Mini toolbar.

Question 47

The fill handle appears in all four corners of a selection.

Question 48

Text values and number values are two types of data that can be entered in a worksheet's cell.

Question 49

Directional arrow keys can be used to move the active cell indicator in the direction of the arrow.

Question 50

Using the Enter button to confirm a cell entry keeps that cell the active cell.

Question 51

When content is being copied from one range of cells to another, all source cells need to be selected before the Copy button is clicked, and all destination cells need to be selected before the Paste button is clicked.

Question 52

In a worksheet, columns have numerical headings and rows have alphabetical headings.

Question 53

If an error is made entering a formula, the Enter key can be pressed to remove the contents and start over.

Question 54

Default row height and default column width CANNOT be altered by the user.

Question 55

Individual cells can be selected in a range of cells that have been merged.

Question 56

The fill handle is used to copy content to adjacent cells.

Question 57

The terms displayed value and underlying value are always synonymous.

Question 58

Using the Enter key to confirm a cell entry makes the cell to the right the active cell.

Question 59

A long text value in a cell overlaps into the display of adjacent columns when the cells in the adjacent columns are empty.

Question 60

In a worksheet, pressing Enter after entering data in cell B5, makes cell C5 the active cell.

Question 61

Clarify data in a row or column by typing a(n) ________ at the beginning of the row or column.

Question 62

A row or column is inserted into a worksheet at the location of the selected cell or cells.

Question 63

The Increase Decimal and Decrease Decimal buttons actually add or remove decimal places to the underlying value in a cell.

Question 64

The fill handle can be used to copy content ONLY into adjacent columns.

Question 65

What is the address of the cell in the upper leftmost corner of a worksheet?

Question 66

Text values are aligned at the ________ cell edge.

Question 67

A word identified as misspelled in the Spelling dialog box may actually be spelled correctly.

Question 68

In a worksheet the intersection of a column and row is a(n) ________.

Question 69

The content of a cell can be edited in the worksheet by double-clicking the cell.

Question 70

In Normal View, headers and footers are displayed on the monitor.

Question 71

When the header or the footer of a worksheet is active, the Header & Footer Tools Layout contextual tab appears on the Ribbon.

Question 72

Number values are aligned at the ________ cell edge.

Question 73

What is the address of the cell where the third column and fourth row intersect?

Question 74

Underlying formulas and functions can be displayed in a worksheet and printed.

Question 75

The Spelling dialog box does NOT suggest corrections for words identified as misspelled.

Question 76

Dotted page break lines appear in a worksheet after it is viewed in Print Preview.

Question 77

If the Tab key is pressed when B7 is the active cell, ________ will become the active cell.

Question 78

Pressing Ctrl + Home keys makes ________ the active cell.

Question 79

When a new row or column is inserted in a range of cells used in a function, the range in the function is not automatically adjusted to include that new row or column.

Question 80

Worksheet headers and footers are divided into three sections-left, middle, right.