Advanced Spreadsheet skills

Question 1

Provides an automated way of displaying any statistical data. It can be used to automatically compute for several factors that are not easy t notice specially when faced by a large data.

Answer 1

Microsoft Excel

Question 2

Includes several arithmetic and basic functions that help you compute faster.

Answer 2

Microsoft Excel

Question 3

The 4 basic excel formulas

Answer 3

Addition, Subtraction, Multiplication, Division

Question 4

Type ____ before the formula

Answer 4

=

Question 5

Combines data into one cell

Answer 5

Concatenate

Question 6

Allows us to add 2 or more number together

Answer 6

SumFunction

Question 7

Counts the numbers of cells in a range that have numbers in them.

Answer 7

Count Function

Question 8

Count the numbers of non-empty cells in a range. It will count cells that have numbers and/or any other character in them.

Answer 8

CountA Function

Question 9

Counts the number of character in a cell. It also include the space.

Answer 9

LEN Function

Question 10

Useful for removing extra space in a cell whether at beginning, trailing, or anywhere between the words.

Answer 10

Trim Function

Question 11

Is a very powerful formula which can be used to derive results of complex problems.

Answer 11

IF Statement

Question 12

It can be used to avoid multiple steps while working on a worksheet and instead can give result in one shot.

Answer 12

IF Statement

Question 13

Formula for IF Statement

Answer 13

=IF(logical_test, value_if_true, value_if_false)

Question 14

A function used to compute for the average of the number of a range

Answer 14

Average

Question 15

A function used to count the cells with a specified content within a range.

Answer 15

Count IF

Question 16

A function used to compute for the summation of a range if a certain condition is met

Answer 16

Sum IF

Question 17

A function used to compute for the average of a range if a certain condition is met

Answer 17

Average IF