User Account

All Pages

excel, Algebra

Assignment Help:
Ask question1
MATH 1110 – Mathematics for I.T.
Follow the instructions given below to submit your work.
? Use MS Word to open a new solution file.
? Write your name, Student Id and Course Code on the top of the page as shown
below and Save it as assn1_sol.doc.
Student ID :
Student Name:
Course Code : CRN:
Date :
Type : Assignment 1
? Draw a dotted line
? Paste your work whenever you see Submit for any question (It could be Excel
output in cropped format showing the column and row numbers correctly) – make
sure you type the question number as Q1, Q2, etc.
? You must insert page numbers at the bottom of the page
? Submit both the solution document and excel files to DC Connect as per the
due date. If you do not submit both the files, the assignment will be marked for 0.
1. Microsoft Excel – formulas
? Create the Excel worksheet as shown below. (use the Insert equation to type the
equations in Excel). The formatting should be exactly as shown.
? Write the excel formula for each question
? Find the answers by entering appropriate formulas. Round your answer to 1 digit
after the decimal point.
? Rename the worksheet as formulas.
? Save the file as assignment1_studentFirstName
? Paste the Excel output in the solution document.
2
2. Microsoft Excel – BEDMAS
? To switch between displaying formulas and their values on a worksheet, Press CTRL+`
(grave accent – back quote). This allows you to view values or formulae.
a. Move to Sheet2, rename the worksheet as BEDMAS
b. Enter the title “MATH 1110 : BEDMAS (Assignment 1)” in row 1 in boldface and
underline.
c. Place the following headings in row 2 for columns A to H (i.e. A2 to H2) as a, b, c,
d, F1, F2, F3, F4 (in bold face).
d. In column A cells 4 to 18, enter the numbers 1 through 15 (Hint: You can also use
Fill Handle feature learnt in the lecture notes – page 50)
e. In column B, cells 4 to 18 enter the numbers as 1500, 4500, 7500, ….. 43500 (Hint:
You can also use Fill Handle feature learnt in the lecture notes – page 50)
f. In column C, cells 4 to 18, enter 1.5%, 3.5% 5.5% to 29.5% (Hint: You can also
use Fill Handle feature learnt in the lecture notes – page 50)
g. In column D, cells 4 to 18, enter the squares 1, 4, 9, … 225 (Hint: You can also use
a formula to square the numbers in column A)
h. Do all the formatting needed like boldface, color, picture (computer or any other
picture), your details, etc. Your excel worksheet should be as given below:
3
i. In column E, cells 4 to 18, enter the formula for F1 as = a * (0.6+ c)
b +4d (Hint:
You have to convert the variables into the corresponding cells. Copy the formula
from cell F4 to F5 to F18.

j. In column F, cells 4 to 18, enter the formula for F2 as = a * (7 + c
2
) + b2
- a
3
(Hint:
You have to convert the variables into the corresponding cells while entering the
formula).
k. In column G, cells 4 to 18, enter the formula for F3 as = d * (5c
2
+ b ÷ 365c
2
)
(Hint: You have to convert the variables into the corresponding cells while entering
the formula).
l. In column H, cells 4 to 18, enter the formula for F4 as
= d * [(1 – (1 + a) (-d)
) ÷ 9c4
]. (Hint: You have to convert the variables into the
corresponding cells while entering the formula).
m. Find the lowest number in cells E4 to E18 and place the answer in cell E19 (use
appropriate function)
n. Find the Average of the numbers in cells F4 to F18 and place the answer in cell
F19 (use appropriate function)
o. Find the highest number in cells G4 to G18 and place the answer in cell G19 (use
appropriate function)
p. Find the Total of the numbers in cells H4 to H18 and place the answer in cell H19
(use appropriate function)
q. Format the numbers in column E to H to currency to the nearest cent (2 decimals)
r. Save the file
? Paste the Excel output in the solution document
Submit the Excel file (.xlsx) along with the solution document to DC
Connect.
4
Marking Scheme (Guidelines to be followed)
1. Dropbox submission: Excel file and solution document must be submitted to dropbox
( (1 mark)
2. Solution document must have proper formatting (title page, page numbers, question
numbers, cropping the output correctly, ….) (1 mark)
3. Q1. (3 marks)
a. Use equation editor to enter question details
b. Use BEDMAS while entering the formulas using cell addresses and not the
values to get the correct output
c. Formulas must be entered correctly, else invalid answer
d. Excel sheet must be renamed as Formulas
4. Q2 (5 marks)
a. Create the worksheet as given in the assignment
b. Use BEDMAS while entering the formulas using cell addresses and not the
values to get the correct output
c. Use an appropriate functions instead of entering the individual cells or values
in E19, F19, G19 and H19
d. Format the numbers in currency format as indicated. Do not use Accounting
format
e. Formatting: Draw lines around the cells, heading, picture, bold face, etc.
f. Excel sheet must be renamed as BEDMAS
g. Name, Student ID and Date must be entered at the end of the table #Minimum 100 words accepted#

Related Discussions:- excel

Finding coordinates, (2,9);y=3x-1

(2,9);y=3x-1

Number and expressions, Ask ques1. Isaac goes to an amusement park where ti...

Ask ques1. Isaac goes to an amusement park where tickets for the rides cost $10 per sheet and tickets for the shows cost $15 each. (a) Write an expression that describes the amount

Convert following into the function, Convert following into the form    ...

Convert following into the form                                        f (x ) = a ( x - h ) 2  + k Solution We are going to complete the square here.  Though, it is a s

Linear eqation in one variable, there are some benches in a class room if ...

there are some benches in a class room if 4 student sit on each benche 3bencha are left vacant and if 5 student sit each benche 3 student are left standing how many student are the

Slope intercepts, (4, -5) , y = -1

(4, -5) , y = -1

Solving algebraic expressions, Need to solve for x x over 17/5 equals 1/17...

Need to solve for x x over 17/5 equals 1/17

Expressions and inequlites, A blue whale gains 2.3 tons a month for the fir...

A blue whale gains 2.3 tons a month for the first year of life. If a blue whale weighed 15 tons at birth, how much will it weigh on its first birthday?

Fundamental theorem of algebra, If P (x) is a polynomial of degree n then P...

If P (x) is a polynomial of degree n then P (x) will have accurately n zeroes, some of which might repeat. This fact says that if you list out all the zeroes & listing each one

Standard form, 4(x)^2-40x+107 in standard form

4(x)^2-40x+107 in standard form

Areas, does total surface area mean total exposed area

does total surface area mean total exposed area

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd