EXCEL MCQ

Soopro Pathshala provides EXCEL MCQ(Multiple Choice Questions)

1. Excel is a ____ program developed by Microsoft.

a) Spreadsheet

b) Document

c) Data Management

d) all of the above

View Answer

2. What is the extension of a Microsoft Excel File?

a) .msxcl

b) .xcl

c) .xlsx

d) .xlsm

View Answer

3. Which logical function returns true if all arguments evaulate true; false if not?

a) or

b) and

c) if

d) andif

View Answer

4. Which programming langauge is used to write a macro in MS Excel?

a) c

b) c++

c) java

d) visual basic

View Answer

5. Which function is used to remove extra spaces from the text in MS Excel?

a) Remove()

b) TRIM()

c) TRUNC()

d) all of the above

View Answer

6. The____function is used to convert to text in a number format in MS Excel?

a) CONVERT()

b) TEXT()

c) NUM()

d) CONVERTTEXT()

View Answer

7. ___Returns the least common multiple?

a) LCCM()

b) LCM()

c) TLCM()

d) RTLCM()

View Answer

8. Excel documents are stored as files called

a) workgroups

b) worktables

c) worksheets

d) workforce

View Answer

9. How do you display current date only in MS Excel?

a) DATE()

b) TODAY()

c) NOW()

d) TIME()

View Answer

10. MS Excel is based on_____

a) Windows

b) DOS

c) UNIX

d) OS/2

View Answer

11. _____include the Quick Access Toolbar, Ribbon, Name Box, Formula Quick Menu, Formula Bar, Status Bar, Worksheet, worksheet etc.

a) Excel Interface

b) Cell

c) Row

d) Column

View Answer

12. The intersection point of a row and column is referred to as a ____.

a) Excel Interface

b) Cell

c) Row

d) Column

View Answer

13. A ____ is a horizontal space in a table used to record data.

a) Excel Interface

b) Cell

c) Row

d) Column

View Answer

14. A column is a vertical space in a table used to record data.

a) Excel Interface

b) Cell

c) Row

d) Column

View Answer

15. An Excel _____ refers to the area of rows and columns, which jointly from a table.

a) Worksheet

b) Cell

c) Row

d) Column

View Answer

16. An Excel ____ refers to the main file that includes worksheet's and related objects.

a) Worksheet

b) Workbook

c) Row

d) Column

View Answer

17. _______is the set of coordinates where a cell is located.

a) Worksheet

b) Cell Reference

c) Row

d) Column

View Answer

18. _______ is currently selected cell, outlined by a green box.

a) Worksheet

b) Cell Reference

c) Row

d) Active Cell

View Answer

19. _______ are mathematical equations, cell references or functions that can be placed inside a cell to produce a value.

a) Worksheet

b) Formulas

c) Row

d) Active Cell

View Answer

20. _______ is the long input bar that is used to enter values or formulas in cells. It is located at the top of the worksheet.

a) Worksheet

b) Formulas

c) Formula Bar

d) Active Cell

View Answer

21. _______ located to the left of the formula bar shows the number and letter coordinates of an active cell.

a) Worksheet

b) Formulas

c) Formula Bar

d) Address Bar

View Answer

22. _______ are rules user can employ to select what rows in a worksheet to display.

a) Filter

b) Formulas

c) Formula Bar

d) Address Bar

View Answer

23. Which feature enables users to copy data to more than one cell automatically?

a) Autofill

b) Formulas

c) Formula Bar

d) Address Bar

View Answer

24. Which feature enables users to add multiple values?

a) Autofill

b) Autosum

c) Formula Bar

d) Address Bar

View Answer

25. _____ is the data summarization tool sorts and calculates data automatically.

a) Autofill

b) Autosum

c) Formula Bar

d) Pivot Table

View Answer

26. _____ is the information that is used to create Pivot Table..

a) Autofill

b) Autosum

c) Formula Bar

d) Source Data

View Answer

27. The ____ is usually situated on the top of the Excel. It consists of various shortcuts that we can give commands in Excel.

a) Ribbon

b) Autosum

c) Formula Bar

d) Source Data

View Answer

28. The _____ located on the ribbon is mainly used to access core commands such as creating a new document, saving an existing document taking prints etc.

