2024 Fiverr Microsoft Excel Skill Test Questions And Answers

1.How can we remove password encryption from a Microsoft Excel 2016 file?
i) Open the Workbook and save it again with a new password
ii) Copy and paste the data in another Workbook and save it.
iii) Enter the password of the Workbook and delete the password in the Permissions. Encrypt with password box-Answer
iv) Open the Workbook and from the file menu, select process workbook decrypt the Workbook

2. Peter was working in a Microsoft Excel 2016 workbook. His workbook 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?
i) Go to the File tab -> Click on Save -> Click on Recovered Workbook
ii) Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks -Answer
iii) Go too the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks
iv) 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, in order to connect with external data?
i) Connections
ii) Trust Center -Answer
iii) Proofing
iv) Data validation

4. 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
1. Only option ii)
2. Only options ii) and iii)
3. Only options i) and ii)
4. All options i) and iii)-Answer

5. In Microsoft Excel 2016 which of the following Engineering functions tests the equality of two numbers?
i) BESSELI
ii) BITOR
iii) BiTAND
iv) DELTA-Answer

6. Which of the following logical functions doesn’t return True or False as a result in Microsoft Excel 2016?
i) AND Function
ii) IF Function -Answer
iii) OR Function
iv) XOR Function

7. From the given image, which of the following options should be selected, in order to enable Page Break Preview in Microsoft Excel 2016?
i) 1
ii) 2
iii) 3
iv) None of the above

8. In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
i) It will select cell At.
ii) It will select the complete Worksheet.-Answer
iii) It will select all the Worksheet available in a Workbook
iv) It will add a Worksheet to the file

9. We are the correct purposes of CEILING, MATH() function in Microsoft Excel 2016?
i) It rounds a number up to the nearest integer.-Answer
ii) It rounds a number up, to the nearest multiple of significance.-Answer
iii) It rounds a number down, to the nearest even integer.
iv) It rounds a number up, to the nearest add 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?
i) Go to the File tab -> Click info -> Click Excel options -> Click Security -> Select Allow digitally signed macros only
ii) Go to the File tab -> Click info -> Click Excel Options -> Click Security -> Select Disable All macros except digitally signed macros
iii) 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-Answer
iv) Go to the File tab -> Click Options ->Click Trust Center under the Excel Options dialog 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?
i) Two
ii) Three
iii) Four-Answer
iv) Five

12. Suppose that you conducted an aptitude test in a class room 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”?
i) =AVERAGE (B4:G4)
ii) =AVG(B4 C4 D4 E4 F4 G4)
iii) =(SUM(B4:G4) COUNT(B4:G4))
iv) Both options a and c.-Answer
v) Both options a and b

13. Consider the given image for the following question.
John insert 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 pane. Which of the following options will be the default selection under the Values section?
i) Max of Days
ii) Average of Days
iii) Sum of Days-Answer
iv) Count of Days

14. Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?
i) Consolidating by position
ii) Consolidating by category
iii) Consolidation by data type-Answer
iv) 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 color
3. Cell test
i) Only 1 and 2-Answer
ii) Only 1 and 3
iii) Only 2 and 3
iv) All 1, 2 and 3

16. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?
i) TRUE-Answer
ii) FALSE
iii) 0
iv) -1-Answer

17. In Microsoft Excel 2016, which of the following tabs will you click for accessing the View Macros option?
i) Developer
ii) Review
iii) View -Answer
iv) Home

18. Which of the following options can be used for checking the protection stats of a file in Microsoft Excel 2016?
i) Click on the Review tab > Select New > Click on Protect Workbook
ii) Click on the File tab > Select Options > Click on Protect Workbook
iii) Click on the File tab> Select Info>Click on Protect Workbook
iv) Click on the Review tab > Select Account > Click on Protect Workbook

19. In order 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
i) All 1, 2 and 3- Answer
ii) Only 1 and 2
iii) Only 1 and 3
iv) Only 2 and 3

20. In Microsoft Excel 2016, what is the correct function of the Format Painter option?
i) To edit font.
ii) To Insert function
iii) To copy and paste the formatting of one cell to another in a Worksheet-Answer
iv) 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?
i) Click anywhere on the table -> Click on the Design option under Table Tools -> Click on the Convert to Range option under the Tools group.-Answer
ii) Right-click on the table ->Click on the Design option -> Select the Convert to Range option.
iii) Click anywhere on the table -> Click on the Developer option under Table Tools -> Click on the Convert to Range option under the Tools group.
iv) 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 average for helping in summarizing data?
i) Group
ii) Filter
iii) Data Validation
iv) Subtotal-Answer

23. While creating a PivotTable in Excel 2016, where can a user place the PivotTable report?
i) It is always placed in a new worksheet -Answer
ii) It is always placed in an existing worksheet
iii) It can either be placed in a new worksheet or in an existing worksheet

24. Choose True or False
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.
i) True
ii) False-Answer

25.In relation to the Cube function in Excel 2016, which of the following functions returns an aggregated value from the cube?
i) CUBESET
ii) CUBEMEMBERPROPERTY
iii) CUBEVALUE -Answer
iv) CUBEKPIMEMBER

Fiverr microsoft excel test answers 2022 SET-02.

26. 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?
i) FILTERS:Days, VALUES: Count of Days
ii) COLUMNS: Days, VALUES: Count of Days
iii) COLUMNS: Count of Days, VALUES: Days
iv) ROWS: Days, VSLUES : Count of Days-Answer

27. Which of the following can be used o avoid users to make changes to a worksheet in Microsoft Excel 2016?
i) By providing Read only access
ii) By password protecting a Workbook
iii) Restricting permissions by information Rights Management (IRM).
iv) All of the above.-Answer

28. In Microsoft Excel 2016 worksheet, which of the following shortcuts is used for switches between displays formulas and their results?
i) CTRL + S
ii) CTRL + D
iii) CTRL +& (Ampersand)
iv) CTRL + (grave accent)-Answer

29. In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?
i) Manage Data Model
ii) Filter
iii) Advanced
iv) Data validation- Answer

30. What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?
i) It keeps the rows and columns visible when the rest of the worksheet is scrolled -Answer
ii) It hides the selected rows and columns
iii) The selected rows and columns cannot be edited
iv) The selected rows and columns can accept only a particular type of data

31. Which of the following statements is/are correct about Track Changes in Microsoft Excel 2016?
i) A workbook is automatically shared when the Track Changes option is turned on.-Answer
ii) Excel can track all types of changes in a Worksheet
iii) The Track Changes option can be accessed from the view tab
iv) All of the above statements are correct.

32. Which of the following functions can be performed on a protected worksheet if the password is not known?
i) We can copy and paste data from the protected sheet to a new Workbook-Answer
ii) Insert columns are protected, but delete columns are not protected, therefore, we only insert columns but can’t delete columns in the protected worksheet.
iii) We can paste data into the protected worksheet
iv) We can de-crypt the password of the protected sheet

33. What is/are the default file extension(S) of Microsoft Excel 2016 workbook?
i) .xls
ii) .xlsx-Answer
iii) .doc
iv) Both options a and b

34. Which of the following commands is used in Microsoft Excel 2016 for totaling all the budget spreadsheet prepared, each department in an organization?
i) Sort
ii) AutoSum
iii) Filter
iv) Consolidate-Answer

35. Consider the given image for the following questions.
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 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?
i) Max of Days
ii) Average of Days
iii) Sum of Days-Answer
iv) Count of Days

36. Which of the following keyboard shortcuts is used for moving from any cell to the beginning of a worksheet , i.e. cell A1?
i) Windows + Home key
ii) Alt + 1 Key
iii) Ctrl + Home key – Answer
iv) Windows + 1 key

37. In the given image, what does the red circled button imply?
i) It implies that the filter is disabled.
ii) It implies that the filter is enabled button applied.
iii) It implies that a filter is applied.-Answer
iv) It implies that multiple filters are applied and enabled.

38. Can you perform a case sensitive data sorting in Microsoft Excell 2016?
i) Yes-Answer
ii) No

39. What will happen if you enter XYZ1 in a cell and drag the fill handle down?
i) It will XYZ1 all the cells that are dragged through
ii) It will fill the series with XYZ2, XYZ3, XYZ4 and so on, respectively.-Answer
iii) It will fill the sites with XYZ2, ABC3, DE and so on, respectively.
iv) None of the above

40. In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?
i) Non-numeric fields
ii) Data and time hierarchies-Answer
iii) Numeric fields

41. In Microsoft Excel 2016, when do we receive a “#Value!” error in the VLCOKUP function ?
1. When the “lookup_value” argument is more than 255 characters.
2. When the “col_index_num” argument contains text.
3. When the “ col_index_num” argument is equal to 0.
i) Only option i) and ii) are correct-Answer
ii) Only option i) is correct
iii) Only option ii) and iii) are correct
iv) All option i) ii) and iii) are correct.

42. For 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 correct-
Select allow digitally signed macros only
i) GO to the File tab -> Click info -> Click Excel Options -> Click Security -> select Disable All Macros except digitally signed macros
ii) 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-Answer
iii) Go to the File tab -> Click Options -> Click Trust Center under the Excel options dialog box -> Click Macros -> Select Disable All macros except digitally signed macros

43. Choose True or False.
A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 Workbook.
i) True -Answer
ii) False

44. While using cell references with multiple worksheets in Microsoft Excel 2016, which of the following options is the correct absolute cell reference that must be used for cell B2 on a sheet named ‘Sheet5’?
i) $Sheet5$B2
ii) $Sheet5.B2
iii) Sheet5!B2-Answer
iv) $Sheet5!B2

45. In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?
i) Apostrophe (‘)-Answer
ii) Exclamation (!)
iii) Equal (=)
iv) Hash (#)

46. Which of the following is the correct function of the Wrap Text in Microsoft Excel 2016?
i) It is used average multiple cells to one cell.
ii) It is used to delete the hidden text from a cell.
iii) It is used to convert extra-long text of a cell into multiple lines so that used can see all of it.-Answer
iv) None of the above.

47. In Microsoft Excel 2016, the =TODAY() command returns:
i) The current day name
ii) The date when the Excel file was created
iii) The current day and date
iv) The current date-Answer

48. In relation to the Clear option under the Home tab in Microsoft Excel 2016, which of the following options can be cleared from the cell?
i) Formats
ii) Contents
iii) Comments -Answer
iv) Layouts

49.Which of the following statements is/are correct about macro naming rules in Microsoft Excel 2016?
i) A macro name’s first character must be a letter.-Answer
ii) A macro name can contain spaces.
iii) An underscore cannot be used in a macro name.
iv) A macro name cannot contain numbers.

50. 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?
i) F1
ii) Ctrl+6
iii) F4-Answer
iv) Ctrl+2

Share:

Facebook
Twitter
Pinterest
LinkedIn

Leave a Reply

Your email address will not be published. Required fields are marked *

On Key

Random Posts

2024 Fiverr Adobe Illustrator Test Certification Answers

2024 Fiverr Adobe Illustrator Test Certification Answers download link https://sanalsayfa.org/en/wp-content/uploads/sites/2/2024/05/fiveerrr.docx     Q 1. Which of the following statements are correct about importing AutoCAD files