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 SUMPRODUCT function do?
A. Multiplies corresponding elements in arrays and then sums those products
B. Calculates the sum of a range of values
C. Counts the number of cells in a range
D. Finds the maximum value in a range
Answer: Multiplies corresponding elements in arrays and then sums those products
How can you quickly fill a range with a series of numbers?
A. Use the Fill Handle to drag the series
B. Use the Data Validation feature
C. Use the Conditional Formatting tool
D. Use the Find & Replace feature
Answer: Use the Fill Handle to drag the series
How can you use the INDEX and MATCH functions together?
A. To look up a value in a table based on a row and column index
B. To calculate the sum of a range of values
C. To find the average of a range
D. To join two or more text strings into one text string
Answer: To look up a value in a table based on a row and column index
Which function calculates the internal rate of return for a series of cash flows?
A. IRR()
B. NPV()
C. PMT()
D. FV()
Answer: IRR()
What does the CHOOSE function do?
A. Returns a value from a list based on an index number
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 a value from a list based on an index number
Which function would you use to calculate the standard deviation of a data set?
A. STDEV()
B. SUM()
C. COUNT()
D. AVERAGE()
Answer: STDEV()
How can you remove duplicates from a range of data in Excel?
A. Use the Remove Duplicates feature in the Data tab
B. Use the Conditional Formatting tool
C. Use the Find & Replace feature
D. Use the Sort & Filter feature
Answer: Use the Remove Duplicates feature in the Data tab
What is the purpose of the ‘Sparklines’ feature in Excel?
A. To create small charts within a single cell to show trends
B. To format cells based on their content
C. To sort data in ascending or descending order
D. To filter data in a range
Answer: To create small charts within a single cell to show trends
Which of the following is NOT a valid chart type in Excel?
A. Box Plot
B. Bubble Chart
C. Waterfall Chart
D. Radar Chart
Answer: Box Plot