Advanced and Complex Formulas and Computations Flashcards

1
Q

a tool that is used to
store, manipulate, and analyze data. Data in a spreadsheet is organized in a series of rows and columns and can be searched, sorted, calculated, and used in a variety of charts and graphs.

A

Spreadsheet Software

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

Spreadsheet Software Examples

A

*LibreOffice Calc
*OpenOffice.org Calc
*Google Sheets
*Apple iWork Numbers
*Kingsoft Office Spreadsheets
*StarOffice Calc
*Microsoft Excel

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

horizontal line of entries in a table

A

Row

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

vertical line of entries in a table

A

Column

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

the place where info. is held in a spreadsheet

A

Cell

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

the selected cell

A

Active Cell

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

the box at the top of each column containing a letter

A

Column Heading

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

the row number

A

Row Heading

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

the cell address of the cell usually combine letter and number (ex. A1, B4, C2)

A

Cell Reference

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

combining or joining two or more cells

A

Merge

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

is an expression that calculates the value of a cell.

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

are predefined formulas and are already available in Excel

A

Functions

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

the bar that displays the contents of a cell

A

Formula Bar

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

returns the sum of x and y or (all the numbers within the range)

Basic Math Operations (Functions)

A

=SUM(x,y) or =SUM(range)

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

returns the product of x and y

Basic Math Operations (Functions)

A

=PRODUCT(x,y)

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

returns the quotient of x divided by y

Basic Math Operations

A

=QUOTIENT(x,y)

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

returns the difference of x subtracted by y

Basic Math Operations

A

=x-y

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

returns the sum of x and y

Basic Math Operations

A

=x+y

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

returns the product of x and y

Basic Math Operations

A

=x*y

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

returns the quotient of x divided by y

Basic Math Operations

A

=x/y

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

returns the absolute value of x

Other Functions

A

=ABS(x)

22
Q

returns the average of x and y

Other Functions

A

=AVERAGE(x,y)

23
Q

joins x and y

Other Functions

A

=CONCATENATE(x,y)

24
Q

returns x if the condition is true, else it returns y

A

=IF(Condition, x, y)

25
Q

returns true if x is an even number

A

=ISEVEN(x)

26
Q

returns true if x is an odd number

A

=ISODD(x)

27
Q

counts the number of cells containing a number within a range

A

=COUNT(range)

28
Q

count the number of cell that fits with the criteria within the range

A

=COUNTIF(range, criteria)

29
Q

returns true if x is a number

A

=ISNUMBER(x)

30
Q

returns true if x is a text

A

=ISTEXT(x)

31
Q

returns the length of characters in x

A

=LEN(x)

32
Q

returns the proper casing of x

A

=PROPER(x)

33
Q

returns the characters of x specified by y (from the left)

A

=LEFT(x,y)

34
Q

returns the characters of x specified by y (from the right)

A

=RIGHT(x,y)

35
Q

returns the value of pi

A

=PI()

36
Q

returns the smallest number between x and y

A

=MIN(x,y)

37
Q

returns the largest number between x and y

A

=MAX(x,y)

38
Q

returns the smallest number within the range

A

=MIN(range)

39
Q

returns the largest number within the range

A

=MAX(range)

40
Q

returns the value of x raised to the power of y

A

=POWER(x,y)

41
Q

rounds x to a specified number of digits (y)

A

=ROUND(x,y)

42
Q

returns the column number of x

A

=COLUMN(x)

43
Q

returns the row number of x

A

=ROW(x)

44
Q

returns the square root of x

A

=SQRT(x)

45
Q

removes extra spaces in x

A

=TRIM(x)

46
Q

returns x in all capital form

A

=UPPER(x)

47
Q

returns x in non- capital form

A

=LOWER(x)

48
Q

returns the current date

A

=TODAY()

49
Q

returns the current date and time

A

=NOW()

50
Q

is a special
feature (formatting feature) of Excel used to find unique and duplicate values by formatting the cells.

A

Conditional Formatting

51
Q

As the name implies ________________ allows the users to format the cells and their data based on some conditions specified by the user. Using conditional formatting, you can highlight a cell with a certain color and its content with a different font.

A

Conditional Formatting