Don't use plagiarized sources. Get Your Custom Essay on
Belhaven University Mathematics Quantitative Reasoning Worksheet
Just from $13/Page
2.1 Set Notation3
2.2 Subsets and Venn Diagrams
2.3 Operations with Sets
2.4 Applications and Survey Analysis
Exercises:Open a new spreadsheet in Microsoft Excel and complete the following.
1.In cell A1, type “Monday”.
2.In cell A2, type “10”.In cell B2, type “11”, and in cell A10, type “20”.
3.To illustrate Excel’s calculator feature in cell A3, type “= 4 + 5*6 –2”. You should get the value 32.
4.As an example of a function in cell A4, type “=Sqrt(A2)”. Sqrt(number) is the square root function that is built into Excel. You should have
5.In cell A5, type “=A2/$A$10”. This divide the contents of A2 by the contents of A10. You should have the value 0.5
.6.Click oncell A1 and drag the rectangle to E1. By doing so, the first row should read “Monday, Tuesday, Wednesday, Thursday, Friday”.
7.Highlight cells A2and B2. Draw the rectangle to E2. The second row should now read “10, 11, 12, 13, 14”.
8.Click on cell A4 and drag the rectangle to E4.The fourth row should now read “3.162278, 3.316625, 3.464102, 3.605551, 3.741657”.
9.Click on cell A5 and drag the rectangle to E5. The fifth row shouldnow read “0.5, 0.55, 0.6, 0.65, 0.7”.
10.Click on cell D5. Notice that the formula bar reads “=D5/$A$10”. Excel knows how to correctly fill in the formula by dragging. However, why did A5 change to D5 but A10 did not change to D10? By placing $’saround A, we communicated to Excel to keep that value fixed. Through dragging, $A$10 was kept constant.11.Save and submit your spreadsheet in Canvas under Excel Assignment 1