QUESTION 1 ____ format codes allow you to specify how a cell entry assigned a format will appear….

QUESTION 1 ____ format codes allow you to specify how a cell entry
assigned a format will appear. a. Duplicate b. Individual c.
Specific d. Custom 1 points Save Answer QUESTION 2 A ____ is a
reference to a cell or range of cells in another workbook. a. code
b. formula c. function d. link 1 points Save Answer QUESTION 3 A
range that spans two or more worksheets in a workbook is called a
____ range. a. 1-D b. 2-D c. 3-D d. 4-D 1 points Save Answer
QUESTION 4 A workbook contains ____ worksheet(s) by default. a. one
b. two c. three d. four 1 points Save Answer QUESTION 5 A(n) ____
reference is a formula that depends on its own value. a. implicit
b. explicit c. singular d. circular 1 points Save Answer QUESTION 6
As you link workbooks, the cell reference inserted by Excel each
time you tap or click a cell in a workbook results in a(n) ____
cell reference. a. integrated b. dynamic c. absolute d. relative 1
points Save Answer QUESTION 7 Headers, footers, and margins are all
____ options. a. validation b. control c. page setup d. calculation
1 points Save Answer QUESTION 8 If multiple sheets are selected and
you want to select the active sheet, if you are using a touch
screen, press and hold and select ____ from the shortcut menu. a.
Ungroup Sheets b. Disaggregate Sheets c. Select Active Sheet d.
Quick Select 1 points Save Answer QUESTION 9 It is recommended that
you use the ____ function on formulas that potentially can result
in more decimal places than the applied format displays. a. IF b.
SUM c. DATE d. ROUND 1 points Save Answer QUESTION 10 Once you have
selected a range to chart, you can press ____ to draw a chart on a
worksheet. a. F5 b. F6 c. F11 d. F12 1 points Save Answer QUESTION
11 The ____ keyboard shortcut copies an image of the source area as
a picture. a. CTRL+K b. CTRL+R c. CTRL+I d. CTRL+U 1 points Save
Answer QUESTION 12 The ____ style is the format style that Excel
initially assigns to all cells in a workbook. a. Standard b. Number
c. Normal d. Currency 1 points Save Answer QUESTION 13 The code
____ instructs Excel to insert the page number in the header or
footer section. a. (LoadPageNum) b. &[Page] c. <> d.
[PageNum] 1 points Save Answer QUESTION 14 The following sequence,
1, 1, 1, etc., is an example of a(n) ____ series. a. linear b.
growth c. date d. auto fill 1 points Save Answer QUESTION 15 The
following sequence, 1, 2, 3, etc., is an example of a(n) ____
series. a. linear b. growth c. date d. auto fill 1 points Save
Answer QUESTION 16 The following sequence, 2, 4, 6, etc., is an
example of a ____ series. a. growth b. fill c. linear d. date 1
points Save Answer QUESTION 17 The following sequence, Jan, Feb,
Mar, etc., is an example of a ____ series. a. fill b. linear c.
growth d. date 1 points Save Answer QUESTION 18 The path to the
Comma Style button is ____. a. (HOME tab | Cells group) b. (HOME
tab | Alignment group) c. (HOME tab | Number group) d. (HOME tab |
Font group) 1 points Save Answer QUESTION 19 The path to the Sum
button is ____. a. (Editing tab | Calculations group) b. (Insert
tab | Editing group) c. (Home tab | Editing group) d. (Data tab |
Functions group) 1 points Save Answer QUESTION 20 The process of
summarizing data included on multiple worksheets on one worksheet
like the one shown in the accompanying figure is called ____. a.
recapitulation b. encapsulation c. summarization d. consolidation 1
points Save Answer QUESTION 21 To copy the contents of a cell to
the cell directly below it, click the target cell and press ____.
a. CTRL+D b. CTRL+X c. CTRL+C d. CTRL+V 1 points Save Answer
QUESTION 22 To select adjacent sheets, select the first sheet by
clicking its tab and then hold down the ____ key and click the
sheet tab at the other end of the list of adjacent sheet tabs. a.
CTRL b. SHIFT c. ALT d. ESC 1 points Save Answer QUESTION 23 To
select nonadjacent sheets, select the first sheet by clicking its
tab and then hold down the ____ key and click the sheet tabs of the
remaining sheets you want to select. a. CTRL b. ESC c. ALT d. SHIFT
1 points Save Answer QUESTION 24 When you insert a manual page
break, Excel displays a(n) ____ line between pages. a. orange b.
solid c. dotted d. red 1 points Save Answer QUESTION 25 When you
print a worksheet or use the Page Setup dialog box, Excel inserts
____ breaks that show the boundaries of what will print on each
page. a. section b. sheet c. range d. page 1 points Save Answer
QUESTION 26 When you print a worksheet or use the Page Setup dialog
box, Excel inserts ____ that show the boundaries of what will print
on each page. a. margins b. indices c. selection barriers d. page
breaks 1 points Save Answer QUESTION 27 Which of the following
format codes insures that Excel will display a decimal point in the
number? a. . (period) b. $* c. ( ) d. % (percent) 1 points Save
Answer QUESTION 28 Which of the following format codes shows
percent values with two decimal places and shows negative percent
values in blue with parentheses? a. $*#,##0_;[Blue]($*#,##0_) b.
0.00%[Blue];(0.00%) c. 0.00%;[Blue](0.00%) d.
#,##0.00;[Blue](#,##0.00) 1 points Save Answer QUESTION 29 Which of
the following format symbols displays text along with numbers
entered in a cell? a. “ ” (quotation marks) b. # (number sign) c. 0
(zero) d. _ (underscore) 1 points Save Answer QUESTION 30 Which of
the following is the path to the Breaks button? a. (HOME tab | Page
Setup group) b. (PAGE LAYOUT tab | Sheet Options group) c. (PAGE
LAYOUT tab | Page Setup group) d. (VIEW tab | Show group) 1 points
Save Answer QUESTION 31 Which of the following is the path to the
Fill button? a. (FORMULAS tab | Fill group) b. (HOME tab | Editing
group) c. (INSERT tab | Editing group) d. (DATA tab | Fill group) 1
points Save Answer QUESTION 32 Which of the following is the path
to the Insert Cells button? a. (INSERT tab | Cells group) b. (DATA
tab | Insert group) c. (CELLS tab | Home group) d. (HOME tab |
Cells group) 1 points Save Answer QUESTION 33 Which of the
following is the path to the Switch Windows button? a. (VIEW tab |
Window group) b. (INSERT tab | View group) c. (VIEW tab | Workbook
Views group) d. (REVIEW tab | Windows group) 1 points Save Answer
QUESTION 34 Which of the following keyboard shortcuts allows you to
select a range of cells with entries surrounded by blank cells? a.
SHIFT+HOME+ASTERISK (*) b. CTRL+SHIFT+ASTERISK (*) c.
ALT+SHIFT+ASTERISK (*) d. TAB+SHIFT+ASTERISK (*) 1 points Save
Answer QUESTION 35 You can display the ____ tab to specify page
setup options. a. PRINT b. SETUP c. DISPLAY d. PAGE LAYOUT 1 points
Save Answer QUESTION 36 You can drill all of the following down
through a workbook EXCEPT ____. a. formulas b. groupings c. formats
d. numbers 1 points Save Answer QUESTION 37 You can switch to Page
Layout view by clicking the Page Layout button ____. a. (VIEW tab |
Show group) b. on the FILE tab c. on the status bar d. (HOME tab |
Layout group) 1 points Save Answer QUESTION 38 You should click
____ in the Category list on the Number sheet in the Format Cells
dialog box to select or create a format code. a. General b. Custom
c. Number d. Accounting 1 points Save Answer QUESTION 39 You should
create good ____ to ensure your workbooks are free of errors. a.
color contrast b. range boundaries c. test data d. none of the
above 1 points Save Answer QUESTION 40 You should hold down the
____ key to select the nonadjacent cells. a. END b. TAB c. CTRL d.
SHIFT