Data Handling
Part 2
Advanced Filters
To construct advanced filters for more
control over your data tables, follow
these steps:
1. For instance, to display records of kids whose hobby is photography:
2. Click the arrow button next to the Hobby field header.
3. Select Text Filters, then click Custom Filter.
4. In the Hobby list, choose "contains," and type "photography" in the
adjacent text box.
5. Click OK. Now, only the records with
"photography" in the Hobby field will be
displayed.
Working with Power and Percentage:
Power
In complex calculations, where a formula has multiple parts, the order of
calculations is from left to right. However, any part of the formula enclosed in
parentheses will be calculated first.
By: Fatima Adnan
, The basic calculations and their symbols in MS Excel:
1. For a simple exponent/power calculation using the ^ symbol in your
formula, the answer will be 4.
2. Type the numbers below.
3. Click any cell and type =((C1^A1)-
(D1^B1))+((B1/A1)*A1)^2.
4. Press Enter, and you will see the
answer as -309.
5. In MS Excel, ^ is used for exponentiation, while the default function
POWER(A2,B2) can also be used for the same purpose.
Percentage
Values can be changed from a decimal number to a percentage by applying the
percentage format. Microsoft Excel multiplies the cell by 100 and displays the
result with the percentage sign.
1. Click cell B3 and type =B2/D2.
2. Click cell C3 and type =C2/D2.
3. Select the cells which contain the numbers you want to format, in this case,
B3 and C3.
By: Fatima Adnan
Part 2
Advanced Filters
To construct advanced filters for more
control over your data tables, follow
these steps:
1. For instance, to display records of kids whose hobby is photography:
2. Click the arrow button next to the Hobby field header.
3. Select Text Filters, then click Custom Filter.
4. In the Hobby list, choose "contains," and type "photography" in the
adjacent text box.
5. Click OK. Now, only the records with
"photography" in the Hobby field will be
displayed.
Working with Power and Percentage:
Power
In complex calculations, where a formula has multiple parts, the order of
calculations is from left to right. However, any part of the formula enclosed in
parentheses will be calculated first.
By: Fatima Adnan
, The basic calculations and their symbols in MS Excel:
1. For a simple exponent/power calculation using the ^ symbol in your
formula, the answer will be 4.
2. Type the numbers below.
3. Click any cell and type =((C1^A1)-
(D1^B1))+((B1/A1)*A1)^2.
4. Press Enter, and you will see the
answer as -309.
5. In MS Excel, ^ is used for exponentiation, while the default function
POWER(A2,B2) can also be used for the same purpose.
Percentage
Values can be changed from a decimal number to a percentage by applying the
percentage format. Microsoft Excel multiplies the cell by 100 and displays the
result with the percentage sign.
1. Click cell B3 and type =B2/D2.
2. Click cell C3 and type =C2/D2.
3. Select the cells which contain the numbers you want to format, in this case,
B3 and C3.
By: Fatima Adnan
