Question

Unit 1: Discussion

In this unit, you learn many functionalities in Microsoft Excel. Choose any functionality that you learned about in this unit, and propose an application in your daily life or an imaginary application that can utilize the functionality. Explain in detail how the application can utilize the functionality that you choose. Feel free to bring in your own personal experience, as long as it is a relevant, concrete, interesting, or provocative example from your own experience, on which you can write with confidence.Discussion should be 100-300 words. No plagiarizing please.

Answer 1

In this Unit we have learn a lot of functionality in Microsoft Excel in which we have learned about some functionalities like:

1. Mathematical functions:

it involves functions like SUM, SUMIF, SUMPRODUCT, ROUND, ROUNDUP,ROUNDDOWN,CEILING,FLOOR.

​​​​​​ 2.Statistical function​:

it involves function like COUNT, AVERAGE, MAX, MIN etc.

3.Text Functions:

  it involves function like LEFT, RIGHT, UPPER, LOWER,etc.

and many more.

the main uses of these functions of Microsoft Excel in daily life is for is to perform calculation, analysis and visualization of data and information. it helps to organize business system and process data in the form of table(with rows and columns) with the help of these above functionalities mentioned.

Microsoft excel is used in WINDOWS, Mac OS, Cloud computing and Android users. in the excel spreadsheet users can perform lots of work such as mathematical, financial, logical calculations, data manipulation, data analysis and visualization of information in a very quick way. it also provides table styles and conditional formatting option for users.

the application of excel that i have chosen after learning these functionalities is in EDUCATION and we will see how these Microsoft excel is helpful for teachers as well as students to grab the information given by these excel sheets.

• teachers can use table styles, shapes, charts and formulas to teach students in the classrooms , student can learn and solve basic and logical mathematical problems and statistics in excel.
• teachers can teach by creating table in excel sheet ,they can highlight more interesting facts using colors , bars and charts. lets see this with the help of an example :
  Basic example of Data Visualization in Excel 2010 for Students Hame Menu Conditional Formatting Litracy Rate Country Litracy Rate 74.04% 99% India China USA 95% ABC 45% Litracy Rate Example 120.00% 100.00% illi 60.00% 60.00% Chart option in Insert Menu 40.00% Litracy Rate 20.00% t 0.00% India China USA ABC Countries
  
• the above visualization of data is easy to understand which is created by the use of two excel functions which are conditional formatting and charts. as we can see in the first picture that literacy rate of countries is highlighted in red color by use of conditional formatting and in charts we can see that china data bar is bigger than other. we can access these options from insert menu in menu bar of excel sheet.
• we can see another use of excel for teachers to schedule periods :
  IT School Vijay Sharma Period Schedule 10/11/2017 From: To: 10/15/2017 Monday Tuesday Plan Plan Period Period 1st Lecture about Computer Fundamental 1st 2nd 2nd 3rd 3rd 4th 4th 5th 5th 6th 6th Uses of Internet in our daily life 7th 7th 8th 8th Wednesday Thursday Plan Plan Period Period 1st 1st 2nd 2nd Block Diagram of Computer 3rd 3rd 4th 4th 5th 5th 6th 6th 7th 7th Period Schedule dv
  
• we can do this scheduling with the help of TEMPLATE function of excel.
• the above examples can also be used in business in similar way only need to change the values , the option in excel sheet given is same for all users but it depends on us that how we are going to use this options for creating more interactive and more interesting for the understading purpose.