CSC170 Excel STUDY GUIDE

• All format cell options
• Copy cells
• mathematical formulas
• Sum function (∑)
• Cell Borders
• Print layouts (column headings, fitting to one page, landscape/portrait, header/footer)
• Know there are multiple sheets in a workbook
• Set titles for window (freeze panes)
• Set titles for printing (page setup)
• Fit to width in order to squeeze onto printing one page
• Sort
• Wrap lines of a cell to fit in one cell and show (align / wrap checkbox)
• Merge or unmerge cells (align / merge checkbox)
• Know that pivot tables make easy summaries by categories

• If statement
• Know how Excel adjusts cell references when it copies (i.e. moving a cell with =A1/B3 over 2 and down 4 would be = C5/D7
• Absolute Reference (Be able to tell why it is used; Be able to tell how you would use $ to stop excel from changing addresses when you copy. So, I might ask how you can change the address in a cell with =A1/B3 so that when it moves over 2 and down 4 it stays as =A1/B3;
• Average, Min and Max functions
• Loan payment function
• Concatenate text
• Merge cells
• Use the Excel chart  to make charts with labels for series, x-axis and y-axis
• Chart making guidelines:
• Bar and Column Charts should start at 0, while line graphs should have a range that focuses on important data
• Excel default formatting can be misleading
• Limit pie slices
• Pie must represent parts of a whole
• Label Axes and chart and series
• Consider color blindness
• Sort graph data
• 3D effects distort proportions
• Avoid line graphs when there is no time or trend element

To practice for this quiz:

You need to know how to format a spreadsheet and enter formulas without instructions on how to do the entry. For example, I will ask you to set your print out to have the column headings print at the top of every page. You would need to know where to find that function in your own version of Excel. To practice, please copy your first 20 rows and 5 columns of your inventory spreadsheet to a new spreadsheet. Then redo all the formatting and enter all the formulas again.