| CSC1009 Quiz 2 | 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 2

 

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

This is the weekly quiz for 27 September 2012 for the CSC 1009 course. Please do this quiz after you have completed the rest of assignment 2. 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 206 (through Chapter 11) 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. Explain, according to Gips, what are the steps in cell protection?

  2. What is different about function calls in Excel and Calc?

  3. Explain, according to Gips, what is conditional formatting?

  4. Explain, according to Gips, what is mixed addressing?

  5. Explain, according to Gips, how do you validate input?

  6. Explain, according to Gips, what are the five phases of solving problems using Excel?

  7. Explain, according to Gips, how to create a chart in Excel.

  8. According to Gips, what is a trendline and how do you create one?

  9. Explain the use of the IF function, giving an example.

  10. Explain the use of the AND, OR and NOT functions, giving an example of each.

  11. Explain what you have done on exercise 11-17.

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

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

Revised 29 August 2012