Question

The
mixed
cell
reference
SAAT
indicates
:
al
The
column
does
not
change
when
copied
b
)
The
row
does
not
change
when
copied
10
Both
the
column
and
row
does
not
change
when
copie
Write
(
77
for
true
and
2.
What
is
the
default
cell
reference
in
Microsoft
Excel
?
3.
Which
of
the
following
is
the
default
option
of
AutoSum
featur
Let's Evaluate
ch
nek the correct option
1
easy to interpret data
To create a chart, on
desired chart catego
1d) None of these
(b) Mixed
(a) Absolute
10 Relative
To join two strings
Cell reference, SE
In Pie chart, each
Chart styles ides
make it easily c
5. Bar chart conn
(d) None of these
2
(b) Sum
(d) Min
(a) Average
10) Count
4. Which error will be displayed if it is division by zero?
(a) #DIV/0!
(c) #NAME?
D. Answer the follow
1. Define the fo
(b) #N/A
(a) Formul
Demonstra
and divide
2.
(d) #VALUE!
5. What does the formula =AVERAGE (A1:C1,B2) mean?
(a) The average of cells in the range of cells from A1 to Ci
(b) The average of cells in the range of cells from Al to C1 and B2
(c) The average of cells A1, B2 and C1
(d) The average of cells in the range of cells from C1 to B2
3. Describe
Name ar
4.
5. Differen
38 Exploring ICT World - 8​

Answer 1

Answer:

plz write it properly..........!