91. In a computer spreadsheet, block of cells is called ………?
a) Workbook
b) Function
c) Column
d) Range
Answer – [D]
92. In MS-Excel, conditional formatting is in ………… tab.
a) Home
b) View
c) Page Layout
d) Insert
Answer – [A]
93. In MS-Excel readymade templates are available under ………. tab?
a) File
b) Insert
c) Design
d) None of the above
Answer – [A]
94. The greater than sign is an example of ………… operation?
a) Arithmetic
b) Logical
c) Conditional
d) Greater
Answer – [B]
95. Which function displays row data into column or column data into row?
a) Hyperlinks
b) Index
c) Transpose
d) Rows
Answer – [C]
96. Shortcut key Ctrl + D is used to ……….
a) Open Font dialog box
b) Fill Down in the selection
c) Open Format Cells dialog box
d) Shift current cell’s value in the right cell
Answer – [B]
97. In MS-Excel ………. feature makes it easier to add repetitive data to a worksheet.
a) Autosum
b) Sort
c) Filter
d) Autocomplete
Answer – [D]
98. What is the shortcut key to insert a hyperlink in Excel?
a) Ctrl + K
b) Alt + K
c) Shift + K
d) Ctrl + Shift + K
Answer – [A]
99. Which of the following chart types is used to show the distribution of data?
a) Line Chart
b) Bar Chart
c) Histogram Chart
d) Scatter Chart
Answer – [C]
100. What is a “Cell” in Excel?
a) A collection of data
b) The intersection of a row and a column
c) A formula
d) A chart element
Answer – [B]