Using Microsoft Excel only!!!! Please list all steps on how to create each part

ID: 3201766 • Letter: U

Question

Using Microsoft Excel only!!!! Please list all steps on how to create each part and please include what to type into each cell to get it to perform the desired operation.

Create a spreadsheet which has the following features: Has two boxes in which the user may enter values. The values will be called a and b. These boxes should be labeled in a useful way. Given those two values, there is a labeled 21 by 21 grid that computes az by, where z and y run from 0 to 20 corresponding to the grid. Changing the values of a and b should change the values in the grid automatically.

Explanation / Answer

here is steps what you have to do:

write as it is written in A1 cell a ; B1 cell 3 (for example)

A2 cell b ; B2 cell 7 (for example)

now write from E2 cell to Y2 cell numbers 0 to 20 as values of X ; as given in pic.

and write from D3 cell to D23 cell numbers 0 to as value of Y , as given in pic

now in E3 cell write the formula : =E$2*$B$1+$D3*$B$2

press enter.

after that copy that formula and paste in all colums of the range.

the spreadsheet is ready now you can change a and b values and can get the result.

i am sharing a template with a=8 and Y=12

please revert if any doubt.

a 8 X b 12 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Y 0 0 8 16 24 32 40 48 56 64 72 80 88 96 104 112 120 128 136 144 152 160 1 12 20 28 36 44 52 60 68 76 84 92 100 108 116 124 132 140 148 156 164 172 2 24 32 40 48 56 64 72 80 88 96 104 112 120 128 136 144 152 160 168 176 184 3 36 44 52 60 68 76 84 92 100 108 116 124 132 140 148 156 164 172 180 188 196 4 48 56 64 72 80 88 96 104 112 120 128 136 144 152 160 168 176 184 192 200 208 5 60 68 76 84 92 100 108 116 124 132 140 148 156 164 172 180 188 196 204 212 220 6 72 80 88 96 104 112 120 128 136 144 152 160 168 176 184 192 200 208 216 224 232 7 84 92 100 108 116 124 132 140 148 156 164 172 180 188 196 204 212 220 228 236 244 8 96 104 112 120 128 136 144 152 160 168 176 184 192 200 208 216 224 232 240 248 256 9 108 116 124 132 140 148 156 164 172 180 188 196 204 212 220 228 236 244 252 260 268 10 120 128 136 144 152 160 168 176 184 192 200 208 216 224 232 240 248 256 264 272 280 11 132 140 148 156 164 172 180 188 196 204 212 220 228 236 244 252 260 268 276 284 292 12 144 152 160 168 176 184 192 200 208 216 224 232 240 248 256 264 272 280 288 296 304 13 156 164 172 180 188 196 204 212 220 228 236 244 252 260 268 276 284 292 300 308 316 14 168 176 184 192 200 208 216 224 232 240 248 256 264 272 280 288 296 304 312 320 328 15 180 188 196 204 212 220 228 236 244 252 260 268 276 284 292 300 308 316 324 332 340 16 192 200 208 216 224 232 240 248 256 264 272 280 288 296 304 312 320 328 336 344 352 17 204 212 220 228 236 244 252 260 268 276 284 292 300 308 316 324 332 340 348 356 364 18 216 224 232 240 248 256 264 272 280 288 296 304 312 320 328 336 344 352 360 368 376 19 228 236 244 252 260 268 276 284 292 300 308 316 324 332 340 348 356 364 372 380 388 20 240 248 256 264 272 280 288 296 304 312 320 328 336 344 352 360 368 376 384 392 400

Navigate

Using Microsoft Excel Only!!!!! Please list all steps as to what to type into ea

Using Microsoft Excel, prepare CONSOLIDATION WORKSHEET (spreadsheet) for Salmon

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

Using Microsoft Excel only!!!! Please list all steps on how to create each part

Question

Explanation / Answer

Related Questions

Navigate