Excel Sheet Format For Quiz Questions

75 Questions | By Minhpd.87 | Last updated: Jan 11, 2018

Settings

- +

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,

Questions and Answers

1.

Trong Microsoft Excel，phuong an nao duoi day khong phai la dia chi o?
- A.
  
  AS12
- B.
  
  $A$12
- C.
  
  $12$A
2.

Trong Microsoft Excel, phuong an nao duoi day la dia chi tuyet doi?
- A.
  
  $A$12
- B.
  
  $12$A
- C.
  
  A$12$
3.

Trong Microsoft Excel, phuomg an nao duoi day la dia chi hon hop?
- A.
  
  A12$
- B.
  
  $A12
- C.
  
  $A$12
4.

Trong cong thuc cua Microsoft Excel, su dung phim nao de chuyen doi dia chi tuyet doi sang dia chi tuong doi hoac nguoc lai cho o hoac vung lua chon?
- A.
  
  F2
- B.
  
  F3
- C.
  
  F4
5.

Trong Microsoft Excel, cach nao de mo mot tep Excel da co tren may tinh?
- A.
  
  Ctrl十M
- B.
  
  Ctrl+N
- C.
  
  Ctrl+O
6.

Trong Microsoft Excel, cach nao de tao moi mot tep?
- A.
  
  Ctrl+N
- B.
  
  Ctrl + M
- C.
  
  Ctrl + O
7.

Trong Microsoft Excel, cach nao de dong mot tep?
- A.
  
  Ctrl+F4
- B.
  
  Shift十 F4
- C.
  
  Alt+F4
8.

Trong Microsoft Excel, cach nao de thoat khoi chuang trinh?
- A.
  
  Shift+F4
- B.
  
  Alt+F4
- C.
  
  Ctrl+F4
9.

Trong Microsoft Excel, cach nao de luu tep hien tai voi ten moi?
- A.
  
  F10
- B.
  
  F12
- C.
  
  F11
10.

Trong Microsoft Excel 2003，cach nao de chen bang tinh?
- A.
  
  Insert/ Newsheet
- B.
  
  Insert / Sheet
- C.
  
  Insert / Worksheet
11.

Trong Microsoft Excel, cach nao de them mot Sheet moi?
- A.
  
  Shift 十 FI1
- B.
  
  Alt+F11
- C.
  
  Ctrl + FI1
12.

Trong Microsoft Excel, thao tac nao de doi ten bang tinh
- A.
  
  Kich phai chuot tai ten bang tinh/ New/ Nhap ten mai/ Enter
- B.
  
  Kich phai chuot tai ten bang tinh/ Rename/ Nhap ten moi/ Enter
- C.
  
  Kich phai chuot tai ten bang tinh/ Newname/ Nhap ten moi/ Enter
13.

Trong Microsoft Excel 2003，cach nao de tao duong vien cho o da chon?
- A.
  
  Format/ Cells/ Colors
- B.
  
  Format/ Borders/ Pattern
- C.
  
  Format/ Cells/ Border
14.

Trong M icrosoft Excel 2003，cach nao de chen mot hang phia tren hang hien hanh?
- A.
  
  Insert/ New Rows
- B.
  
  Insert/ Rows
- C.
  
  Insert/ Row above
15.

Trong Microsoft Excel 2003, cach nao de chen mot cot truoc cot hien hanh?
- A.
  
  Insert/ Columns
- B.
  
  Insert/ Column left
- C.
  
  Insert/mow Columns
16.

Trong Microsoft Excel 2003，thao tac nao de xoa mot hang trong bang tinh?
- A.
  
  Chon o tai hang can xoa/ Kich phai chuOt/ Delete/ Entire Row
- B.
  
  Chon o tai hang can xoa/ Kich phai chuot/ Delete/ Row above
- C.
  
  Chon o tai hang can xoa/ Kich phai chuQt/ Delete/ Row
17.

