Question:
How would you select an entire PivotTable report?
None of the above
Question:
Which among the following options displays Legend entries in the given picture?
b.B
Question:
When does the error, as shown in the picture, occur?
c.It occurs when a negative time is used
Question:
Which keyboard shortcut should be used to minimize or restore the ribbon?
b. CTRL+F2
Question:
Which of the following options would you choose to clear a PivotChart report?
c. None of the above
Question:
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.
a. True
Question::
Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?
c. C
Question:
What is the option on the Document Inspector that finds the content type information?
d. Hidden Rows and Columns
Question:
State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
b. False
Question:
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.
b.False
Question:
When would the data validation command be unavailable on the data tab?
c. When the workbook is shared or protected
Question:
Refer to the given image. What will be the result if the formula =B3&", "&A3 is applied on the given table?
b. It will display Fuller Andrew
Question:
Which Consolidate option would you choose when you want to arrange the data in all the worksheets in identical order and location?
a. Consolidate by position
Question:
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?
c. None of the above
Question:
Which file format is typically used to remove printer corruption?
c. SYLK format
Question:
State whether true or false:
When a part of a formula is replaced with its calculated value, it cannot be restored.
a.True
Question:
Which chart displays axes but cannot display axis titles?
d. Pie chart
Question:
How will you find cells with data validation?
b. On the View tab, in the Windows group, click Data Validation
Question:
Where can the 'Show All Comments' command be found?
c. On the Review tab
Question:
Which of the given methods would you follow to add an alternative text to a picture?
b. Right-click on the picture, click on Format. Click on the Alt text tab, and then in the alternative text box, enter your text
Question:
As shown in the image, the checkbox 'Create links to source data' has been selected. Which of the following statements is correct regarding this?
d. None of the above
Question:
How should blank cells be inserted on a Worksheet?
a. Select the cell or the range of cells. Then on the Home tab, in the Cells group, click 'Insert Cells'
Question:
Which of the following charts have no axes?
c. Both a and b
Question:
Refer to the given image. What is the purpose of the cell denoted as 'A' in the worksheet?
b. It selects a large range of cells in the worksheet
Question:
Which of the following is not true regarding naming a cell?
d. Some keyboard characters can cause unexpected results if used in cell names
Question:
Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
c. By value field
Question:
What is the purpose of using the Keep text flat option, as shown in the picture???
b. It prevents the text from blurring
Question:
How would you assign a Macro to a graphic?
b. On the View tab, click on Macros and then click 'Assign Macro' on the shortcut menu. In the Macro name box, click on the macro that you want to assign --
Question:
What does the screen tip displaying "Showing All" mean?
b. It means that Filtering has been enabled but not applied
Question:
State whether true or false:
A Macro project can be digitally signed.
b. False
Question:
Which of the following is not a valid file extension in which an Excel file can be saved?
d. All of the above are valid
Question:
Which of the following is not true regarding column width?
b. A column width between 0 to 255 can be specified
Question:
Which among the following settings is the default macro setting?
d. Enable all macros
Question:
Which keyboard shortcut should be used to enter the current time?
b. CTRL+SHIFT+:
Question:
Which tab should be used to display or hide axes?
c. Insert tab
Question:
Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
b. B
Question:
State whether true or false:
No data is deleted when an outline is hidden or removed.
b. False
Question:
How will you reverse the direction of a SmartArt graphic?
c. Under SmartArt Tools, on the Design tab, in the Create Graphic group, click on Right to Left
Question:
What is the significance of the red symbol at the top right corner of the cell, as shown in the picture?
c. It signifies that the cell contains a macro
Question:
State whether true or false:
A Macro project can be digitally signed.
a. True
