Page 39 - iPlus_Ver_2.0_class_8
P. 39
4. Assertion (A): Sorting in Excel can only be done in ascending order.
Reason (R): Excel does not support sorting data in descending order.
(a) Both Assertion (A) and Reason (R) are true and Reason (R) is a correct explanation of Assertion (A)
(b) Both Assertion (A) and Reason (R) are true and Reason (R) is not a correct explanation of
Assertion(A)
(c) Assertion (A) is true and Reason (R) is false
(d) Assertion (A) is false and Reason (R) is true
#Problem Solving & Logical Reasoning
Crack The Code #Digital Literacy
Solve the crossword using the clues.
Across:
3. Symbols that specify calculations to 1 2
be performed 4
5. Function used to convert 3 E O S
text string into uppercase
8. Numbers or text that do not change
9. Function used to convert 5 R
text string into lowercase
10. Function used to multiply values in cells
Down:
1. Cell address that is to be used in 6
a calculation
2. Function used to display 7
current date 8 C N
4. Function used to add 9 O E
values in cells
6. Predefined formula in Excel
7. Chart type in which data is displayed 10 O
in the form of vertical bars
#Problem Solving & Logical Reasoning
Let’s Explore #Digital Literacy
Find out the various ways in which people organise data to make their everyday work
easier. You can start this by asking a shopkeeper.
37
Spreadsheet—Functions and Charts

