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 MATCH function do in Excel?
A. Searches for a specified item in a range and returns the relative position of that item
B. Joins two or more text strings into one text string
C. Calculates the sum of a range of values
D. Finds the minimum value in a range
Answer: Searches for a specified item in a range and returns the relative position of that item
What does the CONCATENATE function do in Excel?
A. Joins two or more text strings into one text string
B. Calculates the average of a range of values
C. Finds the maximum value in a range
D. Searches for a value in a range and returns a corresponding value
Answer: Joins two or more text strings into one text string
In Excel, what is the purpose of the INDEX function?
A. Returns the value of a cell at the intersection of a specified row and column
B. Finds the position of a value in a range
C. Searches for a value in the first column and returns a value in the same row from a specified column
D. Calculates the sum of a range of values
Answer: Returns the value of a cell at the intersection of a specified row and column
Which of the following is not a valid data type for a cell in Excel?
A. Text
B. Number
C. Date
D. Object
Answer: Object
What is the function of the VLOOKUP formula in Excel?
A. To search for a value in the first column of a range and return a value in the same row from a specified column
B. To calculate the sum of a range of values
C. To sort data in ascending or descending order
D. To find the average of a range of values
Answer: To search for a value in the first column of a range and return a value in the same row from a specified column
Which of the following functions is used to return the current date and time in Excel?
A. NOW()
B. TODAY()
C. CURRENT()
D. DATE()
Answer: NOW()
How can you prevent a cell reference in a formula from changing when you copy it to another cell?
A. Use a relative reference
B. Use a mixed reference
C. Use an absolute reference
D. Use a dynamic reference
Answer: Use an absolute reference