Microsoft Excel Trivia 2

Question 1

What year was Microsoft Excel first released for the Macintosh?

Accepted Answer

1985

Answer

1982

Answer

1987

Answer

1990

Question 2

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

Accepted Answer

COUNTA

Answer

COUNT

Answer

COUNTBLANK

Answer

COUNTIF

Question 3

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

Accepted Answer

1,048,576

Answer

65,536

Answer

524,288

Answer

2,097,152

Question 4

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

Accepted Answer

Ctrl+;

Answer

Ctrl+D

Answer

Ctrl+T

Answer

Ctrl+Shift+D

Question 5

What does the TRIM function do in Excel?

Accepted Answer

Removes leading and trailing spaces and reduces internal spaces to one

Answer

Removes all spaces from text

Answer

Cuts text to a specified length

Answer

Removes numeric characters from text

Question 6

Which Excel chart type is best suited for showing data trends over time with continuous data?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Radar chart

Question 7

What does the F4 key do when editing a cell formula in Excel?

Accepted Answer

Toggles absolute/relative cell references

Answer

Deletes the current cell

Answer

Opens the function wizard

Answer

Saves the workbook