Question

mart, scatter
B. Fill in the blanks with the help of given words.
Data Series Line Max Charts Formula
is an expression that is made up of numbers, arithmetic
function displays the highest value in the given range of cells.
chart has data points connected with lines which makes it
3.
T11c
cis or X-axis,
formatting
1.
operators, cell address and parenthesis.
2.
group, select the
easy to interpret data values if increasing or decreasing.
To create a chart, on the Insert tab, in the
desired chart category.
4.
is the data entries from where a chart is derived.
5.
C. Write (T) for true and (F) for false statements.
1. To join two strings use the dollar($) character.
MONO
2. Cell reference, $E$1, is a valid mixed cell reference.
3. In Pie chart, each data value represents one slice of a pie.
4. Chart styles identifies the data series and defines a unique color to
make it easily distinguishable.
00 000
5. Bar chart connects dots to show trends in data of time.
D. Answer the following questions.
1. Define the following terms:
(a) Formula
(b) Function
Demonstrate with the help of an example, how will you add, subtract, multiply
and divide values in Excel?
3. Describe relative cell referencing with the help of an example.
4. Name and describe the components of a chart.
2.
B2
5. Differentiate between column and bar chart.
39
Formulas, Functions and Charts​

Answer 1

Answer:

You'll plug in your x1 and y1 along with the slope into the formula. Then you'll evaluate and rewrite it in the slope-intercept form by solving for the y variable. From this, we see that our equation for the trend line is y = (1/3)x + 2, and we are done!