NEW
Font size
S
M
L
XL
WorksheetsM1_Final_Quiz1_2017
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
What is the symbol for addition in Microsoft excel.
a)
*
b)
/
c)
+
d)
<>
2.
What is the symbol for subtraction in Microsoft excel.
a)
*
b)
/
c)
+
d)
-
3.
What is the symbol for division in Microsoft excel.
a)
*
b)
/
c)
+
d)
-
4.
What operation is used in this mathematical equation?
(31+24)(52-10)=2310
(31+24)(52-10)=2310
a)
Addition, subtraction
b)
Addition, multiplication
c)
Addition,multiplication,subtraction
d)
Addition,subtraction,multiplication
5.
One of the most helpful accessories, it helps and serves as the cell pointer.
a)
mouse
b)
printer
c)
keypad
d)
electronic pen
6.
All formula starts with this sign.
a)
#
b)
/
c)
=
d)
+
7.
It contains cell reference instead of actual of actual numbers.
a)
data
b)
labels
c)
formula
d)
numbers
8.
The cell that you are currently clicked in is called the ________.
a)
row
b)
column
c)
active cell
d)
cell reference
9.
What is labelled with numbers s in Microsoft Excel?
a)
row
b)
column
c)
active Cell
d)
cell reference
10.
What is labelled with letters in Microsoft Excel?
a)
row
b)
column
c)
active cell
d)
cell reference
11.
_________ is the most common spreadsheet application, although there are other spread sheets available.
a)
Microsoft excel
b)
Microsoft word
c)
Microsoft access
d)
Microsoft powerPoint
12.
In the formula = SUM (A1:B5), how many cells are there?
a)
2
b)
3
c)
5
d)
10
13.
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 15 is __________.
a)
B1-G15
b)
B1.G15
c)
B1; G15
d)
B1:G15
14.
The _______ functions calculate the average of specified data.
a)
MIN
b)
SUM
c)
MAX
d)
AVERAGE
15.
What Excel function that calculate the Minimum number?
a)
MIN
b)
SUM
c)
MAX
d)
AVERAGE
16.
Which Excel Function that counts of the cells that contain numerical data in the selected range of cells.
a)
MIN
b)
SUM
c)
MAX
d)
COUNT
17.
What is a single layer or sheet within the workbook and contains data or charts.
a)
workbook
b)
worksheet
c)
record
d)
file
18.
What type of data that includes letters numbers, symbols on the keyboard
a)
TEXT
b)
CONANSTANT
c)
FORMULA
d)
NONE OF THE ABOVE
19.
Columns are vertical alignments, while rows are horizontal alignments of cells.
a)
True
b)
false
20.
There are 300 columns in a worksheet
a)
True
b)
false
Reset
