Scribd
Upload
224 views2 pages

Excel Formulas and Functions - Test Part 1

The document outlines a test on Excel formulas and functions, covering topics such as basic formula creation, cell references, common functions, and practical exercises. It includes questions on writing formulas, understanding cell references, and using functions like VLOOKUP and TRIM. Additionally, it features bonus questions about specific formula representations and text string manipulation.

Uploaded by

Штефырца Елена
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
224 views2 pages

Excel Formulas and Functions - Test Part 1

The document outlines a test on Excel formulas and functions, covering topics such as basic formula creation, cell references, common functions, and practical exercises. It includes questions on writing formulas, understanding cell references, and using functions like VLOOKUP and TRIM. Additionally, it features bonus questions about specific formula representations and text string manipulation.

Uploaded by

Штефырца Елена
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Excel Formulas and Functions: Test Part 1

Section 1: Basics of Excel Formulas


1. Write a formula in Excel to calculate the sum of 15 and 20.
2. What symbol must all formulas begin with in Excel?
3. Which operator would you use to calculate the square of a number in Excel?

Section 2: Understanding Cell References


4. Define the three types of cell references in Excel.
5. If the formula =A1+$B$1 is copied from cell C1 to C2, what will the formula look like
in C2?
6. What is the difference between relative and absolute cell references? Provide an
example.

Section 3: Common Excel Functions


7. Write the formula to calculate the average of values in cells B1 through B10.
8. What result will the formula =IF(A1<50, "Fail", "Pass") produce if A1
contains the value 60?
9. Use the VLOOKUP function to retrieve the price of "Banana" from the following table:

A B C

100 Apple $1.00

101 Banan $0.50


a

102 Cherry $2.00

Write the formula.

10. Explain the purpose of the TRIM function and provide an example.

Section 4: Creating Your Own Formula


11. Create a formula that multiplies the value in cell A1 by 2 and then adds the value in
cell B1.
12. Explain the importance of parentheses in formulas with an example.
Section 5: Working with Excel Formulas
13. List three common error messages in Excel and explain what each one means.
14. If you want to apply the same formula to multiple cells, what tool can you use?

Section 6: Practical Exercise


15. Perform the following steps:
a. Open a new Excel sheet.
b. Enter the numbers 10, 20, 30, 40, and 50 in cells A1 to A5.
c. In cell A6, write a formula to calculate the sum of the values in cells A1 to A5.
d. Enter 75 in cell B1 and 50 in cell B2. In cell B3, write a formula to determine if the
value in B1 is greater than B2. Use "Pass" for greater and "Fail" otherwise.

Bonus Questions

16. What does the formula ="" represent, and where might it be useful?
17. How can you include a double quote inside a text string in Excel?

You might also like