Excel: more functions

Excel: more functions

9th - 12th Grade

12 Qs

quiz-placeholder

Similar activities

Câu hỏi về hàm SUMIF trong Excel

Câu hỏi về hàm SUMIF trong Excel

9th Grade - University

10 Qs

Excel - функции за 9 клас 2023

Excel - функции за 9 клас 2023

9th Grade

12 Qs

Câu hỏi về hàm COUNTIF và SUMIF trong Excel

Câu hỏi về hàm COUNTIF và SUMIF trong Excel

9th Grade

14 Qs

TRẮC NGHIỆM HÀM TRONG EXCEL

TRẮC NGHIỆM HÀM TRONG EXCEL

11th Grade

10 Qs

Khám Phá Hàm COUNTIF, SUMIF, IF Trong Excel

Khám Phá Hàm COUNTIF, SUMIF, IF Trong Excel

9th Grade

16 Qs

Câu hỏi về hàm COUNTIF trong Excel

Câu hỏi về hàm COUNTIF trong Excel

9th Grade

12 Qs

Hàm SUMIF - Tin 9

Hàm SUMIF - Tin 9

9th Grade

10 Qs

Excel: more functions

Excel: more functions

Assessment

Quiz

Computers

9th - 12th Grade

Hard

Created by

Nicola Woods

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

To find the highest number

=max(a1:a8)

=max(a2:a8)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

To sum all the numbers less than 33

=sum(a2:a8,<33)

=sumif(a2:a8,"<33")

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

To count all the numbers

=countif(a2:a8)

=count(a2:a8)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

To find the average of all the numbers

=avg(a2:a8)

=sum(a1+a2+a3+a4+a5+a6+a7+a8)/7

=average(a2:a8)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

To add 2 numbers 12 and 55

=sum(a2:a6)

=a2+a6

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

According to a given criteria if age is greater than or equals to 18 display "License Granted" else "Denied". The age is in cell a4

=if(a4>=18,"License Granted","Denied")

=if(a4 >=18,License Granted,Denied)

=if(a4>18,"License Granted","Denied")

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the formula to count the number of text values

=COUNTA(A1:C1)

=COUNT(A1:C1)

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?