If you can't answer these questions, get down to the lab and figure out the answer in Excel. If you still have problems (or if you don't understand one of the questions) ask John Rieman or one of the TA's before the final.
1. What is a "formula"?
2. What is a "function"?
3. Show exactly what you would type into cell A50 to give the total of cells A1 through A20.
4. How could you use the toolbar to quickly put the total of cells A1 through A20 into cell A21?
5. Show exactly what you would type into cell A3 to give the total of cells A1 and A2, divided by seven.
6. Show exactly what you would type into cell A3 to give the total of cells A1 and A2, divided by cell B3.
7. Why would you refer to a cell in a formula as $A$3 instead of A3?
8. You create the formula =percentile(C1:C10,$C$11) in cell C12. Then you copy the formula and paste it into cell D12. What formula will D12 hold?
9. If you want to use a function but you don't remember exactly the order of the parameters (that is, the order of the things in the parentheses), what is the most efficient way to find out? (It's not the Help menu!)
10. Describe briefly what each of these functions does: average, sum, round, if, isblank, max, min, count.
1. What does the cursor look like when you are changing the width of a column?
2. Which toolbar button makes text bold?
3. Which toolbar button sorts columns?
4. Which toolbar button lets you put bold borders around cells?
5. If you want to sort rows 1 through 5, how should you select them to be absolutely sure you have selected all the data in the rows?
1. Which toolbar button starts the chart wizard?
2. As soon as you click on the chart wizard button, you get a cursor shaped like a cross. What should you do with that cursor?
3. In the first dialog box of the chart wizard, how would you specify that you want a graph of column A along with columns C, D, and E (skipping column B)? Assume there is data in the first 10 rows of the spreasheet.)
4. After you have created a graph, how can you change the things in it (for example, the weight of the plot line, or the labels on the axis, or the information in the legend)?
5. Identify the the x-axis and the y-axis on a line graph.
6. If you are using the chart wizard, and you want column A to be the labels for the x-axis, what do you do?
7. When you copy a graph out of Excel and paste it into Word, why would you use the "Paste Special" menu option?
1. How common are errors in the spreadsheets used in business?
2. What are some of the common kinds of errors found in spreadsheets?
3. What is a "rounding error"? Is it something that happens only in spreadsheets?
4. What will help to avoid errors in your own spreadsheets?
5. Since you probably can't avoid every error in your spreadsheets, what should you do?
6. You need to enter and analyze some data, and you could use either a spreadsheet or a database. What factors should you consider in deciding which to use?