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"?
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:
Post a Comment