Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
If my student number is 213405252 1. Open a new Excel file, write your student ID number in the first row and first column, one
If my student number is 213405252 1. Open a new Excel file, write your student ID number in the first row and first column, one digit per cell; color the cells, and apply border lines (must be formatted similar to the sample view). 2. Write the formulas that give the product of the numbers in the cells where the numbers intersect. Cell addresses should be used in formulas, not numbers. The Absolute Reference ($) feature should be used to copy the correct formulas, when you copy the formulas you will write in the second row, to the cells in the same column. 3. Formulas to give the sum of the values in each column should be written in the eleventh line.
1. Write a program that gets a string containing a person's first, middle, and last names, and displays their first, middle, and last initials. For example, if the user enters John William Smith, the program should display J. W. S. 1. Write a program that gets a string containing a person's first, middle, and last names, and displays their first, middle, and last initials. For example, if the user enters John William Smith, the program should display J. W. S
If my student number is 213405252
1. Open a new Excel file, write your student ID number in the first row and first column, one digit per cell; color the cells, and apply border lines (must be formatted similar to the sample view).
2. Write the formulas that give the product of the numbers in the cells where the numbers intersect.
Cell addresses should be used in formulas, not numbers.
The Absolute Reference ($) feature should be used to copy the correct formulas, when you copy the formulas you will write in the second row, to the cells in the same column.
3. Formulas to give the sum of the values in each column should be written in the eleventh line.
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/66a1b3ba2ddf8_33766a1b3b9d3552.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started