BASICS_OF_EXCEL and its formulas to calculate Examples.

santhoshs176 5 views 24 slides Jul 29, 2024

Slide 1 of 24

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

About This Presentation

BASICS_OF_EXCEL

Size: 1.47 MB

Language: en

Added: Jul 29, 2024

Slides: 24 pages

Slide Content

Statistical Functions

4. COUNTIFS function COUNTIFS function is the most used function in Excel. The function will work on one or more than one condition in a given range and counts the cell that meets the condition.

Mathematical Function in Excel

1. SUM

2. Sumif

SUMIF

Ans

Explanation: if the score is greater than or equal to 60, the IF function returns Pass, else it returns Fail.

Tags

excel formulas like sum avg ro

Categories

Finance

Download

Download Slideshow Get the original presentation file

Quick Actions

Statistics

Views 5
Slides 24
Age 491 days

Related Slideshows

View More in This Category