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

Precalculus help--Dividing complex numbers, 5-i/ 3+4i

5-i/ 3+4i

Adding and subtrackting fractions, I don''t understand it

I don''t understand it

Name the set of numbers to which each number belong, square root o f 34

square root o f 34

Factoring.., w^2 + 30w + 81= (-9x^3 + 3x^2 - 15x)/(-3x) (14y = 8y^2 + y^3 +...

w^2 + 30w + 81= (-9x^3 + 3x^2 - 15x)/(-3x) (14y = 8y^2 + y^3 + 12)/(6 + y) ac + xc + aw^2 + xw^2 10a^2- 27ab + 5b^2 For the last problem I have to incorporate the following words

Inequality problem, why is the inequality symbol must be reversed when both...

why is the inequality symbol must be reversed when both sides of a inequality are multiplied or divided by a negative number

#title.Linear Sytems Summative Assessment, Use the infomation beow tassess ...

Use the infomation beow tassess how much money Dave and Jane will be able to give to charity. They plan toma them in two sizes, small and large. Dave will carve them from wood. Sma

Example of factorable quadratic equation, Complete the square on each of th...

Complete the square on each of the following.                       x 2   -16x Solution                           x 2 -16x Here's the number which we'll insert to th

Examples of polynomial, Examples of  polynomial that  doesn't factor No...

Examples of  polynomial that  doesn't factor Now, all of the examples that we've worked to this point comprised factorable polynomials. However, that doesn't have to be the cas

Solving problem using polynomial inequalities, Example Solve 3x 2 - 2 x -...

Example Solve 3x 2 - 2 x -11 = 0. Solution In this case the polynomial doesn't factor thus we can't do that step.  Though, still we do have to know where the polynomial i

Area of a polygon., what is the area of a polygon.

what is the area of a polygon.

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: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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