FBA-Lab4-Basic Data Cleaning and Formatting MCQs

(Tab to RIGHT OPTION to see the answer.)

Which shortcut is used to apply or remove filters in Excel?

Alt + F + L

Ctrl + L

Ctrl + Shift + L

Ctrl + Alt + L

Correct! Wrong!

Which page layout setting changes the paper from Landscape to Portrait?

Margins

Scale

Orientation

Themes

Correct! Wrong!

Which command is used to change misspelled text throughout a worksheet?

Wrap Text

AutoFill

Merge Cells

Replace All

Correct! Wrong!

Why is Data Validation more effective than manually typing product names?

It changes page orientation

It allows only consistent and approved entries

It creates charts automatically

It increases worksheet size

Correct! Wrong!

Which shortcut directly opens the Go To dialog box in Excel?

Ctrl + J

Ctrl + G

Ctrl + Shift + G

Ctrl + T

Correct! Wrong!

Which tab contains the Text to Columns option?

Data

View

Home

Insert

Correct! Wrong!

Which Excel feature helps users choose values only from a predefined list?

Flash Fill

Data Validation

AutoSum

Goal Seek

Correct! Wrong!

Which shortcut inserts a new blank column in Excel?

Ctrl + Alt + +

Ctrl + Shift + +

Alt + Shift + C

Ctrl + I

Correct! Wrong!

If a customer name contains both first and last name in one cell, which delimiter should normally be selected?

Space

Tab

Semicolon

Comma

Correct! Wrong!

What does AutoFit Column Width do?

Changes font size

Makes all columns equal

Deletes empty columns

Adjusts column width to fit content

Correct! Wrong!

Which Excel feature is mainly used to display only rows with blank cells?

Freeze Panes

Conditional Formatting

Sort

Filter

Correct! Wrong!

Which option in Filter should be selected to find missing sales amounts?

Duplicates

Zeros

Blanks

Errors

Correct! Wrong!

FBA-Lab4-Basic Data Cleaning and Formatting MCQs

Super Excellent ****

Excellent ***

Very Good

Good *

Need Improvements