Question

B Fill in the blanks,
1. To prepare a filtered list at a new place, choose the
option in the
Advanced Filter dialog box,
2. Excel can sort data in more than one helds using the
option of the
Sort dialog box
3.
make the comparison of data easy at different points,
4. Excel first sorts
then
followed by
blank cells.
5. The
filter is used to add more than are criterion,
C. Which feature of Excel should be used to do the following?
1. To present data in a pictorial form
2. To compare large sets of data
3. To find the Bottom 10 items of a list
4. To arrange the data of a column in descending order
5. To get particular Information from a list without changing
the order of the list​

Answer 1

Answer:

changing

Explanation:

option of the

Sort dialog box

3.

make the comparison of data easy at different points,

4. Excel first sorts

then

followed by

blank cells.

5. The

filter is used to add more than are criterion,

C. Which feature of Excel should be used to do the following?

1. To present data in a pictorial form

2. To compare large sets of data

3. To find the Bottom 10 items of a list

4. To arrange the data of a column in descending order

5. To get particular Information from a list without changing

the order of the list