a) Ribbon Start Button

b) Autosum

c) Formula Bar

d) Source Data

View Answer

29. The ____ are mainly used to group various commands in a small area.

a) Ribbon Start Button

b) Ribbon Tabs

c) Formula Bar

d) Source Data

View Answer

30. The ______ mainly consists of shortcuts for font sizes, font styles, font colors.

a) Home Tab

b) Insert Tab

c) Page layout Tab

d) Formulas Tab

View Answer

31. The ______ mainly consists of shortcuts for table formatting and styling, inserting pictures, figures, charts or graphs, header/footer options, equations or symbols.

a) Home Tab

b) Insert Tab

c) Page layout Tab

d) Formulas Tab

View Answer

32. The ____ mainly includes shortcuts for themes, page setup theme orientation etc.

a) Home Tab

b) Insert Tab

c) Page layout Tab

d) Formulas Tab

View Answer

33. The ____ contains options that help us insert formulas within the table and get the results.

a) Home Tab

b) Insert Tab

c) Page layout Tab

d) Formulas Tab

View Answer

34. The _____ contains shortcuts that help us insert external data from the web and filter options.

a) Data Tab

b) Insert Tab

c) Page layout Tab

d) Formulas Tab

View Answer

35. The _____ offers commands to do proof reading for the excel worksheets (such as spell check) Moreover, users can add comments using the options given under this tab.

a) Data Tab

b) Insert Tab

c) Page layout Tab

d) Review Tab

View Answer

35. The ____ comprises several options that allow us to view the excel sheets differently.

a) Data Tab

b) Insert Tab

c) View Tab

d) Review Tab

View Answer

36. Which function gives the total of the selected range of cell values?

a) SUM()

b) MIN()

c) MAX()

d) AVERAGE()

View Answer

37. The ______ function calculate the average of the selected range of cell values.

a) SUM()

b) MIN()

c) MAX()

d) AVERAGE()

View Answer

38. The ____ function finds the lowest number in the selected range of cell values.

a) SUM()

b) MIN()

c) MAX()

d) AVERAGE()

View Answer

39. The______ function finds the highest number in the selected range of cell values.

a) SUM()

b) MIN()

c) MAX()

d) AVERAGE()

View Answer

40. The _____ function counts the total number of cells in a range that contains a number.

a) SUM()

b) COUNT()

c) MAX()

d) AVERAGE()

View Answer

41. The ________ function returns the subtotal in a database.

a) SUM()

b) SUBTOTAL()

c) MAX()

d) AVERAGE()

View Answer

42. The _____ function works on returning the remainder when a particular number is divided by a divisor.

a) SUM()

b) SUBTOTAL()

c) MOD()

d) AVERAGE()

View Answer

43. The _____ function returns the result of a number raised to a certain power.

a) SUM()

b) SUBTOTAL()

c) MOD()

d) POWER()

View Answer

44. The ______ function rounds a number up to its nearest multiple of significance.

a) SUM()

b) SUBTOTAL()

c) CEILING()

d) POWER()

View Answer

45. The ______ function contrary to the ceiling function, the floor function rounds a number down to the nearest multiple of significance.

a) SUM()

b) FLOOR()

c) CEILING()

d) POWER()

View Answer

46. The _______function joins several text strings into one text string.

a) SUM()

b) FLOOR()

c) CONCATENATE()

d) POWER()

View Answer

47. The ______ function returns the total no. of characters in a string.

a) LEN()

b) FLOOR()

c) CONCATENATE()

d) POWER()

View Answer

48. The ____ function gives the number of characters from the start of a text string.

a) LEFT()

b) RIGHT()

c) MID()

d) None of These

View Answer

49. The ____ function returns the characters from the middle of a text

a) LEFT()

b) RIGHT()

c) MID()

d) None of These

View Answer

50. The _____function returns the numbers of characters from the end of a text string.

a) LEFT()

b) RIGHT()

c) MID()

d) None of These

View Answer

51. The ____ function converts any text string to UPPERCASE.

a) UPPER()

b) LEFT()

c) RIGHT()

d) None of These

View Answer

52. The ______ function converts any text string to lowercase.

