Deck 9: Manage Multiple Worksheets

Question 1

The Select All Sheets option appears when the user ________.

A) double-clicks on a sheet tab
B) double-clicks on the tab scrolling buttons
C) right-clicks on a sheet tab
D) right-clicks on the tab scrolling buttons

Answer 1

C

Question 2

Tab scrolling buttons are used to ________.

A) scroll up and down through the active worksheet
B) scroll left and right through the active worksheet
C) zoom in and out on the active worksheet
D) display worksheet tabs that are not in view

Answer 2

D

Question 3

If a date is typed as 7-6-14, Excel will complete it as ________.

A) Jul-6-14
B) Jul-14
C) 6-Jul-14
D) 7/6/2014

Answer 3

D

Question 4

One way to rename a worksheet tab is by ________.

A) entering the new name in the Name Box
B) clicking the Rename Sheet option of the Format button in the Cells group on the Home tab
C) entering the new name in the formula bar
D) entering the new name in cell A1 of the worksheet

Question 5

When a selection has been made and the cut button or copy button is clicked, the selection is ________.

A) highlighted
B) surrounded by a moving border
C) surrounded by a red solid border
D) surrounded by a green solid border

Question 6

All of the following are options of the Clear button EXCEPT ________.

A) Clear All
B) Clear Formats
C) Clear Contents
D) Clear Error Value

Question 7

Sheet tab grouping can be canceled by ________.

A) clicking the word Group]on the title bar
B) right-clicking the word Group on the title bar and selecting Ungroup
C) single-clicking on any worksheet tab
D) right-clicking on the tab scrolling buttons and selecting Ungroup

Question 8

When a worksheet is inactive, ________.

A) its tab is moved to the end of the Tab group
B) its tab has no color
C) a gradient of its selected color fills its tab
D) its entire tab is filled with the selected color

Question 9

The keyboard shortcut to insert the current date, obtained from your computer, is ________.

A) [Ctrl] + ;
B) [Ctrl] + /
C) [Ctrl] + -
D) [Ctrl] + ,

Question 10

Options in the Themes group on the Page Layout tab include all of the following EXCEPT ________.

A) Alignment
B) Colors
C) Fonts
D) Effects

Question 11

When multiple worksheet tabs are selected, the title bar displays the word ________ after the name of the workbook.

A) Group
B) Connected
C) Pivot
D) Linked

Question 12

After typing the new name of a worksheet tab, press the ________ key to accept the name change.

A) left arrow
B) right arrow
C) [Enter]
D) [Esc]

Question 13

When Clear Content is selected from the Clear button options, only the ________ is removed from the cell.

A) fill
B) text
C) comment
D) hyperlink

Question 14

Double-clicking a worksheet tab will ________.

A) select the tab's name
B) move the tab to the beginning of the Tab group
C) move the tab to the end of the Tab group
D) make cell A1 the active cell

Question 15

The cut and copy commands make use of temporary storage called the ________.

A) Pasteboard
B) Temporary Board
C) Clipboard
D) Cut/Copy board

Question 16

Clicking the Paste button places the ________ in the destination cells.

A) cell content only
B) cell formatting only
C) cell content and cell formatting
D) cell content, cell formatting, and column width

Question 17

When pasting a range of cells, you only need to select the ________ corner of the paste area.

A) upper right
B) upper left
C) lower right
D) lower left

Question 18

Which date is assigned the serial number of 1?

A) January 1, 2000
B) January 1, 1900
C) January 1, 1800
D) January 1, 1700

Question 19

Clicking the Paste arrow opens the ________ gallery.

A) Clipboard
B) Cut/Paste
C) Copy/Paste
D) Paste Options

Question 20

If the year is left off an entered date, ________.

A) the year 1900 will be automatically inserted
B) the year 2000 will automatically be inserted
C) the current year will be inserted
D) the year will stay blank

Question 21

When the formula =(4-2)*6/2+7 is evaluated in Excel, which will be the first mathematical operation performed?

A) Subtraction
B) multiplication
C) Division
D) Addition

Question 22

Using the Paste button on cells in a selected destination pastes ________.

A) content only
B) formatting only
C) content and formatting
D) nothing (the Paste arrow must be uses and the desired option selected)

Question 23

A ________ is a worksheet with cells referred to by summary sheet formulas.

A) total sheet
B) detail sheet
C) cover sheet
D) properties sheet

Question 24

Right-clicking on a row heading displays ________.

A) a shortcut menu
B) a mini toolbar
C) an Options button
D) a shortcut menu and a mini toolbar

Question 25

The color of a worksheet tab is the same for active and inactive worksheets.

Question 26

The ________ Excel formula accurately displays the use of a cell from another worksheet.

A) =B6
B) =!B6
C) =May!B6
D) =B6!May

Question 27

A ________ is a worksheet that displays and summarizes totals from other worksheets.

A) summary sheet
B) detail sheet
C) synopsis sheet
D) review sheet

Question 28

A worksheet tab can be removed from view by right-clicking the tab and selecting ________ from the shortcut menu.

A) Protect Sheet
B) Move or Copy
C) Hide
D) Tab Color

Question 29

When grouped worksheets are printed, ________.

A) only the first worksheet appears in the Print preview
B) only the last worksheet appears in the Print preview
C) all of the grouped worksheets appear in the Print preview
D) none of the grouped worksheets appears in the Print preview

Question 30

