| CSC1009 Quiz 3 | Contact Info |

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

21471 CSC 1009N -- Introduction to Spreadsheets and Data Analysis -- Spring 2014
Online Course

Quiz 3

 

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

This is the weekly quiz for 19 February 2014 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:

Name:


Email:


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 18 January 2014