excel ch 3

18) When multiple worksheet tabs are selected, the title bar displays the word ________ after the name of the workbook. A) Group B) Pivot C) Connected D) Linked

A) Group

7) Which date is assigned the serial number of 1? A) January 1, 1900 B) January 1, 2000 C) January 1, 1800 D) January 1, 1700

A) January 1, 1900

26) Right-clicking a row heading displays ________. A) a shortcut menu B) a shortcut menu and a mini toolbar C) a mini toolbar D) an Options button

A) a shortcut menu

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

A) all worksheets in the group receive the Total style

17) Clicking the Paste button places the ________ in the destination cells. A) cell content and cell formatting B) cell content only C) cell formatting only D) cell content, cell formatting, and column width

A) cell content and cell formatting

38) A screen ________ is a picture of a portion of the computer screen that can be inserted into a worksheet. A) clipping B) shot C) snap D) illustration

A) clipping

35) A ________ chart is useful in comparing values across categories. A) clustered bar B) scatter C) line D) pie

A) clustered bar

30) A worksheet tab can be removed from view by right-clicking the tab and selecting ________ from the shortcut menu. A) hide B) Protect Sheet C) Tab Color D) Move or Copy

A) hide

27) When multiple worksheets are grouped, inserting a row ________. A) inserts it into all of the worksheets in the group B) inserts it only into the first worksheet in the group C) displays an error message D) fails to insert a row into any of the worksheets in the group

A) inserts it into all of the worksheets in the group

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

A) select the tab's name

33) A ________ is a worksheet that displays and summarizes totals from other worksheets. A) summary sheet B) detail sheet C) synopsis sheet D) review sheet

A) summary sheet

14) When a selection has been made and the cut button or copy button is clicked, the selection is ________. A) surrounded by a green solid border B) surrounded by a red solid border C) highlighted D) surrounded by a moving border

A) surrounded by a green solid border

12) When Clear Content is selected from the Clear button options, only the ________ is removed from the cell. A) text B) fill C) comment D) hyperlink

A) text

13) The cut and copy commands make use of temporary storage called the ________. A) Tablet B) Clipboard C) Pasteboard D) Cut/Copy board

B) Clipboard

36) A(n) ________ gives a visual representation of information that is used to effectively communicate ideas. A) clustered bar chart B) SmartArt graphic C) organization chart D) screen clipping

B) SmartArt graphic

23) When the formula =(4-2)*6/2+7 is evaluated in Excel, which will be the first mathematical operation performed? A) Multiplication B) Subtraction C) Division D) Addition

B) Subtraction

32) A ________ is a worksheet with cells referred to by summary sheet formulas. A) total sheet B) detail sheet C) cover sheet D) properties sheet

B) detail sheet

2) Tab scrolling buttons are used to ________. A) scroll up and down through the active worksheet B) display worksheet tabs that are not in view C) scroll left and right through the active worksheet D) zoom in and out on the active worksheet

B) display worksheet tabs that are not in view

21) According to the rules of operator precedence, expressions using ________ are calculated first. A) multiplication B) parentheses C) division D) addition or subtraction

B) parentheses

19) The Select All Sheets option appears when the user ________. A) double-clicks on the tab scrolling buttons B) right-clicks on a sheet tab C) double-clicks on a sheet tab D) right-clicks on the tab scrolling buttons

B) right-clicks on a sheet tab

25) Clicking a row heading ________. A) deletes the row B) selects the row C) inserts a row above the clicked row D) bolds the content of the entire row

B) selects the row

37) A screen ________ is an image of the computer screen. A) clipping B) shot C) snap D) illustration

B) shot

10) If a date is typed as 7-5-17, Excel will complete it as ________. A) 7/5/2017 B) Jul-17 C) 5-Jul-17 D) Jul-5-17

C) 5-Jul-17

34) The ________ Excel formula accurately displays the use of a cell from another worksheet. A) =B6! B) =B6 C) =May!B6 D) =B6!May

C) =May!B6

5) Options in the Themes group on the Page Layout tab include all of the following EXCEPT ________. A) Colors B) Fonts C) Alignment D) Effects

C) Alignment

11) All of the following are options of the Clear button EXCEPT ________. A) Clear All B) Clear Formats D) Clear Contents C) Clear Error Value

C) Clear Error Value

9) The keyboard shortcut to insert the current date, obtained from your computer, is ________. A) Ctrl + * B) Ctrl + / C) Ctrl + ; D) Ctrl + ,

C) Ctrl + ;

3) After typing the new name of a worksheet tab, press the ________ key to accept the name change. A) right arrow B) left arrow C) Enter D) Esc

C) Enter

15) Clicking the Paste arrow opens the ________ gallery. A) Cut/Paste B) Clipboard C) Paste Options D) Copy/Paste

C) Paste Options

39) The small toolbar that contains buttons for commonly used tasks is the ________ Toolbar. A) Task Access B) Common Reference C) Quick Access D) Quick Reference

C) Quick Access

6) When a worksheet is inactive, ________. A) its tab is moved to the end of the Tab group B) its tab has no color C) its entire tab is filled with the selected color D) a gradient of its selected color fills its tab

C) its entire tab is filled with the selected color

22) According to operator precedence, the correct order of mathematical operations is ________. A) addition or subtraction; multiplication or division; parentheses B) parentheses; addition or subtraction; multiplication or division C) parentheses; multiplication or division; addition or subtraction D) multiplication or division; addition or subtraction; parentheses

C) parentheses; multiplication or division; addition or subtraction

16) When pasting a range of cells, you only need to select the ________ corner of the paste area. A) upper right B) lower right C) upper left D) lower left

C) upper left

28) Select All Sheets is an option that appears when a(n) ________ is right-clicked. A) row heading B) active cell C) worksheet tab D) column heading

C) worksheet tab

1) One way to rename a worksheet tab is by ________. A) entering the new name in cell A1 of the worksheet B) entering the new name in the Name Box C) entering the new name in the formula bar D) clicking the Rename Sheet option of the Format button in the Cells group on the Home tab

D) clicking the Rename Sheet option of the Format button in the Cells group on the Home tab

40) An example of a(n) ________ is http://www.microsoft.com. A) reference B) clipping C) operator D) hyperlink

D) hyperlink

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

D) in the location designated by the user in the dialog box that appears

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

D) right-clicking on the tab scrolling buttons and selecting Ungroup

8) If the year is not entered when typing a date into a cell, ________. A) the year 2000 will be automatically inserted B) the year 1900 will be automatically inserted C) the year will stay blank D) the current year will be inserted

D) the current year will be inserted