Ms Excel

Question 1

SpreadSheets Software

Answer 1

allows users to organize data in rows an columns and perform calculations on the data. These rows and columns collectively are called worksheet

Question 2

Microsoft Excel

Answer 2

is a spread sheets developed by Microsoft for Windows, MacOs, Android and iOs. It features calculations, graphing, tools, pivot tables, and a macro programming language called Visual Basic for Application

Question 3

Row

Answer 3

horizontal line of entries in a tables

Question 4

Column

Answer 4

vertical line of entries in a table

Question 5

Cell

Answer 5

the place where info is held in a spreadsheet

Question 6

Active Cell

Answer 6

the selected cell

Question 7

Column Heading

Answer 7

the box at the top of each column containing a letter

Question 8

Row Heading

Answer 8

the row number

Question 9

Cell Reference

Answer 9

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

Question 10

Merge

Answer 10

combining or joining two or more cells

Question 11

Functions Bar

Answer 11

the bar that displays the contents of a cell

Question 12

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

Answer 12

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

Question 13

=PRODUCT(x,y)

Answer 13

returns the product of x and y

Question 14

=QUOTIEN(x,y)

Answer 14

returns the quotient of x divided by y

Question 15

=x-y

Answer 15

returns the difference of x subtracted by y

Question 16

=x+y(x)

Answer 16

returns the sum of x and y

Question 17

=x*y(x)

Answer 17

returns the product of x and y

Question 18

=x / y

Answer 18

returns the quotient of divided by y

Question 19

=x-y

Answer 19

returns the difference of x subtracted by y

Question 20

=ABS( X )

Answer 20

returns the absolute value of x

Question 21

=AVERAGE( x,y )

Answer 21

turns the average of x and y

Question 22

=CONCATENATE( x,y ) -joins x and y

Answer 22

joins x and y

Question 23

=IF( Condition x , y )

Answer 23

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

Question 24

=ISEVEN( x )

Answer 24

returns true if x is an even number

Question 25

=ISODD( x )

Answer 25

returns rue if x is an odd number

Question 26

=COUNT( range )

Answer 26

counts the number of cell containing a number within a range

Question 27

=COUNTIF( range , criteria )

Answer 27

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

Question 28

=ISNUMBER( x )

Answer 28

returns true if x is a number

Question 29

=ISTEXT( X )

Answer 29

returns true if x is a text

Question 30

=LEN( X )

Answer 30

returns the length of characters in x

Question 31

=PROPER( x )

Answer 31

returns the proper casing of x

Question 32

=LEFT( x,y )

Answer 32

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

Question 33

=RIGHT( x,y )

Answer 33

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

Question 34

=PI()

Answer 34

returns the value of pi

Question 35

=MIN( x,y )

Answer 35

returns the smallest number between x and y

Question 36

=MAX( x,y )

Answer 36

returns the largest number between x and y

Question 37

=MAX( range )

Answer 37

returns the largest number within the range

Question 38

=POWER( x , y )

Answer 38

returns the value of x raised to the power of y

Question 39

=ROUND( x , y )

Answer 39

rounds x to a specified number of digits ( y )

Question 40

=COLUMN( X )

Answer 40

returns the column number of x

Question 41

=ROW( x )

Answer 41

returns the row number of x

Question 42

=SQRT( X )

Answer 42

returns the square root of x

Question 43

=TRIM( x )

Answer 43

removes extra spaces in x

Question 44

=UPPER ( X )

Answer 44

returns x in all capital form

Question 45

=LOWER( X )

Answer 45

returns x in non- capital form

Question 46

=TODAY( )

Answer 46

returns the current date

Question 47

=NOW( )

Answer 47

returns the current date and time