Рет қаралды 12,611
#naanmudhalvan
#microsoft
#digitalskills
#microsoftexcel
#answersdotcom
#excel
Assessment- 3
Open MS Excel on your respective desktop / or www.office.com
Open MS Excel on your desktop or log onto www.office.com to open MS Excel
Add the data to the spreadsheet
Add the data set to the spreadsheet.
Use appropriate chart representation using recommended charts to show - Sales price of various products
Copy the products and sales price in different column
Go to Insert Ribbon Menu
Click on to Recommended Chart
Use the most preferred and ideal chart to show the sales price
Filter the segment and only show the small businesses, Enterprise market, etc.
Select the segment column
Go to Sort and Filter in Home Ribbon Menu
Choose Filter
From the dialog box select Small Businesses and Enterprise Market
Use a scatter chart to show the units sold
Select the column Units Sold
Go to Insert Ribbon Menu and select Charts
Select the Scatter Chart
Insert the Scatter Chart and label it as Units Sold
Format the cells and use cell styles
Select the cells where you want to apply cell styles
Go to Cell Styles in Home Ribbon Menu
From the drop-down box, select Themed Cell Styles
Apply the preferred one to your selected cells.
Save the Excel document in a different format
Go to File Ribbon Menu
From the task pane choose Save As an option
Select the location where you want to save the file
Add the file name and choose the preferred format from Save As Type
Then click on Save, and the file will be saved in a different format.