Which shortcut is used to apply or remove filters in Excel?
Correct!
Wrong!
Which shortcut inserts a new blank column in Excel?
Correct!
Wrong!
What does AutoFit Column Width do?
Correct!
Wrong!
Which shortcut directly opens the Go To dialog box in Excel?
Correct!
Wrong!
Which page layout setting changes the paper from Landscape to Portrait?
Correct!
Wrong!
Which tab contains the Text to Columns option?
Correct!
Wrong!
Which command is used to change misspelled text throughout a worksheet?
Correct!
Wrong!
Which Excel feature helps users choose values only from a predefined list?
Correct!
Wrong!
Why is Data Validation more effective than manually typing product names?
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!
FBA-Lab4-Basic Data Cleaning and Formatting MCQs
Super Excellent ****
Excellent ***
Very Good
Good *
Need Improvements
Share your Results: