Fiverr Microsoft Excel Test Answers for 2025 [98% Score Guaranteed]

Career, Digital Marketing, Education, Featured, Latest

Mastering the Fiverr Microsoft Excel test is a crucial step for freelancers aiming to establish themselves in the competitive freelance market. Get the latest Fiverr Microsoft Excel test answers to ease up your next exam and prepare you to score the best number.

Here, I’ve shared Fiverr Microsoft Excel test questions and answers for 2025. I’m ensuring that you will get a score of 9.8 out of 10 (Top 10). It’s 99% accurate. Check out the proof below.

Fiverr Microsoft Excel Test Answers 2025

Check out Fiverr Microsoft Excel test answers for 2025 below. The correct answers are marked as bold. You can also check Fiverr English Test Answers 2025.

1. What is the keyboard shortcut command to move the mouse pointer to cell A1?

Control + Home
Control + F4 key
Name box
Control + A1
Control + Tab key

2. A workbook contains:

1 worksheet
2 worksheets
3 worksheets
4 worksheets
No worksheets

3. The feature that enables you to automatically complete a list of 12 months after you key one month is:

Cell style
Fill handle or Autofill
Page layout
Find
Replace

4. What is the default alignment for values and dates in a cell?

Justified
Left aligned
Centered
Bottom aligned
Right aligned

5. How would the cell reference $F$4 be described?

Mixed reference
Absolute reference
Relative reference
Additional reference
Money reference

6. What type of operation is being performed in the formula =A4*B5?

Addition
Subtraction
Division
Percentage
Multiplication

7. Which orientation is taller than it is wide?

Landscape
Portrait

8. What term describes a model workbook used as the basis for other workbooks?

Form
Demonstration
Template
Cell styles
Page Layout

9. How can you start Edit mode to edit a formula?

Tools
Format
F4
F2 or double-click cell
Find and replace

10. Three types of data visualization are:

Tools, Columns, Styles
Data bars, Color scales, Icon sets
Cell styles, Bold, Italics
Home, Edit, Fill
Shapes, Arrows, Clip art

11. Name the function that adds cell values only if they meet your criteria.

Average()
Count()
Mean()
SumIF()
Round

12. What function would display the highest sales amount in a column?

Min()
Avg()
Max()
Most()
Sum()

13. Which logical function shows the opposite of the condition?

NOT function
False function
Nper function
Sum function
PMT function

14. Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?

NPER function
Sum function
FV function
PMT function
Today function

15. What is the term used to describe a function inside a function?

Conditional
Argument
Nested
Double
Hyperlink

16. What does a hyperlink do?

Adds another argument
Displays a website
Formats worksheet
Hides worksheets

17. Which function enters the current date?

Now()
Days()
DDYYMM
TODAY()

18. What does Excel do if a function is volatile?

Renames the workbook
Closes the program
Recalculates it based on the computer where it is opened
Nothing changes

19. How are data organized in a spreadsheet?

Lines and spaces
Layers and planes
Rows and columns
Height and width

20. Which types of charts can Excel produce?

Line graphs and pie charts only
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only

21. Each Excel file is called a workbook because:

It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it

22. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

Go to File-Save As – Save As Type – Excel worksheet
Right click on the spreadsheet tab and select DELETE
Right click on the spreadsheet and select Insert – Entire Column
None of above

23.What is an expression that tells how the numbers in a determined set of cells are to be calculated?

Formula
Field
Data
Query

24. You can use the formula palette to:

Format cells containing numbers
Create and edit formulas containing functions
Entered assumptions data
Copy a range of cells

25. The autofill feature:

Extends a sequential series of data
Automatically adds a range of cell values
Applies a border around selected cells
None of above

26. Where can you set the shedding color for a range of cells in Excel?

Choose required color from Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
Choose required color on Fill Color tool in Drawing toolbar
All of above

27. How can you remove borders applied in cells?

Choose None on Border tab of Format cells
Open the list on Border tool in Formatting toolbar then choose first tool (no border)
Both of above
None of above

28. Which function will you use to enter the current time in a worksheet cell?

=today()
=now()
=time()
=currentTime()

29. Formatting a cell in Number format you can’t set:

