Microsoft Excel 2016 Skills Test Fiverr

 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?

a. 5
b. 6
c. 8
d. 12
e. It will return an error because the formula is incorrect.

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?

a. Go to the File tab -> Click on Save -> Click on Recovered Workbook
b. Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks
c. Go to the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks
d. Go to the File tab -> Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooks

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

a. Alt+F1
b Alt+Shift+F1
c. Ctrl+F1
d. F1

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.

a. Only option ii).
b. Only options ii) and iii).
c. Only options i) and iii).
d. All options i), ii) and iii).

What are ScreenTips in Microsoft Excel 2016?

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

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

a. ALT+F9
b. CTRL+ALT+F10
c. SHIFT+F5
d. CTRL+5

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

a. Disable all macros without notification.
b. Disable all macros with notification.
c. Disable all macros including digitally signed macros.
d. Enable all macros.
e. Disable all macros except digitally signed macros.

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?

a. FILTERS: Days, VALUES: Count of Days
b. COLUMNS: Days, VALUES: Count of Days
c. COLUMNS: Count of Days, VALUES: Days
d. ROWS: Days, VALUES: Count of Days

 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?

a. 0
b. 0.14111
c. -1.21111
d. Error

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

a. True
b. False

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

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

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

a. A workbook is automatically shared when the Track Changes option is turned on.
b. Excel can track all types of changes in a Worksheet.
c. The Track Changes option can be accessed from the View tab.
d. All of the above statements are correct.

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

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

 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?

a. 1
b. 2
c. 3
d. None of the above.

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

a. Windows + Home key
b. Alt + 1 key
c. Ctrl + Home key
d. Windows + 1 key

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

a. Two
b. Three
c. Four
d. Five

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

a. Ctrl + B
b. Alt + F
c. Alt + B
d. Tab + F

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

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

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

a. ou will move to next column.
b. You will move to the first column.
c. You will move to the last column.
d. You will move to the previous column.

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

a. Now()
b. Trend()
c. TimeValue()
d. Numbervalue()

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

a. Ribbon
b. View tab
c. Backstage View
d. Page Layout tab

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

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

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

a. Right-click on the cell and click on "Define Name".
b. Click on the "Formulas" tab and click on "Define Name" under the "Define Names" group.
c. Click on the "Home" tab and click on "Format" under the "Cells" group.
d. Click on the "Home" tab and click on "Define Name" under the "Define Names" group

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

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

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.

a. True
b. False

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

a. File > Options > Publish to Power BI
b. File > Save As > Change "File as type" > Publish to BI
c. File > Share > Publish to BI > Save to Cloud
d. File > Publish > Publish to Power BI

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

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

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?

a. EDATE
b. EOMONTH
c. DATEVALUE
d. NUMBER

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

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

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

a. Sort
b. AutoSum
c. Filter
d. Consolidate

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

a. 64
b. 128
c. 254
d. 508

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

a. File
b. Home
c. Review
d. View

In Microsoft Excel 2016, which of the following options can be locked in a worksheet?
i) Ranges
ii) Formulas

a. Only option i).
b. Only option ii).
c. Both options i) and ii).
d. Neither option i) nor ii).

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

a. Formulas
b. Format Painter
c. Data
d. Review

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

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

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

a. A$2
b. $A2
c. !A2
d. A!2

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.

a. Only option i) is correct.
b. Only option ii) is correct.
c. Both options i) and ii) are correct.
d. Both options i) and ii) are incorrect.

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

a. 7
b. 11.25
c. 13.5
d. It will throw an error.

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

a. True
b. False

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

a. Alignment
b. Background color
c. Cell text
d. None of the above

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

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

Microsoft Excel 2016 Skills Тест Answers part 2

Microsoft Excel 2016 Fiverr Skills Test 2020