a) UPPER()

b) LOWER()

c) RIGHT()

d) None of These

View Answer

53. The ____ function converts any text string to proper case i.e the first letter in each word will be in uppercase, and all the other will be in lowercase.

a) UPPER()

b) LOWER()

c) RIGHT()

d) PROPER()

View Answer

54. The ______ function works on replacing the part of a text string with a different text string.

a) UPPER()

b) LOWER()

c) RIGHT()

d) REPLACE()

View Answer

55. The ______ function replaces the existing text with a new text in a text string.

a) UPPER()

b) LOWER()

c) SUBSTITUE()

d) REPLACE()

View Answer

56. The ____ function in Excel gives the current system date and time.

a) UPPER()

b) LOWER()

c) SUBSTITUE()

d) NOW()

View Answer

57. The TODAY() function in excel provides the current system date.

a) UPPER()

b) LOWER()

c) TODAY()

d) NOW()

View Answer

58. Which function is used to return the day of the month.

a) UPPER()

b) DAY()

c) TODAY()

d) NOW()

View Answer

59. The _______ function returns the month, a number from 1 to 12, where 1 is January and 12 is December.

a) MONTH()

b) DAY()

c) TODAY()

d) NOW()

View Answer

60. The ____ function converts hours, minutes, seconds, given as numbers to an Excel serial no formatted with a time format.

a) MONTH()

b) DAY()

c) TODAY()

d) TIME()

View Answer

61. The ____ function generates the hour from a time value as a no from 0 to 23, Here 0 means 12 AM and 23 is 11 PM.

a) HOUR()

b) DAY()

c) TODAY()

d) TIME()

View Answer

62. The _____ function returns the minute from a time value as a number from 0 to 59.

a) MINUTE()

b) DAY()

c) TODAY()

d) TIME()

View Answer

63. The ______ function returns the second from a time value as a no from 0 to 59.

a) MINUTE()

b) DAY()

c) TODAY()

d) SECOND()

View Answer

64. The ____ function provides the difference between two dates in terms of years, months, or days.

a) DATEDIF()

b) DAY()

c) TODAY()

d) SECOND()

View Answer

65. The _______ function stands for the vertical lookup that is responsible for looking for a particular value in the left most column of a table.

a) DATEDIF()

b) DAY()

c) VLOOKUP()

d) SECOND()

View Answer

66. The function _____ looks for a value in the top of a table or array of benefits.

a) DATEDIF()

b) DAY()

c) VLOOKUP()

d) HLOOKUP()

View Answer

67. Which function checks a given condition and returns a particular value if it is TRUE?

a) IF()

b) DAY()

c) VLOOKUP()

d) HLOOKUP()

View Answer

68. The _____ function returns a value if an expression evaluates to an error, or else, it will return the value of the expression.

a) IF()

b) IFERROR()

c) VLOOKUP()

d) HLOOKUP()

View Answer

69. The function ______ is used to count the total number of cells within a range that meet the given condition.

a) IF()

b) COUNTIF()

c) VLOOKUP()

d) HLOOKUP()

View Answer

70. The ____function adds the cells specified by a given condition or criteria.

a) IF()

b) COUNTIF()

c) VLOOKUP()

d) SUMIF()

View Answer

71. _____function is used when you want to calculate the monthly payment you need to pay to settle the loan amount.

a) IF()

b) PMT()

c) VLOOKUP()

d) SUMIF()

View Answer

72. The _____ function in Excel returns the order of a numeric value compared to other values in the same list.

a) RANK()

b) PMT()

c) VLOOKUP()

d) SUMIF()

View Answer

73. The ____ function is used to check more than one logical condition at the same time up to 255, conditions supplied as arguments.

a) OR()

b) PMT()

c) VLOOKUP()

d) SUMIF()

View Answer

74. __ is not a valid data type in MS-Excel.

a) Number

b) Character

c) Label

d) Date/Time

View Answer

75. What is MS Excel?

a) Spreadsheet

b) Database management

c) Presentation

d) Workbook

View Answer

76. What is the row limit of MS Excel 2019?

a) 4,81,0576

b) 1,048,576

c) 1,57,648

d) 1,63, 84

View Answer

77. In Microsoft Excel spreadsheets, rows are designated as __

a) 1,2,3,....

b) A, B, C,...

c) A1, B1, C1....

d) I,II,III,....

View Answer

78. __ logical function indicates TRUE only if all arguments are assessed as TRUE, and FALSE otherwise.

a) OR

b) AND

c) IF

d) ANDIF

View Answer

79. The intersection of a column and a row in a worksheet is called_

a) Column

b) Address

c) Value

d) Cell

View Answer

80. The Greater Than sign (>) exemplifies a/an _____ operator.

a) Arithmetic

b) Conditional

c) Logical

d) Greater

View Answer

81. ___ type of chart is good for a single series of data.

a) Column Chart

b) Cone chart

c) Line chart

d) Pie chart

View Answer

82. What do Excel formulas start with?

a) /

b) f

c) =

d) _

View Answer

83. What is an Excel feature that displays only the data in column (s) according to specified criteria?

a) Filtering

b) Sorting

c) Formula

d) _

View Answer

84._ is not a function in Excel.

a) SUM

b) MIN

c) SUBSTRACT

d) MAX

View Answer

85. _ Excel function returns TRUE or FALSE based on two or more conditions

a) =AVERAGEIFS

b) =CONCAT

c) =COUNTA

d) =AND

View Answer

86. Why is the =COUNTIF function in Excel used?

a) Counts cells as specified

b) Counts blank cells in a range

c) Counts cells with numbers in a range

d) Returns values based on a TRUE or FALSE condition

View Answer

87. _ is the programming language used to write a Macro in MS Excel.

a) Visual Basic

b) C+

c) Java

d) C++

View Answer

88. Which keyboard shortcut is used to easily switch open workbooks?

a) Alt+S

b) CTRL+S

c) CTRL+Alt

d) CTRL+Tab

View Answer

89. _ happens when you select a cell in MS Excel and type “=B25”

a) Selected cell will show an error message

b) Selected cell will show “=B24”

c) Selected cell will show the same value as in B25

d) Selected cell will be blank

View Answer

90. Which file extension is used by default for Excel workbooks in recent versions?

a) .xls

b) .xlsx

c) .csv

d) .txt

View Answer

91. What is MS Excel?

a) Word Processor

b) Spreadsheet Program

c) Presentation Software

d) Database

View Answer

92. A workbook is made up of:

a) Rows

b) Columns

c) Worksheets

d) Cells

View Answer

93. Intersection of a row and column is called:

a) Box

b) Cell

c) Table

d) Sheet

View Answer

94. Default file extension of Excel (modern versions):

a) .xls

b) .xlsx

c) .docx

d) .pptx

View Answer

95. Maximum number of rows in Excel (latest versions):

a) 65536

b) 1048576

c) 100000

d) Unlimited

View Answer

96. Maximum number of columns in Excel:

a) 256

b) 512

c) 16384

d) 10000

View Answer

97. Shortcut key to save workbook:

a) CTRL+S

b) CTRL+C

c) CTRL+V

d) CTRL+X

View Answer

98. Formula in Excel starts with:

a) @

b) #

c) =

d) &

View Answer

99. SUM function is used to:

a) Multiply numbers

b) Add numbers

c) Subtract numbers

d) Divide numbers

View Answer

100. Which symbol is used for absolute reference?

a) #

b) $

c) &

d) @

View Answer

101. Which function count numerric values?

a) COUNT

b) SUM

c) MAX

d) MIN

View Answer

102. Which key edits a cell?

a) F1

b) F2

c) F3

d) F4

View Answer

103. What is the default alignment of numbers?

a) Left

b) Center

c) Right

d) Justify

View Answer

104. Which chart shows parts of a whole?

a) Bar chart

b) Pie chart

c) Line chart

d) Column chart

View Answer

105. Shortcut for copy:

a) CTRL+X

b) CTRL+V

c) CTRL+C

d) CTRL+A

View Answer

106. Shortcut for paste:

a) CTRL+P

b) CTRL+V

c) CTRL+C

d) CTRL+S

View Answer

107. Which function finds highest value?

a) MIN

b) MAX

c) SUM

d) AVG

View Answer

108. Which function finds lowest value??

a) MIN

b) MAX

c) SUM

d) AVG

View Answer

109. A cell address consists of:

a) Row only

b) Column only

c) Column letter and row number

d) AVG

View Answer

110. Example of cell address:

a) 1A

b) A1

c) AA

d) 11

View Answer

111. Which key deletes selected cell content?

a) Enter

b) Shift

c) Delete

d) Ctrl

View Answer

112. Which tab is used for formatting?

a) Insert

b) Home

c) Data

d) Review

View Answer

113. What does Ctrl + Z do?

a) Copy

b) Undo

c) Redo

d) Paste

View Answer

114. What does Ctrl + Y do?

a) Copy

b) Undo

c) Redo

d) Paste

View Answer

115. Which feature sorts data?

a) Filter

b) Sort

c) Format

d) Align

View Answer

116. Which function calculates average?

a) SUM

b) AVG

c) AVERAGE

d) COUNT

View Answer

117. Shortcut to select all:

a) CTRL+A

b) CTRL+S

c) CTRL+X

d) CTRL+D

View Answer

118. Which tab is used to insert charts?

a) Home

b) Insert

c) Data

d) View

View Answer

119. Freeze Panes is used to:

a) Lock cells

b) Freeze rows/columns

c) Delete rows

d) Hide columns

View Answer

120. Which Excel tool filters data?

a) Sort

b) Filter

c) Chart

d) Pivot

View Answer

121. Which function is used to join text?

a) CONCAT

b) MERGE

c) JOIN

d) LINK

View Answer

122. What does LEN function do?

a) Counts numbers

b) Counts characters

c) Counts words

d) Counts cells

View Answer

123. Which function converts text to uppercase?

a) LOWER

b) UPPER

c) PROPER

d) TEXT

View Answer

124. Which function converts text to lowercase?

a) LOWER

b) UPPER

c) PROPER

d) SMALL

View Answer

125. What is the shortcut for new workbook?

a) CTRL+N

b) CTRL+W

c) CTRL+O

d) CTRL+B

View Answer

126. What does Ctrl + P do?

a) Paste

b) Print

c) Preview

d) Page setup

View Answer

127. Which function is used to find the average?

a) MEAN

b) AVG

c) AVERAGE

d) MID

View Answer

128. Which option is used to combine cells?

a) Merge cells

b) Group cells

c) Wrap Text

d) Split Cells

View Answer

129. What is Wrap Text used for?

a) Delete Text

b) Adjust text within cell

c) Format numbers

d) Insert image

View Answer

130. Which tab contains Pivot Table?

a) Home

b) Insert

c) Data

d) Review

View Answer

131. What is Pivot Table used for?

a) Formatting

b) Data analysis

c) Printing

d) Editing

View Answer

132. Which function returns current date?

a) NOW()

b) DATE()

c) TODAY()

d) TIME()

View Answer

133. Which function returns current date & time?

a) NOW()

b) DATE()

c) TODAY()

d) TIME()

View Answer

134. Which function counts non-empty cells?

a) COUNTA

b) COUNT

c) COUNTIF

d) SUM

View Answer

135. What is COUNTIF used for?

a) Count all cells

b) Count cells with condition

c) Add numbers

d) Multiply numbers

View Answer

136. Which function looks up values vertically?

a) HLOOKUP

b) VLOOKUP

c) LOOKUP

d) MATCH

View Answer

137. Which function looks up values horizontally?

a) HLOOKUP

b) VLOOKUP

c) INDEX

d) MATCH

View Answer

138. Which symbol is used for multiplication?

a) +

b) -

c) *

d) /

View Answer

139. Which symbol is used for division?

a) +

b) -

c) *

d) /

View Answer

140. Which feature highlights duplicate values?

a) Conditional formatting

b) Sorting

c) Fitering

d) Wrap Text

View Answer

141. Which option protects worksheet?

a) Lock Sheet

b) Protect Sheet

c) Freeze Sheet

d) Hide Sheet

View Answer

142. Shortcut to open file:

a) Ctrl+N

b) Ctrl+O

c) Ctrl+S

d) Ctrl+P

View Answer

143. Which key moves to next cell?

a) Shift

b) Enter

c) Ctrl

d) Alt

View Answer

144. Which key moves to previous cell?

a) Shift+Enter

b) Ctrl+Enter

c) Tab

d) Alt+Enter

View Answer

145. Which key moves right?

a) Enter

b) Tab

c) Shift

d) Ctrl

View Answer

146. What is AutoFill used for?

a) Delete Data

b) Fill series automatically

c) Format cells

d) Insert rows

View Answer

147. Which function returns remainder?

a) DIV

b) MOD

c) REM

d) BAL

View Answer

148. Which function extracts part of text?

a) LEFT/RIGHT/MID

b) CUT

c) COPY

d) PASTE

View Answer

149. Which tab contains Sort & Filter?

a) Home

b) Insert

c) Data

d) Review

View Answer

150. Which function returns position of text?

a) FIND

b) SEARCH

c) LOCATE

d) BOTH a and b

View Answer

151. What does IF function do?

a) Adds numbers

b) Check condition

c) Counts cells

d) Formats text

View Answer

152. Syntax of IF function is:

a) IF(test)

b) IF(logical_test, value_if_true, value_if_false)

c) IF(value1, value2)

d) IF(condition)

View Answer

153. Which function removes extra spaces?

a) CLEAN

b) TRIM

c) SPACE

d) REMOVE

View Answer

154. Which function joins text from different cells?

a) CONCATENATE

b) MERGE

c) LINK

d) CONNECT

View Answer

155. Which function rounds a number?

a) ROUND

b) ROLL

c) FIX

d) INT

View Answer

156. Which function rounds down?

a) ROUND

b) ROUNDDOWN

c) DOWN

d) FLOOR

View Answer

157. Which function rounds up?

a) ROUNDUP

b) ROUND

c) UP

d) CEIL

View Answer

158. Which function returns largest value (with condition)?

a) MAX

b) MAXIF

c) MAXIFS

d) LARGE

View Answer

159. Which function returns smallest value (with condition)?

a) MINIFS

b) MIN

c) SMALL

d) MINIF

View Answer

160. Which function returns nth largest value?

a) MAX

b) LARGE

c) BIG

d) HIGH

View Answer

161. Which function returns nth smallest value?

a) SMALL

b) MIN

c) LESS

d) LOW

View Answer

162. Which function is used to find position in a list?

a) MATCH

b) INDEX

c) FIND

d) SEARCH

View Answer

163. Which function returns value from a table?

a) MATCH

b) INDEX

c) FIND

d) COUNT

View Answer

164. Combination of INDEX and MATCH is used for:

a) Formatting

b) Advanced lookup

c) Counting

d) Printing

View Answer

165. Which function returns text length?

a) COUNT

b) LEN

c) TEXT

d) SIZE

View Answer

166. Which function converts first letter capital?

a) UPPER

b) LOWER

c) PROPER

d) CAPITAL

View Answer

167. What does Ctrl + Shift + L do?

a) Lock cells

b) Apply filter

c) Insert table

d) Delete row

View Answer

168. What is Data Validation used for?

a) Delete data

b) Restrict input

c) Format text

d) Print sheet

View Answer

169. Which chart is best for trends over time?

a) Pie chart

b) Line chart

c) Bar chart

d) Scatter chart

View Answer

170. Which chart compares values?

a) Pie

b) Bar/Column

c) Line

d) Area

View Answer

171. What is a Macro?

a) Chart

b) Recorded steps

c) Formula

d) Table

View Answer

172. Which language is used in Excel Macros?

a) Java

b) Python

c) VBA

d) C++

View Answer

173. Which tab contains Macros?

a) Developer

b) Home

c) Insert

d) Data

View Answer

174. What is conditional formatting used for?

a) Add formulas

b) Highlight data

c) Delete rows

d) Insert charts

View Answer

175. Which option hides rows/columns?

a) Freeze

b) Hide

c) Lock

d) Protect

View Answer

176. Which function replaces text?

a) REPLACE

b) SUBSTITUE

c) CHANGE

d) BOTH A AND B

View Answer

177. Which function finds exact match?

a) FIND

b) SEARCH

c) MATCH

d) LOOKUP

