8.3 Advanced Spreadsheets FFA

Front

Which symbol must all formula begin with? Options: =, +, (, @

Back

=

Front

What formula must be written in cell G6 to divide cell C3 by C6?

Back

=C3/C6

Front

What symbol can we use to make a cell reference stick when its replicated?

Back

$

Front

An "If Statement" will:

Back

return a result based on a condition

Front

What will the following "If Statement" return? Options: Yes, No, Good, Bad

Back

Good

Front

What will the following "If Statement" return? Options: Yes, No, Good, Bad

Back

Bad

Front

What formula is written in C20 to calculate the total hours needed?

Back

=SUM(C6:C19)

Front

What formula is written in F20 to calculate the average target %? Options: =SUM(F6:F19), =MAX(F6:F19), =AVERAGE(F6:F19), =MIN(F6:F19)

Back

=AVERAGE(F6:F19)

Front

Which is the correct function to count all the cells in range A1 to A5 that are equal to 5? Options: =COUNTIF(A1:A5,"5"), =COUNTIF(A1:A5,=5), =COUNT(A1:A5), =COUNTIF(A1-A5,"5")

Back

=COUNTIF(A1:A5,"5")

Front

What would be a correct formula for SUM  in excel?

Back

=SUM(B3:B9)