Q71. MS-Excel file can not be directly exported as ………..
a) PDF
b) TXT
c) PPT
d) CSV
Answer – [C]
72. In MS-Excel, Page Border option is available under ……… tab.
a) Insert
b) Page Layout
c) View
d) None of the above
Answer – [D]
73. …………. can be used as a keyboard shortcut key to check spelling in MS-Excel?
a) F1
b) F7
c) F2
d) F12
Answer – [B]
74. Which key is used for Help in MS-Excel?
a) Window + H
b) F1
c) F10
d) F2
Answer – [B]
75. Open workbooks can easily be switched using …………..
a) Ctrl + S
b) Alt + S
c) Ctrl + Alt
d) Ctrl + Tab
Answer – [D]
76. What is the purpose of conditional formatting in Excel?
a) To change the format of the text
b) To format a cell based on its value
c) To protect cells
d) To highlight duplicate values
Answer – [B]
77. Which feature in Excel is used to quickly analyze data and provide different viewing options?
a) Quick Analysis
b) Data Analysis
c) PivotTable
d) Solver
Answer – [A]
78. The default alignment of numbering data in MS-Excel is …..
a) Left
b) Right
c) Center
d) Justify
Answer – [B]
79. The default alignment of texts in MS-Excel is ………….
a) Left
b) Right
c) Center
d) Justify
Answer – [A]
80. Which of the following is not a valid data type in Excel?
a) Number
b) Character
c) Label
d) Date/Time
Answer – [B]