MS EXCEL

ELEMENTS

10

What element displays the active cell?

Name Box

15

What element is in between row and column?

Cell

25

What element runs horizontally on the Excel sheet?

Rows

30

What element can be found at the top window?

Tabs

40

What element provides easy access to various features and functionalities?

Ribbon & Ribbon Group

FUNCTION

10

What function calculates the average?

Average

15

What function adds up the value of a range of cells?

Sum

25

What function counts the number of cells based on numbers?

Count

30

What function merges one text to another text?

Concatenate

40

What function counts the number of cells based on alphabets?

CountA

CONDITIONAL

10

What conditional function counts how many times it is listed?

Countif

15

What conditional function sums the values in a range that meet a specified condition. 

Sumif

25

What conditional function calculates the average of a range of cells that meet a specified condition?

Averageif

30

What conditional function allows defining values returned for TRUE and FALSE outcomes?

IF

40

What conditional function is useful for complex logical tests with multiple criteria?

IFS