Ex_Class(Count,CountA,Excel General)

What formula should be written to calculate total sales (for each product line)?

• =B2*C2

• =MULTIPLY(B2;C2)

• =B2*(1+C2)

• =B2^C2

What result is returned by the function =COUNT(B2:D5)?

• 0

• 3

• 12

• 6

to find out how many persons are there in a certain field, the following function is applied

• average(--:--)

• counta(--:--)

• counta(--;--)

• count(--:--)

to count any fields containing numbers we use:

• countIF function

• countIFs function

• count function

• counta function

the structure of sumif is:

• sumif(range of cells to be added,criteria, range of cells to be tested)

• sumif(range of cells to be tested,criteria,range of cells to be added)

• sumif(criteria,range of cells to be tested)

What does every formula in a spreadsheet start with?

• +

• (

• =

• A number

Which formula is the best (and correct) for adding up a selection of numbers

• sum(A1+A10)

• sum(A1:A10)

• =sum(A1:A10)

• =sum(A1+A10)

Each box on a spreadsheet is called a ...

• row

• box

• cell

• column

Which function calculates the TOTAL (adds all the cells in the range together)?

• SUM

• MIN

• MAX

• AVERAGE

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

• SUM

• MIN

• MAX

• COUNTA