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?
From the given image, 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 “14”?
Consider the given image for the following question. John inserts a pivotable 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 paneWhich of the following options will be the default selection under the Values section?
Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?
In Microsoft Excel 2016, which of the following tabs will you click for accessing the View Macros option?
Which of the following options can be used for checking the protection stats of a file in Microsoft Excel 2016?
Peter was working in a Microsoft Excel 2016 workbookHis 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?
In order to protect your Excel data, which of the given file-level protections are available in Microsoft Excel 2016?
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?
In Excel 2016, which of the following options is the correct procedure that is used for converting a table to a regular range?
Choose True or False: 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.
In relation to the Cube function in Excel 2016, which of the following functions returns an aggregated value from the cube?
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?
Which of the following types of filters can be created using the AutoFilter option in Microsoft Excel 2016?
Which of the following logical functions doesn’t return True or False as a result in Microsoft Excel 2016?
In Microsoft Excel 2016 which of the following Engineering functions tests the equality of two numbers?
From the given image, which of the following options should be selected, in order to enable Page Break Preview in Microsoft Excel 2016?
From the given image, In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
From the given image, 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?
In a Microsoft Word 2016 document, by default, which of the following options is the maximum border weight/width that can be applied to a picture from the Picture Border option under the Format tab?
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?
From the given image, Which of the following keyboard shortcuts is used for achieving the strikethrough effect as shown in the given image?
From the given image, Consider the Excel sheet given in the image. What will be the output if you enter the formula, =AVERAGE(A3:C8), in cell C9?
From the given image, 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?
Which of the following functions is used for providing the decimal number of the time represented by a text string?
From the given image, 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”)?
From the given image, Consider the data given in the image. What will be the output if the formula, =PROPER(A1), is applied to cell A2?
Which of the following keyboard shortcuts is used to display or hide the ribbon in Microsoft Excel 2016?
Which of the following options is the correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?
From the given image, In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
In Microsoft Excel 2016, which of the following options provides a user the access to options such as Share, Export, Account, Publish, etc.?
Choose True or False, If a user specifies a print area from the backstage view, then it saves the setting with the workbook.
In Microsoft Excel 2016, which of the followings is NOT a valid option for Macro Settings under the Trust Center?
In Microsoft Excel 2016, the CHOOSE function can be used for selecting up to how many values based on an index number?
Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?
Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?
