How can you quickly adjust the width of a column to fit its content?
A. Double-click the right edge of the column header B. Right-click and select “Fit to Content” C. Press Ctrl + W D. Use the Format Painter
Answer: A. Double-click the right edge of the column header
Explanation: Double-clicking the boundary between column headers automatically adjusts the width to fit the content.
Question 42
Which of the following functions can be used to calculate monthly loan payments in Excel?
A. FV B. PV C. PMT D. SUM
Answer: C. PMT
Explanation: The PMT function calculates the periodic payment for a loan based on a constant interest rate and payment amount.
Question 43
What is the purpose of the LEN function in Excel?
A. To count the number of cells in a range B. To calculate the length of a string of text C. To calculate the length of a range of values D. To remove extra spaces from text
Answer: B. To calculate the length of a string of text
Explanation: LEN returns the number of characters in a text string, including spaces.
Question 44
Which of the following will you use to restrict user input in a cell to only predefined values?
A. Data Validation B. Conditional Formatting C. Trace Dependents D. Protect Sheet
Answer: A. Data Validation
Explanation: Data Validation is used to control the type of data or values that users can enter into a cell.
Question 45
Which function allows you to retrieve data from multiple worksheets at once?
A. INDIRECT B. VLOOKUP C. SUMIF D. MULTIREF
Answer: A. INDIRECT
Explanation: INDIRECT allows you to reference cells and ranges dynamically across multiple worksheets based on their text values.
Question 46
How do you switch between different open workbooks in Excel?
A. Press Alt + Tab B. Press Ctrl + Tab C. Press Shift + Tab D. Press Ctrl + Shift + Tab
Answer: B. Press Ctrl + Tab
Explanation: Ctrl + Tab cycles between open workbooks in Excel.
Question 47
What is the result of the formula =ROUND(15.75, 0)?
A. 15 B. 16 C. 17 D. 15.8
Answer: B. 16
Explanation: ROUND(15.75, 0) rounds the number to the nearest integer, which is 16.
Question 48
Which function calculates the internal rate of return for a series of cash flows in Excel?
A. IRR B. PV C. FV D. RATE
Answer: A. IRR
Explanation: The IRR function calculates the internal rate of return for a series of cash flows, which is the interest rate at which the net present value (NPV) of cash flows equals zero
Question 49
How can you quickly copy the formatting of a cell to another cell in Excel?
A. Use the Format Painter tool B. Press Ctrl + Shift + C C. Use Data Validation D. Press Alt + C
Answer: A. Use the Format Painter tool
Explanation: The Format Painter tool allows you to copy the formatting from one cell and apply it to others.
Question 50
Which of the following will you use to create a summary of a dataset with totals and averages?
A. PivotTable B. Data Validation C. Conditional Formatting D. Filter
Answer: A. PivotTable
Explanation: A PivotTable is used to summarize large datasets by providing totals, averages, and other aggregate data.