wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

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

Total questions: 59

Worksheet time: 45mins

Name
Class
Date
1.

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

a)

Tính trung bình

b)

Tìm số nhỏ nhất

c)

Tìm số lớn nhất

d)

Tính tổng

2.

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

a)

Data

Filter

b)

Data

Home

c)

Data

View

d)

Data

Formular

3.

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

a)

Sort and Filter

b)

Connections

c)

Data Tools

4.

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

a)

=Sum (C6:H6)

b)

=Sum(C6:H6)

c)

=SUM(C6:H6)

d)

=sem(c6:h6)

5.

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?

a)

=AVERAGE(C8:H8)

b)

=AVERAGE(C9:H9)

c)

=AVERAGE(C10:H10)

d)

=AVERAGE(C11:H11)

6.

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é.

a)

Sort & Filter/Sort A to Z

b)

Sort & Filter/Sort Largest to Smallest

c)

Sort & Filter/Sort Z to A

d)

Sort & Filter/Sort Smallest to Largest

7.

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

a)

=Min(E6:E10)

b)

=Max(E6:E11)

c)

=Min(E6:E11)

d)

=Max(E6:E10)

8.

Để lọc dữ liệu, em dùng lệnh nào sau đây trong nhóm lệnh Sort and Filter?

a)

Sort A to Z

b)

Sort Z to A

c)

Filter

9.

Lệnh nào sau đây dùng để sắp xếp dữ liệu theo thứ tự tăng dần?

a)
b)
10.

Lệnh nào sau đây dùng để sắp xếp dữ liệu theo thứ tự giảm dần?

a)
b)
11.

Để sắp xếp dữ liệu trong bảng tính theo thứ tự tăng dần em sử dụng nút lệnh nào dưới đây:

a)
b)
c)
d)
12.

Đâu là tên hàm đúng trong Microsoft Excel ?

a)

Avezage

b)

Average

c)

Everage

d)

Averega

13.

Nút này có chức năng bật/ tắt lọc dữ liệu đúng không?

a)

Đúng

b)

Sai

14.
Để tìm giá trị nhỏ nhất trong vùng dữ liệu từ A7:A30 ta sử dụng công thức nào sau đây?
a)
=MIN(A7:A30)
b)
=MIN(A7; A30)
c)
=AVERAGE(A7:A30)
d)
=DMIN(A7:A30)
15.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
16.

From here to the end of the quiz, questions are in English.

a)

I got it

b)

I got it

c)

It got it

17.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
18.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
19.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
20.

What is the cell address of fish?

a)

A3

b)

3D

c)

5C

d)

C5

21.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
22.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
23.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
24.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
25.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
26.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
27.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
28.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
29.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
30.
What would you format a cell as when working with amounts of money?
a)
currency
b)
percent
c)
number
d)
scientific
31.
What symbol do we use for multiplication in a Spreadsheet program? 
a)
/
b)
=
c)
^
d)
*
32.
What do all formulas begin with?
a)
%
b)
[ ]
c)
=
d)
:
33.
What symbol do we use for subtraction in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
-
34.
What symbol do we use for division in a Spreadsheet program? 
a)
/
b)
*
c)
+
d)
=
35.
Which of the following tells a Spreadsheet to subtract the value in cell A4 from the value in cell A3?
a)
A4-A3=
b)
A3-A4=
c)
=A4-A3
d)
=A3-A4
36.
Which of the following tells a Spreadsheet to Divide the value in cell A3 by 27?
a)
=27/A3
b)
= A3/27
c)
= 27^A3
d)
=A3*27
37.
Which of the following is a formula that will add cells C9 and C10?
a)
=C9+C10
b)
C9+C10
c)
=C9:C10
d)
=C9*C10
38.
Which of the following is a formula that will multiply cells A1 and A2?
a)
A1*A2
b)
=A1:A2
c)
=A1*A2
d)
=Multiply(A1:A2)
39.
Which of the following is a formula that will divide cell D10 by 2?
a)
=D10/A2
b)
10/2
c)
=D10*2
d)
=D10/2
40.
Which of the following is a formula that will subtract cell B4 from cell B3?
a)
=3-4
b)
=B3-B4
c)
=B3*B4
d)
B3-B4
41.
Which of the following is a formula that will divide cell A10 by cell A1?
a)
=A10/A1
b)
=A1/A10
c)
=A10*A1
d)
=Divide(A10:A1)
42.
Which of the following is a correct example using the AUTOSUM function?
a)
sum(D14:D19)
b)
=D14:d19
c)
=sum(D14:D19)
d)
=D14+D15+D16+D17+D18+D19
43.
Which of the following is a correct example using the AUTOSUM function?
a)
=Sum(A1-A10)
b)
=Sum(A1:A10)
c)
=A1+A2+A3+...+A10
d)
=Sum(A1+A2+A3+...+A10)
44.

