11th class Computer Unit 9 MCQs
26. Which of the following is an absolute address?
a. A$1$
b. A1
c. A1$
d. None of these
27. The cell range from A3 through G3 should be written as:
a. A3…G3
b. A3-G3
c. A3.G3
d. A3:G3
28. Calling a cell in MS-Excel by just their addresses is called:
a. Relative refreshing
b. Names range
c. Absolute refreshing
d. Labeling
29. Which of the following is a correct cell address?
a. 3b
b. AA
c. C5
d. 25
30. Absolute reference is created by adding:
a. % Sign
b. #Sign
c. @Sign
d. $ Sign
31. A cell at second column and 15throw has a cell address:
a. B 15
b. 15 A
c. A 15
d. 15 B
32. Which of the following is a correct formula?
a. +D1 . D4
b. +A1 andA4
c. = D1 + D4
d. = A1 & A4
33. Which of the following is an absolute address of a cell in MS-Excel?
a. $B$1
b. B1$
c. $B1$
d. B$1$
34. Which of the following is a correct cell address?
a. 3B
b. AA
c. C5
d. 25
35. A block of cells is called:
a. Column
b. Workbook
c. Range
d. Function
36. The cell whose address is used in formula is called:
a. Sheet Reference
b. Reference Cell
c. Row reference
d. Column Reference
37. The address A1 is known as:
a. Advanced referencing
b. Mixed referencing
c. Absolute referencing
d. Relative referencing
38. Which type of cell reference in a formula does not change when it is copied to another cell? Q
a. Advanced referencing
b. Mixed referencing
c. Absolute referencing
d. Relative referencing
39. The combination of letters and numbers such asA5,B9,D15 refers to:
a. Function
b. Row identifier
c. Formula
d. Cell address
40. A spreadsheet cell highlighted with a heavy border is the:
a. Locked cell
b. Active cell
c. Passive cell
d. Absolute cell
41. Which of the following is a correct row address?
a. 3B
b. AA
c. C5
d. 25
42. Each cell can contain a:
a. Formula
b. Label
c. Value
d. All
43. The row numbers used in a spreadsheet are called:
a. Formula
b. Labels
c. Values
d. Reference
44. The data in a spreadsheet cell representing wages or test scores should be a :
a. Formula
b. Label
c. Calculation
d. Value
45. An entry in a spreadsheet cell like “Monthly Wages” or “Final Approval Rating” would most likely be a:
a. Formula
b. Label
c. Calculation
d. Value
46. An entry in a spreadsheet cell like “=(b2+b3)/2” is to an example of:
a. Formula
b. Label
c. Function
d. Value
47. The cell that contains a formula or function will show:
a. The result value
b. Formula or function
c. Range address
d. Cell’s address
48. B2:E3 is an example of a cell:
a. Command
b. Range
c. Style
d. Location
49. Which of the following cell address will be included in the range C5:E7?
a. E4
b. C8
c. D9
d. D6
50. Which of the following is a relative cell reference?
a. B3
b. $B$1
c. $D$7
d. $C$5