Share Facebook Email Telegram WhatsApp Results #1. Which chart type is used to visually compare values across a few categories? Area Chart Area Chart Bar Chart Bar Chart Doughnut Chart Doughnut Chart Hierarchy Chart Hierarchy Chart #2. Which chart type is used to show trends over time and categories? Area Chart Area Chart Bar Chart Bar Chart Doughnut Chart Doughnut Chart Hierarchy Chart Hierarchy Chart #3. Which chart type is used to show the proportions of a while? Area Chart Area Chart Bar Chart Bar Chart Doughnut Chart Doughnut Chart Hierarchy Chart Hierarchy Chart #4. Which is not a Text function in MS Excel? CODE() CODE() CLEAN() CLEAN() CHAR() CHAR() DB() DB() #5. Which Excel function is used to get the discount rate for security? DISCOUNT() DISCOUNT() DISC() DISC() DSC() DSC() PERC() PERC() #6. What is the keyboard shortcut to insert a new comment in a cell in MS Excel? F2 F2 Ctrl + F2 Ctrl + F2 Alt + F2 Alt + F2 Shift + F2 Shift + F2 #7. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel? Shift + F9 Shift + F9 Shift + F10 Shift + F10 Shift + F12 Shift + F12 Shift + F11 Shift + F11 #8. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel? Styling Styling Conditional Formatting Conditional Formatting Compare Formatting Compare Formatting Special Formatting Special Formatting #9. Under which menu, we can insert Header and Footer on the sheet? Format Format Review Review Data Data Insert Insert #10. Show/Hide Gridlines option is available in the ____ Menu. Page Layout Page Layout Data Data Insert Insert Format Format Finish
