Mathmatics Quantitative Reasoning

admin one

9 months ago

Mathmatics Quantitative Reasoning

Question Description

2.1 Set Notation 3

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 Excels 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



^{Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."}

Exit mobile version