Fiverr Microsoft Excel Test Answers [Updated]

Are you looking for Fiverr Microsoft Excel Test Answers? If yes, here is the latest and updated answer to the Fiverr Microsoft Excel Test and Get a free certificate. This article will help you with the Fiverr Microsoft Excel Skill Assessment Answers in the easiest ways.

How to Fix Take a Test Option Not Showing In Fiverr?

Join Fiverr

Use CTRL + F or Find In Page to find questions.

Fiverr Microsoft Excel Test Answers

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 in another Workbook and save it.
  3. Enter the password of the Workbook and delete the password in the PermissionsEncrypt with password box
  4. Open the Workbook and from the file menu, select process workbook decrypt the Workbook

2. Peter was working in a Microsoft Excel 2016 workbookHis 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?

  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, in order 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. BESSELI
  2. BITOR
  3. BiTAND
  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, in order to enable Page Break Preview in Microsoft Excel 2016?

From the given image, 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?

From the given image, In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
  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. We are the correct purposes of 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 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?

  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 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?

  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”?

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”?
  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 color
  3. Cell text

16. In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() 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. 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
  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 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 average for helping 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 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.

  1. True
  2. False

25. In relation to 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 correct fields combination 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 avoid users to make changes to a worksheet in Microsoft Excel 2016?

  1. By providing Read only access
  2. By password protecting a Workbook
  3. Restricting permissions by information Rights Management (IRM).
  4. All of the above.

3. In Microsoft Excel 2016 worksheet, which of the following shortcuts is used for switches between displays 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 de-crypt 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 totaling all the budget spreadsheet prepared, each department in an organization?

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

10. 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 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

11. Which of the following keyboard shortcuts is used for moving from any cell to the beginning of a worksheet, i.e cell A1?

  1. Windows + Home key
  2. Alt + 1 Key
  3. Ctrl + Home key
  4. Windows + 1 key

12. In the given image, what does the red circled button imply?

  1. It implies that the filter is disabled.
  2. It implies that the filter is enabled button applied.
  3. It implies that a filter is applied.
  4. It implies that multiple filters are applied and enabled.

13. Can you perform a case-sensitive data sorting in Microsoft Excell 2016?

  1. Yes
  2. No

14. What will happen if you enter XYZ1 in a cell and drag the fill handle down?

  1. It will XYZ1 all the cells that are dragged through
  2. It will fill the series with XYZ2, XYZ3, XYZ4, and so on, respectively. 
  3. It will fill the sites with XYZ2, ABC3, DE, and so on, respectively.
  4. None of the above

15. In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?

  1. Non-numeric fields
  2. Data and time hierarchies
  3. Numeric fields

16. 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.
  1. Only option (1) and (2) are correct
  2. Only option is correct
  3. Only option and are correct
  4. All option and are correct.

17. 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

  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 Macro Settings -> Select Disable All macros except digitally signed macros
  4. 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

18. Choose True or False.
A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 Workbook.

  1. True
  2. False

19. 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’?

  1. $Sheet5$B2
  2. $Sheet5.B2
  3. Sheet5!B2
  4. $Sheet5!B2

