Microsoft Excel MCQs | STS IBA FPSC BPSC SPSC PPSC Mcqs Test Preparation
Master Microsoft Excel with our extensive collection of basic computer MCQs and computer science MCQs. Our platform offers a variety of computer MCQ online tests designed to enhance your proficiency in Excel. Practice with our computer MCQ test online resources, which include detailed questions and answers to boost your Excel skills. Recognized as the best MCQs portal in the world, we provide top-quality resources for learning Microsoft Excel.
If you’re looking for the best MCQs site for computer MCQs related to Microsoft Excel, you’ve come to the right place. Our site features a comprehensive collection of computer MCQs that are ideal for Excel users. With our computer MCQ online test options, you’ll have access to high-quality practice materials that will help you excel in using Excel. Discover why we are the best MCQs site for computer MCQs and the best MCQs portal in the world for mastering Microsoft Excel.
What is the use of the HLOOKUP function in Excel?
A. Searches for a value in the top row of a table and returns a value in the same column from a specified row
B. Searches for a value in the first column of a table and returns a value in the same row from a specified column
C. Calculates the average of a range of values
D. Finds the maximum value in a range
Answer: Searches for a value in the top row of a table and returns a value in the same column from a specified row
What does the TRANSPOSE function do in Excel?
A. Switches the rows and columns of a range
B. Calculates the transpose of a matrix
C. Finds the average of a range
D. Counts the number of cells in a range
Answer: Switches the rows and columns of a range
What is the purpose of the PMT function in Excel?
A. Calculates the payment for a loan based on constant payments and a constant interest rate
B. Calculates the total amount paid over the life of a loan
C. Finds the future value of an investment
D. Calculates the interest paid on a loan
Answer: Calculates the payment for a loan based on constant payments and a constant interest rate
How can you protect a worksheet to prevent unauthorized changes?
A. Use the Protect Sheet option in the Review tab
B. Use the Format Cells dialog box
C. Use the Data Validation tool
D. Use the Conditional Formatting tool
Answer: Use the Protect Sheet option in the Review tab
What is the function of the INDIRECT function in Excel?
A. Returns the reference specified by a text string
B. Finds the maximum value in a range
C. Calculates the sum of a range of values
D. Joins two or more text strings into one text string
Answer: Returns the reference specified by a text string
What does the SUMIF function do in Excel?
A. Adds the cells specified by a given condition or criteria
B. Counts the number of cells that meet a specified condition
C. Calculates the average of a range based on a condition
D. Finds the maximum value in a range based on a condition
Answer: Adds the cells specified by a given condition or criteria
Which formula can be used to count the number of cells that contain numbers in a range?
A. COUNT()
B. COUNTA()
C. COUNTIF()
D. SUM()
Answer: COUNT()
What does the IFERROR function do in Excel?
A. Returns a value you specify if a formula evaluates to an error
B. Checks if a condition is met and returns one value if true and another if false
C. Finds the maximum value in a range
D. Joins two or more text strings into one text string
Answer: Returns a value you specify if a formula evaluates to an error
How can you apply conditional formatting to a cell in Excel?
A. Use the Conditional Formatting menu in the Home tab
B. Use the Format Cells dialog box
C. Use the Fill Color tool in the Home tab
D. Use the Number Format menu in the Home tab
Answer: Use the Conditional Formatting menu in the Home tab