[A] Describe the FIVE (5) types of charts available in Microsoft Excel with the help of suitable example.
The Column Chart adequately demonstrates the correlation of at least one arrangement of information focuses. Be that as it may, the Clustered Column Chart is particularly valuable in looking at different information arrangement. The information that we select for the chart is known as an information arrangement. It comprises of one row and one column of information.
Next, the pie chart is the first of the five types of charts available in Microsoft Excel. A Pie Chart can just display one arrangement of information. Exceed expectations utilizes the arrangement identifier as the chart title and shows the qualities for that arrangement as relative cuts of a pie. Here’s an example of a pie chart.
Likewise, there is the Line Chart. The Line Chart is particularly viable in showing patterns. In a Line Chart, the vertical pivot (Y-axis) dependably shows numeric esteems and the level hub (X-axis) shows time or other class. You may pick each Line Chart sort with or without markers. Markers are circles, squares, triangles, or different shapes which check the information focuses. Exceed expectations shows a one of a kind marker – diverse shape as well as shading – for every datum arrangement. In spite of the fact that not as vivid as alternate charts, it is anything but difficult to perceive how compelling the Line Chart in demonstrating a pattern for a solitary arrangement, and looking at patterns for different arrangement of information esteems. Other than the Line Chart, we have the Stacked Line Chart and the 100% Stacked Line Chart – with or without markers. A 3-D Line Chart is accessible, yet the Line Chart does not show information well in three measurements.
The Bar Chart resembles a Column Chart lying on its side. The level hub of a Bar Chart contains the numeric esteems. At the point when to utilize a Bar Chart versus a Column Chart relies upon the kind of information and client inclination. Now and again it is justified regardless of an opportunity to make the two charts and look at the outcomes. Be that as it may, Bar Charts do tend to show and analyze an expansive number of arrangement superior to anything the other chart sorts. The majority of the Bar Charts are accessible in 2-D and 3-D formats, but just the bars are 3-D. There is no 3-D Bar chart containing three tomahawks. Likewise, with the other chart sorts, Excel gives the Stacked Bar Chart and 100% Stacked Bar Chart. his chart sort doesn't show money on the even hub, yet rates. It enables us to perceive what rate every datum call attention to out of 100%. Similarly, as with the other chart sorts, new forms of Excel give the alternative of utilizing chambers, pyramids, or cones rather than bars.
The Area Chart resemble Line Charts with the exception of that the area underneath the plot line is strong. What's more, similar to Line Charts, Area Charts are utilized fundamentally to demonstrate drifts after some time or other classification. There are three charts accessible: The Area Chart, the Stacked Area Chart, and the 100% Stacked Area Chart. Each of these charts come in 2-D arrange and in genuine 3-D organize with X, Y, and Z tomahawks. By and large, the 2-D rendition of the Area Chart can be insufficient in showing different arrangement of information seriously. Arrangement with lesser esteems might be totally holed up behind arrangement with more noteworthy esteems – as exhibited in the principal chart beneath. Blossoms is completely covered up, and only a small piece of Trees tops through. Not an exceptionally compelling chart!
https://www.keynotesupport.com/excel-basics/excel-chart-types.shtml
[B] Discuss the FIVE (5) steps on inserting a function in Excel with the help of suitable example as your evidence.
There are a few approaches to embed functions. Before anything, you have to ensure your cursor is in the cell in which you need the outcome. Once there, pick one of the techniques underneath to embed your capacity:
Steps on inserting functions are shown below:
Step 1: Select a cell.
Step 2: Before you enter the formula, type an equal (=) sign.
Step 3: Type the formulae SUM(select A1 and A2).
Step 4: Press the Enter button on your keyboard and the value will be calculated and appear.
Step 5: If you changed the number in cell A2 to 24, the Excel will recalculate the value.
http://guides.lib.umich.edu/c.php?g=283162&p=1888332
[C] In MS-Excel, differentiate between relative and absolute cell referencing techniques with the help of sample data or example.
There are two noteworthy sorts of references utilized as a part of Microsoft Excel which is an Absolute Reference and a Relative Reference. On an everyday premise, the relative and absolute reference doesn't generally influence the operations of your spreadsheet. Where it becomes a perceptible issue is the point at which you begin duplicating recipes starting with one cell then onto the next.
http://www.psexam.com/Notes-for-Computer-Science/relative-absolute-and-mixed-cell-reference-explained-types-of-cell-address-microsoft-excel.html
[D] In MS Access, discuss the tables, queries, forms, and reports with examples on each entity.
A table holds and stores the data. A table contains a column and a row. Data contained in the rows are known as record.
A query is nearly the same to a table as they demonstrate data in matrices. A query is a summon to the database which enables us to haul out the data from the data. Queries can limit and concentrate on specific things.
A query is nearly the same to a table as they demonstrate data in matrices. A query is a summon to the database which enables us to haul out the data from the data. Queries can limit and concentrate on specific things.
A report presents data in a designed example and it can be utilized to demonstrate data in a composed example. A report can be founded on a table or a query. Reports can be utilized to gathering or create outlines. For instance, telephone directory.
E. In MS Access, what is the function of a key field in a database. Briefly discuss “Primary Key”, “Candidate Key” and “Foreign Key” with example.
A candidate key has the base mix of range that only identifies each record in a table. Each table ought to have no less than one candidate key; It can have a few candidate keys in the meantime. For instance, student ID. It identifies every single student in a table. We may have the principal name and last name of the students in a similar table, they could be candidate keys as well.
A primary key is the most suitable to be utilized as the principle reference key for a table. It is utilized all through the database keeping in mind the end goal to construct associations with different tables. Primary keys contain exceptional esteems which must be recorded in a table.
A foreign key shows up as a field starting with one table then onto the next where the main table is connected to the second. In another way, it implies the primary key X in table An is connected to that in table B which has X in the field, at that point the foreign key in B is X. An illustration would be Course ID.