20. In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?

  1. Apostrophe (‘)
  2. Exclamation (!)
  3. Equal (=)
  4. Hash (#)

21. Which of the following is the correct function of the Wrap Text in Microsoft Excel 2016?

  1. It is used average multiple cells to one cell.
  2. It is used to delete the hidden text from a cell.
  3. It is used to convert extra-long text of a cell into multiple lines so that used can see all of it.
  4. None of the above.

22. In Microsoft Excel 2016, the =TODAY() command returns:

  1. The current day name
  2. The date when the Excel file was created
  3. The current day and date
  4. The current date

23. 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?

  1. Formats
  2. Contents
  3. Comments
  4. Layouts

24. Which of the following statements is/are correct about macro naming rules in Microsoft Excel 2016?

  1. A macro name’s first character must be a letter.
  2. A macro name can contain spaces.
  3. An underscore cannot be used in a macro name.
  4. A macro name cannot contain numbers.

25. 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?

  1. F1
  2. Ctrl+6
  3. F4
  4. Ctrl+2

Fiverr Microsoft Excel Skill Test Set – 3

1. In a Microsoft Word 2016 document, by default, which of the following options is the maximum border weight/width that can be applied to a picture from the Picture Border option under the Format tab?

  1. 5 pt
  2. 6 pt
  3. 7 pt
  4. 9 pt

2. In Microsoft Word 2016, what can be the position of a Legend in a chart?

  1. Left of the chart.
  2. Right of the chart.
  3. Top of the chart.
  4. Bottom of the chart.
  1. Only 1 and 3.
  2. Only 2 and 3.
  3. Only 1 and 2.
  4. Only 3 and 4.
  5. Any of the four positions

3. In Microsoft Word 2016, which of the following options is NOT a type of SmartArt graphic?

  1. Process
  2. Pyramid
  3. Pattern
  4. Picture
  5. Relationship

4. In a Microsoft Word 2016 document, which of the following keyboard shortcuts is used for using Thesaurus?

  1. F6
  2. F7
  3. Shift + F9
  4. Shift + F7

5. In a Microsoft Word 2016 document, which of the following section breaks is NOT available under the Layout tab?

  1. Next page
  2. Last page
  3. Even page
  4. Continuous

6. John creates a macro that needs to be available on all the documents. Which of the following is the correct way to share the macro on all documents?

  1. Right-click on the macro and select the Add to Global Macro template.
  2. Add the macro to the “Normal.dotm” template.
  3. While recording the macro, select the “Share on all documents” checkbox.
  4. Add the macro to the “Global.dotm” template.

7. In Microsoft Excel 2016, which of the following options can be locked in a worksheet?

  1. Ranges
  2. Formulas
  1. Only option (1)
  2. Only option (2)
  3. Both options (1) and (2)
  4. Neither option (1) nor (2)

8. From the given image, Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?

From the given image, Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?
  1. 5
  2. 6
  3. 8
  4. 12
  5. It will return an error because the formula is incorrect.

9. From the given image, There are red triangles in the upper-right corner of each cell under the column titled ‘Class’. What do they signify?

From the given image, There are red triangles in the upper-right corner of each cell under the column titled ‘Class’. What do they signify?
  1. They represent that the cells are containing formatted data.
  2. They represent that some data validation is associated with the cells.
  3. They represent that the comments are associated with the cells.
  4. They represent that the cells cannot be edited.

10. From the given image, Consider the data given in the image. What will be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft Excel 2016?

From the given image, Consider the data given in the image. What will be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft Excel 2016?
  1. 0
  2. 0.14111
  3. -1.21111
  4. Error

11. Which of the following Microsoft Excel 2016 functions is used in order to return the serial number that is used for representing the date, which is the indicated number of months before or after a specified date?

  1. EDATE
  2. EOMONTH
  3. DATEVALUE
  4. NUMBER

12. From the given image, Which of the following keyboard shortcuts is used for achieving the strikethrough effect as shown in the given image?

From the given image, Which of the following keyboard shortcuts is used for achieving the strikethrough effect as shown in the given image?
  1. ALT+F9
  2. CTRL+ALT+F10
  3. SHIFT+F5
  4. CTRL+5

13. In Microsoft Excel 2016, how can we publish a Workbook to Power BI?

  1. File > Options > Publish to Power BI
  2. File > Save As > Change “File as type” > Publish to BI
  3. File > Share > Publish to BI > Save to Cloud
  4. File > Publish > Publish to Power BI

14. From the given image, Consider the Excel sheet given in the image. What will be the output if you enter the formula, =AVERAGE(A3:C8), in cell C9?

From the given image, Consider the Excel sheet given in the image. What will be the output if you enter the formula, =AVERAGE(A3:C8), in cell C9?
  1. 7
  2. 11.25
  3. 13.5
  4. It will throw an error

15. From the given image, Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab?

From the given image, Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab?
  1. 15
  2. 18
  3. 29
  4. 79

16. By default, how many worksheets are there in a new Microsoft Excel 2016 workbook?

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

17. From the given image, Consider the Excel sheet given in the image. What will be the output if we apply the formula, =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, “>6”)?

From the given image, Consider the Excel sheet given in the image. What will be the output if we apply the formula, =AVERAGEIFS(D2:D7, A2:A7, 2016, B2:B7, “>6”)?
  1. 4
  2. 6
  3. 10
  4. 16

18. Which of the following functions is used for providing the decimal number of the time represented by a text string?

  1. Now()
  2. Trend()
  3. TimeValue()
  4. Numbervalue()

19. In Microsoft Excel 2016, when do we receive a “#Value!” error in the VLOOKUP 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.
  1. Only option (1) is correct.
  2. Only options (1) and (2) are correct.
  3. Only options (2) and (3) are correct.
  4. All options (1), (2), and (3) are correct.

20. Which of the following keyboard shortcuts is used to display or hide the ribbon in Microsoft Excel 2016?

  1. Alt+F1
  2. Alt+Shift+F1
  3. Ctrl+F1
  4. F1

21. By default, all cell references in Microsoft Excel 2016 are:

  1. Relative.
  2. Absolute.
  3. None of the above.

22. What will happen if you enter XYZ1 in a cell and drag the fill handle down?

  1. It will fill XYZ1 in all the cells that are dragged through.
  2. It will fill the series with XYZ2, XYZ3, XYZ4 and so on, respectively.
  3. It will fill the series with XYZ2, ABC3, DEF4 and so on, respectively.
  4. None of the above.

