Excel

Hi-hi!! Today I’ll post something about my ICT material, Microsoft Excel. So, Excel is a software that is made by Microsoft and spreadsheet program allows presenting information in a clear and concise manner, and can be used to perform mathematical calculations. Excel allows you to convert the spreadsheet data into various charts, such as Bar, Pie, 2D, and 3D. Excel documents consist of columns  and rows of data, made up of individual cells. Below are the important sections that are marked

for-blog


Basic Formulae

Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (), an asterisk for multiplication (*), a forward slash for division (/), a caret (^) for exponents, a semicolon (;) or a coma (,) for Reference operator, a parentheses [ ( and ) ] for opening and closing the group of formula or to
change the order of evaluation and <, >, <=, >=, <> is used for comparison: less than, greater than, greater than or equal to, less than or equal to, not equal to. All formulas in excel have to be started with equal sign  (=). 

Understanding cell references

mehisperf

While you can create simple formulas in Excel manually (for example, =2+2 or =5*5), most of the time you will use cell addresses to create a formula. This is known as making a cell reference.

Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.

2

3


Functions

A Functions is a pre-defined formula for performing a particular task.

  • SUM          →         =SUM(starting cell:ending cell)

To add all numbers in a range of cells

  • MAX          →         =MAX(starting cell:ending cell)

Finding the largest number from series of cells

  • MIN           →         =MIN(starting cell:ending cell)

Finding the smallest number from series of cells

  • AVERAGE →        =AVERAGE(starting cell:ending cell)

Finding the mean/average of series cells

  • COUNT     →         =COUNT(starting cell:ending cell)

Finding the total amount of the selected cells

  • SUMIF      →         =SUMIF(range, criteria, [sum_range])

Finding the sum the values in a range that meet criteria that you specify.

  • ROUND    →         = ROUND(number, num_digits)

Round a number to the decimal places you want

  • IF               →         = IF(logical test;”value if true”;”value if false”)

To decide a condition is true and another value if it’s false

Ok that’s here for today. I’m really tired right now and I wanna watch some korean drama and anime😊😊 See you next time~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s