CIS200 – Homework #1 – Relative & Absolute Addressing



CSE 1111 – Homework #1 (10 points) – Intro to Computers & Writing Formulas in Excel

Matching- Please write the letter of the best response. (1/2 pt. each)

A. Application Software

B. Absolute

C. Border

D. Cell

E. Formula

F. Formula Bar

G. Gigabyte

H. Kilobyte

I. Linux

J. Megabyte

K. Menu Bar

L. Named Cell/Range

M. Operating System

N. Primary Memory

O. Relative

P. Search Engine

Q. Storage Devices

| |

|_ 1. Google is an example of this. |

|_ 2. RAM is an example of this. |

|_ 3. Approximately 1000 Bytes. |

|_ 4. Linux and Windows are examples of this. |

|_ 5. In Excel, this type of cell reference is affected by the displacement of a formula from its original position. |

|_ 6. $B$4 is referred to as this type of cell reference. |

|_ 7. In Excel this area displays the contents of the selected cell. |

True or False: Please indicate if this statement is True or False. (1/2 pt. each)

____ 8. The primary function of an Operating System is to help you prepare textual documents in paragraph format.

_____ 9. The value resulting from the formula = A2+10/2 would be 7 if cell A2 contains the value 4.

_____ 10. By storing temporary data in primary memory, the computer can reduce the access time because it doesn’t have to go to secondary memory to get it.

Short Answer

11. (1 point) On the left are the expenses for a party that John threw last weekend. The formula =B3+B4+B5+B6 has been entered into cell B7. Please explain (briefly) the most logical reason why the addition appears to be incorrect.

12. (1 point) Write the full file path (including file extension) for the Excel file named lab2 located on the Z drive in the Homeworks directory and cse1111 subdirectory.

13. (1 point) The formula =C4+$E$4+D$9+$B10 is in cell F10 of your Excel worksheet. What formula would result if you copied this formula from cell F10 into cell H11 on your worksheet?

14. (1/2 point) What value would result if you copy the formula in question 13 from cell F10 into cell A1 of your spreadsheet. Explain your answer.

[pic]

15. (1½ points) The worksheet above lists the prices and sales quantities of various best-seller books for different weeks in June by a Barnes ‘n Noble bookstore. Write an Excel formula in cell G4 to calculate the total value of the “At First Sight” books sold (price * quantity) in week 1. Write the formula so that it can be copied down the column to determine the total value for each book in week 1 and across the row to determine the total value for each week.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download