Microsoft excel functions

Microsoft excel functions
A function is an inbuilt formula.
This command is used in ms excel to insert formulas for calculation or analysis. It also has a shortcut on the standard toolbar.
A formula always starts with an equal sign is (=).
This signs tells excel that the succeeding value comprises of a formula.
Excel calculates a formula from the left to right according to a specific order from each operater.
We have these functions categories in ms Excel:
1.Financial
2.Date and time
3.Mathematical
4.Stastiscal.
5.look up and reference
6.Database
7.Text
8.Logical
9.Information
Procedure for inserting a function
Click on insert.
Click on function.
Click OK.
Choose the appropriate function from the dialog box.
Click OK
Indicate the range.

Subcribe to this blog for more computer blogs https://trendingoncampu.blogspot.com/

Don't forget to share

Comments

How to Remove Powered by Blogger – Attribution Widget?

In this article, I will be demonstrating how to remove or hide attribution widget ‘Powered by Blogger’ in footer of blogger blogspot blogs. Before going to the process, backup your blogger template , while editing html code if anything goes wrong or template modified design doesn’t work or looks good you can restore from backed up template. Here I have demonstrated you two methods for removing attribution widget. Some blogger templates may not support method 1 then you need to follow method 2 for successfully removing attribution widget. Method 1: Remove ‘Powered by Blogger’ by unlocking Attribution widget Step 1 : Go to your blog “Template” | click on “Edit HTML”. Step 2 : Here on drop-down “jump to widget” option and select Attribution 1 as shown below Step 3: After selecting Attribution 1 widget you will be able to see this line <b:widget id=’Attribution1′ locked=’true’ title=” type=’Attribution’> on your blogger template. Step 5: Once done click on...

Top 7 Modules in Python Programming language | 2020

Python is a simple programming language yet of very high level and is very much popular. This days the use of python has gone very high and it is expected to be much higher in the upcoming days in the near future. So, today in this article we will be discussing about some modules in python language which are most to be learnt: NumPy: It helps to do basic mathematical operations and complex math with algebraic formulas, statistical operations,etc. It is a valuable python package and is important for machine learning. Pendulum: It helps to do complex coding involving dates and time and is broad form of datetime module. It also manages the time zone automatically hence, it is a replacement for the datetime module. Python imaging library: It makes easy to write codes that involves to open, read and manipulate or modify images in a variety of formats. The Pillow or PIL imaging library is good for importing, manipulation and exporting images. MoviePy: As pillow is to images, moviePy ...

The four yugas (Era or Epoch) in Hinduism

A yuga is the period-of-time or ages. In Hinduism, the Chatur-yuga (Four-Yuga) are large time periods characterizing and defining humans as well as social development on the earth. There are four different yugas, (Chatur---> Four) and each of them have their own feature in history. Let's see their names: Satya Yuga (सत्य युग) Treta Yuga (त्रेता युग) Dwapara Yuga (द्वापर युग) Kali Yuga(कली युग) Let's learn briefly on them: 1. Satya Yuga: It is also called as Krita yuga, which is the first of the yuga. Satya means truth. It lasted for 17,28,000 years or 4800 Divine years. It is the truth or golden age, where all humans were good and very religious. It was the first and best yuga without crime and all humans were kind and friendly. It is called Krita Yuga as there was one religion and all men were saintly. Humans used to be 33 feet in height and average human lifespan was of 1,00,000 years. The bull of Dharma symbolizes that morality stood on all four legs durin...

wanem guide

Search This Blog