business programming excel exam

cell reference

unique identifier of a cell, ex. A2, G56

text aligns to the…

left

numbers align to to the …

right

formulas start with …

an = sign

formula

collection of mathematical expressions

function

prebuilt to automatically do formulas and ensure accuracy

relative reference

gives the fill function freedom to change values

absolute reference

tells excel to absolutely lock a reference in place with $

.csv file

comma separated values, file type for sharing data but not sharing formatting (bold, font, etc)

empty

absence of value, not counted

zero

numeric value that is counted

function to count the number of data points that are numeric values

=count(V1, V2)

function to count the number of cells in a range, any cell that isn’t empty

=counta(V1, V2)

function for counting with criteria

=countif(range, “>#”), must use quotation marks

function for calculating the average

=average(V1, V2)

function for calculating the average under criteria and the average of other cells without criteria

=average(V1, V2, “>#”, V3, V4)

function for randomization between 0 and 1

=rand()

function for randomization between 0 and 100

=rand()*100

function for randomization between x and y

=randbetween(x, y)

.xlsx file

excel file

function to remove spaces

=trim(cell)

function to uppercase first letter of each word

=proper(cell)

function to uppercase all letters

=upper(cell)

function to lowercase all letters

=lower(cell)

filtering

sort by specific conditions and only see data that you filter by

sorting

by a-z, z-a, or custom by x and then by y