Trong Microsoft Excel 2003，thao tac nao de xoa mot cot trong bang tinh?
- A.
  
  Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column right
- B.
  
  Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Entire Column
- C.
  
  Chon o tai cot can xoa/ Kich phai chuot/ Delete/ Column
18.

Trong Microsoft Excel, cach nao cho phep dua con tro ve o A1 cua bang tinh?
- A.
  
  Alt+Home
- B.
  
  Shift 十 Home
- C.
  
  Ctrl+Home
19.

Trong Microsoft Excel, cach nao cho phep di chuyen giua cac sheet?
- A.
  
  Ctrl + Page Up; Ctrl + Page Down
- B.
  
  Alt + Page Up ; Alt + Page Down
- C.
  
  Ctrl+Home ; Ctrl十End
20.

Trong Microsoft Excel, phim nao cho phep di chuyen con tro sang phai cua o hien hanh?
- A.
  
  Tab
- B.
  
  Enter
- C.
  
  Backspace
21.

Trong Microsoft Excel, cach nao cho phep di chuyen con tro sang trai cua o
- A.
  
  Ctrl + Tab
- B.
  
  Alt + Tab
- C.
  
  Shift + Tab
22.

Trong Microsoft Excel, phim nao cho phep di chuyen con tro den cot dau tien cua dong hien tai?
- A.
  
  Home
- B.
  
  Page Down
- C.
  
  Page Up
23.

Trong Microsoft Excel, cach nao cho phep di chuyen con tro den vi tri man hinh khuat phai
- A.
  
  Shift+ Page Down
- B.
  
  Ctrl + Page Down
- C.
  
  Alt + Page Down
24.

Trong Microsoft Excel, phim nao cho phep di chuyen con tro den vi tri man hinh khuat trai?
- A.
  
  Ctrl + Page Up
- B.
  
  Shift + Page Up
- C.
  
  Alt 十 Page Up
25.

Trong Microsoft Excel, cach nao cho phep di chuyen con tro len vi tri man hinh khuat tren?
- A.
  
  Page Up
- B.
  
  Page Down
- C.
  
  Home
26.

Trong Microsoft Excel, cach nao cho phep di chuyen con tro xuong vi tri man hinh khuat duoi?
- A.
  
  Page Down
- B.
  
  Home
- C.
  
  Page Up
27.

Trong Microsoft Excel 2003, thao tac nao sau day cho phep co dinh cot A va hang 1 trong khi cuon cac hang hoac cac cot khac?
- A.
  
  Chon o B2/ Window/ Freeze Panes
- B.
  
  Chon o B1/ Window/ Freeze Panes
- C.
  
  Chon o A1/ Window/ Freeze Panes
28.

Trong Microsoft Excel 2003, thao tac nao sau day cho phep chia man hinh bang tinh thanh 4 phan?
- A.
  
  Chon o B1/Window/ Split
- B.
  
  Chon o A2/Window/ Split
- C.
  
  Chon o A1/ Window/ Split
29.

Trong Microsoft Excel 2003，cach nao de sao chep dir lieu trong vung da Chon?
- A.
  
  Edit/ Replace
- B.
  
  Edit/ Copy
- C.
  
  Edit/ Cut
30.

Trong Microsoft Excel 2003，cach nao chi xoa noi dung cua 1 hang da chon?
- A.
  
  Edit/ Delete
- B.
  
  Edit/ Row/ Delete
- C.
  
  Delete/ Row
31.

Trong Microsoft Excel, cach nao de dat con tro vao trong mot o da chon?
- A.
  
  F5
- B.
  
  F3
- C.
  
  F2
32.

Trong Microsoft Excel 2003，cach nao thuc hien tron cac o da chon?
- A.
  
  Format/ Cells/ Alignment/ morge Cells
- B.
  
  Format/ Cells/ merge/ Cells
- C.
  
  Format/ Alignment/ merge/ Cells
33.

Trong Microsoft Excel 2003，thao tac nao canh giua noi dung trong cot B?
- A.
  
  Chon cot B, chon nut Center tren thanh cong cu
- B.
  
  Chon nut Center tren thanh cong cu, chon cot B
- C.
  
  Chon cot B，chon Edit/ Align/ Center
34.

Trong Microsoft Excel 2003, cach nao de mo hop thoai Move or Copy?
- A.
  
  Edit/ Move Or Copy Sheet...
- B.
  
  Edit/ Sheet
- C.
  
  Edit/ Sheet/ Move Or Copy
35.

Trong Microsoft Excel 2003, cach nao de lap lai hang tieu de tren cac trang?
- A.
  
  File/ Page Setup/ Page
- B.
  
  File/ Page Setup/ Sheet
- C.
  
  File/ Page Setup/ Print area
36.

Trong Microsoft Excel 2003，cach nao de ngat trang tai vi tri hien hanh?
- A.
  
  Edit/ Page Break
- B.
  
  Insert/ Page Break
- C.
  
  View/ Page Break
37.

Trong Microsoft Excel 2003，tai hop thoai Move Or Copy, thao tac nao de sao chep mot bang tinh?
- A.
  
  Chon muc Move
- B.
  
  Chon muc Copy
- C.
  
  Chon muc Create a copy
38.

Trong Microsoft Excel 2003，cach nao de sap xep du lieu theo thur tu tang dan?
- A.
  
  Data/ Sort by / Descending
- B.
  
  Data/ Sort/ Descending
- C.
  
  Data/ Sort/ Ascending
39.

Trong Microsoft Excel 2003, cach nao de sap xep du: lieu theo thur ty giam dan?
- A.
  
  Data/ Sort/ Descending
- B.
  
  Data/ Sort/ Ascending
- C.
  
  Data/ Sort by/ Descending
40.

Trong Microsoft Excel 2003, cach nao de loc du* lieu tu dong?
- A.
  
  Data/ Filter/ Advance Fitter
- B.
  
  Data/ Auto/ Filter
- C.
  
  Data/ Filter/ AutoFilter
41.

Trong Microsoft Excel 2003, cach nao cho phep loc co dieu kien trong vung tieu chuan?
- A.
  
  Data/ Filter/ Advance
- B.
  
  Windows/ Filter/ Advance Filter
- C.
  
  Data/ Filter/ Advance Filter
42.

Trong Microsoft Excel 2003, chon Data/ Filter de thuc hien cong viec gi?
- A.
  
  Tong hop du"lieu
- B.
  
  Trich loc du lieu
- C.
  
  Sap xep du lieu
43.

Trong Microsoft Excel 2003，cach nao cho phep tao bieu do cho vung gia tri duoc chon?
- A.
  
  Insert/ Bar Chart
- B.
  
  Insert/ Chart
- C.
  
  Insert/ Column Chart
44.

Trong Microsoft Excel 2003, cach nao khong tao duoc bieu do cho vung gia tri duoc chon?
- A.
  
  Chon bieu tuong Chart Wizard tren thanh cong cu
- B.
  
  Insert/ Chart Option
- C.
  
  Insert/ Chart
45.

Trong Microsoft Excel 2003, hop thoai Chart Options cho phep dua cac thong tin nao sau day cho bieu do?
- A.
  
  Hien thi hay khong hien thi cac gia tri tren bieu do
- B.
  
  Bao gom ca 2 phiromg an con lai
- C.
  
  Tieu de cua bieu do, tieu de cac true, cac kieu dirorng ludi trong bieu do
46.

Trong Microsoft Excel 2003, khi ve bieu do bang cong cu Chart Wizard, the Data Range cho phep lam gi?
- A.
  
  Gan nhan cho vung du* lieu
- B.
  
  Thay doi vung du lieu ve bieu do
- C.
  
  Xoa du lieu
47.

Trong Microsoft Excel 2003，thao tac nao cho phep thay doi lai kieu bieu do?
- A.
  
  Kich chuot phai vao duong vien cua bieu do/ Chart Type/ Chon lai kieu/ OK
- B.
  
  Kich chuot phai vao duong vien cua bieu do/ Chart Window/ chon lai kieu/OK
- C.
  
  Kicli chuot phai vao duang vien cua bieu do/ Chart Options/ Chon lai kieu/ OK
48.

Trong Microsoft Excel, bieu do loai nao thich hop cho viec hien thi gia tri dudi dang % (percentage)?
- A.
  
  Pie
- B.
  
  Column
- C.
  
  Line
49.

Trong Microsoft Excel 2003，cach nao cho phep chon font chu cho tieu de cua bieu do?
- A.
  
  Kich chuot phai vao vung tieu de/ Font Chart Tilte/ Font
- B.
  
  Kich chuot phai vao vung tieu de/ Format Font/ Font
- C.
  
  Kich chuot phai vao vung tieu de/ Format Chart Tilte/ Font
50.

Trong Microsoft Excel 2003，cong cu nao cho phep thay doi mau sac cho vung duoc chon?
- A.
  
  Cong cu Fill Color tren thanh dinh dang
- B.
  
  Cong cu Line Color tren thanh dinh dang
- C.
  
  Cong cu Font Color tren thanh dinh dang
51.

Trong Microsoft Excel, ham SUM dung de lam gi?
- A.
  
  Tinh tong cac gia tri so trong vung duoc chon
- B.
  
  Tim gia tri nho nhat trong cac gia tri duocchon
- C.
  
  Tim gia tri lon nhat trong cac gia tri duoc chon
52.

Trong Microsoft Excel, cong thuc =MAX(30,10,65,5) nhan duoc ket qua la bao nhieu?
- A.
  
  120
- B.
  
  110
- C.
  
  65
53.

Trong Microsoft Excel, cong thuc nao dung?
- A.
  
  =SUM(A1:B5)
- B.
  
  =SUM(A1..B5)
- C.
  
  =SUM < A1:B5 >
54.

Trong Microsoft Excel，cong thuc =EVERAGE(5,7,9) cho ket qua the nao?
- A.
  
  7
- B.
  
  #NAME?
- C.
  
  9
55.

Trong Microsoft Excel, cong thu'c =SUM(19,11,MAX(1,3,5)) se cho ket qua la bao nhieu?
- A.
  
  31
- B.
  
  30
- C.
  
  35
56.

Trong Microsoft Excel, ham nao de tim so nho nhat trong cac gia tri duoc chon?
- A.
  
  MINUM
- B.
  
  MIN
- C.
  
  MINUTE
57.

Trong Microsoft Excel, ham nao de tim gia tri trung binh cua cac gia tri duoc chon?
- A.
  
  EVERAGE
- B.
  
  AVERAGE
- C.
  
  ERVERAGE
58.

Trong Microsoft Excel, cong thirc =COUNT(19,l 1,4) se tra ve ket qua la bao nhieu?
- A.
  
  34
- B.
  
  3
- C.
  
  19
59.

Trong bang tinh Excel, cong thuc -COUNTA(19,"S","n01","n02") se tra ve ket qua la bao nhieu?
- A.
  
  4
- B.
  
  3
- C.
  
  19
60.

Trong Microsoft Excel, cu phap ham nao la dung?
- A.
  
  =ranks(number,ref,[order])
- B.
  
  =ranke(number,ref,[order])
- C.
  
  =rank(number,ref, [order])
61.

Trong Microsoft Excel, cong thuc nao cho phep xep thu tu vung gia tri so A2:A10 theo chieu tang dan?
- A.
  
  =rank(A2,$A$2:$A$10,0)
- B.
  
  =rank(A2,$A$2:$A$10)
- C.
  
  =rank(A2,$A$2:$A$10,1)
62.

Trong Microsoft Excel,o A2 co du lieu ”TINHOC"; Tai o B2 nhap cong thuc =VALUE(A2) thi nhan duoc ket qua nao?
- A.
  
  6
