How To Create Marksheet In Ms Excel Step By Step

marksheet

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications

Microsoft Excel is a helpful and powerful program for data analysis and documentation. It is a spreadsheet program, which contains a number of columns and rows, where each intersection of a column and a row is a “cell.” Each cell contains one point of data or one piece of information. By organizing the information in this way, you can make information easier to find, and automatically draw information from changing data.

FUNCTIONS OF MS EXCEL

Function nameType and description
ABS functionMath and trigonometry:    Returns the absolute value of a number
ACCRINT functionFinancial:    Returns the accrued interest for a security that pays periodic interest
ACCRINTM functionFinancial:    Returns the accrued interest for a security that pays interest at maturity
ACOS functionMath and trigonometry:    Returns the arccosine of a number
ACOSH functionMath and trigonometry:    Returns the inverse hyperbolic cosine of a number
ACOT function
Excel 2013
Math and trigonometry:    Returns the arccotangent of a number
ACOTH function
Excel 2013
Math and trigonometry:    Returns the hyperbolic arccotangent of a number
AGGREGATE functionMath and trigonometry:    Returns an aggregate in a list or database
ADDRESS functionLookup and reference:    Returns a reference as text to a single cell in a worksheet
AMORDEGRC functionFinancial:    Returns the depreciation for each accounting period by using a depreciation coefficient
AMORLINC functionFinancial:    Returns the depreciation for each accounting period
AND functionLogical:    Returns TRUE if all of its arguments are TRUE
ARABIC function
Excel 2013
Math and trigonometry:    Converts a Roman number to Arabic, as a number
AREAS functionLookup and reference:    Returns the number of areas in a reference
ARRAYTOTEXT function
Office 365 button
Text:    Returns an array of text values from any specified range
ASC functionText:    Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters
ASIN functionMath and trigonometry:    Returns the arcsine of a number
ASINH functionMath and trigonometry:    Returns the inverse hyperbolic sine of a number
ATAN functionMath and trigonometry:    Returns the arctangent of a number
ATAN2 functionMath and trigonometry:    Returns the arctangent from x- and y-coordinates
ATANH functionMath and trigonometry:    Returns the inverse hyperbolic tangent of a number
AVEDEV functionStatistical:    Returns the average of the absolute deviations of data points from their mean
AVERAGE functionStatistical:    Returns the average of its arguments
AVERAGEA functionStatistical:    Returns the average of its arguments, including numbers, text, and logical values
AVERAGEIF functionStatistical:    Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria
AVERAGEIFS functionStatistical:    Returns the average (arithmetic mean) of all cells that meet multiple criteria.
BAHTTEXT functionText:    Converts a number to text, using the ß (baht) currency format
BASE functionMath and trigonometry:    Converts a number into a text representation with the given radix (base)
BESSELI functionEngineering:    Returns the modified Bessel function In(x)
BESSELJ functionEngineering:    Returns the Bessel function Jn(x)
BESSELK functionEngineering:    Returns the modified Bessel function Kn(x)
BESSELY functionEngineering:    Returns the Bessel function Yn(x)
BETADIST functionCompatibility:    Returns the beta cumulative distribution functionIn Excel 2007, this is a Statistical function.
BETA.DIST function
Excel 2010
Statistical:    Returns the beta cumulative distribution function
BETAINV functionCompatibility:    Returns the inverse of the cumulative distribution function for a specified beta distributionIn Excel 2007, this is a Statistical function.
BETA.INV function
Excel 2010
Statistical:    Returns the inverse of the cumulative distribution function for a specified beta distribution
BIN2DEC functionEngineering:    Converts a binary number to decimal
BIN2HEX functionEngineering:    Converts a binary number to hexadecimal
BIN2OCT functionEngineering:    Converts a binary number to octal
BINOMDIST functionCompatibility:    Returns the individual term binomial distribution probabilityIn Excel 2007, this is a Statistical function.
BINOM.DIST function
Excel 2010
Statistical:    Returns the individual term binomial distribution probability
BINOM.DIST.RANGE function
Excel 2013
Statistical:    Returns the probability of a trial result using a binomial distribution
BINOM.INV function
Excel 2010
Statistical:    Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
BITAND function
Excel 2013
Engineering:    Returns a ‘Bitwise And’ of two numbers

FEATURES OF MS EXCEL

Features of Microsoft Excel

  • Add Header and Footer. MS Excel allows us to keep the header and footer in our spreadsheet document.
  • Find and Replace Command. …
  • Password Protection. …
  • Data Filtering. …
  • Data Sorting. …
  • Built-in formulae. …
  • Create different charts (Pivot Table Report) …
  • Automatically edits the result.

HOW TO CREATE MARKSHEET IN MS EXCEL

1) Start “MS Excel” program

2) Fill your data by these information “SNO”, “Name”, “F/Name”, “English”, “Chemistry”, “Mathematics”, “Physics”, “Biology”, “Drawing”, “History”, “Total Marks”, “Marks Obtained”, “Minimum no”, “Maximum no”, “Average”, and “Grade”. Bold your text and then fill it by your own information as given below.

3) Use this function in first cell of “Marks Obtained” which is given above. =sum(F5:L5) As you will type this function “=sum(F5:L5)”. After type it press “Enter”. As you will press “Enter” our value will directly define as given below.

4) “=sum(F5:L5)” In this function the first is =. = we use it at the beginning of every function and number second is “Sum”. Sum function is use for adding of value and the last think of this function is (F5:L5) is the area of values that we want to add. (F5:L5) means (F5 cell to L5).

5) Now follow these steps which are given below.

6) The next column is about “Minimum no”. In this column we will find the minimum no of paper that what the minimum mark is. To find the minimum no of paper type this function at first cell of “Minimum no” column “=Min(F5:L5)” as given below.

7) Drag “Minimum no” column also like “Marks Obtained”.

8) Now we are going to work on “Maximum no” column that how to find the maximum no of paper. To fine the maximum no of paper we use the function “=max(F5:L5)” as given below.

After type of function press “Enter”. As you will press “Enter” the value will define. Drag it below.

9) Now is the turn of to find the “Average” of your marks. To find the average of mark type this function at the first cell of “Average” column =Average(F5:L5) as given below.

After type of function press “Enter” and drag it as given below.

10) The last think is to find the “Grade” of your marks. To find the Grade first of all click on the first cell as given above and then type in “Formula bar” as given below.

After click on “Formula bar” type the below function

=IF(N5>=550,”Grade A”,IF(N5>=450,”Grade B”,IF(N5>=400,”Grade C”,IF(N5>=350,”Grade D”,”Failed”))))

Press “Enter” and drag it as given before.

11) Select your Result sheet and click on “Outside broders” and then select a color of background and then click on it

Drop your comment

Hits: 4

Related Post

Leave a Reply

Your email address will not be published.