FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What graphically represents trends in plotted data and predicts futurevalues?
A
Sparkline
B
Trendline
C
Chartline
D
Error bar
Explanation: 

Detailed explanation-1: -Line chart It can also expose overall trends, to help the reader make predictions or projections for future outcomes. Multiple line charts can also give rise to other related charts like the sparkline or ridgeline plot.

Detailed explanation-2: -What graphically represents trends in plotted data and predicts future values? Trendline.

Detailed explanation-3: -In Microsoft Excel, charts are used to make a graphical representation of any set of data. A chart is a visual representation of data, in which the data is represented by symbols such as bars in a bar chart or lines in a line chart.

Detailed explanation-4: -A chart is a graphical representation of data in a worksheet. It is an effective way to display data in a pictorial form. It helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparisons and see growth and relationship among the values and trends in data.

There is 1 question to complete.