Spreadsheets: Introduction Assignment #1
Check out the following Excel Tutorial to help you complete Part A.
PART A: Introduction Questions
1.What is a spreadsheet?( 2 marks )
2.List four occupations or professions that would often use spreadsheets. ( 4 marks)
3.Identify and define cells, labels and values. ( 3 marks)
4.List 3 formatting commands and describe what they do. (6 marks)
5.Describe how you would insert a row or a column. ( 2 marks)
6.Describe various calculation formulas including SUM, AVERAGE ( 4 marks)
PART B: Create a Spreadsheet
- You are going to create a record of simulated sales for vacation destinations.
- You will be listing sales from various sources for various destinations.
- You will be totaling sales for the individual destinations, the type of sales, and overall sales
1.Open Excel
2.Select cell A1 and type Southern Paradise Vacations - First Qtr Sales This is the name of your workbook.
3.Select cell B2 and enter Mail. This is the column title for column B
4.In cells C2-F2 enter the column titles, Campus, Telephone, Web and Total, in that order.
5.Select cell A3. Enter the first row title, Bahama Beachfront.
6.In cells A4-A7 enter the row titles Daytona Desires, Key West Spa, Cayman Cabanas, and Total,
in that order. Notice the way the row titles are displayed in the cells at this time.
Bahama Beachfront / 52978.23 / 38781.35 / 37213.45 / 29998.65
Daytona Desires / 28234.50 / 48401.53 / 27034.56 / 42911.16
Key West Spa / 62567.25 / 72516.12 / 24354.86 / 77019.32
Cayman Cabanas / 28567.15 / 69777.64 / 49976.60 / 32019.45
7.Enter the amounts above in the appropriate cell.
8.Using the AutoSum Icon, Total all rows and columns. You may use an alternative way to find the sums using the formula method
9.Following the tips below and format column width and row height.
Column Width and Row Height
Too small will hide part of the data. Too large wastes space and can even make the sheet hard to read. Resizing rows and columns is a task you will do often.
Column Width: AutoFit all
- Move your pointer to the right edge of the heading of Column A until it changes to the Resize Column shape.
- Press the left mouse button down. (Don’t release it yet.)
The popup tip appears, showing the current width of Column A.
Row Height: Drag
- Position the pointer over the bottom edge of the Row 1 heading until it changes to the Resize Row shape. Click and hold to see the popup tip with the Row Height. Release mouse button.
Notice that the Row Height is larger than the Font Size that you set to 20 points. This creates the white space above and below the text.
If you drag by accident, you will resize the row height. Use Undo to reverse this, if necessary.
10.Follow the tips below and insertcomments into the single cells defined as Mail and Web. You make up comments. They should be 15 words or less.
Comments
Select cell and right click select Insert Comment.
When a comment is in a cell a Red triangle appears in the right corner
Hover over the cell and the embedded comment appears.
11.Set your print area to include all the information above after the calculations.
12.Setup your page to print gridlines along with text and numbers.
13.Create a “Spreadsheet” folder and save this assignment.