Scribd
Upload
4 views22 pages

BA Record_organized

The document provides a comprehensive guide on various Excel functionalities, including inserting spreadsheets, summing numbers, generating random values, and utilizing pivot tables. It also explains statistical functions such as MAX, MIN, AVERAGE, variance, and standard deviation, along with methods for data export and visualization through charts. Additionally, it covers data protection and the use of auto-fill for efficiency.

Uploaded by

batchaids
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views22 pages

BA Record_organized

The document provides a comprehensive guide on various Excel functionalities, including inserting spreadsheets, summing numbers, generating random values, and utilizing pivot tables. It also explains statistical functions such as MAX, MIN, AVERAGE, variance, and standard deviation, along with methods for data export and visualization through charts. Additionally, it covers data protection and the use of auto-fill for efficiency.

Uploaded by

batchaids
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 22

PROCEDURE:

1. Inserting a Spreadsheet
By default, you start with 1-3 sheets. If you need more, simply click the “+”
button at the bottom to add a new sheet. Alternatively, you can use the shortcut
Shift+F11 to quickly insert a new spreadsheet. This makes managing multiple
sheets for your data simple and efficient.

2. Sum Of Numbers:
To quickly sum a list of numbers, select the cell where you want the result and
press Alt+=. Excel will automatically calculate and display the sum.

3. Inserting Random Numbers:


Use the RANDBETWEEN function to insert random numbers. It takes two
arguments: the smallest and largest numbers. This allows you to quickly
generate random numbers in a selected range.
4. Password Protection:
To secure your data, use password protection. This prevents unauthorized
access, ensuring that only those with the password can open the document.
5. Pivot Tables:
Analysing the data in Excel is quite interesting. If you want to create a table that
is clear to understand, you can use the pivot table feature.

6. Auto-Fill
Auto-fill is a simple but useful feature in Excel. With this feature, you can fill
the data in series. You can save a lot of time with this feature.

7. Rand Function
To generate random fractional values between 0 and 1, use the RAND function.
It requires no parameters—just enter RAND(). Note that the values will update
when the sheet is recalculated.
8. Various Charts:

MS Excel offers various chart types for data visualization, including column,
bar, line, and pie charts for comparisons and trends. Scatter and bubble charts
illustrate relationships, while histograms and area charts emphasize distributions
and totals. Combo and radar charts provide further analysis options for
multivariate data and comparisons.
PROCEDURE:

Get the input values from user. The MAX function returns the highest value in a
set of data. Firstly, in Cell B12 type the formula given below =MAX(C3:C9)

The MIN function returns the smallest value from the numbers provided.
Firstly, in Cell B13 type the formula given below = MIN(C3:C9)

The AVERAGE function calculates the average (arithmetic mean) of a group of


numbers. Firstly, in Cell B14 type the formula given below
=AVERAGE(B2:B8)
The SUM function calculates the SUM of a group of numbers in Excel. Firstly,
in Cell C14 type the formula given below

The Excel SQRT function returns the square root of positive number.
The ROUND function rounds a number to a specified number of digits.
Procedure:
Export Data When you have data that needs to be transferred to another system,
export it from Excel in a format that can be interpreted by other programs, such as
a text or CSV file.
PROCEDURE:
Mean, median, and mode: Mean, median, and mode are different measures of
center in a numerical data set. They each try to summarize a dataset with a single
number to represent a "typical" data point from the dataset.

Mean: The "average" number; found by adding all data points and dividing by
the number of data points.
Median: The middle number; found by ordering all data points and picking out
the one in the middle (or if there are two middle numbers, taking the mean of
those two numbers).

Mode: The most frequent number that is, the number that occurs the highest
number of times.

Variance:
According to layman’s words, the variance is a measure of how far a set of data
are dispersed out from their mean or average value. It is denoted as ‘σ2 ’.
Standard Deviation:
The spread of statistical data is measured by the standard deviation. Distribution
measures the deviation of data from its mean or average position. The degree of
dispersion is computed by the method of estimating the deviation of data points. It
is denoted by the symbol, ‘σ’.

VAR function in Excel:


It is the oldest Excel function to estimate variance based on a sample. The VAR
function is available in all versions of Excel 2000 to 2019.
VAR.S function in Excel:
It is the modern counterpart of the Excel VAR function. Use the VAR.S function
to find sample variance in Excel 2010 and later.
VARA function in Excel:
The Excel VARA function returns a sample variance based on a set of numbers,
text, and logical values as shown in this table.

You might also like