CMPS 273 Review of Excel and Basic

  1. Important data: (15)
  2. Name
  1. W number
  1. Favorite desert

Use Excel to answer the following questions. Use Blackboard to send me your program when you are complete.

  1. Make a plot of the equation Y = x3 + 5 (15)
  2. Start the X values at –10, end them at 10
  3. 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.
  4. Create a kilograms to pounds conversion table. (10)
  5. Start the table at 0 and stop at 100
  6. Use the equation: pounds = (2*kilos)*1.1
  7. 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
  1. 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)
  2. What it the average score of the two versions of the quiz?
  3. Using a weighted average, what is the average if the second quiz is worth 70%.

  1. 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
  1. Who, on average is the bigger eater?
  2. Who was more consistent? What is your proof?

Answer the following questions about computers and basic.

  1. Math (6)
  2. 20 =
  1. 14 * 101 * 24 =
  1. 103 =
  1. Binary to Decimal (6)
  2. 1100 =
  1. 1001 =
  1. 0010 =
  1. Decimal to Binary (6)
  2. 8 =
  1. 3 =
  1. 1 =
  1. Write an IF statement that prints out the number x it is between 40 and 50. (20)
  1. 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)
  1. Write a remark statement that indicates that you are going to average some numbers. (2)
  1. Describe the difference between real numbers and integers. (10)
  1. Write a statement that tells the computer that the variable count is an integer. (10)