Y8 Lesson 3_ EXCEL FUNCTIONs(SUM,AVERAGE,MAX,MIN,COUNTA,COUNTIF)

Before we begin the quiz, please download the quiz source files. To answer second part of the quiz, you must insert the formulas or functions into this spreadsheet file.

Revision

Excel functions:
=SUM( ), =AVERAGE( ), =MIN( ), =MAX( ), =COUNTA ( ) , =COUNTIF ()

SUM, AVERAGE, MIN, MAX, COUNTA, and COUNTIF functions

Quiz - Part 1

Multiple Choice

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

• &

• #

• =

• *

Multiple Choice

What function was used to find the highest data ?

• AVERAGE

• MIN

• SUM

• MAX

Multiple Choice

The function that lets you add up a range of cells or values

• AVERAGE

• SUM

• MIN

• MAX

Multiple Choice

What function was used to find the highest data ?

• AVERAGE

• MIN

• SUM

• MAX

Multiple Choice

What is the name of the bar in Excel where information appears as you enter data/formula called?

• File Bar

• Help Bar

• Formula Bar

• Window Bar

Multiple Choice

What function was used to find the lowest data ?

• AVERAGE

• MIN

• MAX

• SUM

Multiple Choice

What´s the difference between a formula and a function?

• There is no difference

• Functions are more complicated than formulas

• Formulas are designed by the user and functions are predefined in Excel

• They both start with the =

Multiple Choice

Looking at the data in the picture, which function can be used to find the youngest and oldest athlete?

• MIN & AVERAGE

• MAX & AVERAGE

• MIN & MAX

• COUNTA & MAX

Multiple Choice

The Microsoft Excel ___________function counts the number of cells in a range, that meets a given criteria.

• counta

• countif

• count

• countblank

Multiple Choice

If you want to count cells with any type of data (and not just numbers), simply replace COUNT by________ .

• countblank

• counta

• countb

• max

Quiz: Part 2

Open the Online store sales data in Excel to answer the following questions:

Open Ended

Exit ticket:

Imagine you have a list of student test scores. How would you calculate the percentage of students who scored above 90 using the COUNTIF function?

Poll

Do you require more practical tasks using the SUM, AVERAGE, MAX, MIN, COUNTA, COUNTIF functions?

• yes

• no