Trivia Flashcards

What year was Microsoft Excel first released for the Macintosh?

Answer: 1985

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

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

Answer: COUNTA

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

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

Answer: 1,048,576

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

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

Answer: Ctrl+;

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

What does the TRIM function do in Excel?

Answer: Removes leading and trailing spaces and reduces internal spaces to one

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

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

Answer: Line chart

Line charts are ideal for displaying continuous data trends over time, clearly showing direction and rate of change.

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

Answer: Toggles absolute/relative cell references

F4 cycles through the four reference types: relative (A1), absolute ($A$1), mixed ($A1), and mixed (A$1).

Which Excel feature allows you to automatically fill a series of dates, numbers, or text patterns?

Answer: AutoFill

AutoFill uses the fill handle (small square at the bottom-right of a selection) to extend a series automatically.

What is the correct syntax to look up a value in the first column of a table and return a value from another column using VLOOKUP?

Answer: VLOOKUP(value, table_array, col_index_num, range_lookup)

VLOOKUP syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).

In Excel, what symbol is used to make a cell reference absolute?

Answer: $

The dollar sign ($) locks a row or column reference so it does not change when a formula is copied.

What Excel function calculates the internal rate of return for a series of cash flows?

Answer: IRR

IRR (Internal Rate of Return) calculates the discount rate that makes the net present value of a series of cash flows equal to zero.

Which of the following paste options preserves only the calculated values, not the formulas?

Answer: Paste Values

Paste Values (or Paste Special > Values) pastes only the displayed result of a formula, not the formula itself.

What is the name of the Excel feature that highlights cells based on their content or value?

Answer: Conditional Formatting

Conditional Formatting automatically applies colors, icons, or data bars to cells that meet specified criteria.

How many sheets does a new Excel workbook contain by default in Excel 2016 and later?

Answer: 1

Starting with Excel 2013, a new workbook defaults to a single worksheet named 'Sheet1', changed from the previous default of three sheets.

Which function would you use to combine the text from two or more cells into one cell?

Answer: CONCATENATE

CONCATENATE (or the & operator, or CONCAT in newer versions) joins text strings from multiple cells into a single string.

What does 'PivotTable' allow you to do in Excel?

Answer: Summarize and analyze large data sets interactively

A PivotTable is an interactive tool that quickly summarizes, groups, and analyzes large datasets without changing the original data.

Which Excel function returns the position of a value within a range?

Answer: MATCH

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

What is the file extension for a macro-enabled Excel workbook?

Answer: .xlsm

The .xlsm extension denotes a macro-enabled Excel workbook, while .xlsx files cannot contain VBA macros.

Which Excel tool is used to find the input value needed to achieve a specific formula result?

Answer: Goal Seek

Goal Seek finds the required input value by working backward from a desired formula result.

What does the IFERROR function do in Excel?

Answer: Returns a custom value if a formula produces an error, otherwise returns the formula result

IFERROR evaluates a formula and returns a specified value (like blank or text) if it results in an error, instead of displaying the error code.