Here are the Microsoft Advance Excel quiz questions and answers :ġ) Statistical calculations and preparation of tables and graphs can be done using : ExcelĢ) Which function returns the current date? :NOWģ) Which function is used to return the number of cells in a range that meet a condition set forth in the formula? :CountIFĤ)What function will result in the total number of entries in the cell range B5 to B14 : Countĥ)What type of chart is useful for comparing values over categories? :Column ChartĦ)The Software which contains rows and columns is called _ : Spreadsheetħ)What is the keyboard shortcut key to lock cell references in a formula? : F4Ĩ)What are the shortcut keys for AutoSum?: ALT and =ĩ)Company A is looking into four potential projects and will accept them if the IRR is 10% or above, as shown in cell E2. Microsoft Free Cyber Security Course with CertificationĬoursera Free Premium Courses | Intel | Google Cloud | AWS Free Courses with Certifications Google I/O 2021 Program | Free Google Workshops | Earn Google Developer BadgeĪICTE Opens 2,500 Virtual Internships for Everyone
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |