NEW
Font size
WorksheetsEXCEL FUNCTIONS
Total questions: 10
Worksheet time: 4mins
What function was used to find the lowest grade?
average
sum
min
max
To display the Letter Grade Equivalent, we can use the ___ function.
if
count
average
sum
To sort names in a worksheet, we can use this button.
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
to count any fields containing numbers we use:
countIF function
counta function
count function
countIFs function
A company needs to highlight with red the salaries more than 8000
it should use the bucket filler
it should use the highlighter
it should use the conditional formatting
it uses the (A) button on top of the home tab
the structure of countif is:
contif(criteria,range of cells)
countif(range of cells, criteria, range of cells)
countif(range of cells, criteria)
the structure of sumif is:
sumif(range of cells to be sdded,criteria, range of cells to be tested)
sumif(criteria,range of cells to be tested)
sumif(range of cells to be tested,criteria,range of cells to be added)
if statement structure is:
if(value-if-true,logical-test,value-if-false)
if(logical-test,value-if-false-value-if-true)
if(logical-test,value-if-true,value-if-false)
