3. Write the suitable term for the following.
a. The feature that automatically adds the numbers in the selected cells in
MS Excel.
b. Name the chart that displayed in the form of long rectangular rods called
bars and values are represented along the horizontal bars.
c. Name the reference where row and column references will change when we
copy formula to another cell.
Answers
Answer:
a.All you need is to select a cell next to the numbers you want to add the values of the selected cells and then click on the AutoSum on the Home tab and press enter. When someone clicks the AutoSum function, MS Excel automatically enters a formula to find out the sum the numbers.
B.The title of the horizontal bar graph tells about the data being represented by the graph. The vertical axis represents the data categories. Here, the data categories are the colors. The horizontal axis represents the values corresponding to each data value.
C.Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill.