Vocabulary Quizlet Pt4 Working with Numbers & Formulas

Auto Fill

A feature that generates and extends values into adjacent cells based on the values of selected cells.

Cell Styles

A combination of a font, text color, cell color, and other font attributes applied to a single cell.

Accounting Number Format

Displays numbers with a dollar sign to the left of the number, inserts a comma every three positions to the left of the decimal point, an displays numbers to the nearest cent (hundredths place)

Percent Style

Formats numbers as percentages with the % symbol after the number and no decimal places

Comma Style

Displays two digits to left of decimal point and places a comma every three positions

Increase Decimal

Used to display additional decimal places in a cell for a more precise value.

Decrease Decimal

Decreases one decimal place at a time. Values are rounded when decimals are decreased.

Clear

To remove all of the formatting applied to a cell or range of cells.

Sort & Filter

Gives you the ability to refine a column of data within a table to isolate the key components you need.

Sort

To arrange data alphabetically, numerically, or chronologically.

Remove Duplicates

Automatically searches for and eliminates identical entries from a spreadsheet

Formula

An equation designed by a user that calculates a new value from values currently in a worksheet.

Operators

Special tokens that represent computations like addition, multiplication and division

Number Format

A format that controls how numerical data is displayed, including the use of commas, dollar signs and number of decimal places

Relative Cell Reference

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.

Function

A predefined, built-in formula not created by a user.

Fill

Copy a cell's contents and/or formatting into an adjacent cell or range

Paste Options

Open a menu of options for formatting the pasted text.

AutoSum

A function that calculates (by default) the total from the adjacent cell through the first non numeric cell using the SUM function.

Sum

Used to find the addition of a range of numbers.

Average

Used to find the Mean of a range of numbers.

Min

Used to find the lowest figure in a range of numbers.

Max

Used to find the highest figure in a range of numbers.

Order of Operations

The rules Excel follows to calculate any formula that contains two or more operators.

Show Formulas

A command that displays the formula in each cell instead of the resulting value.

Format Date

Used to choose the date format for a cell

Format Time

Used to choose the time format for a cell.

Define Name

Used to apply a text label to a single or range of cells.

Name Box

Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar.

Absolute cell reference

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet.

Mixed cell reference

A cell reference that uses an absolute column or row reference, but not both.

RIGHT

returns a specified number of characters starting from the end of a block of text

LEFT

returns the specified number of characters starting at the left (beginning) of a text string

MID

returns the specified number of characters from the middle of a text string, based on a starting position and the number of characters.

UPPER

A function that converts text to uppercase letters

LOWER

A function that converts all uppercase letters to lowercase

PROPER

A function that capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter

CONCAT

Combines up to 255 strings of text, values, or characters in a single cell.

COUNT

A function that determines how many cells in a range contain a number.

COUNTA

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

COUNTBLANK

A function that counts the number of blank cells in a range.

IF

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

COUNTIF

A logical function that counts the cells that meet specific criteria in a specified range.

SUMIF

A statistical function that calculates the total of a range of values when a specified condition is met

AVERAGEIF

A statistical function that calculates the average of values in range when a specified condition is met

Hide

Used to conceal columns or rows that don't have to be visible but can't be deleted.

Outline

Allows you to hide/show and subtotal different sections of data

Subtotal

Used to insert subtotal rows at each designated field change in a sorted range of data

Outline Symbols

Icons that add controls next to the row and column headings to change the view of an outlined worksheet.

Group

Used to connect rows or columns of data that have been sorted and subtotaled.

Ungroup

Used to disconnect a range of grouped cells

Freeze Panes

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.

Link

Used to create a clickable link within your worksheet for navigation.

New Window

Allows users to create a mirror image of the current worksheet so you can work on different parts at the same time.

Split

Used to divide a window into different panes that can be scrolled through independent of each other.

Arrange All

Command that tiles and stacks all open windows on the screen so that they are all visible.

Hide/Unhide

Hiding a row or column removes the information from view. However, the information is not deleted, and can be viewed by unhiding.

SEARCH

Returns the position of a specific character, word, or phrase within a block of text

LEN

Returns the length, in number of characters, of a block of text

TEXTJOIN function

Combines up to 252 strings of text, values, or characters in a single cell and uses a delimiter to separate the strings

Combining Functions

The result of adding, subtracting, multiplying and/or dividing two or more functions