Excel Vocabulary Review

Absolute Reference

• A function that counts the number of cells containing no values.

• A type of formula in which a cell address is stationary as a formula is filled or copied and pasted throughout a worksheet

• A means in which an Excel file is usable by people with vision, hearing, or other impairments.

• A number format in which the dollar sign is at the left edge of a cell

• A function that counts the number of cells containing values of any data type.

Accessibility

• A type of formula in which a cell address is stationary as a formula illed or copied and pasted throughout a worksheet.

• A function that counts the number of cells containing no values

• A means in which an Excel file is usable by people with vision, hearing, or other impairments.

• A number format in which the dollar sign is at the left edge of a cell.

•  A function that counts the number of cells containing values of any data type.

  
  

Accounting

• A number format in which the dollar sign is at the left edge of a cell.

• A type of formula in which a cell address is stationary as a formula is filled or copied and pasted throughout a worksheet.

• A chart that shows a visual representation of multiple categories of data.

• A copy and paste concept in which data is filled across rows or down columns according to an established data pattern

• The level at which an Excel file in the current Office suite can be used in previous Office suites.

Alt Text

• A type of formula in which a cell address is stationary as a formula is filled or copied and pasted throughout a worksheet.

• A title that defines the rows or columns being plotted on a chart.

• Alternative Text (Alt Text) is the text used to describe an image or chart to define an image or chart for those with accessibility needs.

• A prebuilt format that can be applied to a cell or a range of cells.

• A means in which an Excel file is usable by people with vision, hearing, or other impairments.

Autofill

• A copy and paste concept in which data is filled across rows or down columns according to an established data pattern.

• A type of formula in which a cell address is stationary as a formula is filled or copied and pasted throughout a worksheet.

• A type of formatting in which cells change formats based on their values.

• A note on a cell that can be replied to and resolved and can contain mentions of other people in an organization. 5. A function that counts the number of cells containing no values.

Average

• A function that calculates the average of cells

• A prebuilt format that can be applied to a cell or a range of cells.

• A function that joins two or more strings of text.

• A number format in which the dollar sign is at the left edge of a cell.

Axis Title

• The positioning of text within a cell, both horizontally and vertically.

• A title that defines the rows or columns being plotted on a chart.

• A function that counts the number of cells containing no values.

• A means in which an Excel file is usable by people with vision, hearing, or other impairments.

• A number format in which the dollar sign is at the left edge of a cell.

Cell Alignment

• The distance between the left edge of a cell and the first character of text within a cell.

• A function that counts the number of cells containing values of any data type

• The positioning of text within a cell, both horizontally and vertically.

• A function that calculates the average for a range of cells.

Cell Indentation

• Alternative Text (Alt Text) is the text used to describe an image or chart to define an image or chart for those with accessibility needs.

• A type of formula in which a cell address is stationary as a formula is filled or copied and pasted throughout a worksheet.

• A function that counts the number of cells containing numeric values.

• The distance between the left edge of a cell and the first character of text within a cell.

• The level at which an Excel file in the current Office suite can be used in previous Office suites.

Cell orientation

• The angle of text within a cell.

• The positioning of text within a cell, both horizontally and vertically.

• The distance between the left edge of a cell and the first character of text within a cell

• A note on a cell that can be replied to and resolved and can contain mentions of other people in an organization

• A means in which an Excel file is usable by people with vision, hearing, or other impairments.