1. what is the extension file excel 2004 ?
a) .xls
b) .excel
c) .xcel
d) .xcl
Ans. A
2. What is the extension file excel 2007 and above ?
a) .xls
b) .excel
c) .xlsx
d) .xcl
Ans. C
3. Worksheet is also called an array of____.
a) column
b) cells
c) box
d) formula
Ans. b
4.How Cells are named in MS Excel?
A. Alphabetically
B. Numerically
C. Alphanumerically
D. Special Character
Ans. c
5.What is the maximum limit of rows in MS Excel 2010?
A. 1084567
B. 1048567
C. 1048576
D. 1084576
Ans. c
6.What is the maximum limit of column in MS Excel 2010?
A. 16384
B. 16438
C. 16843
D. 16348
Ans. a
7.Which bar lies top of the window in Excel Screen?
A. Status Bar
B. Ruler C Title Bar
D. Scroll Bar
Ans. C
8.How rows are numbered in MS Excel?
A. Alphabetically
B. Numerically
C. Alphanumerically
D. Special characters
Ans. b
9.How columns are named in MS Excel?
A. Alphabetically
B. Numerically
C. Alphanumerically
D. Special characters
Ans. A
10.Which tab is used to include pivot table, charts, hyperlinks to a spread sheet?
A. Insert
B. Page Layout
C. Data
D. Review
Ans. a
11.Which tab in Excel is used when importing, querying, outlining and subtotaling the data placed into a worksheet’s data list?
A. Formula
B. Data
C. Review
D. Insert
Ans. B
12.Which tab in Excel is used for proofing, protecting, and marking up a spread sheet?
A. Formula
B. Data
C. Review
D. View
Ans. c P a g e | 432
13.Which tool in Ms office is best for organizing data and making lists?
A. Access
B. Excel C Power Point
D. Word
Ans. b
14.What is the file extension of Excel 2010?
A. xls
B. xlsb
C. xlsm
D. xlsx
Ans. d
15.How does the single element in a worksheet known as in Excel?
A. Cell
B. Column
C. Range
D. Row
Ans. a
16.What do you mean by A3,B13:B20,C7 reference in Excel?
A. Range
B. Union
C. Formula
D. General
Ans. a
17.Which type of key should combine with ctrl key to create a macro key in Excel?
A. Numeric
B. Alphabetic
C. Alphanumeric
D. Special characters
Ans. b
18.Which bar is used to display the sheet information and insertion point location in MS Excel?
A. Ruler
B. Scroll Bar
C. Status Bar
D. Title Bar
Ans. c
19.Which tab is used to change the display of worksheet area and the data it contains?
A. Page Layout
B. Data
C. Review
D. View
Ans. d
20.Which view in Excel displays the pages exactly as they appear when printed?
A. Custom View
B. Full screen View
C. Page Break View
D. Page Layout view
Ans. d
21.Which tab is used for creating, formatting and editing a spreadsheet?
A. Data
B. Home
C. Insert
D. Review
Ans. b
22.Which function is used to count the number of cells that contain numbers, in a range?
A. Count ()
B. Countif()
C. Sum()
D. Sumif()
Ans. a
23.Which function is used to add the values in a range?
A. Count()
B. Sum()
C. ABS()
D. Sumif()
Ans. b
24.which symbol is used to excute formulas in MS Excel?
A = B „
C # D “
Ans. a P a g e | 433
25.Wheredoes the result displays when a formula is entered in Excel?
A. Current Cell
B. Next Cell
C. Previous Cell
D. Formula Bar
Ans. a
26.Which function in Excel is used to find the biggest value in a range?
A. Ceiling
B. DMAX C LEN
D. MAX
Ans. d
27.Which one of the following is a text function in MS Excel?
A. MID()
B. NOW()
C. COUNT()
D. SIGN
Ans. a
28.Which one of the following is a „Date & Time‟ function in Excel?
A. FIND()
B. MOD()
C. NOW()
D. MID()
Ans. c
29.Which function is used to find the middle number in a range?
A. MEDIAN()
B. MID()
C. TRIM()
D. MODE()
Ans. a
30.What is the purpose „Tab‟ key in MS Excel?
A. Moves cell pointer to previous column
B. Moves cell pointer to next column
C. Moves cell pointer previous row
D. Moves cell pointer next row
Ans. b
31.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
Ans. d
32.Which function key is used to open goto dialogue box in MS Excel?
A. F2
B. F5
C. F7
D. F11
Ans. b
33.Which option in MS Excel is used to display the rows that meet certain conditions?
A. Find
B. Filter
C. Format
D. Sort
Ans. b
34.Which option in Excel is used to rearrange the rows base on the content of a particular column?
A. Find
B. Filter
C. Sort
D. Format
Ans. c
35. Microsoft Excel is a powerful____
a) word processing package
b) spreadsheet package
c) communication s/w package
d) DBMS Package Ans. b P a g e | 434
36.Which one of the following is „no argument‟ function?
A. Now()
B. Lower()
C. Max()\
D. IF()
Ans. a
37.Which key is used to move the insertion point to the beginning of the current sheet?
A. Pageup
B. Home
C. Ctrl + pageup
D. Ctrl + Home
Ans. d
38. To remove the content of selected cells you must issue ____ command
a) Delete
b) Clear contents
c) Clear all
d) Clear Delete
Ans. b
39. By default Excel provide 3 worksheets. You need only two of them, how will you delete the third one?
a) Right click on sheet tab of third sheet and choose delete from the context menu
b) click on sheet 3 and from edit menu choose delete
c) both A and B
d) None of these
Ans. a
40. which of the following is not a valid data type in excel?
a) number
b) character
c) label
d) Date/Time
Ans. b
41. The intersection of a row and column in MS Excel is called _______ .
(a) spreadsheet
(b) workbook
(c) document
(d) cell Ans. d
42. The cell having and column number 3 and row number 6 is denoted by the name ______.
(a) F3
(b) C6
(c) C3
(d) F6
Ans. b
43. MS excel provide the default value for step in fill series dialog box
a) 0
b) 1
c) 5
d) 10
Ans. b
44. MS Excel can ______ given data.
(a) sort
(b) statistically analyze
(c) draw graphs for
(d) all of them
Ans. d
45. Which of the following you can paste selectively using paste special command?
a) validation
b) Formats
c) Formulas
d) All of these
Ans. d
46. Edit > Delete command
a) Delete the content of a cell
b) Delete formats of cell
c) Delete the comment of cell
d) Deletes selected cells
Ans. d
47. Excel supports recording of repeated actions with the help of ______.
(a) graph
(b) chart
(c) macro
(d) other applications
Ans. c P a g e | 435
48. MS Excel macros can be invoked using_______.
(a) button
(b) keystroke
(c) both a & b
(d) neither a nor b
Ans. c
49. MS Excel supports a version of Visual Basic called ______for programming.
(a) Javascript
(b) Visual Basic for Applications (VBA)
(c) ASP.NET
(d) C#.NET
Ans. b
50. Each sheet in MS Excel file is called a ______.
(a) workbook
(b) worksheet
(c) notesheet
(d) notebook
Ans. b
51. By default, Excel worksheets are named _______.
(a) book1, book2, book3, ...
(b) sheet1, sheet2, sheet3,...
(c) page1, page2, page3, ...
(d) note1, note2, note3, ...
Ans. b
52. Excel file without any macros has the default extension of ______.
(a) .xlsx
(b) .xls,l,
(c) .xlsm
(d) .xlst
Ans. a
53. Excel file containing macros has the default extension of______ .
(a) .xlsx
(b) .xls
(c) .xlsm
(d) .xlst
Ans. c
54. MS Excel can reference data in _______.
(a) the same sheet
(b) different sheet in the same workbook
(c) different sheet in a different workbook
(d) all of them
Ans. d
55. In MS Excel, the common type of data applicable to any cell is called _____ data type.
(a) General
(b) Number
(c) Currency
(d) Text
Ans. a
56. In MS Excel, the data type suitable for handling numbers is called _______data type.
(a) General
(b) Number
(c) Currency
(d) Text
Ans. b
57. In MS Excel, number data type can control the ________.
(a) digit grouping
(b) number of decimal places
(c) both a & b
(d) neither a nor b
Ans. c P a g e | 436
58. In MS Excel, numbers can be grouped and prefixed with a currency symbol using _____ data type.
(a) Accounting
(b) Currency
(c) both a & b
(d) neither a nor b
Ans. c
59. In MS Excel, ______data type is suitable for handling dates.
(a) Date
(b) Time
(c) Percentage
(d) Fraction
Ans. a
60. In MS Excel, _______data type is suitable for handling time values.
(a) Date
(b) Time
(c) Percentage
(d) Fraction
Ans. b
61. In MS Excel, _______ data type takes values between 0 and 1 and displays them in percentage format.
(a) Date
(b) Time
(c) Percentage
(d) Fraction
Ans. c
62. In MS Excel,_______ data type displays decimal fractions as vulgar or mixed fractions.
(a) Date
(b) Time
(c) Percentage
(d) Fraction
Ans. d
63. In MS Excel, ______data type displays numbers in scientific notation.
(a) Scientific
(b) Text
(c) Custom
(d) Date
Ans. a
64. In MS Excel, _____data type is suitable for names and other character sequences.
(a) Scientific
(b) Text
(c) Custom
(d) Date
Ans. b
65. In MS Excel, _____data type supports formatting of numbers with suitable customization.
(a) Scientific
(b) Text
(c) Custom
(d) Date
Ans. c
66. In MS Excel, for the number 45453453 to be displayed as 4,54,53,453.0, the custom format could be________ .
(a) ##,##,##,##0.0
(b) ###,###,##0.0
(c) ########0.0
(d) ##,##,##,###.#
Ans. a
67. In custom formatting of numbers, an optional digit is denoted by ________symbol.
(a) 0
(b) #
(c) $
(d) ^
Ans. b
68. Long text can be broken down into many lines within a cell. You can do this through
a) wrap text in format >> cells
b) justify in edit >> cells
c) Text wrapping in format >> cells, layout tab
d) All of these
Ans. a P a g e | 437
69. When copying and pasting an excel formula, the method which permits formula to progressively update cell references is called ______ referencing system.
(a) static
(b) semi-relative
(c) relative
(d) none of them
Ans. c
71. When copying and pasting an excel formula, the method which keeps references to a particular cell address is called ______ referencing system.
(a) static
(b) semi-relative
(c) relative
(d) none of them
Ans. a
72. The formula = A5 * 5 is written in ______system.
(a) static
(b) semi-relative
(c) relative
(d) none of them
Ans. c
73. The formula = A5 * 5, when copied to the next row of the same column, will become _______ system.
(a) = A4 * 5
(b) = B5 * 5
(c) = A7 * 5
(d) = A6 * 5
Ans. d
74. In MS Excel, _______ functions help to access databases stored in spreadsheets.
(a) Cube/ Database
(b) Date/ Time
(c) Engineering
(d) Financial
Ans. a
75. You can auto fit the width column by
a) double clicking on the column name on column header
b) double click on the cell pointer in worksheet
c) double clicking on column right border on column header
d) double clicking on the column left boarder of column header
Ans. c
76. _______ functions help to access base conversion, logarithmic and other Engineering features in MS Excel.
(a) Cube/ Database
(b) Date/ Time
(c) Engineering (d) Financial
Ans. c
77. In MS Excel, ______functions help to access interest calculation, accounting and currency related calculations.
(a) Cube/ Database
(b) Date/ Time
(c) Engineering
(d) Financial
Ans. d
78. In MS Excel, ______functions help to check the status of cells, as to whether the cell is blank, contains a number, text, type of data, etc.
(a) Information
(b) Logical
(c) Lookup & reference
(d) Math & Trigonometric
Ans. a
79. In MS Excel, _______ functions help to make logical functions like AND, OR, NOT, etc.
(a) Information
(b) Logical
(c) Lookup & reference
(d) Math & Trigonometric
Ans. b
80. In MS Excel, ______functions help to make lookup in other sheets and references
. (a) Information
(b) Logical
(c) Lookup & reference
(d) Math & Trigonometric
Ans. c
81. In MS Excel, mathematical functions like round, absolute, ceiling, floor, etc. and trigonometric functions like sin, cos, tan, asin, acos, atan, etc are containing the category of _______.
(a) Information
(b) Logical
(c) Lookup & reference
(d) Math & Trigonometric
Ans. d
82. In MS Excel, statistical functions like average, standard deviation, median, mode, etc. can be accessed under the category ________ .
(a) Logical
(b) Lookup & reference
(c) Math & Trigonometric
(d) Statistical
Ans. d
83. In MS Excel, functions for length of text, text search, text concatenation, upper, lower and proper, etc. can be accessed under the category _______
(a) Text
(b) Logical
(c) Lookup & reference
(d) Math & Trigonometric
Ans. a
84. _______ function in MS Excel takes year, month and date values and displays given date.
(a) DATE
(b) DATEDIF
(c) DATEVALUE
(d) DAY
Ans. a
85. _______ function in MS Excel takes a date value and returns the day of month.
(a) DATE
(b) DATEDIF
(c) DATEVALUE
(d) DAY
Ans. d
86. _____function in MS Excel takes 2 date values and calculates the difference between the dates in years ("Y"), months ("M") or days ("D").
(a) DATE
(b) DATEDIF
(c) DATEVALUE
(d) DAY
Ans. b
87. _____ function in MS Excel takes a date string and returns parsed date value.
(a) DATE
(b) DATEDIF
(c) DATEVALUE
(d) DAY
Ans. c
88. ______function in MS Excel returns number of days between given dates.
(a) DAYS/ DAYS360
(b) EDATE
(c) EOMONTH
(d) HOUR
Ans. a
89. What happens when you press Ctrl + X after selecting some cells in Excel?
a) The cell content of selected cells disappear from cell and stored in clipboard
b) The cells selected are marked for cutting
c) The selected cells are deleted and the cells are shifted left
d) The selected cells are deleted and cells are shifted up
Ans. b
90. Which command will you choose to convert a column of data into row?
a) Cut and Paste
b) Edit >> Paste Special>> Transpose
c) Both A and B
d) None of these
Ans. b
91. _______ function in MS Excel returns the hour represented by the given time.
(a) DAYS/ DAYS360
(b) EDATE
(c) EOMONTH
(d) HOUR
Ans. d
92. ______function in MS Excel returns minutes from a time value.
(a) MINUTES
(b) SECOND
(c) EOMONTH
(d) HOUR
Ans. a
93. ______ function in MS Excel returns seconds from a time value.
(a) MINUTES
(b) SECOND
(c) EOMONTH
(d) HOUR
Ans. b
95. ______function in MS Excel returns current date.
(a) MINUTES
(b) SECOND
(c) NOW
(d) TODAY
Ans. d
96. _____function in MS Excel returns day of week for given date.
(a) WEEKDAY
(b) WORKDAY
(c) YEAR
(d) YEARFRAC
Ans. a
97. _______ function in MS Excel returns the date after given number of working days.
(a) WEEKDAY
(b) WORKDAY
(c) YEAR
(d) YEARFRAC
Ans. b
98. Where can you change automatic or manual calculation mode in Excel?
a) Double CAL indicator on status bar
b) Go to Tools >> Options >> Calculation and mark the corresponding radio button
c) Both of above
d) None of these
Ans. b
99. ______function in MS Excel returns fractional year between given dates.
(a) WEEKDAY
(b) WORKDA
(c) YEAR
(d) YEARFRAC
Ans. d
100. In MS Excel, _______function converts a binary number to decimal number.
(a) BIN2DEC
(b) BIN2HEX
(c) BIN2OCT
(d) BITAND
Ans. a
101. In MS Excel, _______function converts a binary number to hexadecimal number.
(a) BIN2DEC
(b) BIN2HEX
(c) BIN2OCT
(d) BITAND
Ans. b
102. In MS Excel, ______function converts a binary number to octal number.
(a) BIN2DEC
(b) BIN2HEX
(c) BIN2OCT
(d) BITAND
Ans. c
103. In MS Excel, _______function performs bitwise AND operation.
(a) BIN2DEC
(b) BIN2HEX
(c) BIN2OCT
(d) BITAND
Ans. d
104. In MS Excel, ______function performs bitwise OR operation.
(a) BITOR
(b) BITSHIFT
c) BITXOR
(d) BITAND
Ans. a
105. In MS Excel, function performs bitwise right shift operation.
(a) BITOR
(b) BITSHIFT
(c) BITXOR
(d) BITAND
Ans. b
106. In MS Excel,_______ function performs bitwise XOR operation.
(a) BITOR
(b) BITSHIFT
(c) BITXOR
(d) BITAND
Ans. c
107. In MS Excel, ________ function converts decimal number to binary number.
(a) COVNERT
(b) DEC2BIN
(c) DEC2HEX
(d) DEC2OCT
Ans. b
108. In MS Excel, _______function converts decimal number to hexadecimal number.
(a) COVNERT
(b) DEC2BIN
(c) DEC2HEX
(d) DEC2OCT
Ans. c
109. In MS Excel, _______function converts decimal number to octal number.
(a) COVNERT
(b) DEC2BIN
(c) DEC2HEX
(d) DEC2OCT
Ans. d
110. In MS Excel, _______ function returns 1 if given values are equal.
(a) DELTA
(b) DEC2BIN
(c) DEC2HEX
(d) DEC2OCT
Ans. a
111. In MS Excel, _______ function converts hexadecimal number to binary number.
(a) DELTA
(b) HEX2BIN
(c) HEX2DEC
(d) HEX2OCT
Ans. b
112. In MS Excel, ______ function converts hexadecimal number to decimal number.
(a) DELTA
(b) HEX2BIN
(c) HEX2DEC
(d) HEX2OCT
Ans. c
113. In MS Excel, ______function converts hexadecimal number to octal number.
(a) DELTA
(b) HEX2BIN
(c) HEX2DEC
(d) HEX2OCT
Ans. d
114. In MS Excel, ______ function returns true if a cell is blank.
(a) ISBLANK
(b) ISERR
(c) ISEVEN
(d) ISODD
Ans. a
115. In MS Excel, ______function returns true if there is an error in the formula contained in given cell.
(a) ISBLANK
(b) ISERR
(c) ISEVEN
(d) ISODD
Ans. b
116. In MS Excel, ______function returns true if the given cell contains an even number.
(a) ISBLANK
(b) ISERR
(c) ISEVEN
(d) ISODD
Ans. c
117. In MS Excel, ________function returns true if the given cell contains an odd number.
(a) ISBLANK
(b) ISERR
(c) ISEVEN
(d) ISODD
Ans. d
118. In MS Excel, ______function returns true if the given cell contains a formula.
(a) ISFORMULA
(b) ISERR
(c) ISEVEN
(d) ISODD
Ans. a
119. In MS Excel, _______function returns true if the given cell a logical value (TRUE or FALSE).
(a) ISNUMBER
(b) ISNONTEXT
(c) ISNA
(d) ISLOGICAL
Ans. d
120. In MS Excel, ______ function returns true if the given cell contains a number.
(a) ISNUMBER
(b) ISNONTEXT
(c) ISNA
(d) ISLOGICAL
Ans. a
121. In MS Excel, ______ function returns true if the given cell contains Logical value (TRUE or FALSE).
(a) ISNUMBER
(b) ISNONTEXT
(c) ISNA
(d) ISLOGICAL
Ans. d
122. In MS Excel, _______function returns true if the given cell contains a value other than text (number, logical, etc.).
(a) ISNUMBER
(b) ISNONTEXT
(c) ISNA
(d) ISLOGICAL
Ans. b
123. In MS Excel, _______function returns true if #NA error has occurred.
(a) ISNUMBER
(b) ISNONTEXT
(c) ISNA
(d) ISLOGICAL
Ans. c
124. In MS Excel, _______ function returns number equivalent of text value.
(a) N
(b) NA
(c) TYPE
(d) AND
Ans. a
126. In MS Excel, _______function returns a number corresponding to the data type of the cell.
(a) N
(b) NA
(c) TYPE
(d) AND
Ans. c
127. In MS Excel, ________function returns true only if all the given conditions are true.
(a) OR
(b) FALSE
(c) TRUE
(d) AND
Ans. d
128. In MS Excel, ________function returns true even if just one of the given conditions is true.
(a) OR
(b) FALSE
(c) TRUE
(d) AND
Ans. a
129. In MS Excel, ______function tests the condition given in the first part, executes second part if the condition is true or executes third part if the condition is false.
(a) OR
(b) IF
(c) TRUE
(d) AND
Ans. b
130. In MS Excel, ________function returns positive value irrespective of whether the input is positive or negative.
(a) ABS
(b) ASIN
(c) ACOS
(d) ATAN
Ans. a
131. In MS Excel, ______ function returns aggregate value like count, sum, average, etc.
(a) ARABIC
(b) ASINH
(c) ATANH
(d) AGGREGATE
Ans. d
132. In MS Excel, ______function returns hyperbolic sin value.
(a) ACOSH
(b) ASINH
(c) ATANH
(d) AGGREGATE
Ans. b
133. In MS Excel, ______function returns hyperbolic cosine value.
(a) ACOSH
(b) ASINH
(c) ATANH
(d) AGGREGATE
Ans. a
134. In MS Excel, ______function returns hyperbolic tan value.
(a) ACOSH
(b) ASINH
(c) ATANH
(d) AGGREGATE
Ans. c
135. In MS Excel, ________function returns the integer just above a fractional number.
(a) CEILING
(b) FLOOR
(c) ROUND
(d) ROUNDDOWN
Ans. a
136. In MS Excel, ______function returns the integer just below a fractional number.
(a) CEILING
(b) FLOOR
(c) ROUND
(d) ROUNDDOWN
Ans. b
137. In MS Excel, ______function returns the number rounded to the given digits.
(a) CEILING
(b) FLOOR
(c) ROUND
(d) ROUNDDOWN
Ans. c
138. In MS Excel, _____function returns the number rounded DOWN to the given digits, simply discarding the trailing value even if it is greater than or equal to 5.
(a) CEILING
(b) FLOOR
(c) ROUND
(d) ROUNDDOWN
Ans. d
139. In MS Excel, ______function returns the number rounded UP to the given digits, simply discarding the trailing value even if it is greater than or equal to 5.
(a) ROUNDUP
(b) FLOOR
(c) ROUND
(d) ROUNDDOWN
Ans. a
140. In MS Excel, ______function converts given angle from radian to degrees.
(a) DEGREES
b) RADIANS
(c) EVEN
(d) ODD Ans. a
141. In MS Excel, ______function converts given angle from degrees to radians.
(a) DEGREES
(b) RADIANS
(c) EVEN
(d) ODD
Ans. b
142. In MS Excel, ______ function returns the nearest even number.
(a) DEGREES
(b) RADIANS
(c) EVEN
(d) ODD
Ans. c
143. In MS Excel, ______function returns the nearest odd number.
(a) DEGREES
(b) RADIANS
(c) EVEN
(d) ODD
Ans. d
144. In MS Excel, _____function returns the exponential value for given number.
(a) EXP
(b) LN
(c) LOG/ LOG10
(d) FACT
Ans. a
145. In MS Excel, _______function returns the natural logarithm for given number.
(a) EXP
(b) LN
(c) LOG/ LOG10
(d) FACT
Ans. b
146. In MS Excel, _____function returns the common logarithm (to the base 10) for given number.
(a) EXP
(b) LN
(c) LOG/ LOG10
(d) FACT
Ans. c
147. In MS Excel, _______function returns the factorial of given number in integer format.
(a) FACTDOUBLE
(b) LN (
c) LOG/ LOG10
(d) FACT
Ans. d
148. In MS Excel, ______function returns the factorial of given number in double number format.
(a) FACTDOUBLE
(b) LN
(c) LOG/ LOG10
(d) FACT
Ans. a
149. In MS Excel, ______function returns the greatest common divisor for given numbers.
(a) FACTDOUBLE
(b) GCD
(c) LCM
(d) INT
Ans. b
150. In MS Excel, _____ function returns the least common multiple for given numbers.
(a) FACTDOUBLE
(b) GCD
(c) LCM
(d) INT
Ans. c
151. In MS Excel, ______function returns the integer equivalent of given number, after discarding fractional parts.
(a) FACTDOUBLE
(b) GCD
(c) LCM
(d) INT
Ans. d
152. In MS Excel, _____function returns the determinant of given matrix.
(a) MDTERM
(b) MINVERSE
(c) MMUL
(d) MOD
Ans. a
153. In MS Excel, ______function returns the module remainder for given number and divisor.
(a) QUOTIENT
(b) MINVERSE
(c) MMUL
(d) MOD
Ans. d
154. In MS Excel, _______function returns the quotient for given number and divisor.
(a) QUOTIENT
(b) MINVERSE
(c) MMUL
(d) MOD
Ans. a
155. In MS Excel, _____function returns the number rounded to the nearest multiple of the second argument
. (a) PI
(b) POWER
(c) MROUND
(d) RAND
Ans. c
156. In MS Excel, ______function returns the power of given number raised by second argument.
(a) PI
(b) POWER
(c) MROUND
(d) RAND
Ans. b
157. In MS Excel, ______function returns a random number.
(a) PI
(b) POWER
(c) MROUND
(d) RAND
Ans. d
158. In MS Excel, ___function returns a random number between given lower limit and upper limit.
(a) PI
(b) POWER
(c) MROUND
(d) RANDBETWEEN
Ans. d
159. In MS Excel, ______function converts a number from Roman numeral to Arabic numeral.
(a) ROMAN
(b) ARABIC
(c) SIGN
(d) SQRT
Ans. b
160. In MS Excel, _______function converts a number from Arabic numeral to Roman numeral.
(a) ROMAN
(b) ARABIC
(c) SIGN
(d) SQRT
Ans. a
161. In MS Excel, ______ function returns the square root of the given number.
(a) ROMAN
(b) ARABIC
(c) SIGN
(d) SQRT
Ans. d
162. In MS Excel, ______function returns the subtotal of given numbers.
(a) SUBTOTAL
(b) SUM
(c) SUMIF
(d) SUMSQ
Ans. a
163. In MS Excel, ______function returns the sum of given numbers.
(a) SUBTOTAL
(b) SUM
(c) SUMIF
(d) SUMSQ
Ans. b
164. In MS Excel, _____function returns the sum of squares of given numbers.
(a) SUBTOTAL
(b) SUM
(c) SUMIF
(d) SUMSQ
Ans. d
165. In MS Excel, _____function returns the sum of those numbers that fulfill given condition.
(a) SUBTOTAL
(b) SUM
(c) SUMIF
d) SUMSQ
Ans. c
166. In MS Excel, _____function truncates decimal digits of given real number to produce an integer value.
(a) TRUNC
(b) SUM
(c) SUMIF
d) SUMSQ
Ans. a
167. In MS Excel, ______ function calculates the average absolute (unsigned) deviation.
(a) AVERAGE
(b) AVEDEV
(c) AVERAGEIFS
(d) CORREL
Ans. b
168. In MS Excel, ______function calculates the average of given numbers.
(a) AVERAGE
(b) AVEDEV
(c) AVERAGEIFS
(d) CORREL
Ans. a
169. In MS Excel, _______ function calculates the average of given numbers which fulfill the given conditions.
(a) AVERAGE
(b) AVEDEV
(c) AVERAGEIFS
(d) CORREL
Ans. c
170. In MS Excel, _______ function calculates the coefficient of correlation.
(a) AVERAGE
(b) AVEDEV
(c) AVERAGEIFS
(d) CORREL
Ans. d
171. In MS Excel, _______function counts the number of objects.
(a) COUNT
(b) DEVSQ
(c) FORECAST
(d) COUNTBLANK
Ans. a
172. In MS Excel, ______function counts the number of blank cells.
(a) COUNT
(b) DEVSQ
(c) FORECAST
(d) COUNTBLANK
Ans. d
173. In MS Excel, ______function returns the sum of squares of deviations.
(a) COUNT
(b) DEVSQ
(c) FORECAST
d) COUNTBLANK
Ans. b
174. In MS Excel, ______function counts the items based on given condition.
(a) COUNT
(b) DEVSQ
(c) FORECAST
(d) COUNTIF
Ans. d
175. In MS Excel, ______function counts the items based on given conditions.
(a) COUNT
(b) DEVSQ
(c) FORECAST
(d) COUNTIFS
Ans. d
176. In MS Excel, ______function provides a linear estimate of the result expected for given input.
(a) COUNT
(b) DEVSQ
(c) FORECAST
(d) COUNTIFS
Ans. c
177. In MS Excel, _______function provides an exponential estimate of the result expected for given input.
(a) GROWTH
(b) GEOMEAN
(c) LARGE
(d) MEDIAN
Ans. a
178. In MS Excel, ______function returns the median value of a list.
(a) GROWTH
(b) GEOMEAN
(c) LARGE
(d) MEDIAN
Ans. d
179. In MS Excel, ______function returns geometric mean.
(a) GROWTH
(b) GEOMEA
(c) LARGE
(d) MEDIAN
Ans. b
180. In MS Excel, ______function returns the inverse of given matrix.
(a) MDTERM
(b) MINVERSE
(c) MMUL
(d) MOD
Ans. b
181. In MS Excel, ______function returns the multiplication result of given matrix.
(a) MDTERM
(b) MINVERSE
(c) MMUL
(d) MOD
Ans. c
182. In MS Excel, ______function returns result of permutations.
(a) MAX
(b) MIN
(c) PERMUT
(d) RANK
Ans. c
183. In MS Excel, _______function returns the rank of given number when compared to a list of numbers.
(a) MAX
(b) MIN
(c) PERMUT
(d) RANK
Ans. d
184. In MS Excel, _______ function returns the nth smallest value from a sorted list.
(a) MAX
(b) SMALL
(c) PERMUT
(d) RANK
Ans. b
185. In MS Excel, ______function returns the standard deviation of given numbers.
(a) MAX
(b) SMALL
(c) PERMUT
(d) STDEV
Ans. d
186. In MS Excel, _______function returns the character equivalent of numeric ASCII value.
(a) CHAR
(b) CODE
(c) DOLLAR
(d) CONCATENATE
Ans. a
187. In MS Excel, ______function returns the ASCII code for given character value.
(a) CHAR
(b) CODE
(c) DOLLAR
(d) CONCATENATE
Ans. b
188. You want to set such that when you type Baishakh and drag the fill handle, Excel should produce jestha, Aashadh and so on. What will you set to effect that?
a) custom list
b) Auto fill Options
c) Fill Across Worksheet
d) Fill series
Ans. a
189. In MS Excel, ______function formats a number as currency and prefixes the currency symbol of the locale.
(a) CHAR
(b) CODE
(c) DOLLAR
(d) CONCATENATE
Ans. c
190. In MS Excel, ______function appends several strings one after the other.
(a) CHAR
(b) CODE
(c) DOLLAR
(d) CONCATENATE
Ans. d
191. The name box on to the left of formula bar
a) shows the name of workbook currently working on
b) shows the name of worksheet currently working on
c) shows the name of cell or range currently working on
d) None of these
Ans. c
192. Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?
a) worksheet
b) chart sheet
c) module sheet
d) data sheet
Ans. d
193. In MS Excel, _______function formats given number based on rules provided using # and 0 characters.
(a) FORMAT
(b) LEFT
(c) EXACT
(d) FIND
Ans. a
194. In MS Excel, ______function returns the leftmost character of a string.
(a) FORMAT
(b) LEFT
(c) EXACT
(d) RIGHT
Ans. b
195. In MS Excel,______ function returns the rightmost character of a string.
(a) FORMAT
(b) LEFT
(c) EXACT
(d) RIGHT
Ans. d
196. In MS Excel, ______function returns the length of given string.
(a) LOWER
(b) UPPER
(c) PROPER
(d) LEN
Ans. d
197. In MS Excel, ______function returns the lower case version of given string.
(a) LOWER
(b) UPPER
(c) PROPER
(d) LEN
Ans. a
198. In MS Excel, ______function returns the upper case version of given string.
(a) LOWER
(b) UPPER
(c) PROPER
(d) LEN
Ans. b
199. In MS Excel, ______ function returns the first letter capitalized version of given string.
(a) LOWER
(b) UPPER
(c) PROPER
(d) LEN
Ans. c
200. In MS Excel, ______function returns a string after replacing given characters of first string using the last string.
(a) SEARCH
(b) REPLACE
(c) REPT
(d) LOWER
Ans. b
201. In MS Excel,______ function repeats a string for given number of times.
(a) SEARCH
(b) REPLACE
c) REPT
(d) LOWER
Ans. c
202. In MS Excel, ______function returns the location of the first string occurring inside the second string.
(a) SEARCH
(b) REPLACE
(c) REPT
(d) LOWER
Ans. a
203. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply
a) Use =if() function to format the required numbers red
b) Apply conditional Formatting command on Format menu
c) Select the cells that contain number between 0 and 100 then click Red color on Text Color tool
d) All of these
Ans. b
204. Which tool you will use to join some cells and place the content at the middle of joined cell?
a) From Format Cells dialog box click on Merge Cells check box
b) From Format Cells dialog box select the Centered alignment
c) From Format Cells dialog box choose Merge and Centre check box
d) Click on Merge and center tool on formatting toolbar
Ans. d
205. In MS Excel, ______function substitutes new text in place of given old text.
(a) T (b) TEXT
(c) SUBSTITTE
(d) TRIM
Ans. c
206. In MS Excel, _____function removes space at the beginning or end of a string.
(a) T
(b) TEXT
(c) SUBSTITTE
(d) TRIM
Ans. d
207. In MS Excel, _____function converts given text to number.
(a) T
(b) VALUE
c) SUBSTITTE
(d) TRIM
Ans. b
208. Data can be sorted using _____ menu in MS Excel.
(a) Data>Filter
(b) Data>Sort
(c) Data>What if analysis>Data table
(d) Data>What if analysis>Pivot table
Ans. b
209. To sort data in MS Excel, _______containing data for sorting should be selected.
(a) all the cells
(b) just the column
(c) just one row
(d) only one cell
Ans. a
210. The sort dialog in MS Excel contains a tick box named ______ to select whether the data contains a header row or not.
(a) My data contains footers
(b) My data contains errors
(c) My data contains pictures
(d) My data contains headers
Ans. d
211. The sorting dialog in MS Excel contains ______boxes to choose sorting criteria.
(a) column name to be used for sorting
(b) whether to sort by value, color or icon
(c) whether to sort ascending or descending
(d) all of them
Ans. d
212. In MS Excel, if the sorting requires several levels of criteria, the same can be added using ________ button in sorting dialog.
(a) Add level
(b) add row
(c) add column
(d) add filter
Ans. a
213. Data can be filtered using _____ menu in MS Excel.
(a) Data>Filter
(b) Data>Sort
(c) Data>What if analysis>Data table
(d) Data>What if analysis>Pivot table
Ans. a
214. For applying filtering, the data should contain ______.
(a) no header row
(b) header row
(c) footer row
(d) pivot table
Ans. b
215. You can set Page Border in Excel from
a) From Border tab in Format Cells dialog box
b) From Border tool in Formatting toolbarr
c) From Line style tool in Drawing toolbar
d) You can not set page boarder in Excel
Ans. d
216. The triangular filter button at header row of data helps sorting of data using _____.
(a) ascending/descending order
(b) color
(c) search specific values or applying filter conditions for numbers
(d) all of them
Ans. d
217. After selecting the cells to be subjected to data validation, choose_____ from the menu to validate data in MS Excel.
(a) Data>Filter
(b) Data>Sort
(c) Data>Validation
(d) Data>What if analysis>Pivot table
Ans. c
218. In MS Excel, permitting data values in specific range for entry in a cell is called _____of data.
(a) validation
(b) sorting
(c) filtering
(d) chart
Ans. a
219. The data validation dialog shows, allow criterion with______ conditions.
(a) between/ not between
(b) equal to/ not equal to
(c) >; <;_;_ (d) all of them
Ans. d
220. In MS Excel, data violating the validation rule may be_______ using Data>Validation>Circle invalid data.
(a) encircled
(b) deleted
(c) sorted
(d) coloured
Ans. a
221. In MS Excel, to display a specific error message for invalid data entry, _____tab in validation dialog can be opened to set a custom message.
(a) Error display
(b) Input message
(c) Output message
(d) Result message
Ans. a
222. MS Excel supports _____ type chart.
(a) column/ bar
(b) pie/ area/ stock/ surface/ doughnut/ bubble/ radar
(c) scatter/ line
(d) all of them
Ans. d
223. The data used for charting should have_____ to decide the graph parameters like axis name.
(a) header row
(b) footer row
(c) blank row
(d) blank column
Ans. a
224. In MS Excel, pie chart may be inserted using_____ menu.
(a) Insert>Pie
(b) Insert>Column
(c) Insert>Bar
(d) Insert>line
Ans. a
225. In MS Excel, bar chart may be inserted using _____menu.
(a) Insert>Pie
(b) Insert>Column
(c) Insert>Bar
(d) Insert>line
Ans. c
226. In MS Excel, column chart may be inserted using _____menu.
(a) Insert>Pie
(b) Insert>Column
(c) Insert>Bar
(d) Insert>line
Ans. b
227. In MS Excel, line chart may be inserted using _____menu.
(a) Insert>Pie
(b) Insert>Column
(c) Insert>Bar
(d) Insert>line
Ans. d
228. In MS Excel, scatter chart may be inserted using_____ menu.
(a) Insert>Pie
(b) Insert>Column
(c) Insert>Bar
(d) Insert>X-Y scatter
Ans. d
229. In MS Excel, charts may be customized by _______ on appropriate element of the graph.
(a) selecting
(b) right clicking
(c) both a & b
(d) none of them
Ans. c
230. Which of the following methods can not be used to enter data in a cell?
a. Pressing an arrow key
b. Pressing the tab key
c. Pressing the Esc key
d. Clicking the enter button to the formula bar Correct
Answer: c
. 231. Which of the following methods cannot be used to edit the content of cell?
a. Pressing the Alt key
b. Clicking the formula bar
c. Pressing F2 d. Double clicking the cell Correct
Answer: a
232. What type of charts is useful for comparing values over categories?
a) Pie chart
b) Column chart
c) Line chart
d) Dot chart
Ans. b
233. A Feature that displays only the data in column according to specified criteria
a) Formula
b) Sorting
c) Filtering
d) Pivot
Ans. c
234. Statistical calculations and preparation of tables and graphs can be done using
a) Adobe Photoshop
b) Excel
c) Notepad
d) Wordpad
Ans. b
235. In MS Excel, data meant for pivot table may be converted to a table using first.
(a) Insert>Table
(b) Insert>Pie
(c) Insert>Column
(d) Insert>Scatter
Ans. a
236. In MS Excel, pivot table may be inserted using ______ first.
(a) Insert>Table
(b) Insert>Pivot>Pivot table
(c) Insert>Pivot>Pivot chart
(d) Insert>Scatter
Ans. b
237. In MS Excel, pivot chart may be inserted using first.
(a) Insert>Table
(b) Insert>Pivot>Pivot table
(c) Insert>Pivot>Pivot chart
(d) Insert>Scatter
Ans. c
238. After selecting the cells to be subjected to data validation, choose ______ from the menu to apply goal seek in MS Excel.
(a) Data>Filter
(b) Data>What if analysis>Data table
(c) Data>What if analysis>Goal seek
(d) Data>What if analysis>Pivot table
Ans. c
239. In MS Excel, adjusting an input value to get specific result is called _______ .
(a) goal seek
(b) charting
(c) sorting
(d) validation
Ans. a
240. In MS Excel, after choosing Data>What if analysis>Goal seek from the menu, a dialog appears to take _______values.
(a) desired result
(b) input cell in which values are to changed
(c) both a & b
(d) none of them
Ans. c
241. After selecting the cells to be subjected to data validation, choose from the menu to apply scenario in MS Excel.
(a) Data>Filter
(b) Data>What if analysis>Data table
(c) Data>What if analysis>Goal seek
(d) Data>What if analysis>Scenario
Ans. d
242. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?
a. Point to speech on the tools menu, and then click show text to speech toolbar.
b. Click validation on the data menu
c. Point to speech on the tools menu, and then click speech recognition
d. All of above Correct
Answer: a
243. Each scenario created using MS Excel may contain______ .
(a) a title
(b) a selection of cells which are affected by that scenario
(c) both a & b
(d) none of them
Ans. c
244. How should you print a selected area of a worksheet, if you‟ll want to print a different area next time?
a. On the file menu, point to print area, and then click set print area.
b. On the file menu, click print, and then click selection under print what
c. On the view menu, click custom views, then click add
d. All of above Correct
Answer: b
245. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result
a. IF
b. AND
c. OR
d. NOT
Ans: a
246. Macros are “run” or executed from the ….. menu
. a. Insert
b. Format
c. Tools
d. Data Correct
Answer: c
247. You can open the consolidate dialog box by choosing Consolidate from the ….. menu.
a. Insert
b. Format
c. Tools d. Data Correct
Answer: d
248. Each excel file is called a workbook because
a. It can contain text and data
b. It can be modified
c. It can contain many sheets including worksheets and chart sheets
d. You have to work hard to create it Correct
Answer: c
249. Which types of charts can excel produce?
a. Line graphs and pie charts only
b. Only line graphs c. Bar charts, line graphs and pie charts
d. Bar charts and line graphs only Correct
Answer: c
250. Gridlines
a. May be turned off for display but turned on for printing
b. May be turned on or off for printing
c. The be turned off for display and printing
d. a, b and c Correct
Answer: d
No comments:
Post a Comment