Page 38 - CG_v2.1_flipBooks_class_6
P. 38
B. Fill in the blanks using the words given below.
Functions Equal to dollar ($) Square root
1. are predefined formulas in Excel.
2. Formulas in Excel begin with the sign.
3. The SQRT function returns the of the given number.
4. In mixed referencing, you can lock either a column or a row by preceding it with a
symbol.
C. State whether these statements are true or false.
1. Excel provides functions to work with text values.
2. Combined reference is a type of cell reference.
3. A function is a built-in formula in Excel.
D. Answer the following questions:
1. What is the difference between NOW() and TODAY() functions?
2. What is the use of the LEN function? Explain with an example.
3. What are the rules for using a function?
FUN ZONE Technology Literacy
Critical Thinking
Solve the crossword using the clues.
Across:
2. Predefined formula in Excel
4. Function used to display current date
5. Cell address that is to be used in a calculation
6. Function used to add values in cells
Down:
1. Function used to multiply values in cells
2. Mathematical expressions that are used perform calculations
3. Function used to convert text string into lowercase
36 Computer Genius (V2.1)-VI