23. Which of the following options is the correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?

  1. Ctrl + B
  2. Alt + F
  3. Alt + B
  4. Tab + F

24. From the given image, Consider the data given in the image. What will be the output if the formula, =PROPER(A1), is applied to cell A2?

From the given image, Consider the data given in the image. What will be the output if the formula, =PROPER(A1), is applied to cell A2?
  1. This is a Book
  2. This Is A Book
  3. This is a book
  4. It will throw an error because the formula cannot contain cell reference.

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

From the given image, In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
  1. It will select cell A1.
  2. It will select the complete Worksheet.
  3. It will select all the Worksheets available in a Workbook.
  4. It will add a Worksheet to the file.

26. In Microsoft Excel 2016, which of the following options provides a user the access to options such as Share, Export, Account, Publish, etc.?

  1. Ribbon
  2. View tab
  3. Backstage View
  4. Page Layout tab

27. Choose True or False, If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

  1. True
  2. False

28. In Microsoft Excel 2016, which of the followings is NOT a valid option for Macro Settings under the Trust Center?

  1. Disable all macros without notification.
  2. Disable all macros with notification.
  3. Disable all macros including digitally signed macros.
  4. Enable all macros.
  5. Disable all macros except digitally signed macros.

29. In Microsoft Excel 2016, the CHOOSE function can be used for selecting up to how many values based on an index number?

  1. 64
  2. 128
  3. 254
  4. 508

30. In Microsoft Excel 2016, which of the following arguments of the YEARFRAC function is/are optional?

  1. Start date.
  2. End date.
  3. The type of day count basis to use.
  1. Only option (2).
  2. Only options (1) and (2).
  3. Only option (3).
  4. Only options (2) and (3).

31. In Microsoft Excel 2016, the Save As option can be accessed from which of the following tabs?

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

32. Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?

  1. If a calculated item is contained by a field, then the subtotal summary function cannot be changed.
  2. Sum, count and average functions can be used as a subtotal.
  3. Var and Varp functions cannot be used as a subtotal.
  4. None of the above.

33. How can we define a name to a cell in a Microsoft Excel 2016 Worksheet?

  1. Right-click on the cell and click on “Define Name”.
  2. Click on the “Formulas” tab and click on “Define Name” under the “Define Names” group.
  3. Click on the “Home” tab and click on “Format” under the “Cells” group.
  4. Click on the “Home” tab and click on “Define Name” under the “Define Names” group.

34. From the given image, 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 “I4”?

  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.

35. Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?

  1. A$2
  2. $A2
  3. !A2
  4. A!2

36. Choose True or False, A PivotChart is a graphical representation for a summary of data displayed in Pivot Table.

  1. True
  2. False

37. From the given image, What does the blue triangle and border color imply in cell B4?

From the given image, What does the blue triangle and border color imply in cell B4?
  1. They imply that a comment is associated to cell B4.
  2. They imply that a filter has been applied to cell B4.
  3. They imply that the Goal Seek option of What-if Analysis is applied to cell B4.
  4. They imply that Track Changes has been enabled and cell B4 is edited.

38. While entering data in an Excel 2016 worksheet, what happens if you press the tab key in a cell?

  1. You will move to next column.
  2. You will move to the first column.
  3. You will move to the last column.
  4. You will move to the previous column.

39. In Microsoft Excel 2016, which of the following options is used to access the option that is used to get data from a text file?

  1. Click the Data tab -> Select the option “From Other Sources” from the Get External Data group-> Click “From Text”
  2. Click the Data tab -> Select the option “Existing Connections” from the Get External Data group-> Click “From Text”
  3. Click the Data tab -> Select the option “From Text” from the Get External Data group
  4. Click the Formulas tab -> Select the option “From Text” under the Connections group

40. Which of the following keyboard shortcuts is used for displaying the Record Macro dialog box that is used for recording macros?

  1. CTRL+A+R+M
  2. CTRL+ALT+M+R
  3. CTRL+M+R
  4. ALT+T+M+R

How to Contact Fiverr Customer Support?

FAQ

How Can I Validate My Skills?

To validate your skills, click Take a Test and answer 40 questions within 40minutes, and you will receive a grade and a breakdown of your answers. You can decide whether to show it on your profile or hide it.

How Often Can I Take A Skills Test?

There is a one-day waiting period between test retakes. You may only take a test twice within three months.

How Can I Retake The Test?

Login to your account > Click on your profile > Click on the test you like to retake> Click the Retake Test button.

Conclusion

That’s all about Fiverr Microsoft Excel Test Answers. If you have any further queries drop them in the comments below. It is a great opportunity to learn new skills from industry experts for free and get a certificate.

Leave a Comment