Microsoft Excel Vocabulary

The term 'Absolute Value' in Microsoft Excel is defined as:

• The value of a number without regard to its sign

• The sum of all values in a range

• The average of a set of numbers

• The maximum value in a dataset

The term 'Autofill' in Microsoft Excel is defined as:

• A feature that automatically fills cells with data based on the pattern of the selected cells.

• A tool used to create charts and graphs from data.

• A function that checks for errors in formulas.

• A command to sort data alphabetically.

The term 'Backstage' in Microsoft Excel refers to:

• A feature that allows users to manage files and data about them, including opening, saving, printing, and sharing Excel files.

• A tool used for creating charts and graphs in Excel.

• A function for performing complex calculations in Excel.

• A setting for adjusting the appearance of Excel worksheets.

Define the term 'Cell' as used in Microsoft Excel.

• A cell is a rectangular area in a worksheet that is used to enter data.

• A cell is a type of chart used in Excel.

• A cell is a function in Excel that performs calculations.

• A cell is a tool for formatting text in Excel.

Define the term 'Cell Reference' as used in Microsoft Excel.

• A unique identifier for a cell, formed by combining the column letter and row number.

• A formula used to perform calculations in a spreadsheet.

• A tool for formatting cells in Excel.

• A feature to sort data in a spreadsheet.

Define the term 'CONCATENATE' as used in Microsoft Excel.

• A function to merge text from multiple cells into one cell

• A function to calculate the sum of a range of cells

• A function to find the average of a set of numbers

• A function to sort data in ascending order

Conditional Formatting in Microsoft Excel is used to:

• Change the font style of text

• Apply different colors to cells based on their values

• Sort data in ascending order

• Create charts and graphs

The term 'COUNTIF' in Microsoft Excel is used to:

• Count the number of cells that meet a single condition.

• Sum the values in a range that meet a single condition.

• Count the number of cells in a range regardless of any condition.

• Find the average of values in a range that meet a single condition.

Define the term 'Export' as used in Microsoft Excel.

• A feature to import data from other software

• A feature to save data in a different format

• A feature to delete data

• A feature to format data

Define the term 'Filter' as used in Microsoft Excel.

• A tool to sort and display specific data based on criteria

• A feature to create charts and graphs

• A function to perform calculations

• A method to protect a worksheet