,

Computer Training Picture

Following this is my some computer training picture. 

 

Fiverr Excel 2016 Test Questions and Answers

 

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.