Scribd
Upload
30 views2 pages

Excel Functions Exercise

The document provides information about Excel functions, including their definitions and usage. It explains the difference between the NOW() and TODAY() functions, the purpose of the LEN function, and outlines the rules for using functions in Excel. Additionally, it includes true/false statements regarding Excel functionalities.

Uploaded by

Simex Flameproof Industries
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
30 views2 pages

Excel Functions Exercise

The document provides information about Excel functions, including their definitions and usage. It explains the difference between the NOW() and TODAY() functions, the purpose of the LEN function, and outlines the rules for using functions in Excel. Additionally, it includes true/false statements regarding Excel functionalities.

Uploaded by

Simex Flameproof Industries
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

B. Fill in the blanks.

1. Functions are predefined formulas in Excel.

2. Formulas in Excel begin with equal (=) sign.

3. The SQRT function returns the square root of the given number.

4. In mixed referencing, you can lock either a column or row by preceding it with a dollar ($) symbol.

C. State whether the following statements are true or false.

1. Excel provides functions to work with text values. - True

2. Combined reference is a type of cell reference. - False

3. A function is a built-in formula in Excel. - True

D. Answer the following questions:

1) What is the difference between NOW() and TODAY() functions?

- NOW() returns the current date and time.

- TODAY() returns the current date only, without the time.

Example:

If today is July 6, 2025, and the current time is 2:30 PM:

=NOW() -> 06/07/2025 14:30

=TODAY() -> 06/07/2025

2) What is the use of the LEN function? Explain with an example.

- The LEN function is used to count the number of characters in a text string, including spaces.

Example:

=LEN("Excel 2025") returns 10, because there are 10 characters (including the space).

3) What are the rules for using a function?

- All functions must begin with an equal (=) sign.


- The function name must be spelled correctly.

- The arguments must be enclosed in parentheses ().

- Arguments are usually separated by commas (,).

- Some functions require cell references, numbers, or text as arguments.

You might also like