STEP: 4
Q-33:
How can a chart be modified? ( Answers)
-By modifying a legend
-By modifying the display of chart axes
-By modifying titles and data labels
-All of the above
Q-34:
This question is based upon the figure shown belowWhen does the triangle
appear in the top-left corner of the cell, as shown in the picture? ( Answers)
-When the cell contains hidden information
-When the cell contains the Time function
-When there is an error in the formula
-None of the above
Q-35:
Which database function estimates variance based on a sample from
selected database entries? ( Answers)
-DSTDEV
-DSUM
-DVAR
-DVARP
Q-36:
Which chart displays axes but cannot display axis titles? (Step: 4 Answers)
-Radar chart
-Doughnut chart
-Pie chart
-All of the above
Q-37:
How will you reverse the direction of a SmartArt graphic? ( Answers)
-Right-click on the SmartArt graphic,
select Reverse
-Under SmartArt Tools, on the Format tab,
in the Arrange group, select Reverse
-Under SmartArt Tools, on the Design tab,
in the Create Graphic group, click on Right to Left
-All of the above
Q-38: Which database function estimates variance based on a sample from selected database entries? ( Answers)
-DSTDEV
-DSUM
-DVAR
-DVARP
Q-39: How would you locate the last cell on a worksheet? ( Answers)
-Click anywhere in the worksheet, and then
press CTRL+HOME
-Click anywhere in the worksheet, and then
press CTRL+INSERT
-Click anywhere in the worksheet, and then
press CTRL+END
-None of the above
Q-40: Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location? ( Answers)
-Consolidate by position
-Consolidate by category
-Consolidate by formula
-None of the above
Q-41:
Which of the following options is not available on the Status bar? (
Answers)
-Cell mode
-Selection mode
-End mode
-Start mode
