CAT11

Sum, average, count, and maximum value are examples of what?

• Formulas

• Functions

• Calculations

• Spreadsheet Data

Which symbol is used to start a formula?

• +

• -

• =

• >

Which of the following formulas show the correct use of the SUM function?

• -SUM(H3-H10)

• =SUM(H3:H10)

• =SUM(H3...H10)

• +SUM(H3:H10)

See the following formula. Which of the following formula is the another method of the given formula?

=(B2+C2+D2+E2)/4

• = SUM (B2,C2,D2,E2)

• = MAX(B2:E2)

• = SUM(B2,E2/4)

• = AVERAGE (B2:E2)

Which of the followings can not be performed in Microsoft Excel?

• Creating chart, making mathematical calculations.

• Inserting pictures, creating table.

• Making graphic design

• Using formulas and functions

An excel workbook is a collection of

• Workbooks

• Worksheets

• Charts

• Worksheets and charts

If you type =2*(6-4) in cell A1, what will be the display value?

• 2

• 4

• 6

• 8

The intersection of a row and a column is called this.

• Active Cell

• Chart

• Column

• Row

The bar where information appears as you input data is called ______________.

• file bar

• help bar

• window bar

• formula bar

What is the Sum formula?

• Sum( )

• Sum( )=

• =( )Sum

• =Sum( )