Trivia Questions and Answers Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning โ missed cards come back until you master them.
Read the first 6 Trivia Questions and Answers flashcards as text
Which company developed VisiCalc, the first spreadsheet application that inspired Excel?
Answer: Software Arts
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.
What does the abbreviation CSV stand for, a common file format used with Excel?
Answer: Comma Separated Values
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.
What is the maximum number of characters that can be stored in a single Excel cell?
Answer: 32,767
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).
What feature introduced in Excel 2013 allows you to create interactive data exploration visualizations?
Answer: Power View
Power View was introduced as an interactive data exploration and visualization tool that creates interactive charts, maps, and other visualizations from data models.
What is the name of the function key that toggles between showing formulas and their results in Excel?
Answer: Ctrl+` (grave accent)
Ctrl+` (the grave accent key, usually above Tab) toggles the display between showing formula text in cells and showing calculated results.
Which Excel feature, introduced in 2015, lets users ask questions about their data in natural language?
Answer: Tell Me / Search
The Tell Me feature (later renamed to Search) added a search bar where users can type what they want to do in plain language and Excel finds the relevant command or feature.