ITEC 1050 - Using Excel: Lab 3

Using Excel: Format a worksheet

• Change a column width: drag a colum edge, fit longest item (double-click on the column edge)
• Change a column height: drag a column edge, fit tallest item
• Change font and size of text
• Change the number format: general, number, currency, ...; quickly change the number format using a toolbar button.
• Change font/fill color
• Change alignment of data: left, center, right; center data across columns: Merge and Center button
• Bold, italic, underline
• Copy formating using the Format Painter toolbar button
• Print preview; print a worksheet
• Change page orientation: portrait, landscape; Change page margins
• Change print options (Page Setup/Sheet)

Using Excel: Working with Charts

• Create a chart from Sales_Figures.xls; modify data used to create the chart; delete a chart.
• Move a chart; resize a chart.
• Change the chart type using a Chart Toolbar
• Print a chart with its data; print a chart on its own page.