CIS200 – Homework #1 – Relative & Absolute Addressing



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

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

A) Absolute

B) Application Software

C) Browser

D) Byte

E) Cell

H) Formula

I) Formula Bar

K) Gigabyte

L) Hypertext Link

M) Menu Bar

N) Named Cell/Range

O) Operating System

P) Primary Memory

Q) Relative

R) Search Engine

S) Secondary Memory

T) Sum

| |

|8 bits. |

| Software that allows you to view web pages. |

| RAM memory is an example of this. |

| Microsoft Windows 7 and Unix are examples of types of this. |

| A named range when copied acts in the same way as this type of cell reference |

|Location on an Excel worksheet below the toolbars that displays the contents of the active cell. |

| These types of cell references in Excel are affected by the displacement of a formula from its original position. |

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

1. This resulting value from the formula = A1+3*2 would be 10 if cell A1 contains the value 2.

2. When you do a search by typing in a keyword into search engine such as Google, that search engine goes out to the web using a web spider to find appropriate matches.

3. A Firewall is Software/Hardware that denies entry to all incoming traffic except those specifically allowed.

Short Answer

11. (1 point)In Grandma’s Best chocolate cake spreadsheet, the formula =B3+B4+B5+B6+B7 has been entered into cell B8. 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 lab1 located on the C drive in the cse1111 directory and prelab subdirectory.

13. (1 point) The formula =B2+$C$2+D$9+$D10 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 this formula from cell F10 into cell A1 of your spreadsheet.

15. (1½ points) The worksheet above lists orders for June by item number including the price for the item and weekly order quantities. Write an Excel formula in cell G3 to calculate the total value of item 234 for sales in week 1 (price * quantity). Write the formula such that it can be copied down the column to determine the total value for each corresponding item for week 1 and across the row to determine the total value for the item for each corresponding week.

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

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

Google Online Preview   Download