101. Which Excel function is used to return the largest value in a range of cells?
a) =LARGE()
b) =MAX()
c) =BIG()
d) =HIGHEST()
Answer: b
102. How can you quickly remove all formatting from a cell in Excel?
a) Press Ctrl + Z
b) Use the "Clear Formats" option in the Home tab
c) Right-click and select "Remove Formatting"
d) Press Ctrl + Shift + F
Answer: b
103. Which of the following Excel functions helps to find the position of a substring within a text string?
a) =POSITION()
b) =SEARCH()
c) =LOCATE()
d) =FIND()
Answer: b
104. What is the correct formula for calculating compound interest in Excel?
a) =CUMIPMT()
b) =PERCENTAGE()
c) =CUMIPY()
d) =FV()
Answer: d
105. How do you create a drop-down list in a cell in Excel?
a) Use the "Data Validation" option in the Data tab
b) Use the "Form Control" option
c) Type the options manually in the cell
d) Use "Conditional Formatting"
Answer: a
106. Which option allows you to calculate running totals in Excel?
a) AutoSum
b) Subtotal
c) Cumulative Sum
d) Data Validation
Answer: b
107. What is the correct way to lock a cell so it cannot be edited in Excel?
a) Use the "Protect Sheet" feature
b) Press Ctrl + Lock
c) Right-click the cell and choose "Lock Cell"
d) Both a and c
Answer: a
108. Which of the following functions returns the current system date and time in Excel?
a) =TIME()
b) =TODAY()
c) =NOW()
d) =DATE()
Answer: c
109. What does the CONCATENATE function do in Excel?
a) Joins two or more text strings into one
b) Returns the character code for a letter
c) Converts a number to text
d) Splits a cell into multiple values
Answer: a
110. How can you change the color of text in a cell in Excel?
a) Use the "Font Color" button in the Home tab
b) Right-click the cell and select "Change Text Color"
c) Press Ctrl + T
d) Both a and b
Answer: d
111. What feature is used to display numbers in a specific format, such as currency or percentage?
a) Formatting
b) Conditional Formatting
c) Cell Styles
d) Number Formatting
Answer: d
112. How do you round a number to the nearest integer in Excel?
a) =ROUND()
b) =CEILING()
c) =INT()
d) =TRUNC()
Answer: c
113. What is the maximum number of rows that can be in an Excel worksheet?
a) 1,048,576
b) 65,536
c) 1,000,000
d) 256
Answer: a
114. How do you quickly add a total sum to the bottom of a column in Excel?
a) Press Alt + T + S
b) Use the AutoSum button
c) Type =SUM() manually
d) Right-click and choose "Sum"
Answer: b
115. What is the "VLOOKUP" function used for in Excel?
a) To find a value in the first column of a table and return a value from another column
b) To return the largest value in a range
c) To combine two columns into one
d) To look for specific text in a cell
Answer: a
116. How can you remove gridlines from a worksheet in Excel?
a) Go to the View tab and uncheck "Gridlines"
b) Press Ctrl + Shift + G
c) Use the "Remove Gridlines" option in the Home tab
d) Right-click the worksheet and select "Remove Gridlines"
Answer: a
117. Which function is used to calculate the total number of cells that contain values or text in Excel?
a) =COUNT()
b) =COUNTA()
c) =COUNTIF()
d) =COUNTBLANK()
Answer: b
118. How do you freeze the top row in Excel?
a) Go to the View tab and select "Freeze Panes" > "Freeze Top Row"
b) Press Ctrl + Shift + F
c) Use the "Freeze Row" button in the Home tab
d) Right-click the row and choose "Freeze Row"
Answer: a
119. What is the default file extension for an Excel workbook?
a) .xls
b) .xlsx
c) .xlsm
d) .csv
Answer: b
120. How do you create a hyperlink to a webpage in Excel?
a) Press Ctrl + H
b) Use the "Insert" tab and select "Hyperlink"
c) Right-click the cell and choose "Insert Web Link"
d) Use the "Data" tab
Answer: b
121. How do you merge two or more cells in Excel?
a) Right-click the cells and choose "Merge Cells"
b) Use the "Merge & Center" button in the Home tab
c) Press Ctrl + M
d) Both a and b
Answer: d
122. What does the "PMT" function in Excel calculate?
a) The interest rate for a loan
b) The principal of a loan
c) The monthly payment for a loan
d) The total amount of a loan
Answer: c
123. Which function can be used to count cells with specific text in Excel?
a) =COUNTA()
b) =COUNTIF()
c) =SUMIF()
d) =TEXTCOUNT()
Answer: b
124. How do you highlight cells that contain values greater than a certain number in Excel?
a) Use Conditional Formatting
b) Use the Filter option
c) Use the "Highlight" button in the Home tab
d) Use the "Data Validation" feature
Answer: a
125. What is the purpose of the "IFERROR" function in Excel?
a) To return a custom value when a formula results in an error
b) To calculate the total of a range
c) To find the largest number in a range
d) To check if a value is an error
Answer: a
