Microsoft Excel 2016 Fiverr Test Updated Question Answer

0

Microsoft Excel 2016 Fiverr Test Updated Question Answer 



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

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

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

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

  • CTRL+A+R+M
  • CTRL+ALT+M+R
  • CTRL+M+R
  • ALT+T+M+R

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

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

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

  • Yes
  • No

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

 9. 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 Þeveloper 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

10. In Excel 2016, the Lookup & Reference option is available under which of the following tabs?

  • Insert
  • Page Layout
  • Formulas
  • Review

 11. 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 Design 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 uncier the Tools group.
  • Right click on the table -> Click on the Filter option -> Select the Convert to Range option.

 12. Consider the given image for the following question.


John inserts a Pivot Table in a worksheet, as shown in figure 1 of the given image. There are three columns in the data SOLINIQUE IT Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 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.

13. 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-Decrypt the Worldook

 14. In Microsoft Excel 2016, if Sam wants to change the Office theme or background, then which of the following options will he use?

  • Export  
  • Account 
  • Options
  • Info

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

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

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

17. 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 O Filter O Advanced

Data Validation

 

18. Choose True or False.

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

True

False

 

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

A workbook is automatically shared when the Track Changes option is turned on.

Excel can track all types of changes in a Worksheet.

The Track Changes option can be accessed from the View tab.

All of the above statements are correct.

 

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

1. Alignment 2. Background color 3. Cell text

Only 1 and 2 

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

21. 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).

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

 

23.  This question is based upon the figure shown below

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.

 

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

0
0.14111
-1.21111
Error

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

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

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

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

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

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

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

  • 7
  • 11.25
  • 13.5
  • It will throw an error.

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

  • 15
  • 18
  • 29
  • 79

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

One

Two

Three

Five

 

33. This question is based upon the figure shown below

n

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

  • 4
  • 6
  • 10
  • 16

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

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

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

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

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

  • Relative.
  • Absolute.
  • none of the above.

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

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

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

  • Developer
  • Review
  • View
  • Home

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

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

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

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

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

  • (a). xls
  • (b). xlsx
  • (c). doc
  • Both options a and b.

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

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

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

48. Choose True or False.

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

  • True
  • False

49. 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
  • 2
  • 3
  • None of the above.

50. In Microsoft Excel 2016, which of the followings 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.

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

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

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

Start date.

End date.

The type of day count basis to use.

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

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

  • File
  • Home
  • Review 
  • View 

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

56. Which of the following types of filters can be created using the AutoFilter option in Microsoft Excel 2016?

By list values. 11) By format 11) By criteria

  • Only option ii).
  • Only options ii) and ii). Only options) and ii).
  • All options 1), ) and it).

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

1. Pie chart 2. Waterfall chart 3. Treemap chart

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

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

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

  • It is used to merge multiple cells to one cell.
  • It is used to delete the hidden text from a cell.
  • It is used to convert extra-long text of a cell into multiple lines so that user can see all of it
  • None of the above.

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

  • Save 
  • Redo or and  undo
  • Copy
  • Both options a) and b)
  • Record macro option – view

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

  • =VLOOKUP (value, table, col_index, [range_lookup])
  • =VLOOKUP (col_index, [range_lookup])
  • =VLOOKUP (table, [range_lookup]), value, col_index)
  • =VLKUP (value, col_index, table, [range_lookup]

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

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

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

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

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

66. 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 keeps the rows and columns visible when the rest of the worksheet is scrolled.
  • 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.

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

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

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

  • CTRL+A+R+M
  • CTRL+ALT+M+R
  • CTRL+M+R
  • ALT+T+M+R

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

71. Choose True or False.

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

  • True 
  • False

72. 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-Decrypt the Workbook

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

74. Which of the following logical functions doesn

  • AND Function
  • IF Function
  • OR Function
  • XOR Function

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

76. 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).

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

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

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

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

  • File > Options > Publish to Power BI
  • File > Save As > Change
  • File > Share > Publish to BI > Save to Cloud
  • File > Publish > Publish to Power BI

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

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

  • 0
  • 0.14111
  • -1.21111
  • Error

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

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

85. 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 cannotvalid certiswitch display contain numbers.

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

  • F4
  • Tab
  • Esc
  • Alt

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

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

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

  • Comment
  • Table
  • Chart
  • Picture

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

91. 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).

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

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

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

1.  Alignment

2.  Background color

3.  Cell text

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

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

1. A Pivot chart is a graphical depiction of a data summary.

2. You cannot create a Pivot chart without a Pivot table.

3. You can create a Pivot table and a Pivot chart at the same time.

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

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

96. In Microsoft Excel 2016, what does the Look up 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

97. 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)

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

Normal

Wide

Narrow

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

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

1. Pie chart

2. Waterfall chart

3. Treemap chart

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

100. In Microsoft Excel 2016, data sorting in columns can be performed on which Of the given Options?

1. Values

2. Cell Color

3. Font Color

4. Cell icon

  • All 1. 2. 3, and 4
  • Only1, 2. and 3
  • Only 2. 3. and 4

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

BESSELI

BITOR

BlTAND

DELTA  

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

  • Data
  • View
  • Formula
  • Insert

103. In relation to the Cube function in Excel 2016, which Of the following functions returns an aggregated value from the cube?

  • CUBESET
  • CUBEMEMBERPROPERTY
  • CUBEVALUE
  • CUBEKPIMEMBER

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

  • Yes
  • No

105. Which of the given statements are correct about the slicers in Microsoft Excel 2016?

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


Tags:
Post a Comment (0)
Previous Post Next Post