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 does the function MONTH() do?
A. Returns the month of a date
B. Returns the year of a date
C. Returns the day of a date
D. Returns the number of days in a month
Answer: Returns the month of a date
Which function calculates the total of a range of cells but ignores blank cells?
A. SUM
B. AVERAGE
C. COUNTA
D. COUNTBLANK
Answer: SUM
How do you change the color of a cell?
A. Use the Fill Color button on the Home tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Fill Color button on the Home tab
How can you apply a filter to a range?
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
Which function returns the number of columns in a range?
A. COLUMNS
B. ROWS
C. COUNT
D. COUNTA
Answer: COLUMNS
What is the purpose of the function RIGHT()?
A. Extracts a specified number of characters from the end of a text string
B. Finds the length of a text string
C. Extracts a specified number of characters from the beginning of a text string
D. Finds a value in a table
Answer: Extracts a specified number of characters from the end of a text string
How can you add a comment to a cell?
A. Right-click the cell and choose Insert Comment
B. Use the Review tab
C. Use Conditional Formatting
D. Use the Format Cells dialog
Answer: Right-click the cell and choose Insert Comment
Which function calculates the total number of cells that contain text in a range?
A. COUNTA
B. COUNT
C. COUNTBLANK
D. SUM
Answer: COUNTA
Which function returns the year of a date?
A. YEAR
B. MONTH
C. DAY
D. DATE
Answer: YEAR