CMPS 273 Review of Excel and Basic
- Important data: (15)
- Name
- W number
- Favorite desert
Use Excel to answer the following questions. Use Blackboard to send me your program when you are complete.
- Make a plot of the equation Y = x3 + 5 (15)
- Start the X values at –10, end them at 10
- Use the X/Y Scatter chart to graphically display the data, make sure to include a chart title and label the x and y axis.
- Create a kilograms to pounds conversion table. (10)
- Start the table at 0 and stop at 100
- Use the equation: pounds = (2*kilos)*1.1
- Make a pie chart with the following data (label it): (10)
Thanksgiving hog fest
Food / Quantity (ounces)
turkey / 16
dressing / 10
Green beans / 5
Cranberry sauce / 3
Rice and gravy / 5
Pumpkin pie / 10
Ice cream / 10
Pepto-bismal / 5
- You took two versions of a quiz that will be averaged together. Given that you scored a 62 on version 1 and 97 on version two, answer the following questions: (10)
- What it the average score of the two versions of the quiz?
- Using a weighted average, what is the average if the second quiz is worth 70%.
- Using the following data taken from the “Fat Dude Hot-dog Eating Contest”, answer the questions below. (30)
Year / # of dogs Boss Hog ate / # of dogs Uncle Jessy ate
2000 / 45 / 48
2001 / 50 / 51
2002 / 56 / 50
2004 / 44 / 48
2005 / 40 / 47
- Who, on average is the bigger eater?
- Who was more consistent? What is your proof?
Answer the following questions about computers and basic.
- Math (6)
- 20 =
- 14 * 101 * 24 =
- 103 =
- Binary to Decimal (6)
- 1100 =
- 1001 =
- 0010 =
- Decimal to Binary (6)
- 8 =
- 3 =
- 1 =
- Write an IF statement that prints out the number x it is between 40 and 50. (20)
- Write a FOR loop that finds the average of the numbers between 1 and 100. Use a PRINT statement to display the answers to the user. (40)
- Write a remark statement that indicates that you are going to average some numbers. (2)
- Describe the difference between real numbers and integers. (10)
- Write a statement that tells the computer that the variable count is an integer. (10)