excel formulas

excel formulas

University

9 Qs

quiz-placeholder

Similar activities

Microsoft Excel

Microsoft Excel

University

12 Qs

Өзіңді тексер! Excel программасы

Өзіңді тексер! Excel программасы

7th Grade - University

13 Qs

BÀI 11A. SỬ DỤNG HÀM SUMIF

BÀI 11A. SỬ DỤNG HÀM SUMIF

9th Grade - University

10 Qs

MS Excel Basic

MS Excel Basic

University

12 Qs

Bài 10A: Sử dụng hàm COUNTIF

Bài 10A: Sử dụng hàm COUNTIF

9th Grade - University

10 Qs

C programming-1

C programming-1

University

13 Qs

TIN 10 BAI 4

TIN 10 BAI 4

12th Grade - University

10 Qs

Función CONTAR

Función CONTAR

KG - Professional Development

10 Qs

excel formulas

excel formulas

Assessment

Quiz

Computers

University

Practice Problem

Hard

Created by

Elnura Alieva

Used 24+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

9 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

how to add all numbers in the photo?

=sum(1:6)

=sum(A1:A6)

=sum(2:7)

=sum(A2:A7)

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

which formula can do the same function as =average(A2:A7)

=(A1+A2+A3+A4+A5+A6)/2

=(A1+A2+A3+A4+A5+A6)/6

=(A2+A3+A4+A5+A6+A7)/6

=(A2+A3+A4+A5+A6+A7)/2

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

WHICH FORMULA CAN FIND OUT HOW MANY NUMBERS WE HAVE IN THIS TABLE?

=COUNT(A1:A10)

=COUNTIF(A1:A10)

=COUNT(B2:B7)

=AVERAGE(A1;A8)

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

HOW MANY COLUMNS ARE IN TABLE IN PHOTO?

6

7

1

2

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

HOW TO COUNT HOW MANY 78 IN THIS TABLE?

=COUNTIF(2:6,78)

=COUNTIF(2:7,78)

=COUNTIF(A2:A6,78)

=COUNTIF(A2:A7,78)

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

WHICH FORMULA FINDS GREATEST NUMBER IN TABLE?

=MAX(A1:A8)

=MAXIMUM(A2:A7)

=MIN(1:8)

=MIN(A2:A7)

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

HOW MANY ROWS IN TABLE?

1

7

6

2

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Computers