ASSIGNMENT – 38

ANSWER KEY – POWER, PRODUCT, PROPER & REPT

PART A – POWER FUNCTION

Q1. Calculate Power

Formula:

=POWER(A2,B2)
Number Power Result
2 3 8
4 2 16
5 3 125
6 2 36
10 3 1,000

Answers

  • 2³ = 8

  • 4² = 16

  • 5³ = 125

  • 6² = 36

  • 10³ = 1,000

PART B – PRODUCT FUNCTION

Q2. Calculate Product

Formula:

=PRODUCT(A2,B2)
Number 1 Number 2 Product
5 6 30
8 4 32
7 9 63
12 5 60
10 15 150

Q3. Grand Total of Product Results

Formula:

=SUM(C2:C6)

Calculation:

30 + 32 + 63 + 60 + 150 = 335

Answer: 335

PART C – PROPER FUNCTION

Q4. Convert Names into Proper Case

Formula:

=PROPER(A2)
Original Text Proper Text
rahul sharma Rahul Sharma
NEHA KAPOOR Neha Kapoor
amit VERMA Amit Verma
priya singh Priya Singh
KARAN mehta Karan Mehta

PART D – REPT FUNCTION

Q5. Repeat Text

Formula:

=REPT(A2,B2)
Text Repeats Repeated Text
A 5 AAAAA
AB 3 ABABAB
* 10 **********
– 8 ——–
Excel 3 ExcelExcelExcel

MIXED PRACTICE

Q6. Calculate 7⁴

Formula:

=POWER(7,4)

Calculation:

7 × 7 × 7 × 7 = 2,401

Answer: 2,401

Q7. Calculate 12 × 15 × 20

Formula:

=PRODUCT(12,15,20)

Calculation:

12 × 15 × 20 = 3,600

Answer: 3,600

Q8. Convert “advanced excel training” into Proper Case

Formula:

=PROPER("advanced excel training")

Answer:

Advanced Excel Training

Q9. Create a Horizontal Separator Using REPT

For example, to create 20 hyphens:

Formula:

=REPT("-",20)

Result:

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

Answer: 20 hyphens

Q10. Integrated Practice

One possible practice table:

Name Power Calculation Product Calculation Proper Name Repeated Text
Rahul 2³ = 8 5×6 = 30 Rahul RRRRR
Neha 3² = 9 8×4 = 32 Neha NNNNN
Karan 4³ = 64 7×9 = 63 Karan KKKKK
Priya 5² = 25 12×5 = 60 Priya PPPPP
Aarav 6² = 36 10×15 = 150 Aarav AAAAA

Example formulas

POWER:

=POWER(B2,C2)

PRODUCT:

=PRODUCT(D2,E2)

PROPER:

=PROPER(A2)

REPT:

=REPT(A2,5)

FINAL ANSWER SUMMARY

Question Answer
Q1 8, 16, 125, 36, 1,000
Q2 30, 32, 63, 60, 150
Q3 335
Q4 Rahul Sharma, Neha Kapoor, Amit Verma, Priya Singh, Karan Mehta
Q5 AAAAA, ABABAB, **********, ——–, ExcelExcelExcel
Q6 2,401
Q7 3,600
Q8 Advanced Excel Training
Q9 20 hyphens
PreviousNext