Microsoft Excel Flashcards

1
Q

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

A

SUM() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

=SUM(sum_range)

A

SUM() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

SUMIF() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

=SUMIF(range,criteria,sum_range)

A

SUMIF() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

Range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Value which will define which cells will be summed up.

A

Criteria

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Range of cells to be summed up.

A

Sum_range

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

AVERAGE() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

AVERAGE() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

COUNT() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

COUNT() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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.

A

IF() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

IF() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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.

A

AND() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

AND() Function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

AND() Function (Nested to IF Function)

17
Q

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

A

VLOOKUP() Function

18
Q

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

A

VLOOKUP() Function

19
Q

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

A

Look_up value

20
Q

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

A

Table_range

21
Q

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

A

Column_index_number

22
Q

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.

A

Range_lookup

23
Q

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

A

CONCATENATE() Function

24
Q

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

A

CONCATENATE() Function

25
Q

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

A

Geography of Excel