COMP 1270 Final Exam
April 17, 2013
Name: _
Student Number: _
Instructions:
This exam is two hours in length.
Each of the eight questions is worth 5 marks.
Answer all questions in the booklets provided. Written answers should generally consume onehalf
Formulas
A formula specifies a calculation
All formulas begin with = (an equals sign)
As you enter a formula, it is displayed both in the
cell and the Formula Bar
Once the formula is entered, the cell value is
the calculation result
To see the formula tha
COMP 1270 Assignment 2
DUE: No later than 11:59 PM, Friday, March 7, 2013
Objectives:
Create copy of web site from Assignment 1
Create a Weebly page hierarchy
Modify copy of web site from Assignment 1 to include:
o a custom Weebly Form
o a Google Form fee
COMP 1270 Assignment 3
DUE: No later than 11:59 PM, Wednesday, March 26, 2014
Objectives:
Create a TrueCrypt container
Create a hidden inner TrueCrypt container within an outer TrueCrypt container
Use the cloud-based Dropbox to share encrypted TrueCrypt c
COMP 1270 Assignment 4
DUE: No later than 11:59 PM, Wednesday, April 9, 2014
Objectives:
Implement Google Analytics
Demonstrate use of versioning in Dropbox
Note:
We will be discussing many of the assignment details in class.
Place assignment within a Wor
Assignment 2
1.
a. Ep=Y
Ep= C+ I + G + Ex- Im
Ep= 1.7 + 0.8 ( Y T) + 2 + 1 +1 Im
T = 0.1Y + 0.2
IM = 0.06+ 0.1Y
Ep=1.7 + 0.8 (Y-0.1Y-0.2)+2+1+1-(0.06 +0.1Y)
Ep=5.48+0.62Y
Y=5.48+0.62Y
Y= $14.42 billion
b.
1/1-b(1-t)+m
1/1-0.8(1-0.1)+0.1=2.632
c.
-b/1-b(1-
D. Formula errors#
If something goes wrong with calculating or displaying a
cell value, Excel displays an error indicator in the cell
_ Error indicators start with # so they can be seen even
in narrow fields
_ #. means the value is too big to display as
f
Split viewing options
General series fill options
_ For large or complex fills, use the Home Fill button
_ first select the entire range to be filled (for a large
range this is easier than dragging a fill handle)
_ the Fill dropdown menu lets you choose f
Spreadsheet Design
Step A: Set goals
_ What do you want your spreadsheet to do? For whom?
_ What input values will you need, and what results
will you calculate?
_ Which results do you want people to notice, and which
ones can be out of sight?
Example: Su
Advanced formulas
A. Relative and absolute references
_ In the Loan Payment sheet described earlier, the loan
payment is calculated in F3, and used in C6:C17
_ =F3 in C6 would get the loan payment correctly
_ But if you fill down, C7 would get =F4, which
C. PMT and IF functions
PMT (Loan Payment) function
_ =PMT(Rate,Nper,Pv) where:
_ Rate = interest rate (per payment period)
_ Nper = number of payment periods
_ Pv = initial loan amount [$] (Present value of loan)
_ Tricky point: Pv and the result of PMT
Copying and moving cells
Copy: copies the selected source cells to the clipboard.
The source cells are highlighted with a twinkling
border until you enter something in a cell.
Paste: pastes the clipboard to the destination. After a
copy you can do repeate
Functions
Some formulas require a lot of error-prone typing
_ E.g., adding a column of 100 numbers
=D10+D11+D12+ +D109
_ Others cant be done using the arithmetic operators
_ E.g., finding the largest value in a row of a table
_ Excel provides functions to
SPREADSHEETS & EXCEL
Spreadsheet: a rectangular table (or grid) of
information, often financial information1
Spreadsheet program: an application that manages
spreadsheets, providing both formatting assistance and
the ability to perform many complex calcul
Excel window
Status Bar
_ The Status Bar gives you information about the
worksheet you are viewing
_ Ready (for input) when a cell is active
_ Average, count and sum of a selection with numbers
_ View selector with the current view highlighted
_ Normal to
Date Formats
_ Dates (from 1900 to 10,000AD) and times are stored
as number of days since 12:00 am, Jan 0, 1900 (=0)
_ a fractional part shows a time during the day
_ e.g., July 1, 2012 is number 41,091.0 and July 1, 2012 at
noon is 41,091.5
_ You can do
COMP 1270April 2013
1. Assume the average the average size of an mp3 is 5 MB. Approximately
how many mp3s would you be able to fit on a 16 GB external flash drive?
Show all your work.
An Internet service provider (ISP) promises downstream speed of 20 Mbps