Microsoft Excel

Question 1

Function that allows the numerical data in any number columns or rows by selecting them or typing them.

Answer 1

SUM() Function

Question 2

=SUM(sum_range)

Answer 2

SUM() Function

Question 3

Function used to summate the values of cells in a range that meet the criteria that have been specified.

Answer 3

SUMIF() Function

Question 4

=SUMIF(range,criteria,sum_range)

Answer 4

SUMIF() Function

Question 5

Cells that contain values and from which values will be checked against the criteria.

Answer 5

Range

Question 6

Value which will define which cells will be summed up.

Answer 6

Criteria

Question 7

Range of cells to be summed up.

Answer 7

Sum_range

Question 8

Function that allows the user to get the average of all the numbers in the chosen cells.

Answer 8

AVERAGE() Function

Question 9

=AVERAGE(range to be averaged) Example: =AVERAGE(B5:B9)

Answer 9

AVERAGE() Function

Question 10

Function used to count the number chosen cells that have a number value in them.

Answer 10

COUNT() Function

Question 11

=COUNT(range to be counted) Example: =COUNT(B5:B9)

Answer 11

COUNT() Function

Question 12

Function allows users to achieve a particular value if the condition has been satisfied or TRUE, or if the condition has not been satisfied by FALSE.

Answer 12

IF() Function

Question 13

=IF(condition,resultifTRUE,resultifFALSE) Example: =IF(B5>74.99,”PASSED”,”FAILED”)

Answer 13

IF() Function

Question 14

Function that will test all the conditions set and will return a “TRUE” value if ALL the conditions are met and “FALSE” even if only one condition is not.

Answer 14

AND() Function

Question 15

=AND(condition to be met) Example: =AND(B5=”PASSED”,C5=”PASSED”,D5=”PASSED”)

Answer 15

AND() Function

Question 16

*Nested to IF Function
=IF(AND(condition to be met)) Example: =IF(AND(B5=”PASSED”,C5=”PASSED”,D5=”PASSED”),”PASSED”,”FAILED”)

Answer 16

AND() Function (Nested to IF Function)

Question 17

Function that enables users to find something on the leftmost column of the chosen range and return a value related t o it.

Answer 17

VLOOKUP() Function

Question 18

=VLOOKUP(lookup_value,table_range,column_index_number,range lookup) Example: =VLOOKIP(A4,A10:C16,3,FALSE)

Answer 18

VLOOKUP() Function

Question 19

The value to be found in the leftmost column of the table array. This can be cell reference or an actual value.

Answer 19

Look_up value

Question 20

The table from which the data is retrieved and the table being searched.

Answer 20

Table_range

Question 21

The column number in the table array from which the value is to be retrieved.

Answer 21

Column_index_number

Question 22

A logical value that can be either “TRUE” or “FALSE”. If left empty, the formula will consider it as “TRUE” and will look for the closest value in Column 1. If “FALSE”, the formula will look for the exact match.

Answer 22

Range_lookup

Question 23

Function that combines two or more text strings. It combines the values from two or more cells into another cell.

Answer 23

CONCATENATE() Function

Question 24

=CONCATENATE(text1,text2,text3) Example: =CONCATENATE(A4,” “,B4)

Answer 24

CONCATENATE() Function

Question 25

Quick Access (Topmost)
The Ribbon (Where all the features are)
Name Box (Name of the cell)
Formula Bar (Where to input the functions)
Column
Row
Cell
Worksheet (Underneath)
Worksheet View Options
Zoom Control

Answer 25

Geography of Excel