excel

normal algebraic precedence

BEDMAS

mixed cell references

Either absolute row or column but not both A $6

COUNT

The number of cell locations in a range that contain a numeric character

COUNTA

The number of cell locations in a range that contain a text or numeric character

SQRT

The positive square root of a number

number format

Two decimal places

formulas

allow you to perform mathematical calculations on numbers in cells also known as values always start with an equals sign usually right-aligned

sheet tab

allows you to move between sheets located near the bottom of the screen

shortcut method

automatically adjust (autofit) column width so that it's just wide enough for the widest entry double clicking right column heading border or by using autofit column

autofill

automatically fills in cells or copies the contents of a cell to adjacent cells

formulas use what for referencing

cell addresses rather than the actual contents

argument

cell reference that said function is to act upon. contains reference operator

occurs after cell deletion

cells automatically shift to fill the space

relative reference

changes when it's copied or dragged to another part of the spreadsheet eg: A4

select single cell

click mouse pointer on a cell

select row

click row heading

merge and center

combine two or more cells and centers the content within the group of cells

enter

confirm entry in active cell

text orientation

control the direction of text or rotate it to whatever degree you select

setting the column width of multiple columns

ctrl then select home>cells group>format option

active cell

currently selected and is shown on screen with a darker frame around it than other cells

reference operator

describes the set of cells that the function is to act on. Two types, range (colon) union (comma)

page break preview

display smaller version of your spreadsheet showing all the pages which page the columns and rows will be printed on

formula bar

displays contents of the active cell

range of cells selection

drag from the first cell to the last cell of a range

White fat cross

equivalent to I beam

spreadsheet

grid of rows and columns used to enter and manage numeric information, create charts, and for a variety of business and scientific applications

to select non-adjacent cells

hold ctrl as you select the others

non-adjacent cells selection

hold the ctrl key as you click/drag through additional cells

text

known as labels contain letter and combinations of numbers and special characters cannot be used in mathematical calculations left aligned

columns are labelled from

left to right beggining with a to xfd. rows are labelled down the left side of the worksheet with numbers 1 through 1048576

autofit row height

makes it just high enough for the tallest entry,double clicking bottom row heading border

two-headed arrow

move cursor over right hand side of column header until it appears, drag cursor to desired width

two parts of function

name of function,argument

print preview pane

preview entire pages of your worksheet before printing

cell

rectangle where a column and a row intersect

range

rectangular selection of more than one cell one cell active(usually the first one)

range

reference operator, means all cells included

union

reference operator, uses a comma just individual cells listed

the vertical line

represents the insertion point

Ctrl + home

return to A1 first cell

insertion technique

select a range of cells the same size as the cells you want to insert, select the cells command on the insert menu, select the direction you want to shift the existing cells(right or down) click OK

all cells on a worksheet

select all button

comma style

separates groups of three digits in numbers greater than 999

name box

shows cell address of the active cell

operators

signal mathematical operations + × ÷ - simplest operators are arithmetic operators

absolute references

signal permanent reference to a cell indicated by a dollar sign $B $7

fill handle

skinny cross, lower right corner of a selection, then you drag it down or to the right to copy selection to adjacent cells(autofill)

two types of sorting

sort ascending and sort descending, the data can be organised alphabetically, numerically or chronologically depending on the type of data

STDEV

standard deviation for a group of numbers based on

three types of data in excel

text, numbers, formulas

adjusting column width

two-headed arrow, shortcut method, setting column width of multiple columns

function

type of formula that manipulates numerical data. have two parts, name, argument, groups functions by categories

autosum

use to enter a formula with the sum function and make educated guess that is usually accurate about which cells you want to add together

Tab and arrow keys

used to navigate through the spreadsheet

formula

values always start with equals sign represent mathematical calculations or expressions right aligned

numbers

values contain characters 0-9 and numeric characters usually right-aligned can be used in mathematical calculations

wrap text

wrap text within a cell so the content can be visible even if the column width is too short for the cell content to fit