function and text function in excel part 1

it's any thing that you can input to excel after equal sign

• function

• metrics

• formula

• all of them

it's built-in formula in excel you can use to perform mathematical , logical and statistical operations

• function

• metrics

• formula

• all of them

choose the correct sentence

• all formulas are functions

• all functions are formulas

• there are no difference between function and formula

• there are no relation between function and formula

it is a set of calculations that help a business measure certain aspects of their operations

• function

• metric

• formula

• all of them

it is a group of cells selected or addressed together

• cell

• cell name

• group of cells

• range

range be known by

• all contained cells

• upper left and lower right cells

• the cell that in its middle

• none

if i am working with a data set by single function with 203 rows what is the best choice

• do it 203 times

• write a code

• autofill feature

• all of them

that is type of range when i move by autofill it moves with me

• relative range

• absolute range

• range

• custom range

it is type of ranges that is fixed and cannot move by the autofill

• relative

  range

• absolute

  range

• range

• custom range

it is a function that used to change some letters in the specific cell in other cell

• len

• mid

• substitute

• find and replace