When several worksheets are grouped, inserting a row ________.

A) inserts it only into the first worksheet in the group
B) inserts it into all of the worksheets in the group
C) displays an error message
D) fails to insert a row into any of the worksheets in the group

Question 31

A ________ chart is useful in comparing values across categories.

A) line
B) column
C) pie
D) clustered bar

Question 32

According to operator precedence, the correct order of mathematical operations is ________.

A) parentheses; multiplication or division; addition or subtraction
B) parentheses; addition or subtraction; multiplication or division
C) addition or subtraction; multiplication or division; parentheses
D) multiplication or division; addition or subtraction; parentheses

Question 33

A single-click or double-click on a worksheet tab makes that worksheet active.

Question 34

According to the rules of operator precedence, expressions using ________ are calculated first.

A) parentheses
B) multiplication
C) division
D) addition or subtraction

Question 35

A worksheet inserted into a workbook using the New Sheet button is inserted ________.

A) at the beginning of the Tab group
B) in the middle of the Tab group
C) at the end of the Tab group
D) in the location designated by the user in the dialog box that appears

Question 36

Select All Sheets is an option that appears when a(n) ________ is right-clicked.

A) row heading
B) column heading
C) active cell
D) worksheet tab

Question 37

When the Total style is applied to a group of worksheets, ________.

A) only the first worksheet in the group receives the Total style
B) only the last worksheet in the group receives the Total style
C) all worksheets in the group receive the Total style
D) none of these worksheets receive the Total style because styles cannot be applied to grouped worksheets

Question 38

Legend is an option in the ________ button, located by default to the right of a selected chart.

A) Chart Styles
B) Chart Elements
C) Chart Filter
D) Chart Layout

Question 39

Clicking on a row heading ________.

A) deletes the row
B) insert a row above the clicked row
C) selects the entire row
D) bolds the content of the entire row

Question 40

Excel evaluates the formula =4-2*6/2+7 and performs ________ first.

A) Subtraction
B) Multiplication
C) Division
D) Addition

Question 41

Hyphen (-) and forward slash (/) behave identically in a date entered into the active cell.

Question 42

When the Paste button is clicked, any data already in the paste area are automatically replaced with the clipboard content.

Question 43

The number of cells in a selected destination must be the same as the number in the selected source.

Question 44

Changes like row insertion, column insertion, and column widening are NOT made to all the worksheets in a group.

Question 45

Worksheet tab names CANNOT include numbers.

Question 46

When an item is pasted, it is NOT removed from the Clipboard.

Question 47

When a date is entered without a year, an error value appears in the active cell.

Question 48

Formulas with multiple operators CANNOT be entered in grouped worksheets.

Question 49

The Show Formulas button is a toggle button.

Question 50

When data are entered in a cell and formatting is applied to a cell in one worksheet in a group, the corresponding cells in the other grouped worksheets also receive the data and formatting.

Question 51

When the date is selected as the Number Category in the Format Cells dialog box, the Sample is actually the preview of the date in the active cell displayed as the option selected.

Question 52

Some mathematical operators are considered to be on the same level of precedence.

Question 53

Only visible worksheet tabs can be grouped.

Question 54

In a formula that includes both multiplication and addition, either can be performed first.

Question 55

Both the title bar and the worksheet tabs indicate a grouping.

Question 56

There is more than one way to rename a worksheet tab.

Question 57

Cell content from a worksheet can be pasted to a worksheet in another workbook.

Question 58

The Clear button does NOT have an option for removing all formatting, comments, text, and hyperlinks from a cell.

Question 59

There are several ways to delete cell content.

Question 60

When the serial number for a date appears in a selected cell in the worksheet, it also appears as the underlying value in the formula bar.

Question 61

Using serial numbers to represent dates in an Excel worksheet enables dates to be used in ________.

Question 62

A deleted worksheet can be restored with the Undo button on the Quick Access Toolbar.

Question 63

When the Show Formulas button is on, the ________ of a date appears in the worksheet cell.

Question 64

Clustered bar charts display categories on the horizontal axis and values on the vertical axis.

Question 65

The month of a date is entered by typing either the first ________ nonnumeric characters of the name of the month or the entire month.

Question 66

The Clear button is on the ________ tab of the Ribbon.

Question 67

When Unhide is applied to a worksheet tab, the tab reappears in its original position in the Tab group.

Question 68

Cell content and formatting can be copied from one worksheet in a workbook to another worksheet in the workbook.

Question 69

The name of a worksheet tab can have as many as ________ characters.

Question 70

Headers and footers can be inserted into all the worksheets in a group.

Question 71

Moving between worksheets in a workbook is done by clicking the ________.

Question 72

The usual positions for a chart legend are top, bottom, right, and left.

Question 73

A gradient color on a worksheet tab indicates that the worksheet is ________.

Question 74

Single-clicking on a row heading selects the entire row.

Question 75

Selecting a row and clicking the Insert command, inserts a row above the selected row.

Question 76

A formula can include cell references from the worksheet in which it is located but NOT from other worksheets in the workbook.

Question 77

Worksheet tabs CANNOT be added to a worksheet.

Question 78

The Show Formulas button is on the ________ tab of the Ribbon.

Question 79

Content of a cell can be cleared by pressing the ________ key when the cell is active.

Question 80

Selecting the ________ option from the Clear button removes all text, comments, formatting, and hyperlinks from the selected cell(s).