- B.
  
  #VALUE!
- C.
  
  TINHOC
63.

Trong Microsoft Excel，o A2 co du lieu "Tin hoc van phong" ; Tai o B2 nhap cong thuc =LOWER(A2) thi nhan duoc ket qua nao?
- A.
  
  Tin hoc van phong
- B.
  
  Tin Hoc Van Phong
- C.
  
  TIN HOC VAN PHONG
64.

Trong Microsoft Excel,o A2 co du* lieu "Tin hoc van phong" ; tai o B2 nhap cong thuc =UPPER(A2) thi nhan duoc ket qua nao?
- A.
  
  TIN HOC VAN PHONG
- B.
  
  Tin Hoc Van Phong
- C.
  
  TINHOCVANPHONG
65.

Trong Microsoft Excel, cong thuc = MIN(0,2,3,4,1) cho ket qua nao?
- A.
  
  1
- B.
  
  10
- C.
  
  0
66.

Trong Microsoft Excel, cong thuc =M1NE(0,1,2,3) cho ket qua nao?
- A.
  
  #NAME?
- B.
  
  3
- C.
  
  0
67.

Trong Microsoft Excel, cong thuc = AVERAGE(4,5,MIN(8,6,7)) cho ket qua nao?
- A.
  
  4
- B.
  
  5
- C.
  
  8
68.

Trong Microsoft Excel, cong thuc =VALUE("01") cho ket qua nao?
- A.
  
  #VALUE!
- B.
  
  1
- C.
  
  01
69.

Trong Microsoft Excel, tai o A2 co du lieu "1Hanoi2”. Su dung Fill hand de dien du lieu den cac o B2，C2，D2, E2; tai o E2 nhan duoc ket qua nao?
- A.
  
  1Hanoi4
- B.
  
  1Hanoi 5
- C.
  
  1Hanoi6
70.

Trong Microsoft Excel,tai o A2 co gia tri la so khong (0); Tai o B2 go vao cong thuc =5/A2 nhan duoc ket qua nao?
- A.
  
  #VALUE!
- B.
  
  #DIV/0!
- C.
  
  0
71.

Trong Microsoft Excel 2003，thao tac nao dat le cho trang in?
- A.
  
  Chon File/ Page Setup/ Margins/ thuc hien cac hieu chinh/ OK
- B.
  
  Chon File/ Margin Setup/ Margins/ thyc hien cac hieu chinh/ OK
- C.
  
  Chon Format/ Page Setup/ Margins/ thyc hien cac hieu chinh/ OK
72.

Trong Microsoft Excel 2003，cach nao de tao tieu de dau trang va tieu de cuoi trang cho bang tinh?
- A.
  
  Insert/ Header and Footer
- B.
  
  Format/ Header and Footer
- C.
  
  View/ Header and Footer
73.

Trong Microsoft Excel, cach nao de mo hop thoai thiet lap cac thong so in bang tinh?
- A.
  
  Ctrl + P
- B.
  
  Ctrl + Print Screen
- C.
  
  Atl + P
74.

Voi cung mot noi dung, kich thuoc cua tep co phan mo rong xls so vai tep co phan mo rong xlsx nhu the nao?
- A.
  
  Kich thuoc 2 tep bang nhau
- B.
  
  Tep co phan mo rong xls co kich thuoc nho hon so voi tep co phan ma rong xlsx
- C.
  
  Tep co phan mo rong xls co kich thuoc lon hon so voi tep co phan ma rong xlsx
75.

So hang va so cot trong Excel 2007 gap bao nhieu lan so voi Excel 2003?
- A.
  
  So hang gap 10 lan va so cot gap 60 lan
- B.
  
  So hang gap 6 lan va so cot gap 4 lan
- C.
  
  So hang gap 16 lan va so cot gap 64 lan

Back to top

More Excel Quizzes

Featured Quizzes