Excel+Assignment+1

This is the new page to post questions and answers concerning Excel Assignment 1. Don't place anything on this page that doesn't have to do with this particular assignment.

I am sure by now you have noted that professional formatting means for you to use the Cell Style selection in the ribbon. Also, when you are asked to total a range of values, you should use the Sum function.

Be sure you are able to answer the following questions:

What is a cell? -- a cell is the intersection of a row and a column and is identified by the letter of the column and the number of the row, as A1. A cell is the smallest unit in excel. User can do anything by using cell. (Jiwon Kim, sophie)

What is relative cell addressing? --- Bonus for the student who posts an answer to this!!! Put your name in the TAG!!! Relative cell addressing is to copy its formula to other cells. Its range also changes automatically.(Flora Cho) A relative cell addressing help you to do Exel easily. When you want to do same function on other cell, you can drag and fill cell automatically by relative cell addressing. (Jiwon Kim, sophie)

What is absolute cell addressing? How is it notated? -- Bonus for the student who posts an answer to this!!!! Put your name in the TAG!!! An absolute cell reference identifies the location a cell or group of cells. An absolute cell reference is used when you want a cell reference to stay fixed on a specific cell. An absolute cell reference consists of the column letter and row number surrounded by dollar signs (**$).** An example of an absolute cell reference would be $C$4, $G$15, or $A$345**.** Absolutes cell addresses can refer to both row and column address or just row or just column by positioning the "$" in front of just the column address or just the row address. **Note:** An easy way to add the dollar signs to a cell reference is to click on a cell reference and then press the **F4** key on the keyboard. An absolute cell addressing is fixing line and row. It notated by "$B1$". (Jiwon Kim, sophie)
 * (Karen Clary)**

What is a range? --- Bonus for the student who posts an answer to this!!! Put your Name in the TAG!!!

A range is a group of cells in a worksheet defined as cell address or range labels.(Karen Clary)

Range is the area of variation between upper and lower limits on a particular scale.(Melina Montes)

A range is a group or block of cells that have been highlighted or selected in a spreadsheet.(Ty Stogsdill)

A range is a scope of cell which is selected by user. (Jiwon Kim, sophie)

A range is a kind of cells that are selected (YeonSoo Lee)

A range is the limits within which something can be effective (Jeongwon Kim)

It is the range of cells which are selected. (Wonheuk Jung)

A range is an area which is selected by the user. (Hayoung Shin)