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 find the total number of characters in a text string, excluding spaces?
A. LEN
B. TRIM
C. SUBSTITUTE
D. TEXT
Answer: LEN
What is the purpose of the function TRIM()?
A. Removes extra spaces from a text string
B. Trims the length of a text string
C. Extracts characters from the middle of a text string
D. Combines multiple text strings into one
Answer: Removes extra spaces from a text string
Which function is used to return the number of characters in a text string?
A. LEN
B. TEXT
C. FIND
D. MID
Answer: LEN
What does the function HLOOKUP() do?
A. Searches for a value in the first row and returns a value in the same column from another row
B. Searches for a value in the first column and returns a value in the same row from another column
C. Finds the maximum value in a range
D. Counts the number of cells
Answer: Searches for a value in the first row and returns a value in the same column from another row
How can you insert a comment in a cell?
A. Right-click the cell and select Insert Comment
B. Use the Review tab
C. Use the Home tab
D. Use Conditional Formatting
Answer: Right-click the cell and select Insert Comment
Which tab do you use to create and modify charts?
A. Insert
B. Data
C. Home
D. View
Answer: Insert
What does the function CHAR() do?
A. Returns the character specified by a number
B. Finds the length of a text string
C. Extracts text from the beginning of a string
D. Combines multiple text strings
Answer: Returns the character specified by a number
Which function is used to find the middle value in a range?
A. MEDIAN
B. MODE
C. AVERAGE
D. SUM
Answer: MEDIAN
How do you change the font size in a cell?
A. Use the Font Size dropdown on the Home tab
B. Use the Format Cells dialog
C. Use Conditional Formatting
D. Use the Fill Handle
Answer: Use the Font Size dropdown on the Home tab