![]() ![]() iv) It rounds a number up, to the nearest add integer.ġ0. We are the correct purposes of CEILING, MATH() function in Microsoft Excel 2016? i) It rounds a number up to the nearest integer.-Answer ii) It rounds a number up, to the nearest multiple of significance.-Answer iii) It rounds a number down, to the nearest even integer. ii) It will select the complete Worksheet.-Answer iii) It will select all the Worksheet available in a Workbook iv) It will add a Worksheet to the fileĩ. In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image? i) It will select cell At. From the given image, which of the following options should be selected, in order to enable Page Break Preview in Microsoft Excel 2016? i) 1 ii) 2 iii) 3 iv) None of the aboveĨ. Which of the following logical functions doesn’t return True or False as a result in Microsoft Excel 2016? i) AND Function ii) IF Function -Answer iii) OR Function iv) XOR Functionħ. In Microsoft Excel 2016 which of the following Engineering functions tests the equality of two numbers? i) BESSELI ii) BITOR iii) BiTAND iv) DELTA-AnswerĦ. 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 1. 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? i) Connections ii) Trust Center -Answer iii) Proofing iv) Data validationĤ. 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? i) Go to the File tab -> Click on Save -> Click on Recovered Workbook ii) Go to the File tab -> Click on Open -> Click on Recover Unsaved Workbooks -Answer iii) Go too the File tab -> Click on Options -> Click Save -> Click on Recover Unsaved Workbooks iv) Go to the File tab ->Click on Options -> Save Workbooks -> Click on Recover Unsaved Workbooksģ. Peter was working in a Microsoft Excel 2016 workbook. Encrypt with password box-Answer iv) Open the Workbook and from the file menu, select process workbook decrypt the WorkbookĢ. iii) Enter the password of the Workbook and delete the password in the Permissions. Fiverr microsoft excel test answers 2022 SET-01.ġ.How can we remove password encryption from a Microsoft Excel 2016 file? i) Open the Workbook and save it again with a new password ii) Copy and paste the data in another Workbook and save it. Fiverr Microsoft excel test answers 2022.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |