126. What is the maximum number of columns in an Excel worksheet?
a) 256
b) 1024
c) 16384
d) 100
Answer: c
127. Which of the following functions is used to calculate the present value of an investment in Excel?
a) =PV()
b) =FV()
c) =NPV()
d) =IRR()
Answer: a
128. How do you apply bold formatting to a cell in Excel?
a) Press Ctrl + B
b) Right-click the cell and select "Bold"
c) Use the "Bold" button in the Home tab
d) All of the above
Answer: d
129. How do you remove a row in Excel?
a) Right-click the row number and select "Delete"
b) Press Ctrl + X
c) Use the "Delete" button in the Home tab
d) Both a and c
Answer: d
130. What does the COUNTIF function do in Excel?
a) Counts the number of cells with a specific condition
b) Counts all non-empty cells in a range
c) Counts the number of blank cells in a range
d) Counts cells based on multiple conditions
Answer: a
131. What function would you use to find the value of a loan after a certain period, assuming equal payments?
a) =PMT()
b) =FV()
c) =PV()
d) =RATE()
Answer: b
132. Which of the following is used to insert a page break in Excel?
a) Press Ctrl + Enter
b) Go to the "Insert" tab and click "Page Break"
c) Right-click a cell and select "Insert Page Break"
d) Both b and c
Answer: d
133. What is the primary use of the "Goal Seek" tool in Excel?
a) To find the value of a cell based on a desired result
b) To break down the data into smaller parts
c) To calculate loan payments
d) To display multiple options of a formula
Answer: a
134. Which of the following is the correct formula to calculate the total sales in Excel from cells A1 to A10?
a) =SUM(A1:A10)
b) =TOTAL(A1:A10)
c) =ADD(A1:A10)
d) =SUMIF(A1:A10)
Answer: a
135. What feature in Excel allows you to display a message or a reminder when entering data in a cell?
a) Data Validation
b) Conditional Formatting
c) Comments
d) Cell Styles
Answer: a
136. How do you insert a new worksheet into an existing Excel workbook?
a) Press Ctrl + N
b) Use the "Insert" tab and select "Worksheet"
c) Right-click a sheet tab and select "Insert"
d) Both b and c
Answer: d
137. Which of the following is used to change the format of text in a cell, such as font size and color, in Excel?
a) Cell Styles
b) Conditional Formatting
c) Font Formatting options in the Home tab
d) Number Formatting
Answer: c
138. Which function is used to return the current date in Excel?
a) =DATE()
b) =NOW()
c) =TODAY()
d) =TIME()
Answer: c
139. What is the purpose of the "MATCH" function in Excel?
a) To find a value in a range and return its relative position
b) To find the maximum value in a range
c) To compare two sets of data
d) To match two values for equality
Answer: a
140. How do you change the row height in Excel?
a) Right-click the row number and select "Row Height"
b) Drag the row boundary in the row header
c) Use the "Format" option in the Home tab
d) All of the above
Answer: d
141. Which of the following would you use to add a comment to a cell in Excel?
a) Right-click the cell and select "Insert Comment"
b) Press Ctrl + Shift + C
c) Use the "Review" tab and select "New Comment"
d) Both a and c
Answer: d
142. What does the "TRIM" function do in Excel?
a) Removes extra spaces from text
b) Trims the edges of a cell
c) Cuts text to a specific length
d) Converts text to uppercase
Answer: a
143. How do you add a new column to an existing worksheet in Excel?
a) Right-click a column header and select "Insert"
b) Press Ctrl + Shift + C
c) Use the "Insert" tab and select "Insert Column"
d) Both a and c
Answer: d
144. What is the purpose of the "IF" function in Excel?
a) To return different values based on a condition
b) To add cells based on a condition
c) To find the largest value in a range
d) To calculate the average of a range
Answer: a
145. Which Excel feature can be used to group data by categories?
a) PivotTable
b) Data Validation
c) Conditional Formatting
d) Subtotals
Answer: a
146. How can you protect a worksheet in Excel from unauthorized changes?
a) Use the "Protect Sheet" feature in the Review tab
b) Set a password for the worksheet
c) Right-click and choose "Lock"
d) Both a and b
Answer: d
147. What type of chart is ideal for showing trends over time in Excel?
a) Pie Chart
b) Bar Chart
c) Line Chart
d) Column Chart
Answer: c
148. What does the "SUMIF" function do in Excel?
a) Sums values based on a condition
b) Sums all values in a range
c) Sums only numbers that are not zero
d) Sums cells based on multiple conditions
Answer: a
149. How do you remove all hyperlinks in a worksheet in Excel?
a) Right-click and select "Remove Hyperlink"
b) Use the "Clear All" option in the Home tab
c) Press Ctrl + Shift + H
d) Both a and b
Answer: d
150. What feature in Excel allows you to quickly analyze data and display trends?
a) PivotTable
b) Conditional Formatting
c) Quick Analysis
d) Slicer
Answer: c
