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 function is used to extract a specific number of characters from a text string?
A. MID
B. LEFT
C. RIGHT
D. SEARCH
Answer: MID
How can you create a dynamic named range in Excel?
A. Use the OFFSET function with the defined name
B. Use the TABLE function
C. Use the INDEX function
D. Use the INDIRECT function
Answer: Use the OFFSET function with the defined name
What is the function of the ‘IF’ statement in Excel?
A. Performs a logical test and returns one value if TRUE and another if FALSE
B. Counts the number of cells in a range
C. Finds the maximum value in a range
D. Calculates the standard deviation of a range
Answer: Performs a logical test and returns one value if TRUE and another if FALSE
How can you calculate the weighted average in Excel?
A. Use the SUMPRODUCT function divided by the SUM function
B. Use the AVERAGE function
C. Use the MEDIAN function
D. Use the WEIGHTED function
Answer: Use the SUMPRODUCT function divided by the SUM function
What does the function CONCATENATE do?
A. Joins several text strings into one text string
B. Finds the sum of a range of values
C. Counts the number of cells that meet a condition
D. Returns the average of a range of values
Answer: Joins several text strings into one text string
Which function is used to find the position of a value in a horizontal array?
A. MATCH
B. INDEX
C. VLOOKUP
D. HLOOKUP
Answer: HLOOKUP
What does the function VLOOKUP do when used with the fourth argument set to FALSE?
A. Looks up an approximate match in the first column of a table
B. Looks up an exact match in the first column of a table
C. Looks up a value in the first row of a table
D. Looks up an approximate match in the first row of a table
Answer: Looks up an exact match in the first column of a table
What does the INDIRECT function do in Excel?
A. Returns the value of a cell specified by a text string
B. Finds the maximum value in a range
C. Calculates the payment for a loan
D. Counts the number of cells in a range
Answer: Returns the value of a cell specified by a text string
How can you freeze panes in Excel?
A. Use the Freeze Panes option in the View tab
B. Use the Split option in the View tab
C. Use the Freeze Panes option in the Home tab
D. Use the Split option in the Data tab
Answer: Use the Freeze Panes option in the View tab