Fill in the blanks
1. Every cell has a name called its
2. An absolute referencing is specified by using
sign
3. The predefined commands that perform some particular operations are called
is a quick way to find a set of data in a range.
5. You can apply filters to only
range on a worksheet at a time.
4
Section-B
Answer the following
1. What is cell referencing?
2. What is meant by sorting?
52
Answers
Answer:
1)cell address
2) an absolute reference is design it in a formula by the addition of a Dollar sign ($).it can precede the column reference, the reference, or both you will generally used that $A $2 to format when creating formula that contain absolute reference.
3)software
4) to find it ,first order letter from least to greatest. then subtract the smallest value from the largest value in the set .
5) you can apply filters to only one range of Cell on sheet at a time when you are when you apply a filter to a column, the only filter available for other columns are the value visible in the currently filtered range
Section B
1) a cell reference refers to a cell or a range of cell on the worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
2) computer in Computer Science arranging in an order sequence is called sorting.