1) What keyboard shortcut is used to activate Flash Fill in Excel? a) Ctrl + F b) Ctrl + Shift + L c) Ctrl + E  d) Alt + Enter 2) Flash Fill works best when a) You want to apply conditional formatting b) The pattern is too complex to detect c) Data has no structure d) The pattern is clear and consistent 3) What happens when you drag the fill handle from a cell containing “Mon”? a) Excel fills in weekday names like Tue, Wed b) Excel repeats “Mon” only c) Excel fills in dates d) Nothing happens 4) What feature helps Excel adjust formulas like =A1+B1 to =A2+B2 when filled down? a) Conditional Formatting b) AutoFill c) AutoCorrect d) AutoAdjust 5) What does the "Paste Values" option do a) Pastes everything including formatting b) Pastes only formulas c) Pastes only the calculated result d) Pastes charts 6) What shortcut opens the Paste Special menu? a) Ctrl + Alt + V b) Ctrl + P c) Shift + V d) Ctrl + F3 7) To move a cell using drag and drop, what do you need to see on your cursor? a) Paintbrush b) Bold arrow c) Cross with arrows d) Dashed circle 8) Holding Shift while dragging data does what? a) Deletes the selected data b) Highlights the data c) Copies the data d) Inserts the data between rows/columns 9) What shortcut opens the Format Cells dialog? a) Ctrl + Shift + F b) Ctrl + 1 c) Alt + Ctrl + Z d) Ctrl + Alt + M 10) Which of these is not a formatting type? a) Bold b) Cell Color c) AutoSort d) Number Format 11) When using Flash Fill to split a name like "Dr. John A. Smith Jr." into first and last names, which of the following is most likely to break Flash Fill’s ability to detect a correct pattern? a) Removing the middle initial b) Having consistent capitalization c) Using the same delimiter (spaces) d) Including honorifics and suffixes inconsistently

Quiz of ICT

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?