WorksheetsExcel Class Quiz 1
Total questions: 8
Worksheet time: 4mins
Name
Class
Date
1.
The numeral Order in Excel shows:
a)
Rows
b)
Column
2.
The alphabetical order in Excel shows:
a)
Rows
b)
Columns
3.
For what purpose this sign used?
a)
resizing of Cells
b)
delete cell
c)
add cell
d)
merge and center
4.
Which of the formula is correct for addition in excel?
a)
=sum(E6.F6)
b)
=Sum(E6:E8)
c)
=sumE5:E6
d)
=(E6:F6)
5.
What is the cell number of sadia'S Obtain Marks?
a)
C7
b)
F7
c)
C8
d)
D7
6.
WHICH OF THESE FORMULAS ARE CORRECT TO FIND THE PERCENTAGE OF MAAZ
a)
=500/200*100
b)
=D5/E5*100
c)
=E5*100/D5
d)
=200*100/500
7.
HOW CAN WE CALCULATE THE AVERAGE SALE OF MARIA WITHOUT FORMULA
(a)
8.
WAHT IS THE FORMULA OF FINDING AVERGAE?
a)
=Average(E6:E8)
b)
=average(E6:E8)
c)
average(E6:E8)
d)
=average(E6.E8)
100 %
