You are working in Excel through free Microsoft Office Online and have just finished inputting the sales data from your company. You wish to save the changes made on your spreadsheet. What step should you follow?1 pointSelect "File" followed by "Save" in the toolbar.Click on the floppy disk icon located in the ribbon.None. All changes are automatically saved while working in Microsoft Excel.Select "Edit" followed by "Save" in the toolbar.2.Question 2Amanda is working on sales data from her company and wishes to create a bar chart showing the total profits for the entire year by region.What PivotTable would she draw to create the bar chart?1 pointThe Pivot table would have: Quantity as Rows and Region as ValuesThe Pivot table would have: Quantity as Values and Region as RowsThe Pivot table would have: Profits as Values and Region as RowsThe Pivot table would have: Profits as Rows and Region as Values

You are working in Excel through free Microsoft Office Online and have just finished inputting the sales data from your company. You wish to save the changes made on your spreadsheet. What steps should you follow?1 pointSelect "Edit" followed by "Save" in the toolbar.Click on the floppy disc icon located in the toolbar.None. All changes are automatically saved while working on Microsoft Excel.Select "File" followed by "Save" in the toolbar.

Question 1You are working in Excel through free Microsoft Office Online and have just finished preparing the first table in the project tracker. You wish to save the changes made on your spreadsheet. What steps should you follow?1 pointNone. All changes are automatically saved when working in Microsoft Excel.Select Edit followed by Save in the toolbar.Select File followed by Save in the toolbar.Click on the floppy disk icon located in the ribbon.

How did you use a spreadsheet to help prepare your data? How did you format your chart to help you analyze your data?

Which Chart(s) can be Created in Excel?PieAreaLineBarNone of Above

Question 9I have a table that contains the data of the monthly sales figures of my company. I was tasked with creating a chart to display the change in sales on a monthly basis. What is the best chart to use to effectively display the change over time of monthly sales?1 pointBubble ChartPie ChartLine ChartBar Chart