MICROCOMPUTER IN SCIENCE (CSCI-235)

NOV QUIZ REVIEW

NAME: ______STUDENT NUMBER ______


SECTION 1: Excel Screen Layout

A B CD E

Fill in the name of the object corresponding to the letter above

A.______

B. ______

C. ______

D. ______

E. ______

F. ______

G. ______

H. ______

I. ______

J. ______

Section 2: Referencing Cells

Answer the following questions assuming a cell located at the junction of row C and column 7 contains the formula =B7+$A$3

  1. What is the relative name of the Cell? ______
  2. What is the absolute name of the Cell? ______
  3. If you copied the cell to the cell directly below it what would the cell contain?

______

  1. What would the cell contain if it were copied one cell up and one cell to the left?

______

  1. If you were going to reference this cell and the next 4 cells on the right hand side what would the range reference look like

______

Section 3: Formatting Cells

  1. If a cell contains the value 12.345 and you want to present the value as 12.3 you would format it as a

______

  1. If a cell is presented as 7.54% what value does it have?______
  2. If a cell is presented as January 25, 1900 what value does it have? ______
  3. How would accounting format present –31.25? ______
  4. If a cell contains 12345.67 what would it look like in currency format ______

Section 4: Concepts

  1. Why is it important to isolate assumptions and initial conditions.

______

______

______

  1. What is a template in Excel?

______

______

______

  1. What is the semantic difference between an absolute and a relative reference?

______

______

______

  1. What is the most important thing to do when selecting a chart?

______

______

______

  1. Compound documents allow you to build documents containing different kinds of objects. Compound documents are built using a technology called

______

______

______

Section 5. Charts

  1. A Pie chart is one of the most effective ways to display ______relationships.
  2. A column chart is used to show actual numbers, a column chart in a horizontal orientation is called a ______chart.
  1. The ______is the easiest way to create a chart.
  1. A chart is composed of individual ______that you can manipulate separately.
  1. How would you add emphasis to a section of a pie chart?______

______

Section 6. Functions and Analysis

Assuming you have a group of cells A1 to A17, B3, and H8.

  1. If you have cells above, how would you compute the average of those cells in cell B17.

______

  1. How would you count the cells that contain numeric entries, including formulas that evaluate to numeric results?

______

  1. How would you count the cells that contain numeric or text data?

______

  1. If cell D2 contains the annual interest rate of a mortgage, D3 contains the number of years of the loan and D4 contains the mortgage amount, compute the monthly mortgage payment in cell D5.

______

  1. If cell B1 is not equal to B2 set cell D3 equal to the sum of cells A1 to A17, otherwise set cell D3 to the minimum value in cells A1 to A17. Enter the formula for cell D3.

______

  1. Suppose you had a professor’s grade sheet and you wanted to assign a letter grade to a student based on the following table. If the student’s numeric grade is in cell F2, how would you assign a letter grade to cell G2.


______

  1. You notice that your formulas are not working correctly and when you open up one of formulas you see it contains =A1+#REF!+A2+A3. What does the #REF!mean?

______

______

  1. Assuming you had a spreadsheet that calculated a car payment. Cell D1 contains the cost of the car, cell D2 contains the annual interest rate, cell D3 contains the down payment and cell D4 is the calculated monthly payment. After entering the cost of the car you discover that the payment is less than you expected. How would you determine how much you could spend on a car without exceeding your target monthly payment? Be explicit as to the command and options required.

______

______

______

  1. If you were generating a financial forecast and you are unsure on the initial conditions, how would you show the effect of changing the initial conditions to accommodate the different possible values of the initial conditions?

______

______

______

  1. You are generating a financial forecast and your initial assumption of unit sales is in cell H3 and your assumed growth for unit sales as a percentage is in cell I3. You are creating a formula in cell D7 that contains the second year’s unit sales. What would the formula be?

______

Section 7: Object Linking and Embedding

  1. Where is an embedded object stored? ______
  2. Where is a linked object stored? ______
  3. When would you use a linked object over an embedded object?______

______

______

  1. What is the primary advantage of a Linked Object? ______

______

______

  1. Assuming you have an area of an Excel worksheet selected and you are going to link it into a Word file that is already open in a Word window. What are the steps required to link the worksheet into the Word document.

______

______

______

______

______

______

  1. What command do you use to retrieve new information from the Excel worksheet?

______

______

______

Page 1 of 5