MICROSOFT EXCEL (SPREADSHEET)

Question 1

it allow large set or group of data to be stored, organized, analyzed, and interpreted automatically

Answer 1

spreadsheet

Question 2

it gives the total of the selected range of cell values. it performs the mathematical operation which is addition

Answer 2

sum ()

Question 3

it focuses on calculating the average of the selected range of cell values

Answer 3

average ()

Question 4

it counts the total number of cells in a range that contains a number. it does not include the cell that is blank and the ones that holds data in any other format apart from numeric

Answer 4

count ()

Question 5

it returns the subtotal in a database.

Answer 5

subtotal

Question 6

it works on returning the remainder when a particular number is divided by a divisor

Answer 6

modulus

Question 7

returns the result of a number raised to a certain power

Answer 7

power

Question 8

it rounds a number up to its nearest multiple of significance

Answer 8

ceiling

Question 9

rounds a number down to the nearest multiple of significance

Answer 9

floor

Question 10

it merges or joins several text strings into one text string

Answer 10

concatenate

Question 11

it returns the total number of characters in a string. it will count the overall characters, including spaces and special characters

Answer 11

len

Question 12

works on replacing the part of a text string with a different text string

Answer 12

replace

Question 13

replaces the existing text with a new text in text string

Answer 13

substitute

Question 14

converts any text string to uppercase

Answer 14

upper

Question 15

converts any text string to lowercase

Answer 15

lower

Question 16

converts any text string to proper case

Answer 16

proper

Question 17

it gives the number of characters from the start of a text string

Answer 17

left

Question 18

returns the characters from the middle of a text string

Answer 18

mid

Question 19

returns the number of characters from the end of a text string

Answer 19

right ()

Question 20

gives the current system date and time

Answer 20

now ()

Question 21

provides the current system dateg

Answer 21

today ()

Question 22

generates the hour from a time value as a number from 0-23

Answer 22

hour, minute, second

Question 23

converts hours, minutes, seconds given us numbers to an excel serial number, formatted with a time format

Answer 23

time ()

Question 24

provides the difference between two dates in terms of years, months, or days

Answer 24

datedif

Question 25

it stands for the vertical lookup that is responsible for looking for a particular value in the leftmost column of a table

Answer 25

vlookup

Question 26

it is the value that you have to look for in the first column of a table

Answer 26

lookup_value

Question 27

indicates the table from which the value is retrieved

Answer 27

table

Question 28

the column in the table from the value is to be retrieved

Answer 28

col_index

Question 29

approximate match

Answer 29

TRUE

Question 30

exact match

Answer 30

FALSE

Question 31

looks for a value in the top row of a table or array of benefits

Answer 31

hlookup

Question 32

checks a given condition and returns a particular value if it is TRUE. it will return another value if the condition is FALSE

Answer 32

IF ()

Question 33

it is used to return a value in a column to the left. with this, you are stuck returning an appraisal from a column to the right

Answer 33

index-match

Question 34

it is used to count the total number of cells within a range that meet the given condition

Answer 34

countif()