The meeting Session in week one covered the basics of what this class will cover, along with a background of Mr. Kotas. He explains the general layout of the course along with the materials required for COMP106. The grading rubric, grade assignment point amounts, attendance policy, and assignment of teams are also covered in the first weeks Meet session. The type of excel used for this class is 2013, unfortunately for those who use an earlier edition or on a mac will see issues. The online website used for the class is MyITlab, which the user is required to purchase an access code. Any problems with this website will be addressed through the website technical support team, any other problem that cannot be resolved through their support team
…show more content…
Wrap text is covered, which is a tool to adjust the layout of a cell so the text or numbers will not be cut off. This session covers the changing of formatting such as currency, cell layout and/or the use format painter, which takes the format from one cell and applies it to another. Absolute cell referencing is the use of the numbers, functions, or formulas used in one cell to reference into another cell, an example would be C$4$, which when inserted into any other cell will cause excel to use the information in c4 into the new cell. If this is not used the cell will use the formulas from the previously selected cell to the left or above, or below rather than the cell that needs to be constant such as C$4$. The next thing covered is the use of the insert function bar, and how to find the function that needs to be use Such as average, IF, COUNTIF, etc. Conditional formatting allows the users to apply a format to one or multiple cells as long as the conditions are met, which is useful when locating numbers an applying new formats to the qualifying cells. Example would be applying a green background to any numbers that are greater or less than 0. I learned that these tools will be very useful for the remainder of the …show more content…
First covered is the selection of information that will be presented within the chart. By selecting the range in which the information is located, you will switch to the insert tab and choose the table button, where you can pick out which form of table or chart you please, or the use the recommend chart tool. Explained next is how to change the formatting of the chart, such as the name of the axis the value range of the axis, inserting of gridlines, and the color of the chart. Another covered topic is how to change the data or select information that is not next to each by using the control function. Pie charts are also covered in week three, particularly how the pie chart is set up, how the items are labeled and the general appearance. What-if analysis and goal seek is covered, which allows you to find the result by changing a particular cell. These tools will come in handy as the assignments and course
Wrap text is covered, which is a tool to adjust the layout of a cell so the text or numbers will not be cut off. This session covers the changing of formatting such as currency, cell layout and/or the use format painter, which takes the format from one cell and applies it to another. Absolute cell referencing is the use of the numbers, functions, or formulas used in one cell to reference into another cell, an example would be C$4$, which when inserted into any other cell will cause excel to use the information in c4 into the new cell. If this is not used the cell will use the formulas from the previously selected cell to the left or above, or below rather than the cell that needs to be constant such as C$4$. The next thing covered is the use of the insert function bar, and how to find the function that needs to be use Such as average, IF, COUNTIF, etc. Conditional formatting allows the users to apply a format to one or multiple cells as long as the conditions are met, which is useful when locating numbers an applying new formats to the qualifying cells. Example would be applying a green background to any numbers that are greater or less than 0. I learned that these tools will be very useful for the remainder of the …show more content…
First covered is the selection of information that will be presented within the chart. By selecting the range in which the information is located, you will switch to the insert tab and choose the table button, where you can pick out which form of table or chart you please, or the use the recommend chart tool. Explained next is how to change the formatting of the chart, such as the name of the axis the value range of the axis, inserting of gridlines, and the color of the chart. Another covered topic is how to change the data or select information that is not next to each by using the control function. Pie charts are also covered in week three, particularly how the pie chart is set up, how the items are labeled and the general appearance. What-if analysis and goal seek is covered, which allows you to find the result by changing a particular cell. These tools will come in handy as the assignments and course