The use of excel spreadsheets is one of the hard things to comprehend in the computer use. However, not everyone really uses excel, but it is widely used especially for official purposes. The quiz below tests this and more,
A12$
$A12
$A$12
Rate this question:
F10
F12
F11
Rate this question:
Gan nhan cho vung du* lieu
Thay doi vung du lieu ve bieu do
Xoa du lieu
Rate this question:
120
110
65
Rate this question:
=SUM(A1:B5)
=SUM(A1..B5)
=SUM < A1:B5 >
Rate this question:
=ranks(number,ref,[order])
=ranke(number,ref,[order])
=rank(number,ref, [order])
Rate this question:
1
10
0
Rate this question:
1Hanoi4
1Hanoi 5
1Hanoi6
Rate this question:
$A$12
$12$A
A$12$
Rate this question:
Ctrl十M
Ctrl+N
Ctrl+O
Rate this question:
Kich phai chuot tai ten bang tinh/ New/ Nhap ten mai/ Enter
Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter
Kich phai chuot tai ten bang tinh/ Newname/ Nhap ten moi/ Enter
Rate this question:
Format/ Cells/ Colors
Format/ Borders/ Pattern
Format/ Cells/ Border
Rate this question:
Tab
Enter
Backspace
Rate this question:
Page Up
Page Down
Home
Rate this question:
Edit/ Replace
Edit/ Copy
Edit/ Cut
Rate this question:
Data/ Sort by / Descending
Data/ Sort/ Descending
Data/ Sort/ Ascending
Rate this question:
Tong hop du"lieu
Trich loc du lieu
Sap xep du lieu
Rate this question:
31
30
35
Rate this question:
MINUM
MIN
MINUTE
Rate this question:
#NAME?
3
0
Rate this question:
Data/ Filter/ Advance Fitter
Data/ Auto/ Filter
Data/ Filter/ AutoFilter
Rate this question:
Hien thi hay khong hien thi cac gia tri tren bieu do
Bao gom ca 2 phiromg an con lai
Tieu de cua bieu do, tieu de cac true, cac kieu dirorng ludi trong bieu do
Rate this question:
Ctrl+N
Ctrl + M
Ctrl + O
Rate this question:
Page Down
Home
Page Up
Rate this question:
Insert/ Bar Chart
Insert/ Chart
Insert/ Column Chart
Rate this question:
Pie
Column
Line
Rate this question:
EVERAGE
AVERAGE
ERVERAGE
Rate this question:
Shift+F4
Alt+F4
Ctrl+F4
Rate this question:
Insert/ Columns
Insert/ Column left
Insert/mow Columns
Rate this question:
Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row
Chon o tai hang can xoa/ Kich phai chuot/ Delete/ Row above
Chon o tai hang can xoa/ Kich phai chuQt/ Delete/ Row
Rate this question:
Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column right
Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column
Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column
Rate this question:
Ctrl + Tab
Alt + Tab
Shift + Tab
Rate this question:
F5
F3
F2
Rate this question:
Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK
Kich chuot phai vao duong vien cua bieu do/ Chart Window/ chon lai kieu/OK
Kicli chuot phai vao duang vien cua bieu do/ Chart Options/ Chon lai kieu/ OK
Rate this question:
Cong cu Fill Color tren thanh dinh dang
Cong cu Line Color tren thanh dinh dang
Cong cu Font Color tren thanh dinh dang
Rate this question:
TIN HOC VAN PHONG
Tin Hoc Van Phong
TINHOCVANPHONG
Rate this question:
So hang gap 10 lan va so cot gap 60 lan
So hang gap 6 lan va so cot gap 4 lan
So hang gap 16 lan va so cot gap 64 lan
Rate this question:
Shift+ Page Down
Ctrl + Page Down
Alt + Page Down
Rate this question:
Ctrl + Page Up
Shift + Page Up
Alt 十 Page Up
Rate this question:
Home
Page Down
Page Up
Rate this question:
Data/ Sort/ Descending
Data/ Sort/ Ascending
Data/ Sort by/ Descending
Rate this question:
34
3
19
Rate this question:
=rank(A2,$A$2:$A$10,0)
=rank(A2,$A$2:$A$10)
=rank(A2,$A$2:$A$10,1)
Rate this question:
6
#VALUE!
TINHOC
Rate this question:
4
5
8
Rate this question:
Ctrl + P
Ctrl + Print Screen
Atl + P
Rate this question:
Insert/ New Rows
Insert/ Rows
Insert/ Row above
Rate this question:
Chon o B2/ Window/ Freeze Panes
Chon o B1/ Window/ Freeze Panes
Chon o A1/ Window/ Freeze Panes
Rate this question:
Quiz Review Timeline (Updated): Jun 25, 2024 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
BASIC 6 COMPUTING QUIZ
The BASIC 6 COMPUTING QUIZ assesses foundational knowledge in spreadsheet management, focusing on Excel. It covers key concepts like cells, databases, sheet tabs, and cell naming,...
Questions:
8 |
Attempts:
122 |
Last updated:
Apr 06, 2023
|
Data Analyst Excel Test
Dive into our Data Analyst Excel Test and show off your skills. In this test, you'll face a range of challenges that cover everything essential for a data analyst. We'll...
Questions:
10 |
Attempts:
7785 |
Last updated:
Jul 03, 2024
|
9th Grade Excel Test
This 9th Grade Excel Test assesses key spreadsheet skills. It covers functions like MAX and RANGE, proper data selection for graphs, and understanding of cell alignment. Ideal for...
Questions:
9 |
Attempts:
1995 |
Last updated:
Nov 08, 2024
|
Keystone Bank Pre-Training Assessment
This assessment tests proficiency in Excel functionalities like sorting, using gridlines, worksheet operations, freeze panes, and functions.
Questions:
20 |
Attempts:
143 |
Last updated:
Mar 22, 2023
|
Microsoft Excel Proficiency Trivia Questions
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions:
122 |
Attempts:
227 |
Last updated:
Sep 13, 2023
|
Test How Much Do You Know About Excel Sheets! Trivia
Explore your knowledge of Excel Sheets with this trivia! Learn to sort columns, freeze panes, create tables, use conditional formatting, and search data efficiently. Perfect for...
Questions:
20 |
Attempts:
482 |
Last updated:
Sep 09, 2024
|
Wait!
Here's an interesting quiz for you.