Excel Window

Shows the formula that you type in a cell

• name box

• formula bar

• sort and filter

• title bar

Shows the cell reference (address) of the active cell

• name box

• formula bar

• sort and filter

• title bar

Used to put the values in order

• name box

• formula bar

• sort and filter

• title bar

Used to quickly find the function for SUM, Average, Max, Min & Count

• name box

• autosum

• sort and filter

• fx

Used to Insert function (any function)

• name box

• merge and center

• sort and filter

• the Fx button

The active cell in the attached window

• D8

• A1

• B1

• A2

Used to make a range of cells become one cell and add text to the middle of the range

• name box

• merge and center

• sort and filter

• fx

Used to reduce the number of decimal places in a value

• name box

• formula bar

• decrease decimal

• title bar

Function used to find the highest value in a range

• MAX

• Median

• SUM

• Average

Function used to find the middle value in a range

• MAX

• Median

• SUM

• Average