MCQ on MS Excel Set 1 Leave a Comment / By MCQBOX / 24 December 2023 MCQ on MS Excel Set 1 for all Competitive Exams “Explore a comprehensive multiple-choice question on Microsoft Excel at MCQBOX. These questions cover basic and advanced Excel functions, ideal for exam preparation such as MS-CIT and university entrance tests. Welcome to your MCQ on MS Excel 1. What symbol is used to begin a formula in Excel? A) = B) + C) * D) – None 2. Which function is used to find the highest number in a range in Excel? A) MAX() B) HIGH() C) TOP() D) PEAK() None None 3. What keyboard shortcut is used to open the 'Format Cells' dialog box? A) Ctrl + F B) Ctrl + Z C) Ctrl + Shift + F D) Ctrl + 1 None 4. Which Excel feature allows you to view different sections of a worksheet simultaneously? A) Freeze Panes B) Split C) Group D) Unhide None 5. Which function is used to count the number of cells in a range that contain numbers? A) SUM() B) COUNT() C) NUMCOUNT() D) TOTAL() None 6. What does the function VLOOKUP do in Excel? A) Finds values in a vertical table B) Adds values vertically C) Looks up values in a horizontal table D) Searches for values in multiple sheets None 7. Which option is used to protect specific cells from editing in Excel? A) Lock Cells B) Hide Cells C) Freeze Cells D) Secure Cells None 8. What does the COUNTIF function do in Excel? A) Counts cells with specific text B) Counts cells with errors C) Counts cells meeting a specific condition D) Counts only empty cells None 9. What does the CONCATENATE function do in Excel? A) Divides text into separate cells B) Combines or joins text from different cells C) Converts text to numbers D) Searches for specific text within cells None 10. Which function is used to calculate the average of a group of numbers in Excel? A) AVG() B) MEAN() C) AVERAGE() D) AV() None Please fill in the comment box below. Time’s up Attempt More MCQs Online Excel Assesment Test
