SETP: 3
Q-1:
Refer to the given picture, which option causes the last row in the
table to appear and displays the word Total in the leftmost cell?
Ans: B (Total row)
Q-2:
What is the option on the Document Inspector that finds the content type
information?
Ans: Document Properties and Personal
Information
Q-3:
How will you find cells with data validation?
Ans: On the Home tab, in the Editing group,
click the arrow next to Find & Select,, then click Go -To Special. Click on
Data Validation, and then click All
Q-4:
For XY (scatter) and bubble charts, error bars for the x values, the y
values , or both can be displayed.
Ans: true
Q-5:
How should blank cells be inserted on a Worksheet?
Ans:
Both a and b
Q-6:
Case-sensitive sorting of text in Excel2007 can be performed.
Ans: True
Q-7:
Which of the following is true about a freeform shape?
Ans: All of the above is true
Q-8:
Which keyboard shortcut should be used to enter the current time?
Ans: CTRL+SHIFT+:
Q-9:
Deleting the PivotChart report automatically deletes the associated PivotTable report.
Ans: False
Q-10:
Which of the following is a default method of a PivotTable report for
scoping the conditional format of a fields in the values area?
Ans: By selection
Q-11:
Which method will you use to update table data from a Sharepoint list?
Ans: In the Design tab, On the External
Data Tools group, Click Refresh
Q-12:
How will you display the Go To dialog box?
Ans: You will press F5
Q-13:
Which part of the formula displays references in the given picture?
Ans: B
Q-14:
Which of the given Document properties includes both file system properties
and statistics that are maintained by Office programs for the user?
Ans: Automatically updated properties
Q-15:
Which keyboard shortcut should be used to minimize or restore the
ribbon?
Ans: CTRL+F1
Q-16:
When the table headers are turned off, the table header Autofilters and
all other applied filters are removed from the table.
Ans: True
Q-17:
If a SmartArt graphic is converted to individual shapes, it is not
possible to convert them back to the SmartArt graphic
Ans: True
Q-18:
Which of the following operators is not a type of calculation operator?
Ans:
equation
Q-19:
Which Consolidate option would you choose when you want to arrange data
in all the worksheets in identical order and location?
Ans: Consolidate by position
Q-20:
Which option would you choose to
display a list of formula used in the current PivotTable report?
Ans: On the Options tab, in the Tools
group, click on Formula, and then click “List Formula”
Q-21:
Which of the given Document properties includes both file system
properties and statistics that are maintained by Office programs for the user?
Ans: Automatically updated properties
Q-22:
When does the error, as shown in the picture, occur?
Ans: All of the above.
Q-23:
Refer to the given, What is the purpose of the cell denoted as 'A' in
the worksheet?
Ans: It selects all the cells in the
worksheet.
Q-24:
Refer to the given image, which formula should be written on the given
table to display "Nancy Davolio"?
Ans: =PROPER(A2)
Q-25:
How would you assign a Macro to a graphic
Ans: On the worksheet, right-click on the
graphic, then click "Assign Macro" on the shortcut menu. In the Macro
name box, click on the macro that you want to assign.
Q-26:
No data is deleted when an outline is hidden or removed.
Ans: True.
Q-27:
Refer to the given image, which of the following Fill options should be
used to add color and transparency to a shape?
Ans: A
(No fill)
Q-28:
Which among the following settings is the default macro setting?
Ans: Disable all macros with notification.
Q-29:
Which type of additional information is stored within the digital
signature?
Ans: All of the above.
Q-30:
When 'a' or 'p' is not typed after the time in Worksheet cells, what
does Excel enter the default time as?
Ans: It enters the time as AM.
Q-31:
Which of the following is not a valid file extension in which an Excel
file can be saved?
Ans: PXL
Q-32:
When would the data validation command be unavailable on the data tab?
Ans: All of the above.
