Question

Answer it fast . Right answer will be marked as Brainliest answer and no useless thing to write or the answer will be reported​

Answer 1

Answer:

(1)In contrast, the definition of absolute cell reference is one that does not change when it's moved, copied or filled. This way, the reference points back to the same cell, no matter where it appears in the workbook. Its indicated by a dollar in the column or row coordinate.

Answer 2

Answer:

here's the first one

Excel automatically makes the cell reference absolute! By continuing to press F4, Excel will cycle through all of the absolute reference possibilities. For example, in the first absolute cell reference formula in this tutorial, =B4*$B$10, I could have typed, =B4*B10, then pressed the F4 key to change B10 to $B$10.

here's the second one

To sum a row of numbers, select the cell immediately to the right. AutoSum is in two locations: Home > AutoSum, and Formulas > AutoSum.

here's the third one

SORTING DATA = ARRANGING THE DATA IN ASCENDING OR DESCENDING ORDER IS DEFINED AS SORTING . FILTERING DATA = FILTERS ARE USED TO LIMIT THE DATA IN A WORKSHEET AND HIDE PARTS OF IT . FILTERING ALLOWS US TO DISPLAY ONLY THE DATA THAT WE WANT TO VIEW.

here's the fourth one

A conditional format changes the appearance of cells on the basis of conditions that you specify. ... If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.

and sorry for fifth because I don't know the answer