Excel Function

Question 1

is the most widely used cell reference in formulas in Excel.

Answer 1

relative reference

Question 1

is indicated in your spreadsheet by a $ sign around the cell

Answer 1

absolute reference

Question 2

absolute cell reference that allows the row reference to change, but not the column reference

Answer 2

$A1

Question 3

absolute cell reference that allows the column reference to change, but not the row reference

Answer 3

A$1

Question 4

absolute cell reference that allows neither the column nor the row reference to change- this is the default one

Answer 4

$A$1

Question 5

is a predefined formula already available in Excel and perform specific calculations in a particular order based on the specified values, called arguments, or parameters

Answer 5

functions

Question 6

function use to add up all the values

Answer 6

sum

Question 7

function use to get the average of values

Answer 7

average

Question 8

function use to get the remainder

Answer 8

mod

Question 9

function use to get the product of all values

Answer 9

product

Question 10

function use to get the quotient of two numbers

Answer 10

quotient

Question 11

formulas in Excel get the largest and smallest value in a set of numbers, respectively

Answer 11

max and min

Question 12

function to compare numbers to other numbers in the same list

Answer 12

rank

Question 13

3 arguments for the rank function

Answer 13

number, ref, order

Question 14

In case you want to take values from two or more cells and combine them into one cell

Answer 14

concatenate

Question 15

To see the current date and time whenever you open your worksheet without having to manually update it on a daily basis

Answer 15

today and now

Question 16

function deals only with those cells that contain numbers

Answer 16

count

Question 17

function counts all cells thatare not blank, whether they contain numbers, dates, times, text, logical values of TRUE and FALSE, errors or empty text strings (“”):

Answer 17

counta

Question 18

is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect

Answer 18

if function

Question 19

relational operators

Answer 19

Less than (<)
Greater than (>)
Equal (=)
Less than equal (<=)
Greater than equal (>=)
Not equal (<>)

Question 20

Boolean operators

Answer 20

AND
OR

Question 21

advanced functions in excel

Answer 21

COUNTIF
SUMIF
AVERAGEIF

Question 22

is used for counting cells within a specified range that meet a certain criterion, or condition

Answer 22

countif function

Question 23

defines one or several cells to count

Answer 23

range

Question 24

defines the condition that tells the function which cells to count. It can be a number, text string, cell reference or expression

Answer 24

criteria

Question 25

is a function to sum cells that meet a single criteria

Answer 25

sumif function

Question 26

syntax of sumif function

Answer 26

=SUMIF (range, criteria, [sum_range])

Question 27

function in Excel calculates the average (arithmetic mean) of all the cells that meet a specified criteria

Answer 27

average if function

Question 28

syntax of averageif function

Answer 28

AVERAGEIF(range, criteria, [average_range])

Question 29

syntax of countif function

Answer 29

COUNTIF(range, criteria)