Excel - Eng+Vie - Sort & Filter + Min + Max + Average

Excel - Eng+Vie - Sort & Filter + Min + Max + Average

7th Grade

59 Qs

quiz-placeholder

Similar activities

ICT Web Design Essentials Review

ICT Web Design Essentials Review

7th - 8th Grade

60 Qs

Y7 Assessment

Y7 Assessment

7th Grade

54 Qs

Second Semester – Grade 7 Revision Sheet

Second Semester – Grade 7 Revision Sheet

7th Grade

55 Qs

ข้อสอบปลายภาค 1/2566 วิชาคอมพิวเตอร์และสารสนเทศเพื่องานอาชีพ

ข้อสอบปลายภาค 1/2566 วิชาคอมพิวเตอร์และสารสนเทศเพื่องานอาชีพ

6th - 8th Grade

60 Qs

ANALISIS DATA KELAS 7 SMP

ANALISIS DATA KELAS 7 SMP

7th Grade

60 Qs

RANGKING 1 PANDIG SPEFRA 2022

RANGKING 1 PANDIG SPEFRA 2022

7th - 9th Grade

55 Qs

Form # Word and Excel

Form # Word and Excel

7th Grade

60 Qs

Computer Quiz

Computer Quiz

7th Grade

58 Qs

Excel - Eng+Vie - Sort & Filter + Min + Max + Average

Excel - Eng+Vie - Sort & Filter + Min + Max + Average

Assessment

Quiz

Computers

7th Grade

Practice Problem

Medium

Created by

Hương Thanh

Used 2+ times

FREE Resource

AI

Enhance your content in a minute

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

59 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Hàm Sum có ý nghĩa gì ?

Tính trung bình

Tìm số nhỏ nhất

Tìm số lớn nhất

Tính tổng

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Muốn sắp xếp dữ liệu thì bạn có thể chọn 1 trong 2 thẻ sau:

Data

Filter

Data

Home

Data

View

Data

Formular

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Lệnh Sort A to Z và Sort Z to A nằm trong nhóm lệnh nào sau đây?

Sort and Filter

Connections

Data Tools

4.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Media Image

Xác định công thức đúng khi tính tổng điểm của bạn Thanh trong bảng tính theo ảnh

=Sum (C6:H6)

=Sum(C6:H6)

=SUM(C6:H6)

=sem(c6:h6)

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Bạn B đã sử dụng công thức sau để tính điểm trung bình cho bạn Hoàng trong danh sách. Theo em công thức bạn đã dùng là công thức nào?

=AVERAGE(C8:H8)

=AVERAGE(C9:H9)

=AVERAGE(C10:H10)

=AVERAGE(C11:H11)

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Bạn Hùng muốn sắp xếp điểm tiếng việt theo dạng từ cao xuống thấp. Em hãy chỉ giúp bạn cách làm đúng nhé.

Sort & Filter/Sort A to Z

Sort & Filter/Sort Largest to Smallest

Sort & Filter/Sort Z to A

Sort & Filter/Sort Smallest to Largest

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Xác định công thức đúng khi tìm điểm tiếng anh nhỏ nhất theo hình ảnh

=Min(E6:E10)

=Max(E6:E11)

=Min(E6:E11)

=Max(E6:E10)

Create a free account and access millions of resources

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