Cells that run horizontally on a spreadsheet

a)

Row

b)

Column

c)

Workbook

d)

Range

45.
What is normally used to perform calculations in a spreadsheet?
a)
Variable
b)
Formula
c)
Conditional formating
d)
Macro
46.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
47.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

48.

Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?

(a)  

49.

What will clicking on Sort A to Z do?

a)

It will sort the data in alphabetical order

b)

It will hide the rows that meet a certain criteria

c)

It will find the first row that contains the data

d)

It will only show the rows that meet a certain criteria

50.

To count cells based on a single condition, we use ......

a)

=COUNTIF

b)

=IF

c)

=COUNT

d)

=SUM

51.

One of these function is not a valid Countif function

a)

=countif(A2:A5,"h+*")

b)

=countif(A2:B5,"h+*")

c)

=countif(A2:A5,"h*")

d)

=countif(A2:A5,">7*")

52.

The first argument in countIf function is criteria

a)

True

b)

False

53.

Which one of these functions gives the result shown in the picture?

a)

=COUNTIF(D5:D13,"<>10")

b)

=COUNTIF(D5:D13,"<15")

c)

=COUNTIF(D5:D13,"=16")

d)

=COUNTIF(D5:D13,">=10")

e)

=COUNTIF(D5:D13,">=15")

54.

The Microsoft Excel COUNTIF function: ____________

a)

counts the number of cells in a range, that meets a given criteria.

b)

Counts ONLY whole numbers in a given range.

c)

Counts any cell that is blank in a given range.

d)

Counts cells that contain text only.

55.

Which of the following is the correct SYNTAX of the COUNTIF FUNCTION.

a)

=COUNTBLANK(range)

b)

=COUNTA(range)

c)

=COUNT(range)

d)

=COUNTIF( range, criteria )

56.

The COUNTIF function returns a numerical value.

a)

True

b)

False

57.

Look at the picture to the left, which of the following is the correct formula that can be used in order for us to find out how many times the number 2000 is repeated in that set of data.

a)

=COUNTIF(A2:A7, "YEAR 2000")

b)

=COUNTIF(A2:A7)

c)

=COUNTIF(A2:A7, D2)

d)

=COUNTIF(2000)

58.

If I wanted to find how many numbers are greater than 55, what would be the correct formula you would write?

a)

=COUNTIF(B2:B5,"<>" "55")

b)

=COUNTIF(B2:B5,">55")

c)

=COUNTIF(B2:B5,"< 55")

d)

=COUNTIF(B2:B5,"=55")

59.

A column is represented by ________?

a)

Numbers

b)

Letters

c)

Lines

d)

Cells

Similar Resources on Wayground

J07+09 简报+试算表

59 questions

J07+09 简报+试算表

quiz

Worksheet

•

6th - 8th Grade

Year 9 ICT Q2 revision: spreadsheets

59 questions

Year 9 ICT Q2 revision: spreadsheets

quiz

Worksheet

•

6th - 8th Grade

G6 4th Qauter 2024

60 questions

G6 4th Qauter 2024

quiz

Worksheet

•

6th - 8th Grade

Computer- Excel Lesson1-4

55 questions

Computer- Excel Lesson1-4

quiz

Worksheet

•

7th Grade

LATIHAN SOAL INFORMATIKA PSAT 2023/2024 INFORMATIKA KELAS 7

60 questions

LATIHAN SOAL INFORMATIKA PSAT 2023/2024 INFORMATIKA KELAS 7

quiz

Worksheet

•

7th Grade

Chuong trinh bang tinh 1

60 questions

Chuong trinh bang tinh 1

quiz

Worksheet

•

7th Grade

Python basics

60 questions

Python basics

quiz

Worksheet

•

5th - 7th Grade

Analisis data kelas 7

60 questions

Analisis data kelas 7

quiz

Worksheet

•

7th Grade