Microsoft Excel General Knowledge 2

Question 1

Which keyboard shortcut saves the current workbook in Excel?

Accepted Answer

Ctrl+S

Answer

Ctrl+W

Answer

Ctrl+P

Answer

Ctrl+N

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

A green arrow pointing down

Answer

A blue circle in the center of the cell

Answer

A double-headed arrow on the cell border

Question 3

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

Accepted Answer

.xlsx

Answer

.xls

Answer

.xlsm

Answer

.csv

Question 4

How many rows are available in an Excel 2019 worksheet?

Accepted Answer

1,048,576

Answer

65,536

Answer

1,000,000

Answer

2,097,152

Question 5

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

Accepted Answer

View

Answer

Page Layout

Answer

Data

Answer

Review

Question 6

What happens when you press Ctrl+Z in Excel?

Accepted Answer

Undoes the last action

Answer

Redoes the last action

Answer

Zooms into the worksheet

Answer

Closes the workbook

Question 7

Which of the following is NOT a valid Excel chart type?

Accepted Answer

Pyramid Bar

Answer

Line

Answer

Scatter

Answer

Pie