Year 9 Test

Microsoft Excel is what type of software?

• Word Processing
• Spreadsheet
• Presentation
• Drawing

The cell address of the highlighted cell is

• C

• A4

• C4

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

• Formula Bar

• Cell

• Template

What function was used to find the lowest grade?

• average

• min

• max

What function was used to find the highest grade?

• min

• sum

• max

Which operator is used to multiply in Excel?

• +

• -

• *

A sales manager has requested the highest sale for the first quarter. Which function will be used?

• SUM

• MAX

• MIN

Columns in a spreadsheet are:

• Vertical
• Horizontal
• right side

What does the Max function do?

• Returns the highest three values in a set of values and ignores text.

• Returns the largest value in a set of values and ignores text.

• Returns the text that you are searching for.

• Returns the smallest value in a set of values and ignores text.

What does the Min function return?

• Returns the smallest three numbers form a set and ignores text.

• Returns the smallest value in a set of values and ignores text.

• Returns the largest three numbers form a set and ignores text.

• Returns the largest value in a set of values and ignores text.