Excel

Which function is used to find the total of range of numbers?

• ADD

• SUM

• AUTOSUM

• DOSUM

Which function is used to calculate the average?

• AVERAGE

• AVG

• AVER

• AVRG

Which function is used to count no. of cells containing values?

• DOCOUNT

• COUNT

• COUNTFOR

• IFCOUNT

What is the file extension of excel?

• .abc

• .xls

• .doc

• .ppt

Spreadsheet is a picture editing application.

• True

• False

Which symbol is used for absolute cell reference?

• #

• $

• &

• @

In relative cell reference, cell address _____________ with respect to rows and columns.

• changes

• remain fixed

The intersection of rows and columns form ________

• formula

• function

• cell

• sheet

Choose the correct cell address

• AB

• 1B

• 10C

• A3

Formula to find total for Pencil

• =A2*B2

• =A1*B1

• =B1*C2

• =B2*C2