Q31. What is the purpose of ‘Tab’ key in MS-Excel?
a) Moves cell pointer to previous column
b) Moves cell pointer to next column
c) Moves cell pointer to previous row
d) Moves cell pointer to next row
Answer – [B]
Q32. What is the purpose of ‘Enter Key’ in MS-Excel?
a) Moves cell pointer to previous column
b) Moves cell pointer to next column
c) Moves cell pointer to previous row
d) Moves cell pointer to next row
Answer – [D]
Q33. What is a ‘Range’ in MS-Excel?
a) A set of rows and columns
b) A single cell
c) A collection of contiguous cells
d) The maximum value in a set of data
Answer – [C]
Q34. Which of the following is not a term of MS-Excel?
a) Cells
b) Rows
c) Columns
d) Document
Answer – [D]
Q35. In a worksheet you can select
a) The entire worksheet
b) Rows
c) Columns
d) All of the above
Answer – [D]
Q36. Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
a) Press Ctrl + Home
b) Press Home
c) Press Shift + Home
d) Press Alt + Home
Answer – [A]
Q37. In MS-Excel two common wildcard characters that MS-Excel recognizes are
a) * and ?
b) < and >
c) ^ and /
d) None of these
Answer – [A]
Q38. …… is the best alternative to MS-Excel offered by Google Inc.
a) Google Slides
b) Google Sheets
c) Google Files
d) Google Keep
Answer – [B]
Q39. Free online version of MS-Excel is known as ………..
a) Office for the web
b) Excel Mobile
c) Word Mobile
d) Excel for the web
Answer – [D]
Q40. What Excel feature automatically fills in values when you drag the handle?
a) Auto Sum
b) Auto Fill
c) Quick Fill
d) Drag Fill
Answer – [B]