1. 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. B2. Which keyboard shortcut should be used to enter the current time?
Ans: d.None of the above
3. What does the screen tip displaying "Showing All" mean?
Ans: b. It means that Filtering has been enabled but not applied
4. 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: b. False
5. Which of the following charts have no axes?
Ans: c. Both a and b
6. How would you locate the last cell on a worksheet?
Ans: d. None of the above
7. What is the purpose of using the Keep text flat option, as shown in the picture?
Ans: d. Both b and c
8. How will you reverse the direction of a SmartArt graphic?
Ans: b. Under SmartArt Tools, on the Format tab, in the Arrange group, select Reverse
9. Refer to the given image. Which of the following Fill options should be used to add color and transparency to a shape?
Ans: c. C
Ans: d. D
11. Which of the following wildcard characters can be used as comparison criteria for Text Filters?
Ans: c. ~
12. How can a chart be modified?
Ans: c. By modifying titles and data labels
13. Which keyboard shortcut re-calculates all formulas in all open workbooks, regardless of whether or not they have changed since the last time?
d. None of the above
14. State whether true or false:
A Macro project can be digitally signed.
Ans: a. True
15. How would you select an entire PivotTable report?
Ans: b. On the Options tab, in the Actions group, click on Select, and then click 'Entire PivotTable'"
16. When 'a' or 'p' is not typed after the time in Worksheet cells, what does Excel enter the default time as?
Ans: a. It displays the prompt box and asks the user to type 'a' or 'p'
17. How would you assign a Macro to a graphic?
Ans: d. All of the above
18. Which of the following is not a valid file extension in which an Excel file can be saved?
Ans: d. All of the above are valid
19. Which of the following options should be used to create a connection to a shared network folder, as shown in the picture?
Ans: c. C
20. Which of the following options is not available on the Status bar?
Ans: b. Selection mode
21. Which of the following is not true regarding naming a cell?
Ans: d. Some keyboard characters can cause unexpected results if used in cell names
22. What is the option on the Document Inspector that finds the content type information?
Ans:c. Document Properties and Personal Information
23. Which of the following is a default method of a PivotTable report for scoping the conditional format of fields in the values area?
Ans: b. By corresponding field
24. State whether true or false:
No data is deleted when an outline is hidden or removed.
Ans: a. True
25. 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: d. None of the above
26. Which of the following methods would you follow to remove subtotals?
Ans: c. Both a and b
27. Refer to the given image. What is the purpose of the cell denoted as ‘A’ in the worksheet?
Ans: c. It selects non-adjacent cells in the worksheet
28. Which of the following is not true about an offline cube file?
Ans: b. The file format for an offline cube file is .CUE
29. Which of the following options would you choose to clear a PivotChart report?
Ans: c. Both a and b
30. State whether true or false:
Case-sensitive sorting of text in Excel2007 can be performed.
Ans: a. True
31. State whether true or false:
When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet.
Ans: a. True
32. 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: b. Scoping by corresponding field
33. 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: a. True
34. 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: a. True
35. Which of the following is not true regarding column width?
Ans: d. All of the above are true
36. Where can the 'Show All Comments' command be found?
Ans: d. All of the above
37. When does the triangle appear in the top-left corner of the cell, as shown in the picture?
Ans: b. When the cell contains the Time function
38. How should blank cells be inserted on a Worksheet?
Ans: b. Slect the cell or the range of cells. Then right-click on the selected cells and click on Insert in the shortcut menu
39. Referring to the given image, point out which option should be selected to automatically save a backup copy of a workbook.
Ans: b. B
40. When would the data validation command be unavailable on the data tab?
Ans: d. All of the above
0 comments:
Post a Comment