Advanced and Complex Formulas and Computations

Question 1

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.

Answer 1

Spreadsheet Software

Question 2

Spreadsheet Software Examples

Answer 2

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

Question 3

horizontal line of entries in a table

Answer 3

Row

Question 4

vertical line of entries in a table

Answer 4

Column

Question 5

the place where info. is held in a spreadsheet

Answer 5

Cell

Question 6

the selected cell

Answer 6

Active Cell

Question 7

the box at the top of each column containing a letter

Answer 7

Column Heading

Question 8

the row number

Answer 8

Row Heading

Question 9

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

Answer 9

Cell Reference

Question 10

combining or joining two or more cells

Answer 10

Merge

Question 11

is an expression that calculates the value of a cell.

Answer 11

• Cells Formula

Question 12

are predefined formulas and are already available in Excel

Answer 12

Functions

Question 13

the bar that displays the contents of a cell

Answer 13

Formula Bar

Question 14

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

Basic Math Operations (Functions)

Answer 14

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

Question 15

returns the product of x and y

Basic Math Operations (Functions)

Answer 15

=PRODUCT(x,y)

Question 16

returns the quotient of x divided by y

Basic Math Operations

Answer 16

=QUOTIENT(x,y)

Question 17

returns the difference of x subtracted by y

Basic Math Operations

Answer 17

=x-y

Question 18

returns the sum of x and y

Basic Math Operations

Answer 18

=x+y

Question 19

returns the product of x and y

Basic Math Operations

Answer 19

=x*y

Question 20

returns the quotient of x divided by y

Basic Math Operations

Answer 20

=x/y

Question 21

returns the absolute value of x

Other Functions

Answer 21

=ABS(x)

Question 22

returns the average of x and y

Other Functions

Answer 22

=AVERAGE(x,y)

Question 23

joins x and y

Other Functions

Answer 23

=CONCATENATE(x,y)

Question 24

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

Answer 24

=IF(Condition, x, y)

Question 25

returns true if x is an even number

Answer 25

=ISEVEN(x)

Question 26

returns true if x is an odd number

Answer 26

=ISODD(x)

Question 27

counts the number of cells containing a number within a range

Answer 27

=COUNT(range)

Question 28

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

Answer 28

=COUNTIF(range, criteria)

Question 29

returns true if x is a number

Answer 29

=ISNUMBER(x)

Question 30

returns true if x is a text

Answer 30

=ISTEXT(x)

Question 31

returns the length of characters in x

Answer 31

=LEN(x)

Question 32

returns the proper casing of x

Answer 32

=PROPER(x)

Question 33

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

Answer 33

=LEFT(x,y)

Question 34

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

Answer 34

=RIGHT(x,y)

Question 35

returns the value of pi

Answer 35

=PI()

Question 36

returns the smallest number between x and y

Answer 36

=MIN(x,y)

Question 37

returns the largest number between x and y

Answer 37

=MAX(x,y)

Question 38

returns the smallest number within the range

Answer 38

=MIN(range)

Question 39

returns the largest number within the range

Answer 39

=MAX(range)

Question 40

returns the value of x raised to the power of y

Answer 40

=POWER(x,y)

Question 41

rounds x to a specified number of digits (y)

Answer 41

=ROUND(x,y)

Question 42

returns the column number of x

Answer 42

=COLUMN(x)

Question 43

returns the row number of x

Answer 43

=ROW(x)

Question 44

returns the square root of x

Answer 44

=SQRT(x)

Question 45

removes extra spaces in x

Answer 45

=TRIM(x)

Question 46

returns x in all capital form

Answer 46

=UPPER(x)

Question 47

returns x in non- capital form

Answer 47

=LOWER(x)

Question 48

returns the current date

Answer 48

=TODAY()

Question 49

returns the current date and time

Answer 49

=NOW()

Question 50

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

Answer 50

Conditional Formatting

Question 51

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.

Answer 51

Conditional Formatting