Fiverr Microsoft Excel Test Answers
Fiverr Skill Test Benefits
- You will be making a
strong impression profile.
- Win be able to win
worthy jobs.
- You will be showing
solid proof of your skill and win a job.
- It helps you gain the
attention of a client.
- You will be able to
earn high through worthy projects
- This will help you
pursue your freelance career as a full-time job.
Fiverr Microsoft Excel 2016 Exam / Test Questions and Answers 2022
In Microsoft Excel 2016, which of the following options can be
locked in a worksheet?
i) Ranges
ii) Formulas
1. a. Only option i).
2. b. Only option ii).
3. c. Both options i) and ii).
4. d. Neither option i) nor ii).
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:B8), in cell B9?
1. a. 5
2. b. 6
3. c. 8
4. d. 12
5. e. It will return an error
because the formula is incorrect.
This question is based upon the figure shown below
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?
1. a. They represent that the cells
are containing formatted data.
2. b. They represent that some data
validation is associated with the cells.
3.
c. They represent that the comments are associated with the cells.
4. d. They represent that the cells
cannot be edited.
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:A11), is applied to the given content in Microsoft Excel
2016?
1. a. 0
2.
b. 0.14111
3. c. -1.21111
4. d. Error
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. a. $Sheet5$B2
2. b. $Sheet5.B2
3. c. Sheet5!B2
4. d. $Sheet5!B2
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. a. EDATE
2. b. EOMONTH
3. c.
DATEVALUE
4. d. NUMBER
This question is based upon the figure shown below
Which of the following keyboard shortcuts is used for achieving
the strikethrough effect as shown in the given image?
1. a. ALT+F9
2. b. CTRL+ALT+F10
3. c. SHIFT+F5
4. d. CTRL+5
In Microsoft Excel 2016, how can we publish a Workbook to Power
BI?
1. a. File > Options >
Publish to Power BI
2. b. File > Save As > Change
"File as type" > Publish to BI
3. c. File > Share > Publish
to BI > Save to Cloud
4. d.
File > Publish > Publish to Power BI
This question is based upon the figure shown below
Consider the given image for the following question.
What does the blue triangle and border-color imply in cell B4?
1. a. They imply that a comment is
associated to cell B4.
2. b. They imply that a filter has
been applied to cell B4.
3. c. They imply that the Goal Seek
option of What-if Analysis is applied to cell B4.
4. d.
They imply that Track Changes has been enabled and cell B4 is edited.
5.
While entering data in an Excel 2016 worksheet, what happens if
you press the tab key in a cell?
1. a. You
will move to next column.
2. b. You will move to the first
column.
3. c. You will move to the last
column.
4. d. You will move to the previous column.
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?
1. a. Go to the File tab ->
Click on Save -> Click on Recovered Workbook
2. b. Go
to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks
3. c. Go to the File tab ->
Click on Options -> Click Save -> Click on Recover Unsaved
Workbooks
4. d. Go to the File tab ->
Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooks
In Microsoft Excel 2016, the =TODAY() command returns:
1. a. the current day name.
2. b. the date when the Excel file
was created.
3. c. the current day and date.
4. d.
the current date.
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:A11), is applied to the given content in Microsoft Excel
2016?
1. a. 0
2. b.
0.14111
3. c. -1.21111
4. d. Error
What is/are the default file extension(s) of a Microsoft Excel
2016 workbook?
1. a. .
xls
2. b. .
xlsx
3.
c. . doc
4. d. Both options a and b.
Which of the following options can be used for checking the
protection status of a file in Microsoft Excel 2016?
1. a. Click on the Review tab >
Select New > Click on Protect Workbook
2. b. Click on the File tab >
Select Options > Click on Protect Workbook
3. c. Click on the File tab >
Select Info > Click on Protect Workbook
4. d. Click on
the Review tab > Select Account > Click on Protect Workbook
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. a. Go to the File tab ->
Click Info -> Click Excel Options -> Click Security-> Select
Allow digitally signed macros
only
2. b. Go to the File tab ->
Click Info -> Click Excel Options -> Click Security-> Select
Disable All macros except digitally signed
macros
3. c. 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. d. 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
In Microsoft Excel 2016, which of the following options provides a
user the access to options such as Share, Export, Account, Publish, etc.?
1. a. Ribbon
2. b. View tab
3. c. Backstage
View
4. d. Page Layout tab
Choose True or False.
If a user specifies a print area from the backstage view, then
it saves the setting with the workbook.
a. True
b.
False
This question is based upon the figure shown below
From the given image, which of the following options should be
selected, in order to enable Page Break Preview in Microsoft Excel 2016?
1. a. 1
2. b. 2
3.
c. 3
4. d. None of the above.
In Microsoft Excel 2016, which of the following is NOT a valid
option for Macro Settings under the Trust Center?
1. a. Disable all macros without
notification.
2. b. Disable all macros with
notification.
3. c.
Disable all macros including digitally signed macros.
4. d. Enable all macros.
5. e. Disable all macros except
digitally signed macros.
In Microsoft Excel 2016, the CHOOSE function can be used for
selecting up to how many values based on an index number?
1. a. 64
2. b. 128
3. c. 254
4. d. 508
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. a. Group
2. b. Filter
3. c. Data Validation
4. d. Subtotal
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.
1. a. Only option ii).
1. b. Only options i) and ii).
2. c. Only
option iii).
3. d. Only options ii) and iii).
In Microsoft Excel 2016, the Save As option can be accessed from
which of the following tabs?
1. a. File
2. b. Home
3. c. Review
4. d. View
Question: 7 - This question is based upon the figure shown below
Which of the following keyboard shortcuts is used for achieving
the strikethrough effect as shown in the given image?
1. a. ALT+F9
2. b. CTRL+ALT+F10
3. c. SHIFT+F5
4. d. CTRL+5
In Microsoft Excel 2016, how can we publish a Workbook to Power
BI?
1. a. File > Options >
Publish to Power BI
2. b. File > Save As > Change
"File as type" > Publish to BI
3. c. File > Share > Publish
to BI > Save to Cloud
4. d. File > Publish > Publish to Power BI
Which of the following
options can be copied using the format painter in Microsoft Excel 2016?
1. a. Alignment
2. b. Background color
3. c. Cell text
4. d. None of the above
This question is based upon the figure shown below
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. a. 7
2. b. 11.25
3. c. 13.5
4. d. It will throw an error.
This question is based upon the figure shown below
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. a. 15
2. b. 18
3. c. 29
4. d. 79
By default, how many worksheets are there in a new Microsoft Excel
2016 workbook?
1. a. One
2. b. Two
3. c. Three
4. d. Five
This question is based upon the figure shown below
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. a. 4
2. b. 6
3. c. 10
4. d. 16
Which of the following functions is used for providing the decimal
number of the time represented by a text string?
1. a. Now()
2. b. Trend()
3. c. TimeValue()
4. d. Numbervalue()
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.
1. a. Only option i) is correct.
2. b. Only options i) and ii) are
correct.
3. c. Only options ii) and iii) are
correct.
4. d. All options i), ii) and iii) are correct.
Which of the following keyboard shortcuts is used to display or
hide the ribbon in Microsoft Excel 2016?
1. a. Alt+F1
2. b. Alt+Shift+F1
3. c. Ctrl+F1
4. d. F1
By default, all cell references in Microsoft Excel 2016 are:
1. a. Relative.
2. b. Absolute.
3. c. none of the above.
What will happen if you enter XYZ1 in a cell and drag the fill
handle down?
1. a. It will fill XYZ1 in all the
cells that are dragged through.
2. b. It will fill the series with XYZ2, XYZ3, XYZ4 and so on,
respectively.
3. c. It will fill the series with
XYZ2, ABC3, DEF4 and so on, respectively.
4. d. None of the above.
Which of the following options is the correct keyboard shortcut
for accessing the backstage view in Microsoft Excel 2016?
1. a. Ctrl + B
2. b. Alt + F
3. c. Alt + B
4. d. Tab + F
In Microsoft Excel 2016, which of the following tabs will you
click for accessing the View Macros option?
1. a. Developer
2. b. Review
3. c. View
4. d. Home
This question is based upon the figure shown below
Consider the data given in the image. What will be the output if
the formula, =PROPER(A1), is applied to cell A2?
1. a. This is a Book
2. b. This Is A Book
3. c. This is a book
4. d. It will throw an error
because the formula cannot contain cell reference.
0 Comments