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
Tony SparkEnlightened
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
Solution:
Custom format codes , it allow to specify how a cell entry
assigned a format will appear.
That means Excel sheet it will accept the cell entries through
the Custom format codes.
Thus the correct option is (d) Custom format
codes.
QUESTION 2
A ____ is a reference to a cell or range of cells in another
workbook.
a. code
b. formula
c. function
d. link
Solution:
Link is a reference to a cell or range of cells in another
workbook. That means can access the values from another work book
through providing link reference.
Thus the correct option is (d) link.
QUESTION 4
A workbook contains ____ worksheet(s) by default.
a. one
b. two
c. three
d. four
Solution:
A workbook contains three worksheet(s) by default. At the time
of open an excel sheet it will contains the default sheets like
sheet1, sheet2, sheet 3.
Thus the correct option is (c) three.
QUESTION 5
A(n) ____ reference is a formula that depends on its own
value.
a. implicit
b. explicit
c. singular
d. circular
Solution:
A circular reference is formula that depends on its own value,
that means can access the own value of a cell then refer the
circular reference.
Thus the correct option is (d) circular.
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
Solution:
Reference of cell inserted by the excel use the relative cell
reference. That means use the relative reference adjust the
reference in copied formula.
Thus the correct option is (d) relative
QUESTION 7
Headers, footers, and margins are all ____ options.
a. validation
b. control
c. page setup
d. calculation
Solution:
In Excel sheet maintain the data in proper format that means
providing some alignments to page like Headers ,footers and
margins, these are all page setup options.
Thus the correct option is (c) page setup
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
Solution:
Select active sheet when multiple sheets are selected by the
user , then go for the option is Ungroup sheets , it will
disconnect the sheets that means you can access selected sheet
.
Thus the correct option is (a) Ungroup
Sheets.
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
Solution:
Round the decimal places in result produced by the functions ,
use the ROUND method it will round up the decimal points of result
up to some level and display the result in proper format.
Thus the Correct option is (c) ROUND
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
Solution:
When draw a chart on worksheet, you need to specify particular
range on chart then press on F11 button. It will draw the chart on
that range .
Thus the correct option is (c) F11
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
Solution:
Copies an image of the source area in excel sheet ,you can go
through the key board shortcut as CTRL+U. The CTRL+U contains the
functionality of the copy an image.
Thus the Correct option is (d) CTRL+U
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
Solution:
Excel sheet have default one format style that assigns to all
cells in a work book that is Normal style. It will be assign
initially some format to the cells of the work book.
Thus the correct option is (c) Normal.
QUESTION 13
The code ____ instructs Excel to insert the page number in the
header or footer section.
a. (LoadPageNum)
b. &[Page]
c. <>
d. [PageNum]
Solution:
Insert the page number in the header or footer section provide
code &[Page], It will instructs to the excel sheet provide page
number in the header or footer section.
Thus the Correct option is (b) &[Page].