WorksheetsEXCEL 1
Total questions: 37
Worksheet time: 19mins
Name
Class
Date
1.
The Quick Access Toolbar is:
a)
customizable
b)
found at the bottom of the screen
c)
found on the right side of the screen
d)
none of the above
2.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
3.
This is the:
a)
entry bar
b)
group
c)
name box
d)
none of the above
4.
The space on the spreadsheet where a column and a row intersect:
a)
cell
b)
name box
c)
entry bar
d)
none of the above
5.
This is the:
a)
title bar
b)
entry bar
c)
group
d)
none of the above
6.
What is this?
a)
active cell
b)
column
c)
cell
d)
none of the above
7.
Provides easy access to frequently used commands:
a)
group
b)
Quick Access Toolbar
c)
cell
d)
none of the above
8.
The cell in a spreadsheet application in which data may be entered:
a)
cell reference
b)
name box
c)
active cell
d)
none of the above
9.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
10.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
11.
What is this:
a)
tab
b)
ribbon
c)
view choices
d)
none of the above
12.
This is a:
a)
row
b)
column
c)
cell
d)
none of the above
13.
What part of the EXCEL screen is this:
a)
active cell
b)
cell
c)
name box
d)
none of the above
14.
The bar that displays the data being entered in the active cell:
a)
status bar
b)
entry bar
c)
Windows Task Bar
d)
none of the above
15.
This is a:
a)
ribbon
b)
group
c)
tab
d)
none of the above
16.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
17.
This is a:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
18.
A vertical row of cells in a spreadsheet – identified by letters:
a)
row
b)
column
c)
tab
d)
none of the above
19.
The entry bar is also known as (AKA):
a)
name box
b)
formula bar
c)
status bar
d)
none of the above
20.
This is the:
a)
Windows Task Bar
b)
Quick Access Toolbar
c)
worksheet tab
d)
none of the above
21.
This is the:
a)
entry bar
b)
title bar
c)
tab
d)
none of the above
22.
To arrange information by kinds or classes, or in a particular order:
a)
enter
b)
tab
c)
sort
d)
none of the above
23.
This is a:
a)
tab
b)
ribbon
c)
group
d)
none of the above
24.
Consists of words that identify information in a column or a row:
a)
label
b)
sort
c)
tab
d)
none of the above
25.
This is a:
a)
tab
b)
group
c)
ribbon
d)
none of the above
26.
Can be used travel from cell to cell in a spreadsheet:
a)
tab
b)
enter
c)
arrow keys
d)
all of the above
27.
The default view for EXCEL is:
a)
page layout
b)
normal
c)
column
d)
none of the above
28.
Which arithmetic operator signifies exponentiation?
a)
^
b)
-
c)
+
d)
/
29.
1. Microsoft Excel ialah perisian ...................... *
a)
Grafik
b)
Pemprosesan perkataan
c)
Hamparan Elektronik
d)
Animasi
30.
Apakah format file bagi Microsoft Excel?
a)
XLW/XLWX
b)
XLE/XLEX
c)
XLF/XLFX
d)
XLS/XLSX
31.
Ruangan pada worksheet yang berbentuk segi empat dan merupakan tempat kumpulan beberapa "cell" disebut …. *
a)
Sheet
b)
Column
c)
Range
d)
Pointer
32.
Berikut ini yang merupakan alamat “cell”, yaitu .… *
a)
84
b)
3F
c)
B5
d)
BB
33.
Fungsi dalam Excel yang digunakan mengira jumlah dari sekelompok nilai ialah …. *
a)
SUM
b)
AVERAGE
c)
MAX
d)
MIN
34.
Ctrl+P adalah shortcut key untuk memunculkan kotak dialog ….
a)
Customize
b)
Print
c)
Heater
d)
Page setup
35.
Manakah komponen berikut yang memaparkan “cell” yang sedang aktif? *
a)
Name box
b)
Formula bar
c)
Menu bar
d)
Status bar
36.
Fungsi apakah yang akan dapat membahagikan paparan kepada 4 bahagian; *
a)
Split
b)
Hide
c)
Zoom
d)
Gridlines
37.
Untuk memindahkan atau menyalin worksheet, menu yang harus dipilih setelah klik kanan pada tab sheet adalah ….*
a)
Delete
b)
Rename
c)
Move or copy
d)
Paste
100 %
