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 RAND() do?
A. Generates a random number between 0 and 1
B. Finds the maximum value in a range
C. Counts the number of cells with numbers
D. Calculates the average of a range of cells
Answer: Generates a random number between 0 and 1
What does the function ISBLANK() do?
A. Checks if a cell is empty
B. Counts the number of cells with text
C. Finds the maximum value in a range
D. Calculates the average of a range of cells
Answer: Checks if a cell is empty
How can you hide a column?
A. Right-click the column header and choose Hide
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Right-click the column header and choose Hide
How can you create a chart in Excel?
A. Use the Insert Chart button on the Insert tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Insert Chart button on the Insert tab
What does the function VLOOKUP() require as its first argument?
A. The value to search for
B. The column index number
C. The range of cells to search
D. The value to return
Answer: The value to search for
How can you group rows or columns?
A. Use the Group button on the Data tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Group button on the Data tab
What does the function YEAR() do?
A. Returns the year of a date
B. Returns the month of a date
C. Returns the day of a date
D. Returns the number of days in a year
Answer: Returns the year of a date
How do you change the font size of text in a cell?
A. Use the Font Size dropdown on the Home tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Font Size dropdown on the Home tab
Which function converts a number to text in a specific number format?
A. TEXT
B. VALUE
C. NUMBER
D. FORMAT
Answer: TEXT