FBA-Lab3-Working with Basic Data MCQs

(Tab to RIGHT OPTION to see the answer.)

Which menu contains the 'Format as Table' option?

Review

Data

Home

Insert

Correct! Wrong!

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

It changes formulas into values

It copies only formatting

It inserts new rows

It fills formulas to the last row of adjacent data automatically

Correct! Wrong!

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

Flash Fill

Conditional Formatting

Freeze Panes

Sort

Correct! Wrong!

Which page layout setting changes the direction of the page?

Orientation

Size

Margin

Zoom

Correct! Wrong!

Which shortcut key is used for Flash Fill in Excel?

Ctrl + F2

Ctrl + D

Ctrl + T

Ctrl + E

Correct! Wrong!

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

AutoFill Handle

Formula Bar

Scroll Box

Resize Handle

Correct! Wrong!

Which shortcut key is used to save the workbook?

Ctrl + P

Ctrl + W

Ctrl + Shift + S

Ctrl + S

Correct! Wrong!

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

Flash Fill

AutoFill

Find and Replace

Copy and Paste

Correct! Wrong!

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

Ctrl + Y

Ctrl + E

Ctrl + Z

Ctrl + D

Correct! Wrong!

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

=E2-F2

=F5-E5

=E5-F5

=E3-F3

Correct! Wrong!

What does Ctrl + T do in Excel?

Creates a chart

Formats data as a table

Deletes a column

Opens a new worksheet

Correct! Wrong!

Which shortcut key selects an entire column?

Ctrl + Space

Shift + Space

Ctrl + A

Alt + Space

Correct! Wrong!

FBA-Lab3-Working with Basic Data MCQs

Super Excellent ****

Excellent ***

Very Good **

Good *

Fair

Need Improvements