ASSIGNMENT – 38

USE OF POWER, PRODUCT, PROPER & REPT

Objective

In this assignment, you will learn how to use:

  • POWER – to calculate a number raised to a power.

  • PRODUCT – to multiply multiple numbers.

  • PROPER – to convert text into Proper Case.

  • REPT – to repeat text or symbols a specified number of times.

PART A – POWER FUNCTION

Table 1 – Calculate Power

Number Power Result
2 3  
4 2  
5 3  
6 2  
10 3  

POWER Syntax

=POWER(number,power)

Example

=POWER(A2,B2)

Q1. Calculate the power of each number using the POWER function.

PART B – PRODUCT FUNCTION

Table 2 – Calculate Product

Number 1 Number 2 Product
5 6  
8 4  
7 9  
12 5  
10 15  

PRODUCT Syntax

=PRODUCT(number1,number2,...)

Example

=PRODUCT(A2,B2)

Q2. Calculate the product of the two numbers using the PRODUCT function.

Q3. Find the Grand Total of all Product results using SUM.

PART C – PROPER FUNCTION

Table 3 – Convert Text into Proper Case

Original Text Proper Text
rahul sharma  
NEHA KAPOOR  
amit VERMA  
priya singh  
KARAN mehta  

PROPER Syntax

=PROPER(text)

Example

=PROPER(A2)

Q4. Convert all the names into Proper Case using the PROPER function.

PART D – REPT FUNCTION

Table 4 – Repeat Text

Text to Repeat No. of Repeats Repeated Text
A 5  
AB 3  
* 10  
– 8  
Excel 3  

REPT Syntax

=REPT(text,number_times)

Example

=REPT(A2,B2)

Q5. Repeat the given text according to the specified number of times using the REPT function.

MIXED PRACTICE

Q6. Calculate 7⁴ using the POWER function.

Q7. Calculate the product of: 12 × 15 × 20 using the PRODUCT function.

Q8. Convert the following text into Proper Case using PROPER:

advanced excel training

Q9. Create a horizontal separator using REPT.

For example:

--------------------

Use the REPT function instead of typing the hyphen manually.

Q10. Integrated Practice

Create a table containing the following columns:

Name Power Calculation Product Calculation Proper Name Repeated Text
Rahul        
Neha        
Karan        
Priya        
Aarav        

Use all four functions:

  • POWER

  • PRODUCT

  • PROPER

  • REPT

Suggested Formulas

POWER:

=POWER(Number,Power)

PRODUCT:

=PRODUCT(Number1,Number2)

PROPER:

=PROPER(Name)

REPT:

=REPT(Text,Number_of_Repeats)

Learning Outcome

After completing this assignment, students will be able to:

  1. Calculate powers using POWER.

  2. Multiply numbers using PRODUCT.

  3. Calculate totals using SUM.

  4. Convert names and text into Proper Case using PROPER.

  5. Repeat characters, words and symbols using REPT.

  6. Create separators and simple text-based visualizations using REPT.

  7. Combine multiple Excel functions in a practical worksheet.

PreviousNext