DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Expert-Verified Answer. The statement given here is false. We can add another data series. The main purpose of excel is to store data for business-related things.
Detailed explanation-2: -Line charts work best when you have multiple data series in your chart-if you have only one data series, consider using a scatter chart instead. Stacked line charts sum the data, which might not be the result you want.
Detailed explanation-3: -After you create a chart, you can change the data series in two ways: Use the Select Data Source dialog box to edit the data in your series or rearrange them on your chart.
Detailed explanation-4: -You can change the type of chart you think would best represent your data at any time. To change the Clustered Column to Pie, select your chart. On the Chart Design tab, click Change Chart Type > Pie > Pie. Your new chart type will show in your spreadsheet.