Question

please give some formula in execl spread sheet plz fast for exam​

Answer 1

Required Answer :

Some formula in execl spreadsheet

Sum two numbers :

• =SUM(number1+number2)

Subtraction two numbers :

• =number1-number2

Multiplication two numbers :

• =number1*number2

Maximum :

• =MAX(select the number)

Minimum :

• =MIN(select the number)

Percentage :

• =Total number/Total subject number

Sum by month ignore year :

• =SUMPRODUCT((MONTH(dates)=month)*amounts)

Count cell between dates :

• =COUNTIES(range, ">=&date1, range, "<="&date2)

Count cell between two numbers :

• =COUNTIES(range, ">=X", range, "<=Y")

Count cell equal to one of many things :

• =SUMPRODUCT(COUNTIF(rng,things))

Count cell equal to case sensitive :

• SUMPRODUCT((-- EXACT(value,range,D3)))

3D sum multiple worksheets :

• =SUM(Sheet1:Sheet3!A1)

3D SUMIF for multiple worksheets :

• =SUMPRODUCT(SUMIF(INDIRECT("'"&sheets&"'!"&"rng"),criteria,INDIRECT("'"&sheets&"'!"&"sumrng")))

Subtotal by color :

• =SUMIF(color_range,criteria,number_range)

Minimum value if :

• {=MIN(IF(range=criteria,values))}

Strip html from text or numbers :

• =MID(text,start,LEN(text)-markup_len)

Summary count with percentage breakdown :

• =COUNTIF(range,criteria)/COUNTA(range)

Large with criteria :

• {=LARGE(IF(range=criteria,values),n)}

Win loss points calculation :

• =VLOOKUP(result,points_table,2,0)

Map text to numbers :

• =VLOOKUP(text,lookup_table,2,0)

Extra Brainly Knowledge :

Some important Spreadsheet shortcut :

Create new workbook :

→ Ctrl + N

Open workbook :

→ Ctrl + O

Save workbook :

→ Ctrl + S

Save as :

→ F12

Print file :

→ Ctrl + P

Close excel :

→ Alt + F4

Cut text :

→ Ctrl + X

Copy text :

→ Ctrl + C

Drag and copy :

→ Ctrl + drag

Spreadsheet has many advantages, such as,

• Records management.
• Analysis data.
• Creating MIS.
• Generating graphs.

Spreadsheet software are follow as :

• MS-Excel.
• Open office - Calc.
• Google documents.

Answer 2

SUM. The SUM function. The function will sum up cells that are supplied as multiple arguments. ...

AVERAGE. The AVERAGE function. ...

COUNT. The COUNT function. ...

COUNTA. Like the COUNT function, COUNTA. ...

IF. The IF function. ...

TRIM. The TRIM function. ...

MAX & MIN. The MAX.

hope this helps!!