| CSC1009 Quiz 3 | Contact Info |

Herbert J. Bernstein Professor of Computer Science
Dept. of Mathematics and Computer Science, 1300 William Floyd Parkway, B205, Shirley, NY 11967

90466 CSC 1009N -- Introduction to Spreadsheets and Data Analysis -- Fall 2012
Online Course

Quiz 3


This web page is http://www.bernstein-plus-sons.com/.dowling/CSC1009F12/CSC1009_Quiz_3.html
Copyright © 2009, 2012 Herbert J. Bernstein and other parties. All rights reserved.

This is the weekly quiz for 2 October 2012 for the CSC 1009 course. Please do this quiz after you have completed the rest of assignment 3. It should take between one half hour and 2 1/2 hours to complete if you are well prepared, longer if not. Please recall that your were supposed to have the Gips textbook and to have read through page 310 (through Chapter 15) and all of Artymiak.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Please fill in the following information:



Skype ID:

  1. Carefully explain how to generate a random integer between 0 and 99 in Excel.

  2. Explain how to sort a list in Excel.

  3. Carefully explain the use of the Excel functions COUNTIF and SUMIF in Excel. If such a function is defined for Calc, how would its use differ?

  4. Carefully explain the use of the VLOOKUP function.

  5. Explain the use of Scroll Bars in Excel.

  6. Explain the use of Option Buttons in Excel. using Excel?

  7. Explain the use of Check Boxes in Excel.

  8. Carefully explain how dates are handled in Excel. Be sure to discuss the years 1900 and 1904.

  9. Explain the use of the PMT function.

  10. Explain the use of the PV function.

  11. Give your proposal for a simulation project for your porfolio.

  <==== Do this AFTER you've answered all the questions

You probably DON'T want to do this ===>  

Revised 2 September 2012