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