![]() ![]() 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 Info -> Click Excel Options -> Click Security-> Select Allow digitally signed macros only ![]() Which of the following is the correct way to restrict the unsigned macros? Q - The IT security department of Mark's organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016. Click on the Review tab > Select Account > Click on Protect Workbook Click on the File tab > Select Info > Click on Protect Workbook Click on the File tab > Select Options > Click on Protect Workbook Click on the Review tab > Select New > Click on Protect Workbook Q - Which of the following options can be used for checking the protection status of a file in Microsoft Excel 2016? Q - What is/are the default file extension(s) of a Microsoft Excel 2016 workbook? What will be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft Excel 2016? the date when the Excel file was created.Ĭonsider the data given in the image. Q - In Microsoft Excel 2016, the =TODAY() command returns: Go to the File tab -> Click on Options -> Save Workbooks -> 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 Open -> Click on Recover Unsaved Workbooks Go to the File tab -> Click on Save -> Click on Recovered Workbook Which of the following is the correct way to recover an unsaved workbook? His workbook closed due to a system error and he couldn't save it. Q - Peter was working in a Microsoft Excel 2016 workbook. Q - While entering data in an Excel 2016 worksheet, what happens if you press the tab key in a cell? They imply that Track Changes has been enabled and cell B4 is edited. They imply that the Goal Seek option of What-if Analysis is applied to cell B4. They imply that a filter has been applied to cell B4. They imply that a comment is associated to cell B4. What does the blue triangle and border-color imply in cell B4? Q - This question is based upon the figure shown belowĬonsider the given image for the following question. 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 Go to the File tab -> Click on Options -> Click on Excel Options -> Click on Security -> Check the Block Office Data Connection Files check box Go to the View tab -> Click on Security -> Click on Protected File Types -> Check the Office Data Connection Files check box Which of the following procedures should be opted by Irvin? Q - The IT security department of Irvin's organization decides that the Office Data Connection Files must be opened in a protected view. Q - Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?Ī PivotChart is a graphical representation for a summary of data displayed in a Pivot table. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab? Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. What will be the output if you enter the formula, =AVERAGE(A3:C8), in cell C9? ![]() Q - This question is based upon the figure shown belowĬonsider the Excel sheet given in the image. Q - Which of the following options can be copied using the format painter in Microsoft Excel 2016?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |