Which Excel feature helps users choose values only from a predefined list?
Correct!
Wrong!
Which shortcut is used to apply or remove filters in Excel?
Correct!
Wrong!
Which command is used to change misspelled text throughout a worksheet?
Correct!
Wrong!
What does AutoFit Column Width do?
Correct!
Wrong!
Why is Data Validation more effective than manually typing product names?
Correct!
Wrong!
Which shortcut inserts a new blank column in Excel?
Correct!
Wrong!
If a customer name contains both first and last name in one cell, which delimiter should normally be selected?
Correct!
Wrong!
Which option in Filter should be selected to find missing sales amounts?
Correct!
Wrong!
Which Excel feature is mainly used to display only rows with blank cells?
Correct!
Wrong!
Which shortcut directly opens the Go To dialog box in Excel?
Correct!
Wrong!
Which tab contains the Text to Columns option?
Correct!
Wrong!
Which page layout setting changes the paper from Landscape to Portrait?
Correct!
Wrong!
FBA-Lab4-Basic Data Cleaning and Formatting MCQs
Super Excellent ****
Excellent ***
Very Good
Good *
Need Improvements
Share your Results: