Question 1 Create a column named series!\" The numbers in this column are: 1,2,

Question

Question 1 Create a column named series!" The numbers in this column are: 1,2, 3, ....99, 100., 198,199,200 Sum these numbers up 7 Question 2 Create a column named "series 2" The numbers in this column are: 1, 3,5, 7.... 399 Sum these numbers up 10 11 Question 3 Create a column named "series 3 The numbers in this column equal to the number in "series 2" above multiply by 1.5 Sum these numbers up 12 13 14 15 Question 4 Create a column named "series 4" 16 17 18 19 Question 5 Create a colum named "square" 20 The numbers in this column equal to the number in "series 2" minus 2.5 Sum these numbers up Square in this series, report the square of number from 1 to 50 like the one in the right hand side Sum these square number up 21 Hint Square function in Excel is: Instruction |HW2a| HW2b HW2c

Explanation / Answer

series 1 series 2 series 3 series 4 series 5 1 1 1.5 -1.5 1 2 3 4.5 0.5 4 3 5 7.5 2.5 9 4 7 10.5 4.5 16 5 9 13.5 6.5 25 6 11 16.5 8.5 36 7 13 19.5 10.5 49 8 15 22.5 12.5 64 9 17 25.5 14.5 81 10 19 28.5 16.5 100 11 21 31.5 18.5 121 12 23 34.5 20.5 144 13 25 37.5 22.5 169 14 27 40.5 24.5 196 15 29 43.5 26.5 225 16 31 46.5 28.5 256 17 33 49.5 30.5 289 18 35 52.5 32.5 324 19 37 55.5 34.5 361 20 39 58.5 36.5 400 21 41 61.5 38.5 441 22 43 64.5 40.5 484 23 45 67.5 42.5 529 24 47 70.5 44.5 576 25 49 73.5 46.5 625 26 51 76.5 48.5 676 27 53 79.5 50.5 729 28 55 82.5 52.5 784 29 57 85.5 54.5 841 30 59 88.5 56.5 900 31 61 91.5 58.5 961 32 63 94.5 60.5 1024 33 65 97.5 62.5 1089 34 67 100.5 64.5 1156 35 69 103.5 66.5 1225 36 71 106.5 68.5 1296 37 73 109.5 70.5 1369 38 75 112.5 72.5 1444 39 77 115.5 74.5 1521 40 79 118.5 76.5 1600 41 81 121.5 78.5 1681 42 83 124.5 80.5 1764 43 85 127.5 82.5 1849 44 87 130.5 84.5 1936 45 89 133.5 86.5 2025 46 91 136.5 88.5 2116 47 93 139.5 90.5 2209 48 95 142.5 92.5 2304 49 97 145.5 94.5 2401 50 99 148.5 96.5 2500 51 101 151.5 98.5 sum 42925 52 103 154.5 100.5 53 105 157.5 102.5 54 107 160.5 104.5 55 109 163.5 106.5 56 111 166.5 108.5 57 113 169.5 110.5 58 115 172.5 112.5 59 117 175.5 114.5 60 119 178.5 116.5 61 121 181.5 118.5 62 123 184.5 120.5 63 125 187.5 122.5 64 127 190.5 124.5 65 129 193.5 126.5 66 131 196.5 128.5 67 133 199.5 130.5 68 135 202.5 132.5 69 137 205.5 134.5 70 139 208.5 136.5 71 141 211.5 138.5 72 143 214.5 140.5 73 145 217.5 142.5 74 147 220.5 144.5 75 149 223.5 146.5 76 151 226.5 148.5 77 153 229.5 150.5 78 155 232.5 152.5 79 157 235.5 154.5 80 159 238.5 156.5 81 161 241.5 158.5 82 163 244.5 160.5 83 165 247.5 162.5 84 167 250.5 164.5 85 169 253.5 166.5 86 171 256.5 168.5 87 173 259.5 170.5 88 175 262.5 172.5 89 177 265.5 174.5 90 179 268.5 176.5 91 181 271.5 178.5 92 183 274.5 180.5 93 185 277.5 182.5 94 187 280.5 184.5 95 189 283.5 186.5 96 191 286.5 188.5 97 193 289.5 190.5 98 195 292.5 192.5 99 197 295.5 194.5 100 199 298.5 196.5 101 201 301.5 198.5 102 203 304.5 200.5 103 205 307.5 202.5 104 207 310.5 204.5 105 209 313.5 206.5 106 211 316.5 208.5 107 213 319.5 210.5 108 215 322.5 212.5 109 217 325.5 214.5 110 219 328.5 216.5 111 221 331.5 218.5 112 223 334.5 220.5 113 225 337.5 222.5 114 227 340.5 224.5 115 229 343.5 226.5 116 231 346.5 228.5 117 233 349.5 230.5 118 235 352.5 232.5 119 237 355.5 234.5 120 239 358.5 236.5 121 241 361.5 238.5 122 243 364.5 240.5 123 245 367.5 242.5 124 247 370.5 244.5 125 249 373.5 246.5 126 251 376.5 248.5 127 253 379.5 250.5 128 255 382.5 252.5 129 257 385.5 254.5 130 259 388.5 256.5 131 261 391.5 258.5 132 263 394.5 260.5 133 265 397.5 262.5 134 267 400.5 264.5 135 269 403.5 266.5 136 271 406.5 268.5 137 273 409.5 270.5 138 275 412.5 272.5 139 277 415.5 274.5 140 279 418.5 276.5 141 281 421.5 278.5 142 283 424.5 280.5 143 285 427.5 282.5 144 287 430.5 284.5 145 289 433.5 286.5 146 291 436.5 288.5 147 293 439.5 290.5 148 295 442.5 292.5 149 297 445.5 294.5 150 299 448.5 296.5 151 301 451.5 298.5 152 303 454.5 300.5 153 305 457.5 302.5 154 307 460.5 304.5 155 309 463.5 306.5 156 311 466.5 308.5 157 313 469.5 310.5 158 315 472.5 312.5 159 317 475.5 314.5 160 319 478.5 316.5 161 321 481.5 318.5 162 323 484.5 320.5 163 325 487.5 322.5 164 327 490.5 324.5 165 329 493.5 326.5 166 331 496.5 328.5 167 333 499.5 330.5 168 335 502.5 332.5 169 337 505.5 334.5 170 339 508.5 336.5 171 341 511.5 338.5 172 343 514.5 340.5 173 345 517.5 342.5 174 347 520.5 344.5 175 349 523.5 346.5 176 351 526.5 348.5 177 353 529.5 350.5 178 355 532.5 352.5 179 357 535.5 354.5 180 359 538.5 356.5 181 361 541.5 358.5 182 363 544.5 360.5 183 365 547.5 362.5 184 367 550.5 364.5 185 369 553.5 366.5 186 371 556.5 368.5 187 373 559.5 370.5 188 375 562.5 372.5 189 377 565.5 374.5 190 379 568.5 376.5 191 381 571.5 378.5 192 383 574.5 380.5 193 385 577.5 382.5 194 387 580.5 384.5 195 389 583.5 386.5 196 391 586.5 388.5 197 393 589.5 390.5 198 395 592.5 392.5 199 397 595.5 394.5 200 399 598.5 396.5 sum 20100 sum 40000 sum 60000 sum 39500

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.