It should look similar to this : 55 . Right click , then select Format Cells in the popup menu : Then make the selections indicated in the options box pictured below . These selections will remove the decimals and add a dollar sign to the columns .
56 . Finalize your worksheet by making sure all columns are formatted to accommodate the size of the data . In the same popup box pictured above in the Border tab , you can format your table as needed to assure it looks clean and neat . Consider putting borders to separate cells . Consider making titles bold .
57 . Save your worksheet . This is what it should look like when you ’ re done :
Making a Chart for Budget Expenses
To view a brief ‘ How To ’ video for creating a chart in your spreadsheet , click on the video below .
58 . To make a chart for budget expenses : o Use the cursor to highlight from A10 to A14 o Hold down the Control key ( Ctrl ) and select C10 to C14 . o Hold down the Control key ( Ctrl ) and Select D10 to D14 . Your columns should look similar to this :
• Click the “ Insert ” tab .
• Click the column chart
Select 2-D Column
In Microsoft Office version 2010 and prior , you will see the Chart Tool activated at the top of the screen for the formatting elements . Click the chart and press the help key ( F1 ) in Microsoft Office to open the help function for the options available in your version . This is a clip of Microsoft version 2010 for your reference :
In the 2013 version of Microsoft Office which is demonstrated below , you should then see something similar to the following graphic