Hopes

I am hoping that my grade in Kumsay will retain or will go higher. Well, I hope so. 

/KeepingMyHopesUp

What I've Learned

I have learned so many things this 3rd quarter regarding Excel. In the third quarter I learned new formulas and functions and I also learned how to use it. I learned how to make a multiplication table by just using one formula. I already know how to make a Macro and how to convert data into charts.

I learned so many things this quarter and I am looking forward to our next quarter and which is also the LAST.

/LookingForward

New Experience

Sir Tom went to the Sapphire Room.

The story behind is that. The power in Pisay went down. Yeah, there's a generator but it is not enough to power the whole ComLab, I think.

But  it's very odd and new to the eyes to see Sir Tom standing in front of our class but in a different room. So yeah, I can't get over. XD 

/CantGetOver

Errors

If you're a beginner in using the Excel maybe these symbols are pretty familiar with you:

•  ####
• #DIV/0!
• #N/A – missing data/found no match
• #NAME? - undefined range or cell name
• #NULL! - two ranges that don’t actually intersect
• #NUM! - pass an invalid argument to a function
• #REF! - invalid cell reference
• #VALUE! - argument for a function is of an incorrect data type

You wanna avoid having these symbols in your spreadsheet? Then just practice and practice until you get the hang of it.:)

Fuctions

FUNCTION
         – A predefined formula
         – May require arguments as inputs
         – Returns a value
         – May be used together with other functions and other operations

Example
         =PRODUCT(150,8)
         =SUM(A1,A30)
         =AVERAGE(B1:B5)
         =COUNTA(A1:A101)
         =NOW()
         =MAX(Z2:Z7)
         =MIN(Z4:Z12)

(c) Sir Tom

FORMULA

Okay. I have already discussed to you the basics in using Excel. Let's now go to Formula.

FORMULA / FORMULAE
        – an expression used to perform calculations
        – begin with an equal ( = ) sign
        – Composed of operands and operators
        – May contain constants, cell references, ranges, and grouping symbols

Example of Formulas
        =96*69
        =R7+P7
        =Boys–Girls
        =A8=C2
        =B1/B7-A4+E3*3

Operators Precedence In Formulas

Mixed Operation

=15>10

=5=2

=0<>0

=8+7-3*8>5+1

=15/3-1<>(4+2)*2

(c) Sir Tom

Cell Reference

Cell and Range

• A7 – single cell
• A7,A14 – cell A7 and cell A14
• A7:A14 – range from A7 to A14 (same col)
• A7:Z7 – range from A7 to Z7 (same row)
• A7:Z17 – range from columns A to Z and rows 10 through 17

Reference Types

• Relative - automatically changes when the formula is copied down a column or across a row
• Absolute - cell reference is fixed, doesn't change when copied to other cells.
  *Uses $ sign like: $A$1
• Mixed - has either an absolute column and a relative row, or an absolute row and a relative column
  *Like A$1 or $A1 

Referencing from other the sheet

• Same file
  – Manual selection
  – Use a formula
  Ex: Sheet2!A1
• Different file
  – Manual selection
  – Use a formula
  Ex: [File2.xlsx]Sheet1!$A$1
         Absolute by default 

(c) Sir Tom

Data Types

DATA TYPES 

1. standardized representation for a particular kind of data.
2. indicates the potential range of values we can store and the operations we could perform with them.

Kinds of Data Types:

• CURRENCY : -922,337,203,685,477.5808 to 922,337,203,685,477.5807 with four decimal digits of fixed precision.
• DATETIME: Valid dates are all dates after January 1, 1900. 
• LOGICAL/Boolean – true or false
• NUMBER
  – Whole Number from (-2^63) to (2^63-1)
  – Decimal Number -1.79E +308 through -2.23E - 308, 0, 2.23E -308 through 1.79E + 308
• TEXT: 268,435,456 Unicode characters

(c) Sir Tom's Presentation. :))

More About..

Of course if you want to know how to you Excel, you have to first know the different/basic parts of it for easier use.

Basic parts of Excel and their usage:

An Excel File is called a WORKBOOK.

WORKSHEET is the page you work on which is made up of grid cells.

Cell/Selected Cell is where you type data into. Cells are arranged in numbered rows and lettered columns. You have to select a cell to add data to it data/formulae can also be typed into the formula bar.

Column/Row Heading use the column/row headings to identify a cells position on the worksheet, example A7, B17. Click heading buttons to select a whole column/row of cells.

Name Box holds a cell’s selected reference number – it’s position on the worksheet.

Well, there you have it, the different parts of  Excel. 

Microsoft Excel

Our third quarter topics revolves around Microsoft Office Excel and how to use it. 

First off, what is MS Excel?

Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

(c) Wikipedia

Before, I thought that MS Excel is only used for computing grade or make a class roster because I only my mom using it for that purpose only. But I was wrong, as we tackled more about Excel, the more I learn about it. 

Excel is not only used for computing games and other teaching related stuff but it is also used for many more things.

3rd Quarter. Yeah.

Waaaah. T.T After this quarter, we're down to the last. Oh. No. T.T 

It means harder topics especially in Kumsay, Math, and Soc Sci. Nooooo!! That can't be. Please bring me back to the first quarter. Puhlease? *puppy eyes*

But on the second thought, if we're near the last quarter, it means also that we're near VACATION! Woot! Woot!