Scribd
Upload
33 views2 pages

Excel Question Paper

The document is a question paper focused on Excel, covering fill-in-the-blank, true/false statements, and open-ended questions about Excel functions and references. It includes topics such as predefined formulas, cell referencing types, and various function categories like statistical, mathematical, and text functions. Additionally, it asks for explanations of specific functions and their uses.

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
33 views2 pages

Excel Question Paper

The document is a question paper focused on Excel, covering fill-in-the-blank, true/false statements, and open-ended questions about Excel functions and references. It includes topics such as predefined formulas, cell referencing types, and various function categories like statistical, mathematical, and text functions. Additionally, it asks for explanations of specific functions and their uses.

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

Excel Worksheet - Question Paper

B. Fill in the blanks:

1. ____________ are predefined formulas in Excel.

2. Formulas in Excel begin with ____________ sign.

3. The SQRT function returns the ____________ of the given number.

4. In mixed referencing, you can lock either a column or row by preceding it with a ____________

symbol.

C. State whether the following 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?

4) What do you understand by cell referencing?

5) Explain relative reference.

6) Explain absolute reference.

7) Explain mixed reference.


8) How can we create references to other worksheet?

9) How can we create other workbook references?

10) What are statistical functions?

11) What are mathematical functions?

12) What are text functions?

13) What are logical functions?

14) What are date and time functions?

You might also like