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