1. Which of the following types of
filters can be created using the AutoFilter option in Microsoft Excel 2016?
i) By list values.
ii) By format.
iii) By criteria.
a. Only option ii).
b. Only options ii) and iii).
c. Only options i) and iii).
d. All options i), ii) and iii).
2. What are ScreenTips in Microsoft
Excel 2016?
a. These are the hyperlinks created
in a workbook, which take a user from one worksheet to another.
b. These are the highlighted arrows displayed on the bottom right corner of a
cell, which increase the size of a cell on dragging.
c. These are the small, onscreen boxes that display descriptive text when the
pointer is rested on a command or control.
d. These are used for hiding/showing the menu bars.
3. Consider the given image for the
following question.
Sam wants to generate a Pivot table based on the data given in the image. He
wants to show the count of employees for the values given in the Days column.
For example, Days 5 = 3, Days 6 = 2, etc. Which of the following options will
be the correct fields' combination to achieve that?
a. FILTERS: Days, VALUES: Count of
Days
b. COLUMNS: Days, VALUES: Count of Days
c. COLUMNS: Count of Days, VALUES: Days
d. ROWS: Days, VALUES: Count of Days
4. Which of the following statements
is/are correct about the customization of the Quick Access Toolbar?
a. A user can change the size of the
Quick Access Toolbar.
b. A user can add command buttons to the Quick Access Toolbar.
c. A user CANNOT remove the command buttons from the Quick Access Toolbar.
d. All of the above statements are correct.
5. Which of the following statements
is/are correct about Track Changes in Microsoft Excel 2016?
a. A workbook is automatically
shared when the Track Changes option is turned on.
b. Excel can track all types of changes in a Worksheet.
c. The Track Changes option can be accessed from the View tab.
d. All of the above statements are correct.
6. Which of the following functions
can be performed on a protected worksheet if the password is not known?
a. We can copy and paste data
from the protected sheet to a new Workbook.
b. Insert columns are protected, but delete columns are not protected,
therefore, we can only insert columns but can't delete columns in the protected
worksheet.
c. We can paste data into the protected worksheet.
d. We can de-crypt the password of the protected sheet.
7. In Microsoft Excel 2016, the
Split command enables a user to view a worksheet in how many panes?
a. Two
b. Three
c. Four
d. Five
8. In Microsoft Excel 2016, which of
the following statements are correct about a Pivot chart?
a. A Pivot chart is a graphical
depiction of a data summary.
b. You cannot create a Pivot chart without a Pivot table.
c. One can create a Pivot table and a Pivot chart at the same time..
9. With respect to Protect Workbook
in Microsoft Excel 2016, the Windows option can be used for preventing users
from moving, resizing or closing the workbook window.
a. True
b. False
10. Which of the following is/are
correct about macro naming rules in Microsoft Excel 2016?
a. A macro name's first character
must be a letter.
b. A macro name can contain spaces.
c. An underscore can be used in a macro name.
d. A macro name cannot contain numbers.
11. Which of the following commands
is used in Microsoft Excel 2016 for totaling all the budget spreadsheets
prepared by each department in an organization?
a. Sort
b. AutoSum
c. Filter
d. Consolidate
12. Which of the following is NOT a
command tab in Microsoft Excel 2016?
a. Formulas
b. Format Painter
c. Data
d. Review
13. In Microsoft Excel 2016, which
of the following statements is/are correct about dates?
i) The default date format uses 4 digits for the year.
ii) The dates are left-justified in the cells by default.
a. Only option i) is correct.
b. Only option ii) is correct.
c. Both options i) and ii) are correct.
d. Both options i) and ii) are incorrect.
14. If a user specifies a print area
from the backstage view, then it saves the setting with the workbook.
a. True
b. False
15. In Microsoft Excel 2016, which of the following options is used
for limiting or restricting the cell entries to a certain data type?
a. Manage Data Model
b. Filter
c. Advanced
d. Data Validation
16. In Microsoft Excel 2016, which of the following keyboard
shortcuts is used for the "Clear filter" command for Slicer in a
Pivot table?
a. Alt + C
b. Ctrl + C
c. Windows + C
d. Shift + C
17. In Microsoft Excel 2016, which of the following options
used for displaying or hiding formulas change(s) the state of a cell?
i) Prevent formulas from displaying in the formula bar by protecting
the cells that contain them.
ii) Switch between displaying formulas and formula results on a
worksheet.
iii) Show hidden formulas by removing the protection from cells.
a. Only option i).
b. Only options ii) and iii).
c. Only options i) and iii).
d. All options i), ii) and iii).
18. In Excel 2016, which of the following options is the correct
procedure that is used for converting a table to a regular range?
a. Click anywhere on the table -> Click on the Design option under Table
Tools -> Click on the Convert to Range option under the Tools group.
b. Right-click on the table -> Click on the Table option -> Select the
Convert to Range option.
c. Click anywhere on the table -> Click on the Developer option under Table
Tools -> Click on the Convert to Range option under the Tools group.
d. Right-click on the table -> Click on the Filter option -> Select the
Convert to Range option.
19. In Microsoft Excel 2016, which of the following options is NOT
available under "What-If Analysis"?
a. Scenario Manager
b. Goal Seek
c. Consolidate
d. Data Table
20. Through which of the following options in Microsoft Excel 2016,
a user can enable the Data Connections settings, in order to connect with
external data?
a. Connections
b. Trust Center
c. Proofing
d. Data Validation
21. In Microsoft Excel 2016, which of the following is the correct
syntax of the VLOOKUP command?
a. =VLOOKUP (value, table, col_index, [range_lookup])
c. =VLOOKUP (table, [range_lookup]), value, col_index)
d. =VLKUP (value, col_index, table, [range_lookup])
22. While working in Microsoft Excel 2016, for which of the
following options, if included in a worksheet, we cannot use the Track Changes
option?
a. Comment
b. Table
c. Chart
d. Picture
23. Which of the following is/are the correct method(s) of
consolidating data in Microsoft Excel 2016?
a. Consolidation by position.
b. Consolidation by category.
c. Consolidation by data type.
d. None of the above.
24. Which of the following can be used to avoid users to make
changes to a worksheet in Microsoft Excel 2016?
a. By providing Read Only access.
b. By password protecting a Workbook.
c. Restricting permissions by Information Rights Management (IRM).
d. All of the above.
25. John inserts a PivotTable in Sheet 2, based on the data given in
the image. He drags the "Days" field from the list of columns to the
Values section in the PivotTable Fields pane. Which of the following options
will be the default selection under the Values section?
a. Max of Days
b. Average of Days
c. Sum of Days
d. Count of Days
.
26. This question is based upon the figure shown below
In the given diagram of a Pivot chart in Microsoft Excel 2016, the
"brush" symbol indicates which of the following options?
a.Chart Color
b.Chart Elements
c.Format Painter
d.Chart Style
27. In Microsoft Excel 2016, the commands used for recording,
creating and deleting macros is accessed from the Developer tab. Which of the
following is the correct way of displaying the developer tab on the ribbon?
a. Click on the File tab -> Click Options-> In the Excel Options
dialog box, click option Customize Ribbon -> Check the Developer tab option
-> Click OK
b. Click on the File tab -> Click Accounts-> In the Excel Accounts dialog
box, click option Quick Access Toolbar -> Check the Developer tab option
-> Click OK
c. Click on the View tab -> Click Options -> In the Excel Options
dialog box, click option Quick Access Toolbar -> Check the Developer tab
option -> Click OK
d. Click on the View tab -> Click Accounts-> Click Options -> In the
Excel Options dialog box, click option Customize Ribbon -> Check the
Developer tab option -> Click OK
28. What happens when the Freeze Panes option is used on some of the
rows and columns in Microsoft Excel 2016?
a. It keeps the rows and columns visible when the rest of the worksheet
is scrolled.
b. It hides the selected rows and columns.
c. The selected rows and columns cannot be edited while the rest of the
worksheet can be edited.
d. The selected rows and columns can accept only a particular type of data.
29. In Microsoft Excel 2016, which of the following functions is
used for returning the sheet number of a reference sheet?
a. Sheets
b. Sheet
c. Number
d. None of the above.
30. In Microsoft Excel 2016, which of the following keyboard
shortcuts should be pressed to switch between relative and absolute cell
references while writing a formula in a worksheet?
a. F1
b. Ctrl+6
c. F4
d. Ctrl+2
31. In Microsoft Excel 2016, what does the VALUE function do?
a. It is used for converting a text argument to a number.
b. It counts the cells that contain numbers in an Excel sheet.
c. It is used for adding numeric values.
d. It is used for calculating the ASCII values of a text string.
32. In Microsoft Excel 2016, which of the following commands should
NOT be removed from the Quick Access Toolbar because these commands are NOT
available on the ribbon's command tabs?
a. Undo
b. Redo
c. Save
d. Copy
e. None of the above
33. In order to treat a numerical value as a text value in Microsoft
Excel 2016, it should precede with which of the following symbols?
a. Apostrophe ( ' )
b. Exclamation ( ! )
c. Equal ( = )
d. Hash ( # )
34. Which of the following statements is correct about the #Data
constant in Microsoft Excel 2016?
a. It is the set of all the cells that contains data, which includes any
header rows but excludes the total or subtotal rows.
b. It is the set of all the cells that contain data, which includes any total or
subtotal rows but excludes the header rows.
c. It is the set of all the cells that contain data including header rows as
well as any total or subtotal rows.
d. It is the set of all the cells that contain data excluding header rows as
well as any total or subtotal rows.
35. John inserts a PivotTable in a worksheet, as shown in figure 1
of the given image. There are three columns in the data source: Employee,
Product and Sales. Now John wants to show the list of products under the
employee names as shown in figure 2 of the given image. Where should he
double-click on the PivotChart in figure 1, so that he should be able to select
the Product column?
a. On the header of the Employee column.
b. On the values of the Sum of Sales column.
c. On the values of the Employee column.
d. On the header of the Sum of Sales column.
Subscribe by Email
Follow Updates Articles from This Blog via Email
No Comments