Microsoft Excel Trivia 2

Question 1

What year was Microsoft Excel first released for the Macintosh?

Accepted Answer

1985

Answer

Microsoft Excel was first released in 1985 for the Apple Macintosh, two years before the Windows version.

Question 2

Which Excel function returns the number of cells in a range that are not empty?

Accepted Answer

COUNTA

Answer

COUNTA counts all non-empty cells in a range, including text, numbers, and errors.

Question 3

What is the maximum number of rows in a modern Excel worksheet (Excel 2007 and later)?

Accepted Answer

1,048,576

Answer

Excel 2007 and later supports 1,048,576 rows per worksheet, a massive increase from the 65,536 limit in earlier versions.

Question 4

Which keyboard shortcut inserts the current date into an Excel cell?

Accepted Answer

Ctrl+;

Answer

Ctrl+; (semicolon) inserts the current date as a static value into the active cell.

Question 5

What does the TRIM function do in Excel?

Accepted Answer

Removes leading and trailing spaces and reduces internal spaces to one

Answer

TRIM removes leading and trailing spaces and reduces any internal sequences of spaces to a single space.

Excel Practice Test