Skip to main content

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

Popular posts from this blog

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 ...

What is a Country? देश भनेकाे के हाे?

Yesterday, on January 13, Nepal's Coat of Arms was updated to add Kalapani and Limpiyadhura as in the new Political map. In this context, we today discuss on what actually 'a country is for it's citizen.' देश भनेकाे के हाे? What is a Country? जनताका लागि देश के हो ? जनताका लागि देश संविधान, कानुन, नागरिकता, सिमाना र झन्डा मात्र हो ? होइन । जनताका लागि देश राजधानी, त्यसबीच ठडिएको दरबार र त्यसको गजुर हो ? होइन । जनताका लागि देश भनेको सरकार हो ? होइन । जनताका लागि देश निर्वाचन क्षेत्र मात्र हो ? हुँदै होइन । त्यसो भए जनताका लागि के हो त देश ? जनताका लागिदेश चार सिमानाभित्रको माटो मात्र होइन । योसँगै जोडिने भावना, प्रेम, ऊर्जा र सपनाहरूको बगैंचा हो । जनताका लागि देश आशा हो । जनताका लागि देश खेतमा झरेको पसिनाको बियाड हो । आन्दोलनहरूमा सडकमा पोखिएको रगत हो । आफ्ना सपनाहरूको कविता हो । जस्तो, एउटा शिशुका लागि आमाको काख । जस्तो, भर्खर हिँड्दै गरेको एउटा बालकका लागि पिताजीको हात । एउटा यात्रीका लागि देश बाटो हो, जसमाथि ऊ आफ्ना पैतालाका डोबहरू छोड्छ र गन्तव्यतिर बढ्छ । देश भनेको ...

Why should you learn Python programming language?

Python is a programming language developed by Guido Van Rossum. It is a very simple programming language so, you can learn Python without facing any issues. You are a beginner at programming can learn python. So, let's see top 7 reasons to learn python: Simple and popular: Python programming language is simple and very popular. Many significant platforms only support Python language. It also ranks top three as per TIOBE Index. Versatile:  It is a versatile language, i.e.; can we used to develop desktop applications, web pages and is considered best for AI and data science. Popularity: Many industries like YouTube, Amazon, Google, Facebook,etc. use this language. So, Python developers are very high in number. Moreover, the users of python are increasing day by day. Portable an extensible: Python course are portable and extensible as a code for Windows even run at Mac, Unix or Linux. Even the codes can be compiled in different languages like C++ or C. Graphical: The Python Computer G...