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 TODAY() do?
A. Returns the current date
B. Returns the current time
C. Finds the maximum value in a range
D. Calculates the average of a range of cells
Answer: Returns the current date
What does the function PMT() do?
A. Calculates the payment for a loan based on constant payments and a constant interest rate
B. Finds the maximum value in a range
C. Counts the number of cells with text
D. Calculates the average of a range of cells
Answer: Calculates the payment for a loan based on constant payments and a constant interest rate
What does the function LOG() do?
A. Returns the logarithm of a number
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: Returns the logarithm of a number
Which function calculates the future value of an investment based on periodic, constant payments and a constant interest rate?
A. FV
B. PV
C. NPV
D. IRR
Answer: FV
How can you remove duplicates from a range?
A. Use the Remove Duplicates button on the Data tab
B. Use Conditional Formatting
C. Use the Format Cells dialog
D. Use the Fill Handle
Answer: Use the Remove Duplicates button on the Data tab
Which function returns the last day of a month based on a given date?
A. EOMONTH
B. DATE
C. TODAY
D. MONTH
Answer: EOMONTH
What does the function ISNUMBER() do?
A. Checks if a value is a number
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 value is a number
How do you adjust the width of a column?
A. Drag the boundary of the column header
B. Use the Format Cells dialog
C. Use Conditional Formatting
D. Use the Fill Handle
Answer: Drag the boundary of the column header
Which function extracts a specified number of characters from the beginning of a text string?
A. LEFT
B. RIGHT
C. MID
D. LEN
Answer: LEFT