MS Excel Glossary With MCQs & Ans, And Quiz

The MS Excel Glossary is also popularly known as Microsoft Excel Terms. To gain more exposure, these explain the main terms of Microsoft Excel commands, tools, features, and other parts.

A complete List o MS Excel Glossary

Excel Glossary

MCQ & Ans

Quiz/Practice Test

Workbook: An Excel file that contains one or more worksheets.

Worksheet: A single sheet inside a spreadsheet containing rows and columns for data organisation and analysis.

Cell: The area where a row and a column meet on a worksheet. Cells can hold data, formulas, or functions.

Range: In a worksheet, a range is a set of cells that have been selected together and can be used for formatting, calculations, or data analysis.

Formula: refers to an equation used to calculate or operate on worksheet data.

Function: an Excel built-in operation that carries out a particular task, like calculating averages or counting cells.

Chart: A visual display of data in a worksheet that can be used to show patterns or trends.

Pivot Table: A worksheet’s pivot table is a tool used to summarize and analyze large amounts of data.

Filter: a function that enables users to arrange and display particular data in a worksheet according to criteria

Conditional formatting: The ability to format cells based on particular requirements or conditions, such as highlighting cells that meet a predetermined threshold, is known as conditional formatting.

Freeze Panes: A function that enables users to scroll through worksheet data while keeping a subset of the rows or columns visible.

Sort: Users can arrange data in an ascending or descending order based on specific criteria, such as alphabetical order or numerical value, using the sort feature.

AutoFill: It is a feature that enables users to quickly fill a row of cells with a pattern, such as a series of matching dates or numbers.

Validation: feature that lets users limit the kinds of data that can be entered into a cell by, for example, requiring a specific format or setting a maximum range of values.

Formula auditing: Lets users follow the connections between cells and formulas to find problems or errors in a worksheet.

Named Ranges: This function makes it simple to refer to and use a specific range of cells in a worksheet by allowing users to give it a name.

Excel’s macro feature enables users to automate repetitive tasks by recording a series of operations and playing them back at a later time.

Goal Seek: A function or feature that enables users to discover the input value necessary to produce a particular output value in a formula or function.

Solver: A tool called a solver is used to find the best solution to a problem by modifying input values in accordance with objectives and constraints.

Conditional Summing: A feature that enables users to sum data in a range depending on particular standards or conditions, such as adding up all sales for a particular product.

Grouping: A feature that enables users to group rows or columns together so that they may execute operations on the entire group at once, such as hiding or formatting.

Text to Columns: A feature that lets users to separate text in a single cell into multiple columns using a delimiter or character of their choice.

Column: A vertical line of cells in a worksheet.

Column Heading: The letter or letters at the head of a column that indicate its location within the worksheet.

Column Label: A text string that is used to specify a particular column and can be customized to include further details or context.

Row: A “row” is a horizontal series of lines that runs across the worksheet. Rows are identified by number headings; the first row began with the number 1.

Row Heading: The row heading is the number at the left-hand side of the worksheet that indicates each row. Row headings are useful for identifying or selecting a specific row or rows.

Row Height: The row height is the amount of vertical space each row occupies on the worksheet. To change rows height taller or shorter, you can adjust the row height.

Default Row Height: Default row height is an automatic setting for each row and is determined by the font size and other settings in the default cell. The default row height for the default Calibri font is 14.4.

Row Selection: Row selection is the process of selecting one or more rows in an Excel worksheet using mouse or keyboard shortcuts.

Row Insertion: The process of adding a new row to an Excel worksheet using mouse from ribbon tabs or keyboard shortcuts.

Row Deletion: the process of removing a row from an Excel worksheet. using the mouse from ribbon tabs or keyboard shortcuts

Merge Cells: A feature that lets users combine multiple cells in a row or column into a single cell. This can affect the content, format, layout and alignment and cell references.

Cell Address (Reference): A unique intersection of a column number and a row letter that tells you where a cell is in the worksheet.

Relative Reference: A type of cell reference that is based on the relative position of a cell to the cell that contains the formula or function. This position changes when the formula or function is moved to a different place in the worksheet.

Absolute Reference: A type of cell reference that is fixed and does not change even when the formula or function is copied or moved to a different place in the worksheet. This type of cell reference can be used by a dollar sign ($) before the cell reference.

Mixed Reference: A type of cell reference that has both relative and absolute references. It can be used to partially fix part of a cell reference’s column or row.

Circular Reference: A situation in which a formula or function refers to the cell that contains the formula or function. This can cause an error in the worksheet.

External Reference: A situation in which a formula or function refers to the cell that contains the formula or function. This can cause an error in the worksheet.

Named range: A range of cells that have been given a name. It can be used instead of the cell reference in formulas and functions.

Drop-down list: A list of options that appear when you click the arrow adjacent to the Name Box, including a list of named ranges and recent cell references.

Insert Functions: Feature that allows you to search for and insert functions into your calculations by displaying a list of available functions, descriptions, and argument requirements.

Arguments: The numbers or cell references that you provide to a function as inputs for the calculation. The commas supersede the arguments that are enclosed in parentheses.

Excel Library: A collection of Excel functions that are organised into categories such as Math & Trig, Statistical, and Date & Time.

Function Wizard: A dialogue box in Excel that helps you create a formula that uses a certain function by letting you choose the function, parameters, and cell range.

Syntax: The Specific format and rules for using a given Excel function, including the function’s name, parentheses, and parameters.

Nested functions: One function is used as an input within another function, enabling for more complicated calculations to be performed within a single formula.

AutoSum: An Excel’s shortcut button for easily inserting the SUM function to calculate the sum in a range of cells.

Print Gridlines: An option that allows you to print the gridlines along with the worksheet data.

Gridline Visibility: If the gridlines are displayed or not on the worksheet. To show or hide them go to “View” Tab, then click check or uncheck mark in the “Show” group.

Active cell: A cell that is currently being selected or used in an Excel worksheet.

Formatting: In Excel, Formatting refers to the process of changing how the data in a cell looks. Any changes you make to the way a cell looks will be made to the active cell.

Active Sheet Tab: An active sheet tab indicates that it is currently highlighted when you select it or do work in its worksheet.

Range of Cells: A range of cells is a group of adjacent/selected cells in an Excel worksheet.

Data Entry: Data entry in Excel refers to the process of inputting data into a cell.

An Excel file that contains one or more worksheets is called
1. Workbook
2. Worksheet
3. Range of cells
4. Any of the above

Worksheet is a
1. Single sheet
2. Double-sheet
3. Workbook
4. Range of cells
The area where a row and a column meet on a worksheet is called___
1. Workbook
2. Worksheet
3. Range of cells
4. Cell
____is a set of cells that have been selected together
1. Workbook
2. Range
3. Sheet
4. Line
is a user-defined operation that refers to an equation used to calculate or operate on worksheet data.
1. Function
2. Formula
3. Function or Formula
4. Function and Formula
___is an Excel built-in operation that carries out a particular task, like calculating averages or counting cells.
1. Function
2. Formula
3. Function or Formula
4. Function and Formula
___is a visual display of data in a worksheet that can be used to show patterns or trends
1. Chart
2. Conditional Formatting
3. Format
4. Data Validation
A worksheet’s ___ is a tool used to summarize and analyse large amounts of data
1. Data Validation
2. Conditional Formatting
3. Format
4. Pivot Table
___is a function that enables users to arrange and display particular data in a worksheet according to criteria
1. Arrange
2. Filter
3. Sheet
4. Find and Select
5. Merge and Center
The ability to format cells based on particular requirements or conditions, such as highlighting cells that meet a predetermined threshold, is known as___
1. Data Validation
2. Format
3. Conditional Formatting
4. Pivot Table
A function that enables users to scroll through worksheet data while keeping a subset of the rows or columns visible.
1. Freeze Panes
2. Selection Pane
3. Navigation Pane
4. None of the above
Users can arrange data in an ascending or descending order based on specific criteria, such as alphabetical order or numerical value, using the sort feature This is called as___
1. Arrange
2. Sort
3. Sheet
4. Find and Select
___ is a feature that enables users to quickly fill a row of cells with a pattern, such as a series of matching dates or numbers
1. Arrange
2. Find
3. Filter
4. Autofill
___is a feature that lets users limit the kinds of data that can be entered into a cell by, for example, requiring a specific format or setting a maximum range of values.
1. Validation
2. Format
3. Conditional Formatting
4. Pivot Table
___lets users follow the connections between cells and formulas to find problems or errors in a worksheet.
1. Validation
2. Format
3. Conditional Formatting
4. Pivot Table
___function makes it simple to refer to and use a specific range of cells in a worksheet by allowing users to give it a name.
1. Named Ranges
2. Range of cells
3. Function name
4. Cells
___macro feature enables users to automate repetitive tasks by recording a series of operations and playing them back at a later time.
1. Workbook’s
2. Worksheet’s
3. Range of cells
4. Any of the above
___a function or feature that enables users to discover the input value necessary to produce a particular output value in a formula or function.
1. Macros
2. Goal Seek
3. Consolidate
4. Flash Fill
___is a feature that lets users to separate text in a single cell into multiple columns using a delimiter or character of their choice
1. Text to Columns
2. Text to Rows
3. Column heading
4. Row heading
What is a Column in Excel?
1. A vertical line of cells in a worksheet
2. A horizontal line of cells in a worksheet
3. A diagonal line of cells in a worksheet
4. A horizontal line of the sheet in a worksheet

[qsm quiz=1]

FAQs on Excel Terminology:

What is an MS Excel Glossary?

The MS Excel Glossary is also popularly known as Microsoft Excel terms. These explain the main terms of the Microsoft Excel commands and tools feature, or other parts to gain more exposure.

What is a row insertion in Excel?

It is the process of adding a new row to an Excel worksheet using mouse from ribbon tabs or keyboard shortcuts.

What is Formatting?

Formatting in Excel involves changing the appearance of cells and data, including fonts, colors, borders, and number formats, to enhance readability and presentation.

What are Filtering and Sorting?

Filtering allows you to display specific data based on criteria, while sorting rearranges data in ascending or descending order based on selected columns.

What is a pivot table?

A PivotTable is a dynamic table that summarizes and analyzes large datasets, allowing users to create custom reports and perform in-depth analysis.

MS Excel Glossary with MCQs & Ans, and Quiz – 2023

Table of Contents