View Answer

178. What is cell formatting?

a) Deleting Data

b) Changing appearance

c) Adding formulas

d) Sorting data

View Answer

179. Which option inserts new row?

a) Add row

b) Insert row

c) New row

d) Create row

View Answer

180. What is page layout used for?

a) Data entry

b) Print settings

c) Chart creation

d) Formula editing

View Answer

181. What does Ctrl + Shift + "+" do?

a) Delete row

b) Insert row/column

c) Copy

d) Paste

View Answer

182. What does Ctrl + "-" do?

a) Insert cell

b) Delete cell

c) Copy

d) Paste

View Answer

183. Which function is used to combine text and numbers?

a) CONCAT / CONCATENATE

b) Delete cell

c) SUM

d) COUNT

View Answer

184. Which function converts number to text format?

a) VALUE

b) TEXT

c) FORMAT

d) CONVERT

View Answer

185. Which function converts text to number?

a) VALUE

b) TEXT

c) NUM

d) CONVERT

View Answer

186. What is the default sheet name?

a) Page1

b) Sheet1

c) Excel1

d) Book1

View Answer

187. Which key is used to repeat last action?

a) F4

b) F2

c) F1

d) F5

View Answer

188. Which function returns largest value (with condition)?

a) MAX

b) MAXIF

c) MAXIFS

d) LARGE

View Answer

189. Which function returns smallest value (with condition)?

a) MIN

b) MINIF

c) MINIFS

d) SMALL

View Answer

190. Which function returns nth largest value?

a) MAX

b) LARGE

c) BIG

d) HIGH

View Answer

191. Which function returns nth smallest value?

a) SMALL

b) MIN

c) LOW

d) LESS

View Answer

192. Which function is used to find position in a list?

a) MATCH

b) INDEX

c) FIND

d) SEARCH

View Answer

193. Which function returns value from a table?

a) MATCH

b) INDEX

c) FIND

d) COUNT

View Answer

194. Combination of INDEX and MATCH is used for:

a) Formatting

b) Advanced lookup

c) Counting

d) Printing

View Answer

195. Which function returns text length?

a) COUNT

b) LEN

c) TEXT

d) SIZE

View Answer

196. Which function converts first letter capital?

a) UPPER

b) LOWER

c) PROPER

d) CAPITAL

View Answer

197. What does Ctrl + Shift + L do?

a) Lock cells

b) Apply filter

c) Insert table

d) Delete row

View Answer

198. What does #DIV/0! mean?

a) Wrong format

b) Divide by zero error

c) Missing Data

d) Invalid formula

View Answer

198. What does #DIV/0! mean?

a) Wrong format

b) Divide by zero error

c) Missing Data

d) Invalid formula

View Answer

199. What does #VALUE! error mean?

a) Invalid data type

b) Missing file

c) Divide error

d) Formatting issue

View Answer

200. What does #REF! error mean?

a) Wrong number

b) Invalid reference

c) Missing formula

d) Divide error

View Answer

201. Which option protects workbook?

a) Lock file

b) Protect workbook

c) Freeze workbook

d) Hide workbook

View Answer

202. What is Freeze Top Row used for?

a) Delete row

b) Lock first row

c) Hide row

d) Format row

View Answer

203. Which option shows formulas instead of results?

a) Show formulas

b) View formulas

c) Formula mode

d) Both a and b

View Answer

204. What is Quick Analysis tool used for?

a) Insert rows

b) Analyze data quickly

c) Delete data

d) Format cells

View Answer

205. Which function returns random number?

a) RAND

b) RANDOM

c) RAND

d) NUMBER

View Answer

206. Which function returns random integer?

a) RAND

b) RANDBETWEEN

c) RANDOM

d) INT

View Answer

207. What is sparklines used for?

a) Formatting

b) Mini charts in cells

c) Sorting

d) Printing

View Answer

208. Which option splits data into columns?

a) Split cells

b) Text to columns

c) Divide text

d) Separate

View Answer

209. Which option combines multiple sheets data?

a) Merge

b) Consolidate

c) Group

d) Combine

View Answer

210. Which tab contains Text to Columns?

a) Home

b) Insert

c) Data

d) Review

View Answer