Prev 1 2 3 4 5 Next
41. Which chart type is used to visually compare values across a few categories?
A. Area Chart
B. Bar Chart
C. Doughnut Chart
D. Hierarchy Chart
ANSWER:B
SOLUTION : In MS Excel, the Bar Chart is used to visually compare values across a few categories.
42. Which chart type is used to show trends over time and categories?
A. Area Chart
B. Bar Chart
C. Doughnut Chart
D. Hierarchy Chart
ANSWER:A
SOLUTION: In MS Excel, the Bar Chart is used to show trends over time and categories.
43. Which chart type is used to show the proportions of a while?
A. Area Chart
B. Bar Chart
C. Doughnut Chart
D. Hierarchy Chart
ANSWER:C
SOLUTION: In MS Excel, the Doughnut Chart is used to show the proportions of a while. It can be used when the total of your numbers is 100%.
44. Which is not a Text function in MS Excel?
A. CODE()
B. CLEAN()
C. CHAR()
D. DB()
ANSWER:D
SOLUTION: The DB() is a financial function, not a Text function, the rest of the others are text functions.
45. Which Excel function is used to get the discount rate for security?
A. DISCOUNT()
B. DISC()
C. DSC()
D. PERC()
ANSWER:B
SOLUTION: The DISC() function is used to get the discount rate for security.
46. What is the keyboard shortcut to insert a new comment in a cell in MS Excel?
A. F2
B. Ctrl + F2
C. Alt + F2
D. Shift + F2
ANSWER:D
SOLUTION :The keyboard shortcut to insert a new comment in a cell is “Shift + F2”.
47. What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?
A. Shift + F9
B. Shift + F10
C. Shift + F12
D. Shift + F11
ANSWER: D
SOLUTION:The keyboard shortcut to insert a new sheet in the current workbook is “Shift + F11”.
48. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?
A. Styling
B. Conditional Formatting
C. Compare Formatting
D. Special Formatting
ANSWER:B
SOLUTION:By using the “Conditional Formatting” feature, we can apply special formatting based on the conditions.
49.Under which menu, we can insert Header and Footer on the sheet?
A. Format
B. Review
C. Data
D. Insert
ANSWER:D
SOLUTION: The header and Footer option is available in the “Insert” Menu. We can insert the Header and Footer in the sheet by clicking on the “Header and Footer” option from “Text Group” in the “Insert” Menu.
50. Show/Hide Gridlines option is available in the ____ Menu.
A. Page Layout
B. Data
C. Insert
D. Format
ANSWER:A
SOLUTION: In the “Page Layout” Menu, the option to show/hide gridlines available.