Friday, August 5, 2016

Microsoft-MS Excel 2007 Test Answers



Ques : What is the option on the Document Inspector that finds the content type information?
Ans  :  Document Properties and Personal Information

Ques : How can a chart be modified?
Ans  : By modifying the display of chart axes

Ques : What does the screen tip displaying "Showing All" mean?
Ans  : It means that Filtering has been enabled but not applied

Ques : Which among the following options displays Legend entries in the given picture?
Ans  : c

Ques : How would you assign a Macro to a graphic?
Ans  : All of the above

Ques : 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'

Ques : Refer to the given image. What will be the result if the formula =B3&", "&A3 is applied on the given table?
Ans  : It will display Fuller, Andrew

Ques : Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
Ans  : Consolidate by position

Ques : 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'

Ques :  Which method will you use to update table data from a Sharepoint list?
Ans  :  On the Design tab, in the External Data group, click Refresh

Ques : How would you locate the last filled cell on a worksheet?
Ans  : Click anywhere in the worksheet, and then press CTRL+END

Ques : Which part of the formula displays references in the given picture?
Ans  : B

Ques : What does the red icon indicate, as shown in the given picture?
Ans  : It tells the user that the document contains Signatures

Ques : 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

Ques : Which Chart type is displayed in the given picture?
Ans  : A surface chart

Ques : State whether true or false:
If a SmartArt graphic was converted to individual shapes, it is not possible to convert them back to the SmartArt graphic.
Ans  : True

Ques :  How would you select an entire PivotTable report?
Ans  :  On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"

Ques :  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

Ques :  When does the triangle appear in the top-left corner of the cell, as shown in the picture?
Ans  : When there is an error in the formula

Ques : How will you display the Go To dialog box?
Ans  :  You will press F5

Ques : Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
Ans  : B

Ques : Which tab should be used to display or hide axes?
Ans  : Layout tab

Ques : 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

Ques : Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?
Ans  :  None of the above

Ques : Which of the following is not true regarding naming a cell?
Ans  :  Names are case sensitive

Ques : State whether true or false:
When you sign the stamp signature line in an Office document, you add both a visible stamp and a digital signature.
Ans  : True

Ques : Where can the 'Show All Comments' command be found?
Ans  : All of the above

Ques : State whether true or false:

When the table headers are turned off, the table header Autofilters and all other applied filters are removed from the table.
Ans  : True

Ques : Which of the following is not true regarding column width?
Ans  : All of the above are true

Ques : Which chart displays axes but cannot display axis titles?
Ans  : All of the above

Ques : When does the error, as shown in the picture, occur?
Ans  : All of the above

Ques : 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

Ques : How should blank cells be inserted on a Worksheet?
Ans  :Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells' + Select the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu

Ques : Which of the following is not true about the Watch Window?
Ans  : There can be two Watch Windows per cell

Ques : Refer to the given image. Which line style option should be used to specify the style used for the end of the line?
Ans  : B

Ques : Which of the given methods would you follow to add an alternative text to a picture?
Ans  : Right-click on the picture, click on Size and Properties. Click on the Alt text tab, and then in the alternative text box, enter your text

Ques : 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

Ques : Which keyboard shortcut should be used to enter the current time in a cell in an excel sheet using a QWERTY computer keyboard?
Ans  : CTRL+SHIFT+:

Ques : When would the data validation command be unavailable on the data tab?
Ans  : All of the above

Ques : Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
Ans  : C

Ques : 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

Ques : Which of the following charts have no axes?
Ans  : Both a and b

Ques : Which keyboard shortcut should be used to enter the current time?
Ans  : CTRL+SHIFT+:

Ques :  Which file format is typically used to remove printer corruption?
Ans  : SYLK format

Ques : State whether true or false:
A Macro project can be digitally signed.
Ans  : True

Ques : Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
Ans  : By value field

Ques : Which of the following options should be used to create a connection to a shared network folder, as shown in the picture
Ans  : A

Ques : Which type of additional information is stored within the digital signature?
Ans  : All of the above

Ques : State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
Ans  : True

Ques : Which of the following is not a valid file extension in which an Excel file can be saved?
Ans  : All of the above are valid

Ques : As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
Ans  : None of the above

Ques : Refer to the given image. What is the purpose of the cell denoted as 'A' in the worksheet?
Ans  : It selects all the cells in the worksheet

Ques : 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 WordArt is rotated

Ques : 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

Ques : Which database function estimates variance based on a sample from selected database entries?
Ans  : DVAR

Ques : State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.
Ans  : True

Ques : Which of the following is not true about an offline cube file?
Ans  : The file format for an offline cube file is .CUE

Ques : State whether true or false:

No data is deleted when an outline is hidden or removed.
Ans  : True

Ques :  State whether true or false:

Deleting the PivotChart report automatically deletes the associated PivotTable report.
Ans  : False

Ques : Which among the following is not true regarding a calculated column?
Ans  : It automatically expands to include additional rows

Ques : How will you reverse the direction of a SmartArt graphic?
Ans  : Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left

Ques : Which keyboard shortcut should be used to minimize or restore the ribbon?
Ans  :  CTRL+F1

Ques :  Which among the following settings is the default macro setting?
Ans  : Disabled all macros with notification

Ques : Which of the following wildcard characters can be used as comparison criteria for Text Filters?
Ans  : All of the above

Ques : 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

Ques : State whether true or false:
For XY (Scatter) and bubble charts; error bars for the x values, the y values, or both, can be displayed.
Ans  : True

Ques : Which of the following options is not available on the Status bar?
Ans  : Start mode

Ques : What would be the result, when =T(A4) is applied on the given table?
Ans  : The text True is returned

Ques : Refer to the given image. Which formula should be written on the given table to display "Nancy Davolio"?

No comments: