Saturday, December 3, 2022
HomeFiverrFiverr Microsoft Excel 2016 Skills Test Answer 2022

Fiverr Microsoft Excel 2016 Skills Test Answer 2022

Microsoft Excel 2016 Skills Test

Test Syllabus

  • Data handling and macros
  • Excel 2016 backstage view
  • Excel 2016 formulas and functions
  • Introduction to Excel 2016
  • Pivotchart and pivottable
  • Protection and security
  • Working with workbooks

Duration

  • 40 minutes

Questions

  • 40 multiple-choice questions.

Instructions

  • Each question has between 2 and 8 options; one or more may be correct.
  • There is no penalty for guessing if you don’t know the answer; therefore, make sure you attempt all of the questions.
  • To pass, you will need to answer at least 60% of the questions correctly.
  • The clock timing of your test is located at the top of the test window.
  • This test is best viewed using Internet Explorer version 11.0 or higher or Mozilla Firefox 45.0 or higher or Google Chrome 48 or higher.
  • Questions will be displayed one at a time. A next button is provided at the bottom of the test page for navigating to the next question. Do not press the next button if you have not answered the question.
  • Once you have answered a question, you cannot go back and change your answer.
  • Do not use the shortcut menu options (mouse right-click) or the keyboard for navigating backwards or forwards within the test.
  • There is a 1 day waiting period between test retakes. You can only take a test twice in a three months time window.

Fiverr Microsoft Excel Skill Test Set – 1

1. How can we remove password encryption from a Microsoft Excel 2016 file?

  1. Open the Workbook and save it again with a new password
  2. Copy and paste the data into another Workbook and save it.
  3. Enter the password of the Workbook and delete the password in the PermissionsEncrypt with a password box
  4. Open the Workbook and from the file menu, select process workbook decrypt the Workbook

2. Peter was working on a Microsoft Excel 2016 workbooks workbook that closed due to a system error and he couldn’t save it which of the following is the correct way to recover an unsaved workbook?

  1. Go to the File tab -> Click on Save -> Click on Recovered Workbook
  2. Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks
  3. Go too the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks
  4. Go to the File tab ->Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooks

3. Through which of the following options in Microsoft Excel 2016, a user can enable the Data connections settings, to connect with external data?

  1. Connections
  2. Trust Center
  3. Proofing
  4. Data validation

4. Which of the following types of filters can be created using the AutoFilter option in Microsoft Excel 2016?

  1. By list values
  2. By format
  3. By criteria
  1. Only option (2)
  2. Only options (2) and (3)
  3. Only options (1) and (2)
  4. All options (1) and (3)

5. In Microsoft Excel 2016 which of the following Engineering functions tests the equality of two numbers?

  1. BESSEL
  2. EDITOR
  3. brand
  4. DELTA

6. Which of the following logical functions doesn’t return True or False as a result in Microsoft Excel 2016?

  1. AND Function
  2. IF Function
  3. OR Function
  4. XOR Function

7. From the given image, which of the following options should be selected, enable Page Break Preview in Microsoft Excel 2016?

which of the following options should be selected, in order to enable Page Break Preview in Microsoft Excel 2016
  1. 1
  2. 2
  3. 3
  4. None of the above

8. From the given image, In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?

It will select the complete Worksheet.
  1. It will select cell At.
  2. It will select the complete Worksheet.
  3. It will select all the Worksheet available in a Workbook
  4. It will add a Worksheet to the file

9. What are the correct purposes of the CEILING, MATH() function in Microsoft Excel 2016?

  1. It rounds a number up to the nearest integer.
  2. It rounds a number up, to the nearest multiple of significance.-Answer
  3. It rounds a number down, to the nearest even integer.
  4. It rounds a number up, to the nearest added integer.

10. The IT security department of Mark’s organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016, Which of the following is the correct way to restrict the unsigned macros?

  1. Go to the File tab -> Click info -> Click Excel options -> Click Security -> Select Allow digitally signed macros only
  2. Go to the File tab -> Click info -> Click Excel Options -> Click Security -> Select Disable All macros except digitally signed macros
  3. Go to the File tab -> Click options -> Click Trust Center under the Excel Options dialog box -> Click Trust Center settings -> Click Macros Settings -> Select Disable All macros except digitally signed macros
  4. Go to the File tab -> Click Options ->Click Trust Center under the Excel Options dialogue box -> Click Macros -> Select Disable All macros except digitally signed macros

11. In Microsoft Excel 2016, the Split command enables a user to view a worksheet in how many panes?

  1. Two
  2. Three
  3. Four
  4. Five

12. From the given image, Suppose that you conducted an aptitude test in a classroom to check if the students are ready for competitive exams Now you want to calculate the average of the total marks obtained by the students in the test which of the following formulas can be used to calculate the average of the “Marks Obtained” in the cell “14”?

Both options a and c.
  1. =AVERAGE (B4:G4)
  2. =AVG(B4 C4 D4 E4 F4 G4)
  3. =(SUM(B4:G4) COUNT(B4:G4))
  4. Both options a and c.
  5. Both options a and b

13. Consider the given image for the following question. John inserts a pivotable 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 paneWhich of the following options will be the default selection under the Values section?

  1. Max of Days
  2. Average of Days
  3. Sum of Days
  4. Count of Days

14. Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?

  1. Consolidating by position
  2. Consolidating by category
  3. Consolidation by data type
  4. None of the above

15. Which of the following options can be copied using the format painter in Microsoft Excel 2016?

  1. Alignment
  2. Background colour
  3. Cell text

16. In Microsoft Excel 2016, which of the following values can be returned by the TEXT() function?

  1. TRUE
  2. FALSE
  3. 0
  4. -1

17. In Microsoft Excel 2016, which of the following tabs will you click for accessing the View Macros option?

  1. Developer
  2. Review
  3. View
  4. Home

18. Which of the following options can be used for checking the protection stats of a file in Microsoft Excel 2016?

  1. Click on the Review tab > Select New > Click on Protect Workbook
  2. Click on the File tab > Select Options > Click on Protect Workbook
  3. Click on the File tab> Select Info>Click on Protect Workbook
  4. Click on the Review tab > Select Account > Click on Protect Workbook

19. To protect your Excel data, which of the given file-level protections are available in Microsoft Excel 2016?

  1. File encryption
  2. Setting a password to open or modify a file
  3. Digital signature
  1. All 1, 2 and 3
  2. Only 1 and 2
  3. Only 1 and 3
  4. Only 2 and 3

20. In Microsoft Excel 2016, what is the correct function of the Format Painter option?

  1. To edit the font.
  2. To Insert function
  3. To copy and paste the formatting of one cell to another in a Worksheet
  4. To sort and filter data

21. In Excel 2016, which of the following options is the correct procedure that is used for converting a table to a regular range?

  1. Click anywhere on the table -> Click on the Design option under Table Tools -> Click on the Convert to Range option under the Tools group.
  2. Right-click on the table ->Click on the Design option -> Select the Convert to Range option.
  3. Click anywhere on the table -> Click on the Developer option under Table Tools -> Click on the Convert to Range option under the Tools group.
  4. Right-click on the table -> Click on the Filter option -> Select the Convert to Range option.

22. Which of the following commands in Microsoft Excel 2016 allows a user to automatically create groups and use common functions such as sum count and the average for help in summarizing data?

  1. Group
  2. Filter
  3. Data Validation
  4. Subtotal

23. While creating a PivotTable in Excel 2016, where can a user place the PivotTable report?

  1. It is always placed in a new worksheet
  2. It is always placed in an existing worksheet
  3. It can either be placed in a new worksheet or an existing worksheet

24. Choose True or False
Concerning protecting Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window.

  1. True
  2. False

25. About the Cube function in Excel 2016, which of the following functions returns an aggregated value from the cube?

  1. CUBE SET
  2. CUBEMEMBERPROPERTY
  3. CUBEVALUE
  4. CUBEKPIMEMBER

Fiverr Microsoft Excel Skill Test Set – 2

1. 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 combination of the correct field to achieve that?

  1. FILTERS: Days, VALUES: Count of Days
  2. COLUMNS: Days, VALUES: Count of Days
  3. COLUMNS: Count of Days, VALUES: Days
  4. ROWS: Days, VALUES: Count of Days

2. Which of the following can be used o prevent users to make changes to a worksheet in Microsoft Excel 2016?

  1. By providing Read-only access
  2. By password protecting a Workbook
  3. We are restricting permissions by Information Rights Management (IRM).
  4. All of the above.

3. In the Microsoft Excel 2016 worksheet, which of the following shortcuts is used for switching between display formulas and their results?

  1. CTRL + S
  2. CTRL + D
  3. CTRL +& (Ampersand)
  4. CTRL + (grave accent)

4. In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?

  1. Manage Data Model
  2. Filter
  3. Advanced
  4. Data validation

5. What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?

  1. It keeps the rows and columns visible when the rest of the worksheet is scrolled
  2. It hides the selected rows and columns
  3. The selected rows and columns cannot be edited
  4. The selected rows and columns can accept only a particular type of data

6. Which of the following statements is/are correct about Track Changes in Microsoft Excel 2016?

  1. A workbook is automatically shared when the Track Changes option is turned on.
  2. Excel can track all types of changes in a Worksheet
  3. The Track Changes option can be accessed from the view tab
  4. All of the above statements are correct.

7. Which of the following functions can be performed on a protected worksheet if the password is not known?

  1. We can copy and paste data from the protected sheet to a new Workbook
  2. Insert columns are protected, but delete columns are not protected, therefore, we only insert columns but can’t delete columns in the protected worksheet.
  3. We can paste data into the protected worksheet
  4. We can decrypt the password of the protected sheet

8. What is/are the default file extension(S) of a Microsoft Excel 2016 workbook?

  1. .xls
  2. .xlsx
  3. .doc
  4. Both options a and b

9. Which of the following commands is used in Microsoft Excel 2016 for totalling all the budget spreadsheets prepared, for each department in an organization?

  1. Sort
  2. AutoSum
  3. Filter
  4. Consolidate
RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments