MS-Excel | MCQs

Explanation

The default name of the first sheet in any workbook is Sheet1.

Excel assigns this name automatically.

It can be renamed by the user if desired.

Explanation

In Excel charts, the vertical axis is called the Y-axis.

The Y-axis typically represents values.

The horizontal axis is referred to as the X-axis.

The X-axis represents categories or time.

Explanation

The vertical dimension of a spreadsheet is called a Column.

Columns run from top to bottom and are identified by letters.

The horizontal dimension of a spreadsheet is called a Row.

Rows run from left to right and are identified by numbers.

Explanation

The formula =5 + 2 * 3 follows the order of operations (PEMDAS):

• Multiply 2 and 3: 2 * 3 = 6
• Add 5 to the result: 5 + 6 = 11

Explanation

 Pivot tables are one of Excel’s most powerful features.

A pivot table allows you to extract the significance from a large, detailed data set.

Explanation

In MS Excel, if you want to add a mathematical symbol that can be typed through the keyboard, you should use the "Insert => Symbol" option.

Explanation

• Another name for a cell address is cell reference.
• It identifies a specific cell in a spreadsheet by its column letter and row number, such as A1 or B2.

Explanation

In Excel, the term "filter" refers to temporarily hiding certain data based on specific criteria.

This helps in focusing on specific subsets of data without deleting or altering the original dataset.

Explanation

The small squares arranged in rows and columns in Excel are called cells.

Each cell is the intersection of a row and a column and can hold data.

Explanation

The Excel feature that allows you to freeze rows and columns so they remain visible while scrolling is Freeze Panes.

This feature enhances navigation by keeping important headings in view.