Microsoft Excel General Knowledge

Question 1

Which keyboard shortcut saves the current workbook in Excel?

Accepted Answer

Ctrl+S

Answer

Ctrl+S saves the active workbook, prompting for a filename if it hasn't been saved before.

Question 2

What does the AutoFill handle look like in Excel?

Accepted Answer

A small square at the bottom-right corner of a selected cell

Answer

The AutoFill handle is the small green square that appears at the bottom-right corner of a selected cell or range.

Question 3

What is the default file extension for Excel workbooks in Excel 2016 and later?

Accepted Answer

.xlsx

Answer

The .xlsx format is the default XML-based format introduced in Excel 2007 and used in all modern versions.

Question 4

How many rows are available in an Excel 2019 worksheet?

Accepted Answer

1,048,576

Answer

Since Excel 2007, each worksheet supports exactly 1,048,576 rows (2^20).

Question 5

Which tab on the Excel ribbon contains the 'Freeze Panes' option?

Accepted Answer

View

Answer

Freeze Panes is located in the Window group on the View tab.

Excel Practice Test