Answer To: KII4003 Working With Spreadsheets Assessment 2 KII4003-AT-V XXXXXXXXXX XXXXXXXXXXDowntown Australia...
Parul answered on Sep 20 2021
Answer 1
Conditional Formatting
It is a formatting function that us used to emphasize the selected data that meets certain threshold and conditions. It is also leveraged for highlighting and differentiating the data in the spreadsheet with respect to others. Essentially, any individual can apply a specific format like highlighting the text or cell or implementation of colors while we want to differentiate the data that meets the conditions.
Example Use in Real Life - This is most commonly used feature that is primarily leveraged in the corporates that requires to offer monthly reporting. By leveraging this function, business professionals are able to comprehend the data easily, identifying the areas where conditions have met and where they haven’t met. Hence, they know where to make adjustments and improve on which aspects in the business.
Analysis ToolPak
Analysis ToolPak is a function in the Excel that is available as an extra "Add-In". Essentially, it is an established small program in excel, once installed offers data analysis tools. It is of great use in financing, statistics and engineering data comprehension.
Examples Use in Real Life - Analysis ToolPak is option that is commonly utilised by students who are performing tremendous amount of research as well as areas that demands computing for statistics. This tool offers smoother computation of data.
Cell Formatting
This one of the commonly used functions in excel that offers user to change the appearance of the cell in the sheet. Specifically, this option only influences the appearance of the cell and doesn’t impact on the value of the data. Therefore, a person can apply number format like percentage, currency, time and date as well as accounting. Other functions of cell formatting include alignment, font styles and border designs.
Example in Real Life - This can be leveraged by accounting professors and students that can use practices in their exercise of reporting and analyzing numbers. Therefore, while conducting the bank reporting, encoders can utilize the format of currency where they can choose the symbol of currency as well as automatically appear on each cell with input.
Functions & Formulas
Functions can be explained as easily accessible and available in excel with predefined purpose. For instance, function of SUM that allows the addition of values present in different cells.
Example in Real Life - The tracking of the expenses and entire computation can be performed using these functions. Business professionals can utilize various functions to chalk out their reports.
Pivot Tables
This is a functionality that is leveraged with different combination of rows and columns that requires to be monitored or tracked. Pivot tables permits the user to frequently compare values from one and another.
Example in Real Life - An example can be business professional one can utilize this function to comprehend different products that were sold with respect to geography, market segments and client-base
Charts
This is one of the most powerful functions as it allows the user to present and display the data vividly. There are different types of charts available that can be leveraged like bar graph, column chart, doughnut graph and scatter plots.
Example in Real Life:
One of the best examples of utilizing the charts in practical application is displaying the results of political polls.
Sorting - It is method of synchronizing the data into an order like ascending or descending order. This can help in clear analysis of data and enhance comprehension even by viewing the content.
Filter - The function of filter offers an easy extraction of data that matches the larger sets of sourced data. Essentially, the filter is very dynamic and values can change according to what is been sourced.
Formula Auditing - In excel, function of formula auditing permits us to see the relationship between the cells and formulas. Formula auditing becomes important when we are working with the complex functions and desire to check if there are any errors. Furthermore, function of auditing also provides ways to track the particular functions.
Macros - Macros comes into power, when one wants to automate the set of actions that are repeatedly performed in the excel. Essentially, macro is an action or group of actions that can be performed multiple number of time and produce results.
Freeze Panes - A tool that allows one to lock the rows or columns can consider as headings. Essentially, it is very useful since when we scroll down or try to view the rest of sheet the first row or column which is been freeze remain on the screen.
Split View - This functionality displays two windows side by side in the form of split-screen with the black partition in the center. It is designed to offer multi-tasking feature both at the same...