Q61. Columns in MS-Excel are named in the form of ……
a) Alphabets (A, B, C, D, ….)
b) Numbers (1, 2, 3, 4, ……)
c) Roman Numbers (I, II, III, IV, ….)
d) None of these
Answer – [A]
Q62. Rows in MS-Excel are named in the form of ………
a) Alphabets (A, B, C, D, ….)
b) Numbers (1, 2, 3, 4, ……)
c) Roman Numbers (I, II, III, IV, ….)
d) None of these
Answer – [B]
Q63. What is a Pivot Table used for in Excel?
a) Sorting Data
b) Organizing and summarizing large amounts of data
c) Merging two tables
d) Changing the font style of a table
Answer – [B]
Q64. Which of the following series type is not valid for Fill Series dialog box?
a) Linear
b) Growth
c) AutoFill
d) Time
Answer – [D]
Q65. Formatting a cell in currency, you can specify
a) Decimal Places
b) Currency Symbol
c) Both of above
d) None of the above
Answer – [C]
Q66. Which of the following chart types is used to display trends over time?
a) Line Chart
b) Bar Chart
c) Pie Chart
d) Scatter Chart
Answer – [A]
Q67. What is the shortcut key to select cells in a worksheet in Excel?
a) Ctrl + A
b) Ctrl + S
c) Ctrl + Shift + A
d) Ctrl + Alt + A
Answer – [A]
Q68. What is the shortcut key to open the “Format Cells” dialog box in Excel?
a) Ctrl + 1
b) Ctrl + 2
c) Ctrl + 3
d) Ctrl + 4
Answer – [A]
Q69. Which of the following chart types is used to compare values side by side?
a) Line Chart
b) Bar Chart
c) Scatter Chart
d) Pie Chart
Answer – [B]
Q70. In Excel all Macro keyboard shortcuts include the ……….. key.
a) Alt
b) Ctrl
c) F11
d) Shift
Answer – [A]