Microsoft Excel 2016 Skills Тест Fiverr

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

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

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

a. Manage Data Model
b. Filter
c. Advanced
d. Data Validation

 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?

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

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

a. Alt + C
b. Ctrl + C
c. Windows + C
d. Shift + C

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

a. $Sheet5$B2
b. $Sheet5.B2
c. Sheet5!B2
d. $Sheet5!B2

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?

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

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

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

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

In Microsoft Excel 2016, which of the following options is NOT available under "What-If Analysis"?

a. Scenario Manager
b. Goal Seek
c. Consolidate
d. Data Table

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

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

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?

a. Connections
b. Trust Center
c. Proofing
d. Data Validation

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

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

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

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

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

a. relative.
b. absolute.
c. none of the above.

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.

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

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

a. Comment
b. Table
c. Chart
d. Picture

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?

a. Group
b. Filter
c. Data Validation
d. Subtotal

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

a. Click on the Review tab > Select New > Click on Protect Workbook
b. Click on the File tab > Select Options > Click on Protect Workbook
c. Click on the File tab > Select Info > Click on Protect Workbook
d. Click on the Review tab > Select Account > Click on Protect Workbook

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

a. Consolidation by position.
b. Consolidation by category.
c. Consolidation by data type.
d. None of the above.

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

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

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?

a. Max of Days
b. Average of Days
c. Sum of Days
d. Count of Days

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

a. 4
b. 6
c. 10
d. 16

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

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

 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?

a.Chart Color
b.Chart Elements
c.Format Painter
d.Chart Style

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?

a. Go to the View tab -> Click on Security -> Click on Protected File Types -> Check the Office Data Connection Files check box
b. Go to the File tab -> Click on Options -> Click on Excel Options -> Click on Security -> Check the Block Office Data Connection Files check box
c. Go to the File tab -> Click on Options -> Click on Trust Centre under the Excel Options dialog box -> Click on File Block Settings -> Check the Office Data Connection Files check box
d. None of the above.

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?

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

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

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

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

a. Sheets
b. Sheet
c. Number
d. None of the above.

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

a. the current day name.
b. the date when the Excel file was created.
c. the current day and date.
d. the current date.

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?

a. F1
b. Ctrl+6
c. F4
d. Ctrl+2

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.

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

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

a. AND Function
b. IF Function
c. OR Function
d. XOR Function

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

a. CTRL+A+R+M
b. CTRL+ALT+M+R
c. CTRL+M+R
d. ALT+T+M+R

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

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

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?

a. Undo
b. Redo
c. Save
d. Copy
e. None of the above

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

a. Apostrophe ( ' )
b. Exclamation ( ! )
c. Equal ( = )
d. Hash ( # )

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?

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

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?

a. Click the Data tab -> Select the option "From Other Sources" from the Get External Data group-> Click "From Text"
b. Click the Data tab -> Select the option "Existing Connections" from the Get External Data group-> Click "From Text"
c. Click the Data tab -> Select the option "From Text" from the Get External Data group
d. Click the Formulas tab -> Select the option "From Text" under the Connections group

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

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

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?

a. On the header of the Employee column.
b. On the values of the Sum of Sales column.
c. On the values of the Employee column.
d. On the header of the Sum of Sales column.

Microsoft Excel 2016 Skills Тест Answers часть 1

Microsoft Excel 2016 Fiverr Skills Тест 2020