Question 1

How many columns are available in a standard MS Excel worksheet?

Accepted Answer

MS Excel (2007 onwards) supports 16,384 columns (A to XFD) and 1,048,576 rows per worksheet.

Question 2

What is the purpose of the AutoSum feature in MS Excel?

Accepted Answer

AutoSum automatically detects and inserts a SUM formula for the selected range of numeric cells.

Question 3

Which keyboard shortcut is used to save a file in MS Excel?

Accepted Answer

Ctrl + S is the standard shortcut to save an open document in MS Excel and most applications.

Question 4

What is the default file extension for a workbook saved in MS Excel 2016 or later?

Accepted Answer

.xlsx is the standard XML-based format for Excel workbooks in modern versions (2007 onwards).

Question 5

Which function in MS Excel is used to find the total sum of a range of cells?

Accepted Answer

The SUM function calculates the sum of numeric values in a specified range of cells.

Question 6

In MS Excel, what does the cell reference 'C5' represent?

Accepted Answer

Cell references in Excel follow the format Column Letter + Row Number, so C5 means Column C, Row 5.

Question 7

Which feature in MS Excel allows you to freeze the header row so it remains visible while scrolling?

Accepted Answer

Freeze Panes is the Excel feature that keeps rows or columns visible while scrolling through the rest of the worksheet.

Question 8

In MS Excel, what does the AutoSum feature automatically calculate when you select a range of numbers?

Accepted Answer

AutoSum automatically inserts a SUM() formula to calculate the total of selected numeric values in Excel.

Question 9

In MS Excel, which keyboard shortcut is used to insert a new row?

Accepted Answer

Right-clicking on a row and selecting 'Insert' from the context menu is the standard method to insert a new row in Excel.

Question 10

In MS Excel, which function is used to find the largest value in a range of cells?

Accepted Answer

MAX() is the standard Excel function that returns the maximum value from a given range of cells.

Question 11

What is the default file extension for a Microsoft Excel workbook in modern versions?

Accepted Answer

The .xlsx format is the default extension for Excel 2007 and later versions, replacing the older .xls format.

Question 12

How many columns are available in a single MS Excel worksheet?

Accepted Answer

Modern MS Excel worksheets contain 16,384 columns (labeled A to XFD) and 1,048,576 rows.

Question 13

Which function in MS Excel is used to count cells that meet a specific criteria?

Accepted Answer

COUNTIF() function counts the number of cells in a range that satisfy a specified condition or criteria.

Question 14

What is the maximum number of rows that can be used in a single MS Excel worksheet?

Accepted Answer

MS Excel 2007 and later versions support a maximum of 1,048,576 rows per worksheet, which is significantly higher than the 65,536 rows limit in older versions.

Question 15

In MS Excel, if you want to prevent a user from editing specific cells while allowing edits in other cells, which feature should you use?

Accepted Answer

Protect Sheet allows you to lock specific cells and restrict editing, while other unlocked cells remain editable after sheet protection is applied.

CAPF AC MS Excel

MS Excel — Practice Questions