Decimal Places
Use 1000 separator
Negative numbers
Currency Symbol

30. Formatting a cell in Currency, you can specify

Decimal Places
Currency Symbol
Both of above
None of above

31. You can automatically adjust the size of the text in a cell if they do not fit in width by

Double clicking on the right border of column header
From Format choose Columns and then Autofit Selection
From Format Cells dialog box mark Shrink to fit check box
All of above

32. Which of the cell pointer indicates that you can move the content to another cell?

Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of above

33. To apply conditional formatting, you do the following except:

Select the cells you would like to format
Select the color scales
Select Home tab
Locate the styles group

34. The fill handle doesn’t always copy information from one cell directly into another cell.

True
False

35. When you open an Excel workbook, there are__________ sheets by default.

Four
Three
Two
One

36. What command combines several cells into one cell occupying the same screen space?

Merge and Center
Align
Freeze columns
Indent
Split

37. How would Excel display this value =ROUND(1.567) in the cell?

1
2
1.57
1.6

38. What does the VLOOKUP function do?

Looks up text that contain ‘v’
Checks whether text is the same in one cell as in the next
Finds related records
All of above

39. Excel is a:

Graphic program
None of these
Word processor
A spreadsheet Program

40. Which of the following is not an option in the spelling dialog?

Ignore
Edit
Ignore all
Change

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

Non-numeric fields
Date and Time hierarchies
Numeric fields

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

It implies that the filter is disabled.
It implies that the filter is enabled but not applied.
It implies that a filter is applied.
It implies that multiple filters are applied and enabled.

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

Consolidation by position.
Consolidation by category.
Consolidation by data type.
None of the above.

44. In Microsoft Excel 2016, which of the following commands should NOT be removed from the Quick Access Toolbar becaus these commands are NOT available on the ribbon’s command tabs?

Save
Redo
Copy
Both options a) and b)

45. Can we change the default font size of a new workbook in Excel 2016 from the Backstage view?

Yes

46. In the given image, what do the red triangles in the upper-right corner of each cell under the column titled ‘Class’ signify?

They represent that the cells are containing formatted data.
They represent that some data validation is associated with the cells.
They represent that the comments are associated with the cells.
They represent that the cells cannot be edited.

47. In relation to the Backstage view in Microsoft Excel 2016, which of the given commands/ options are available under the Info tab?

- 1. Protect Document
- 2. Manage Workbook
- 3. Browser View Options
- All 1, 2, and 3

Only 1 and 2
Only 1 and 3
Only 2 and 3

48. Can you perform a case sensitive data sorting in Microsoft Excel 2016?

Yes
No

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

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

50. A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 workbook.

True
False

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

Go to the File tab -> Click Info -> Click Excel Options -> Click Security -> Select Allow digitally signed macros only
Go to the File tab -> Click Info -> Click Excel Options -> Click Security -> Select Disable All macros except digitally signed macros
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
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

52. Consider the Excel sheet given in the image. If you wanted to find out the average of all the cells that meet multiple criteria, which function would you use?

AVERAGEIFS
AVERAGEA
AVERAGEIF
AVERAGE

53. If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

True
False

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

Max of Days
Average of Days
Sum of Days
Count of Days

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

Ribbon
View tab
Backstage View
Page Layout tab

56. In Microsoft Excel 2016, the commands used for recording, creating, and deleting macros are accessed from the Developer tab. Which of the following is the correct way of displaying the developer tab on the ribbon?

Click on the File tab -> Click Options -> In the Excel Options dialog box, click option Customize Ribbon -> Check the Developer tab option -> Click OK
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
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
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

57. In Excel 2016, the & Reference Option is available under which Of the following tabs?

Insert
Page Layout
Formulas
Review

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

Click on the Review tab -> Select New -> Click on Protect Workbook
Click on the File tab -> Select Options -> Click on Protect Workbook
Click on the File tab -> Select Info -> Click on Protect Workbook
Click on the Review tab -> Select Account -> Click on Protect Workbook

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

FILTERS: Days, VALUES: Count of Days
COLUMNS: Days, VALUES: Count of Days
COLUMNS: Count of Days, VALUES: Days
ROWS: Days, VALUES: Count of Days

60. Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?

AND
OR
IF
XOR

61. If Sam wants to insert a pivot chart in his Excel worksheet, then which of the following tabs should he use to perform the same?

Developer
View
Review
Insert

62. 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 “I4”?

=AVERAGE(B4)
=AVG(B4 C4 D4 E4 F4 G4)
=(SUM(B4)/COUNT(B4))
Both options a and c.
Both options a and b.

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

AND Function
IF Function
OR Function
XOR Function

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

Two
Three
Four
Five

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

Group
Filter
Data Validation
Subtotal

66. While editing a cell’s content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?

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

ALT+F9
CTRL+ALT+F10
SHIFT+F5
CTRL+5

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

the current day name.
the date when the Excel file was created.
the current day and date.
the current date.

69. Which of the given types of pivot charts can be used in Microsoft Excel 2016?

Pie chart

Waterfall chart

Treemap chart

All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3

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

BESSEL
BITOR
BITAND
DELTA

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

$A2
A$2
!A2
A!2

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

Ribbon
View tab
Backstage View
Page Layout tab

73. This question is based upon the figure shown below. Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1), in cell B9?

5
6
8
12
It will return an error because the formula is incorrect.

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

Go to the File tab -> Click on Save -> Click on Recovered Workbook
Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks
Go to the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks
Go to the File tab -> Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooks

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

Alt+F1
Alt+Shift+F1
Ctrl+F1
F1

76. 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.
Only option ii).
Only options ii) and iii).
Only options i) and iii).
All options i), ii) and iii).

77. What are ScreenTips in Microsoft Excel 2016?

These are the hyperlinks created in a workbook, which take a user from one worksheet to another.
These are the highlighted arrows displayed on the bottom right corner of a cell, which increase the size of a cell on dragging.
These are the small, onscreen boxes that display descriptive text when the pointer is rested on a command or control.
These are used for hiding/showing the menu bars.

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

ALT+F9
CTRL+ALT+F10
SHIFT+F5
CTRL+5

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

Disable all macros without notification.
Disable all macros with notification.
Disable all macros including digitally signed macros.
Enable all macros.
Disable all macros except digitally signed macros.

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

FILTERS: Days, VALUES: Count of Days
COLUMNS: Days, VALUES: Count of Days
COLUMNS: Count of Days, VALUES: Days
ROWS: Days, VALUES: Count of Days

81. This question is based upon the figure shown below. Consider the data given in the image. What will be the output if the formula, =SKEW(A2), is applied to the given content in Microsoft Excel 2016?

0
0.14111
-1.21111
Error

82. A PivotChart is a graphical representation for a summary of data displayed in a Pivot table.

True
False

83. Which of the following statements is/are correct about the customization of the Quick Access Toolbar?

A user can change the size of the Quick Access Toolbar.
A user can add command buttons to the Quick Access Toolbar.
A user CANNOT remove the command buttons from the Quick Access Toolbar.
All of the above statements are correct.

84. In Microsoft Excel 2016, which of the following statements are correct about a Pivot chart?

A Pivot chart is a graphical depiction of a data summary.
You cannot create a Pivot chart without a Pivot table.
One can create a Pivot table and a Pivot chart at the same time.

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

Ctrl + B
Alt + F
Alt + B
Tab + F

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

Open the Workbook and save it again with a new password.
Copy and paste the data in another Workbook and save it.
Enter the password of the Workbook and delete the password in the Permissions – Encrypt with Password box.
Open the Workbook and from the file menu, select Protect Workbook-Decrypte the Workbook

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

You will move to next column.
You will move to the first column.
You will move to the last column.
You will move to the previous column.

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

Now()
Trend()
TimeValue()
Numbervalue()

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

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

90. In Microsoft Excel Excel 2016, Consolidate Option is available under which of the following tabs?

Data
View
Formula
Insert

91. In Excel 2016, the Lookup & Reference Option is available under which Of the following tabs?

Insert
Page Layout
Formulas
Review

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

.xls
.xlsx
.doc
Both options a and b.

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

True
False

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

File > Options > Publish to Power BI
File > Save As > Change “File as type” > Publish to BI
File > Share > Publish to BI > Save to Cloud
File > Publish > Publish to Power BI

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

This is a Book
This Is A Book
This is a book
It will throw an error because the formula cannot contain cell reference.

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

EDATE
EOMONTH
DATEVALUE
NUMBER

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

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

98. Which of the following commands is used in Microsoft Excel 2016 for totaling all the budget spreadsheets prepared by each department in an organization?

Sort
AutoSum
Filter
Consolidate

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

64
128
254
508

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

File
Home
Review
View

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

i) Ranges
ii) Formulas
Only option i).
Only option ii).
Both options i) and ii).
Neither option i) nor ii).

102. Which of the following is NOT a command tab in Microsoft Excel 2016?

Formulas
Format Painter
Data
Review

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

To edit font.
To insert functions.
To copy and paste the formatting of one cell to another in a Worksheet.
To sort and filter data.

104. In Microsoft Excel 2016, when do we receive a “#Value!” error in the VLOOKUP function?

i) When the “lookup_value” argument is more than 255 characters.ii) When the “col_index_num” argument contains text.iii) When the “col_index_num” argument is equal to 0.

Only option i) is correct.
Only options i) and ii) are correct.
Only options ii) and iii) are correct.
All options i), ii) and iii) are correct.

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

Only option i) is correct.
Only option ii) is correct.
Both options i) and ii) are correct.
Both options i) and ii) are incorrect.

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

7
11.25
13.5
It will throw an error.

107. If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

True
False

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

Alignment
Background color
Cell text
None of the above

109. Consider the given image for the following question. What does the blue triangle and border color imply in cell B4?

They imply that a comment is associated to cell B4.
They imply that a filter has been applied to cell B4.
They imply that the Goal Seek option of What-if Analysis is applied to cell B4.
They imply that Track Changes has been enabled and cell B4 is edited.

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

Developer
Review
View
Home

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

Manage Data Model
Filter
Advanced
Data Validation

112. This question is based upon the figure shown below. In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?

It will select cell A1.
It will select the complete Worksheet.
It will select all the Worksheets available in a Workbook.
It will add a Worksheet to the file.

113. In Microsoft Excel 2016, which of the following keyboard shortcuts is used for the “Clear filter” command for Slicer in a Pivot table?

Alt + C
Ctrl + C
Windows + C
Shift + C

114. What will be the correct output if we apply the given formula in the B18 cell (as shown in the image)? = COUNT(B3:B17)

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

Go to the File tab -> Click Info -> Click Excel Options -> Click Security-> Select Allow digitally signed macros only
Go to the File tab -> Click Info -> Click Excel Options -> Click Security-> Select Disable All macros except digitally signed macros
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
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

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

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

117. In Microsoft Excel 2016, what does the Lookup value function do

Look up values vertically and horizontally in a list by using an exact match
Look up values vertically in a list by using an exact match
Look up values horizontally in a list by using an approximate match
Look up values vertically and horizontally in a list by using an approximate match

118. They can be used to filter data in a table, 2. They can be used to f‌ilter data in a PivotTable, 3. They can only be connected to PivotTables that share the same data source.

Only1 and 2
Only1 and 3
Only 2 and 3
All 1, 2, and 3

119. What are the correct purposes of CEILINGMATHI) function in Microsoft Excel 2016?

It rounds a number up, to the nearest integer.
It rounds a number up, to the nearest multiple of significance.
It rounds a number down, to the nearest even integer.
It rounds a number up, to the nearest odd integer.

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

$Sheet5$B2
$Sheet5.B2
Sheet5!B2
$Sheet5!B2

121. Which of the given page margins are available under the Page Layout tab in Excel 2016?

Normal
Wide
Narrow
All 1, 2, and 3

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

Only option i).
Only options ii) and iii).
Only options i) and iii).
All options i), ii) and iii).

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

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

124. In Microsoft Excel 2016, which of the following options is NOT available under “What-If Analysis”?

Scenario Manager
Goal Seek
Consolidate
Data Table

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

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

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

Connections
Trust Center
Proofing
Data Validation

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

One
Two
Three
Five

128. In Microsoft Excel 2016, which of the following is the correct syntax of the VLOOKUP command?

a. =VLOOKUP (value, table, col_index, [range_lookup])
b. =VLOOKUP (table, [range_lookup]), value, col_index)
c. =VLKUP (value, col_index, table, [range_lookup])

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

relative.
absolute.
none of the above.

130. Which of the following is/are the correct method(s) of consolidating data in Microsoft Excel 2016?

Consolidation by position.
Consolidation by category.
Consolidation by data type.
None of the above.

131. Which of the following can be used to avoid users to make changes to a worksheet in Microsoft Excel 2016?

By providing Read Only access.
By password protecting a Workbook.
Restricting permissions by Information Rights Management (IRM).
All of the above.

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

Max of Days
Average of Days
Sum of Days
Count of Days

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

7
11.25
13.5
It will throw an error.

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

We can copy and paste data from the protected sheet to a new Workbook.
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.
We can paste data into the protected worksheet.
We can de-crypt the password of the protected sheet.

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

CTRL + S
CTRL + D
CTRL + & (Ampersand)
CTRL + ` (grave accent)

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

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

Chart Color
Chart Elements
Format Painter
Chart Style

138. The IT security department of Irvin’s organization decides that the Office Data Connection Files must be opened in a protected view. Which of the following procedures should be opted by Irvin?

Go to the View tab -> Click on Security -> Click on Protected File Types -> Check the Office Data Connection Files check box
Go to the File tab -> Click on Options -> Click on Excel Options -> Click on Security -> Check the Block Office Data Connection Files check box
Go to the File tab -> Click on Options -> Click on Trust Center under the Excel Options dialog box -> Click on File Block Settings -> Check the Office Data Connection Files check box
Go to the File tab -> Click on Options -> Click Trust Center under the Excel Options dialog box -> Click Macros -> Select Disable All macros except digitally signed macros

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

Click on the File tab -> Click Options -> In the Excel Options dialog box, click option Customize Ribbon -> Check the Developer tab option -> Click OK
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
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
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

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

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

141. In Microsoft Excel 2016, which of the following functions is used for returning the sheet number of a reference sheet?

Sheets
Sheet
Number
None of the above.

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

the current day name.
the date when the Excel file was created.
the current day and date.
the current date.

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

F1
Ctrl+6
F4
Ctrl+2

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

i) Start date.
ii) End date.
iii) The type of day count basis to use.

Only option ii).
Only options i) and ii).
Only option iii).
Only options ii) and iii).

145. While working in Microsoft Excel Excel 2016, for which of the following options, if included in a worksheet, we cannot use the Track Changes option,

Comment
Table
Chart
Picture

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

Alt+F8
Ctrl+Shift+F8
Ctrl+F8
Shift+F8

147. In Microsoft Excel 2016, what does the VALUE function do?

It is used for converting a text argument to a number.
It counts the cells that contain numbers in an Excel sheet.
It is used for adding numeric values.
It is used for calculating the ASCII values of a text string.

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

Undo
Redo
Save
Copy
None of the above

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

Apostrophe ( ‘ )
Exclamation ( ! )
Equal ( = )
Hash ( # )

150. Consider the given image for the following question. There are red triangles in the upper-right corner of each cell under the column titled ‘Class’. What do they signify?

They represent that the cells are containing formatted data.
They represent that some data validation is associated with the cells.
They represent that the comments are associated with the cells.
They represent that the cells cannot be edited.

151. Which of the following statements is correct about the #Data constant in Microsoft Excel 2016?

It is the set of all the cells that contains data, which includes any header rows but excludes the total or subtotal rows.
It is the set of all the cells that contain data, which includes any total or subtotal rows but excludes the header rows.
It is the set of all the cells that contain data including header rows as well as any total or subtotal rows.
It is the set of all the cells that contain data excluding header rows as well as any total or subtotal rows.

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

On the header of the Employee column.
On the values of the Sum of Sales column.
On the values of the Employee column.
On the header of the Sum of Sales column.

These were the answers to the Fiverr Microsoft Excel tests. Prepare well for the upcoming exams. If you want to pursue your career as an SEO expert, you definitely need the Fiverr SEO Skill Assessment Test Answers in 2025.