Microsoft Excel General Knowledge 4

Question 1

What is the purpose of the Excel 'Flash Fill' feature?

Accepted Answer

Automatically fills data based on a detected pattern in adjacent cells

Answer

Flash Fill (Ctrl+E) recognizes patterns from examples you type and automatically fills the remaining cells accordingly.

Question 2

Which function would you use to find the position of a value in a list?

Accepted Answer

MATCH

Answer

MATCH returns the relative position (row or column number) of a value within a range.

Question 3

What does 'Wrap Text' formatting do to a cell?

Accepted Answer

Displays the cell content on multiple lines within the same cell

Answer

Wrap Text increases the row height and displays long text on multiple lines within the cell rather than overflowing into adjacent cells.

Question 4

Which Excel function returns the current date and time, updating every time the worksheet recalculates?

Accepted Answer

NOW()

Answer

NOW() returns the current date and time as a serial number and recalculates dynamically; TODAY() returns only the date.

Question 5

What does a green triangle in the top-left corner of a cell typically indicate?

Accepted Answer

A potential error detected by Excel's error checking

Answer

The green triangle is Excel's error indicator, alerting you to a potential issue like a number stored as text or an inconsistent formula.

Excel Practice Test