Excel Formulas Table 51 - 100 - EXCEL SOFTWARE MASTERING | SmartNote Notes

Topics & Subtopics

000-Complete Excel Mastering Topics

1. Complete Excel Mastering Topics — Comprehensive Index

001-Excel Introduction

1. Excel Introduction

Excel Formulas Table 1 - 50

1. Excel Formulas Table 1 - 50

Excel Formulas Table 51 - 100

1. Excel Formulas Table 51 - 100

Excel Functions Practice - Student Marks

1. Excel Functions Practice - Student Marks

MICROSOFT QUESTIONS MS Office Exam: Word, Excel, Access

1. MS Office Exam: Word, Excel, Access

⬅ Back to Topics

Excel Formulas Table 51 - 100

Objectives: Excel Formulas Table

Excel Formulas Table (Jedwali la Formulas za Excel 100)

Excel Formulas Table / Jedwali la Formulas za Excel (100)

This table contains 100 essential Excel formulas, explained in English and Swahili with simple examples.
Jedwali hili lina formulas 100 muhimu za Excel zikiwa na maelezo ya Kiingereza na Kiswahili na mifano rahisi kuelewa.

No.	Formula Name / Jina la Formula	Description / Maelezo	Example / Mfano
51	`=PMT()`	Loan payment calculation / Malipo ya mkopo	`=PMT(5%/12,60,10000)`
52	`=FV()`	Future value / Thamani ya baadaye	`=FV(5%/12,60,-200)`
53	`=NPV()`	Net present value / Thamani halisi ya sasa	`=NPV(0.08,B2:B6)`
54	`=IRR()`	Internal rate of return / Kiwango cha ndani cha riba	`=IRR(B2:B6)`
55	`=SLN()`	Straight-line depreciation / Upunguzaji wa mstari	`=SLN(10000,2000,5)`
56	`=DDB()`	Double-declining depreciation / Upunguzaji wa mara mbili	`=DDB(10000,2000,5,2)`
57	`=SYD()`	Sum-of-years depreciation / Upunguzaji wa jumla ya miaka	`=SYD(10000,2000,5,3)`
58	`=STDEV.P()`	Population standard deviation / Kipimo cha kawaida cha idadi	`=STDEV.P(A1:A10)`
59	`=STDEV.S()`	Sample standard deviation / Kipimo cha kawaida cha sampuli	`=STDEV.S(A1:A10)`
60	`=VAR.P()`	Population variance / Tope la idadi	`=VAR.P(A1:A10)`
61	`=VAR.S()`	Sample variance / Tope la sampuli	`=VAR.S(A1:A10)`
62	`=TEXT()`	Format number as text / Kuunda namba kama maandishi	`=TEXT(A1,"$#,##0.00")`
63	`=REPLACE()`	Replace part of text / Badilisha sehemu ya maandishi	`=REPLACE(A1,1,3,"New")`
64	`=SUBSTITUTE()`	Replace text / Badilisha maandishi yote	`=SUBSTITUTE(A1,"old","new")`
65	`=FIND()`	Find text position / Tafuta nafasi ya maandishi	`=FIND("abc",A1)`
66	`=SEARCH()`	Similar to FIND, case-insensitive / Kama FIND lakini haioni herufi kubwa ndogo	`=SEARCH("abc",A1)`
67	`=TEXTSPLIT()`	Split text into array / Gawanya maandishi katika array	`=TEXTSPLIT(A1," ")`
68	`=FILTER()`	Filter array / Chuja orodha	`=FILTER(A1:B10,B1:B10>50)`
69	`=SORT()`	Sort array / Pangilia orodha	`=SORT(A1:A10)`
70	`=SORTBY()`	Sort by criteria / Pangilia kwa sharti	`=SORTBY(A1:A10,B1:B10,1)`
71	`=UNIQUE()`	Unique values / Thamani za kipekee	`=UNIQUE(A1:A10)`
72	`=SEQUENCE()`	Generate numbers / Tengeneza namba	`=SEQUENCE(10,1,1,1)`
73	`=XMATCH()`	Find position / Tafuta nafasi (new)	`=XMATCH(50,A1:A10)`
74	`=LET()`	Assign names inside formula / Tumia jina ndani ya formula	`=LET(x,A1+10,x*2)`
75	`=LAMBDA()`	Create custom function / Unda function yako	`=LAMBDA(x,x^2)(5)`
76	`=XLOOKUP()`	Flexible lookup / Kutafuta kwa urahisi zaidi	`=XLOOKUP(A1,B1:B10,C1:C10,"Not Found")`
77	`=CHISQ.TEST()`	Chi-square test / Jaribio la chi-square	`=CHISQ.TEST(A1:A10,B1:B10)`
78	`=CORREL()`	Correlation coefficient / Kiwango cha uhusiano	`=CORREL(A1:A10,B1:B10)`
79	`=COVARIANCE.P()`	Population covariance / Uwiano wa idadi	`=COVARIANCE.P(A1:A10,B1:B10)`
80	`=COVARIANCE.S()`	Sample covariance / Uwiano wa sampuli	`=COVARIANCE.S(A1:A10,B1:B10)`
81	`=FORECAST()`	Forecast future value / Thamani ya makadirio	`=FORECAST(15,A1:A10,B1:B10)`
82	`=FORECAST.LINEAR()`	Linear forecast / Makadirio ya mstari	`=FORECAST.LINEAR(15,A1:A10,B1:B10)`
83	`=GROWTH()`	Exponential growth forecast / Makadirio ya ukuaji	`=GROWTH(A1:A10,B1:B10)`
84	`=TREND()`	Linear trend / Mwelekeo wa mstari	`=TREND(A1:A10,B1:B10)`
85	`=SLOPE()`	Slope of linear regression / Mteremko	`=SLOPE(A1:A10,B1:B10)`
86	`=INTERCEPT()`	Intercept of linear regression / Kati ya mstari	`=INTERCEPT(A1:A10,B1:B10)`
87	`=LINEST()`	Linear regression stats / Takwimu regression ya mstari	`=LINEST(A1:A10,B1:B10,TRUE,TRUE)`
88	`=MODE.SNGL()`	Most frequent value / Thamani ya mara nyingi	`=MODE.SNGL(A1:A10)`
89	`=MODE.MULT()`	Multiple modes / Thamani nyingi za mara nyingi	`=MODE.MULT(A1:A10)`
90	`=MEDIAN()`	Median value / Thamani ya katikati	`=MEDIAN(A1:A10)`
91	`=PERCENTILE.INC()`	Percentile / Asilimia	`=PERCENTILE.INC(A1:A10,0.9)`
92	`=PERCENTILE.EXC()`	Percentile exclusive / Asilimia isiyo jumuishwa	`=PERCENTILE.EXC(A1:A10,0.9)`
93	`=RANK.EQ()`	Rank value / Nafasi ya namba	`=RANK.EQ(A1,A1:A10,0)`
94	`=RANK.AVG()`	Average rank / Nafasi ya wastani	`=RANK.AVG(A1,A1:A10,0)`
95	`=ISNUMBER()`	Checks if cell has number / Angalia kama namba	`=ISNUMBER(A1)`
96	`=ISTEXT()`	Checks if cell has text / Angalia kama maandishi	`=ISTEXT(A1)`
97	`=ISBLANK()`	Checks if cell is empty / Angalia kama seli tupu	`=ISBLANK(A1)`
98	`=ERROR.TYPE()`	Returns error type / Rudisha aina ya kosa	`=ERROR.TYPE(A1)`
99	`=FORMULATEXT()`	Show formula as text / Onyesha formula kama maandishi	`=FORMULATEXT(A1)`
100	`=HYPERLINK()`	Create clickable link / Tengeneza link inayo bonyezeka	`=HYPERLINK("http://example.com","Click Here")`

Reference Book: N/A

Author name: SIR H.A.Mwala Work email: biasharaboraofficials@gmail.com
#MWALA_LEARN Powered by MwalaJS #https://mwalajs.biasharabora.com
#https://educenter.biasharabora.com

:: 1::

⬅ ➡