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 utility of Excel to fill columns or rows with a series of data is Auto Fill.

It allows users to quickly populate cells with a sequence or pattern based on the initial values entered.

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

In Excel, to calculate the product of numbers, the function used is =PRODUCT().

This function multiplies all the numbers provided as arguments and returns the result.

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.

Explanation

• To protect a worksheet, you can lock cells to prevent changes, formatting, or deletion.
• This is done by using the "Protect Sheet" feature in spreadsheet software like Microsoft Excel or Google Sheets.

Explanation

To zoom an Excel worksheet, you can use:

• The mouse pointer in Print Preview: Click and drag the mouse pointer in the lower right corner of the Print Preview window to zoom in or out.
• The zoom button on the Print Preview toolbar: Click the zoom button (magnifying glass icon) to zoom in or out.
• The zoom command on the View menu: Select View > Zoom > Zoom In/Out or use the shortcuts Ctrl+Plus sign (+) to zoom in or Ctrl+Minus sign (-) to zoom out.

Explanation

To move between worksheets in a workbook in MS Excel, you can use the following shortcuts:

• Ctrl+Page Up: Move to the previous worksheet
• Ctrl+Page Down: Move to the next worksheet