SET 2
Q: when a part of a
formula is replaced with its calculated value, it cannot be restored.
a. True.
Q: When you sign the
stamp signature line in an office document, you add both a visible stamp and a
document signature.
a. True
Q: Refer to the given
image, what will be the result if the formula =B3&”, ”&A3 is applied to the given table?
d. Both b and c
Q: How will you
reverse the direction of a Smart art graphics?
c. Under SmartArt tools,
on the Design tab, in the Create Graphic group, click on Right to Left
Q: Which of the
following chart have no
axes?
c. C-both a and b
Q: Which of the
following is not true regarding column width?
d. all of the above are
true
Q: Which chart type
is displayed in the given picture?
b.A surface chart
Q:What does the red
icon indicate as shown in the given picture?
b. it tells the user
that the document contains signatures
Q: Which among the
following is not true regarding a calculated column?
d. Additional formulae
cannot be entered in a calculated column as exceptions
Q: What does the
screen tip displaying “Showing all” mean?
a. It means that a filter
has been applied.
Q: Which chart
displays axes but can not display axis titles?
a. Radar chart
Q: Which file format
is typically used to remove printer corruption?
c. SYLK format
Q: Which of the
following methods would you follow to remove subtotals?
a. On the Data tab, in the
Outline group, click on Subtotal. The subtotal dialog box is displayed. Click
Remove all
Q: When does
triangle appear in the Top-left corner of the cell, as shown in the picture?
c. When there is an error
in the formula
Q: Which lookup
function should be used when the comparison values are located in a column to
the left of the data that is to be found?
b. VLOOKUP
Q16: Which scoping
method should be used to conditionally format a set of fields in the values
area for all levels in the hierarchy of data?
c. Scoping by value field
Q: Where can the
“Show all comments” command be found?
c. On the Review tab
Q: Which of the
following is not true about an offline cube file
b. The file format for an
offline cube file is .CUE
Q: What is the
significance of the red symbol at the top right corner of the cell, as shown in
the picture?
b. It signifies that the
cell contains a comment.
Q: Which of the
following is not true regarding naming a cell?
a. Names are case
sensitive.
Q: Which of the
following options should be used to create a connection to a shared network
folder, as shown in the picture?
a. A
(MAP NETWORK DRIVE)
Q: Which of the
following charts shows numerical values on the vertical (value) axis and
textual groupings (or categories) on the horizontal axis?
c. Area charts
Q: Which of the
following options would you choose to clear a PivotChart report?
a. On the Analyze tab, in
the Data group, click on Clear and then click “Clear All”.
Q: Which of the
following wildcard characters can be used as comparison criteria for Text
Filters?
d. All of the above.
Q: Which tab should
be used to display or hide axes?
b. Layout tab
Q: When would you
use smart graphic?
a. List information b.
create a matrix illustration c. Show a relationship between parts, such as
overlapping concepts
Q: Which tab is
required to work with Macros?
b. Developer tab. e. View
tab
Q: Referring to the
given image, point out which option should be selected to automatically save a
backup copy of a workbook.
b. B General options
Q: Which keyboard
shortcut re-calculates all formulas in all open workbooks, regardless of
whether or not they have change3d since the last time?
d. None of above.
Q: Refer to the
given image Which line style option should be used to specify the style used
for the end of the line?
c. C
c. C
Q: Which of the
following is not true about the Watch Window?
c. There can be two Watch
windows per cell.
Q: How would you
select an entire PivotalTable report?
b. On the Options tab,
in the Actions group, click Select, and then
click Entire PivotTable.
Q: A Macro can be
digitally signed.
a. True
Q: What would be the
result, when =T(A4) is applied on the given table?
a. The text TRUE is
returned
Q: When you freeze
panes, you select specific rows or columns that remain visible when scrolling
in the worksheet.
a. True
Q: Which among the
following options displays Legend entries in the given picture?
c. C
Q: What is the
purpose of using the Keep text flat option, as shown in the picture?
a. It prevents the text
inside the wordart from rotating when rotate wordArt is rotated.
Q: Which of the
given methods would you follow to add an alternative text to a picture?
a. Right-click the picture, click Size and Properties.Click the Alt Text tab, and then in the Alternative text box, enter your text.
a. Right-click the picture, click Size and Properties.Click the Alt Text tab, and then in the Alternative text box, enter your text.
Q: Some data is to
be refreshed in an imported XML file. Where can the command on the Ribbon be
found?
c. On the Developer tab
Q: Refer to the
given image Which of the following password options uses an encryption method?
c. Both a and b
0 comments:
Post a Comment