Question

c. Sort on Color
st match from the words given and shade the circle.
mng above average marks in a subject
btop/Bottom Rules
c. Formatting
a. alpha numeric b. numeric
B. Find the nearest match from the
1 Coloring cells having above average man
a. Filtering
2. Arranging a list of names based on theird
b. Filtering
a. Custom Sorting
ng red, green, yellow arrows for different data ranges
a. Conditional Formatting b. Filtering
4. Displaying different sized color bands for different values
a. Icon Sets
b. Data Bars
5. Displaying only those data whose cell fill color is green
a. Format by Color
b. Sort by Color
c. Custom Sort
c. Color Scales
c. Filter by color
Write T (for True) or F (for False) against the following statements.
1. Rows can be sorted with respect to the colour of the cells in Excel.
. More than one filter can be applied on a given set of data in Excel.
Data cannot be filtered with respect to the colour of a cell in Excel.​

Answer 1

Answer:

c. alpha numeric

1. filtering

2. a . costom sorting

3. filtering

4. icon sets

5. sort by color

true false

1. false

2. true

3. false