Ch.9--"Transposing text and modifying charts in Excel"

Excel chapter 9 talks about how to use auto format, conditional format, enhance appearance of charts and transposing text. Auto format is under the format tab and it formats data that you selected and puts it into a table format that enhances the data’s presentation. Conditional format will highlight any number that you say is either between two numbers, greater than a number or less than a number. It is very useful for identifying numbers that are different from the rest. To enhance the appearance of charts you open the chart toolbar and go to format chart area. You can do things like make its’ corners round or create a shadow effect. There may be times when data is entered in the worksheet in columns or rows and then you realize it would be more appealing if you switched them. That’s what transposing is. You highlight your columns or rows then go to Edit then Paste Special and choose transpose.

The first project makes you format a range of cells and change the date format. (Something that I learned in introductory Excel) Then it asks to take range of cells C4:G14 and paste them in the second sheet. To print the worksheet it says to print it in landscape, which is easily done by going to file then page setup.

The second project asks you to format the sales figures with a $ sign and two decimal places. So I highlighted those cells and went to format cells then number then finally currency with two decimal places. In that same format cells box is a heading that says alignment- that is where I found to make the headings to 45 degrees. The book tells you to merge and center, the title and subtitles only, columns A through D. Then finally I transposed the data in A4:D11 by going to edit then paste special.

The third project has you play around with a chart. It tells you to add a data table to it, to resize it and to change the border style of the chart to rounded edges. To add the data table just open the chart toolbar and choose add data table. To resize it drag one of its’ corners and to change the border style go to format chart area in the chart toolbar and choose rounded corners.

The activity that I had to do was to apply an autoformat to the projected sales data and use conditional formatting to highlight the sales figures that exceed $60,000 for any month and any division. Both of these things can be done by highlighting the cells A4-M12 and go to format and choose autoformat – choose one – then go to conditional formatting in the same heading. Put in cell value is greater than 60,000.