Year 6 Term 3 Final Exam

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

• Formulas

• Functions

• Calculations

• Spreadsheet Data

A cell is the intersection of a row and column?

• True

• False

Displays the both name of application and the name of the spreadsheet.

• Name Box

• Spreadsheet Area

• Worksheet Tabs

• Title Bar

A grid of cells organized into rows and columns in which we enter and store our data.

• Spreadsheet Area

• Name Box

• Insert Function

• All of the above

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

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