FBA-Lab3-Working with Basic Data MCQs

(Tab to RIGHT OPTION to see the answer.)

What does Ctrl + T do in Excel?

Opens a new worksheet

Formats data as a table

Creates a chart

Deletes a column

Correct! Wrong!

What is the main advantage of double-clicking the AutoFill handle instead of dragging it?

It fills formulas to the last row of adjacent data automatically

It inserts new rows

It copies only formatting

It changes formulas into values

Correct! Wrong!

Which menu contains the 'Format as Table' option?

Insert

Review

Home

Data

Correct! Wrong!

Which shortcut key is an alternative to dragging the AutoFill handle downward?

Ctrl + E

Ctrl + Y

Ctrl + Z

Ctrl + D

Correct! Wrong!

Which shortcut key is used to save the workbook?

Ctrl + W

Ctrl + P

Ctrl + S

Ctrl + Shift + S

Correct! Wrong!

Which page layout setting changes the direction of the page?

Zoom

Size

Orientation

Margin

Correct! Wrong!

Which shortcut key is used for Flash Fill in Excel?

Ctrl + E

Ctrl + F2

Ctrl + D

Ctrl + T

Correct! Wrong!

Which Excel feature is used to copy a formula down a column quickly?

Copy and Paste

AutoFill

Find and Replace

Flash Fill

Correct! Wrong!

If G2 contains =E2-F2, what formula would most likely appear in G5 after AutoFill?

=E2-F2

=E3-F3

=F5-E5

=E5-F5

Correct! Wrong!

Which Excel feature recognises a pattern in typed data and completes the remaining entries?

Conditional Formatting

Flash Fill

Sort

Freeze Panes

Correct! Wrong!

Which shortcut key selects an entire column?

Ctrl + Space

Shift + Space

Alt + Space

Ctrl + A

Correct! Wrong!

What appears at the bottom-right corner of a selected Excel cell for AutoFill?

Scroll Box

Formula Bar

AutoFill Handle

Resize Handle

Correct! Wrong!

FBA-Lab3-Working with Basic Data MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements