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.
Which feature allows you to create a summary of your data?
A. PivotTable
B. Conditional Formatting
C. Data Validation
D. Charts
Answer: PivotTable
What does the function DATE() do?
A. Returns the date based on the year, month, and day provided
B. Finds the current date
C. Calculates the difference between two dates
D. Finds the number of days in a month
Answer: Returns the date based on the year, month, and day provided
Which function is used to return the day of the week from a date?
A. WEEKDAY
B. DAY
C. MONTH
D. YEAR
Answer: WEEKDAY
How do you apply a filter to data in Excel?
A. Use the Filter button on the Data tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Filter button on the Data tab
What is the purpose of the function SUBSTITUTE()?
A. Replaces specific text within a text string
B. Finds the length of a text string
C. Extracts text from a cell
D. Combines multiple text strings
Answer: Replaces specific text within a text string
How do you remove duplicates from a range of cells?
A. Use the Remove Duplicates button on the Data tab
B. Use the Format Cells dialog
C. Use Conditional Formatting
D. Use the Fill Handle
Answer: Use the Remove Duplicates button on the Data tab
What is the purpose of the function SUMIF()?
A. Sums the values in a range based on a specific condition
B. Finds the average of a range based on a condition
C. Counts the number of cells based on a condition
D. Finds the maximum value in a range
Answer: Sums the values in a range based on a specific condition
How can you sort data in Excel?
A. Use the Sort button on the Data tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Sort button on the Data tab
What is the function of the IF() function?
A. Performs a logical test and returns one value if true and another if false
B. Finds the average of a range
C. Counts the number of cells
D. Finds the maximum value in a range
Answer: Performs a logical test and returns one value if true and another if false