Microsoft Excel Trivia Questions and Answers 3

Question 1

Which company developed VisiCalc, the first spreadsheet application that inspired Excel?

Accepted Answer

Software Arts

Answer

VisiCalc was created by Dan Bricklin and Bob Frankston at Software Arts in 1979 and published by VisiCorp. It was the first electronic spreadsheet and a revolutionary application.

Question 2

What does the abbreviation CSV stand for, a common file format used with Excel?

Accepted Answer

Comma Separated Values

Answer

CSV stands for Comma Separated Values, a plain text file format where data values are separated by commas and rows are separated by line breaks.

Question 3

What is the maximum number of characters that can be stored in a single Excel cell?

Accepted Answer

32,767

Answer

A single Excel cell can contain up to 32,767 characters, though only 1,024 characters can be displayed in the cell (the full content is visible in the formula bar).

Question 4

What feature introduced in Excel 2013 allows you to create interactive data exploration visualizations?

Accepted Answer

Power View

Answer

Power View was introduced as an interactive data exploration and visualization tool that creates interactive charts, maps, and other visualizations from data models.

Question 5

What is the name of the function key that toggles between showing formulas and their results in Excel?

Accepted Answer

Ctrl+` (grave accent)

Answer

Ctrl+` (the grave accent key, usually above Tab) toggles the display between showing formula text in cells and showing calculated results.

Excel Practice Test

Excel Practice Test

Microsoft Excel Trivia Questions and Answers 3