11th class Computer Unit 9 MCQs
51.What happens if enter key is pressed when B4 is the active cell?
a. C5 be comes the active cell
b. A1becomes the active cell
c. B6 becomes the active cell
d. B5 becomes the active cell
52. Formula can only be applied on:
a. Unmerged cells
b. Values
c. None of these
d. Labels
53. In MS-Excel, formula begins with:
a. =
b. >
c. ==
d. <
54. A mathematical expression used to perform calculations on worksheet is called:
a. Format
b. Cell
c. Formula
d. Bar
55. A formula in Excel always begins with:
a. ==
b. >
c. <
d. =
56. Which of the following formulas give a result of 6?
a. 8-2*3+8/2
b. 9-2*4/2
c. +2*3-4/2
d. 1+2*3-8/2
57. Which of the following is a correct formula?
a. +D4,D5
b. +D3 andD4
c. =D3+D4
d. =D3&D4
58. Which of the following values is the result of the formula (7-3)*(1+6)/4?
a. 2
b. 7
c. 12
d. 1.5
59. What happens if you type =A1+A2 into a worksheet cell?
a. Data appears as a date function
b. Data appears as a label
c. Data appears as a formula
d. Excel shows four characters as number
60. Which of the following function is used to get the current date?
a. Month()
b. Exact()
c. Year()
d. Today()
61. Which of the following function is used to get current date in MS-Excel:
a. Today
b. Month
c. Exact
d. Year
62. The number of arguments in SQRT function in MS-Excel is/are:
a. Equal or range
b. One
c. Equal to column number
d. Two
63. The function in MS-Excel is used to get the smallest value is called:
a. MINIMUM
b. MAX
c. SMALLEST
d. MIN
64. To get the current date, following function is used:
a. =Today(A1)
b. = Dau()
c. = TD()
d. = Today()
65. The values given to function for calculations are called:
a. Command
b. Formula
c. Syntax
d. Argument
66. A built-in formula is known as:
a. Procedure
b. Function
c. Update
d. Calculate
67. How many arguments does SUM function require?
a. 3
b. 1
c. 4
d. 2
68. Which term is used for a predefined calculation in spreadsheet program?
a. Math operator
b. Result
c. Range
d. Function
69. SUM, AVERAGE, MIN and MAX are examples of:
a. Functions
b. Calculation
c. Relative addressing
d. Formulas
70. The function that is used to get minimum value is called:
a. MINIMUM
b. MAX
c. LOWER
d. MIN
71. The function that is used to get the maximum value is called:
a. MAX
b. HIGHEST
c. MAXIMUM
d. GREATER
72. The function that is used to count the number of entries in the give range is called:
a. Counting
b. Length
c. Count
d. Counter
73. The function that is used to get average is called:
a. Medium
b. Average
c. Avrg
d. Avg
74. The default number format assigned to a cell is:
a. Text
b. Currency
c. General
d. Number
75. Each number format in Excel consist of:
a. 3 parts
b. 2 parts
c. 5 parts
d. 4 parts