Draw Design $$ Q Tell me

Viewin

nly To save a copy of this document, click Duplicate.

Us$"$

PART $2$: FORMATTING AND ROUNDING NUMBERS

Download your starting files from your SIMnet account.

This course will be utilizing the SIMnet integrity checking tool. When a beginning file is downloaded from SIMnet a "digital signature" is added to the file. If you use another student's file or copy and paste information from another student's file, you will not be able to upload your file.

Select Prelab $2$ RoundFun as a Resources file to download. Enable Editing if asked.

Complete the RoundFun.xlsx problem as directed. Be sure to read the information on the Round function in the Course Notes:

Enter a starting value: In Cell A$1,$ enter the number $123560\mathrm{.}94732$ and change the cell format to display $5$ decimal places.

Enter Column Titles:

In cell A$3$ enter the text label "Nuniver"

In cell B$3$ enter the text label "Decimal Places"

In cell C$3$ enter the text label "Result".

Copy the contents of cell A$1$: In cell A$4,$ enter the formula $=A$$$1$ and copy the formula down the column into the range $A4$:$A15.$

Enter values in Decimal Place column: In cell B$4,$ enter the number $5.$ In cell $B5,$ enter the formula $=B4-1$ and copy the formula down the column into the range B$5$:B$15.$

Use the Round Function: In cell $C4,$ enter the formula

$\backslash$table$[[,$A$,$B$,$C$],[1,123560\mathrm{.}94732,,],[2,,,],[3,$Number,Decimal Places,Result$],[4,123560\mathrm{.}94732,5,123560\mathrm{.}94732],[5,123560\mathrm{.}94732,4,123560\mathrm{.}94730],[6,123560\mathrm{.}94732,3,123560\mathrm{.}94700],[7,123560\mathrm{.}94732,2,123560\mathrm{.}95000],[8,123560\mathrm{.}94732,1,123560\mathrm{.}90000],[9,123560\mathrm{.}94732,0,123561\mathrm{.}00000],[10,123560\mathrm{.}94732,-1,123560\mathrm{.}00000],[11,123560\mathrm{.}94732,-2,123600\mathrm{.}00000],[12,123560\mathrm{.}94732,-3,124000\mathrm{.}00000],[13,123560\mathrm{.}94732,-4,120000\mathrm{.}00000],[14,123560\mathrm{.}94732,-5,100000\mathrm{.}00000],[15,123560\mathrm{.}94732,-6,0\mathrm{.}00000],[,,,]]$

$=$ ROUND $(A4,B4)$ and copy the formula down the column into the range $C4$:$C15.$

$6.$ Format cells $A4$:$C15$ to display $5$ decimal places.

$7.$ Enter a comment in cell $C15($right click on the cell and choose "Insert Comment"$)$ explaining why the result in cell $C15$ is $0.$