Microsoft Excel

1. There is a tool in Excel that allows you to quickly fill up a column or a row with a series of numbers or alphabets, once you key in the first few.

-> Fill Handle

2. If you have a sheet showing sales of each month in a column, and each product in a row, and you want to see this information in the opposite way (products in the column and months in the rows) how can you easily accomplish this?

-> Data--Pivot Table

3. If you have first names in one column and last name in another column, what funstion can you use to easily put both together as the full name in a third column?

->CONCATENATE()

4. Is there any way you can ensure that the date entered into a column follows certain rules that you can set?

-> Yes, you can use the Validate option under the Data menu.

5. When you type in a formula in Excel and copy this formula across the entire column or row, the formula automatically changes to refer to the next column or row. What is this called?

-> Relative Referencing

6. If you don't want Excel to change cell references automatically, but keep the cell fixed in a formula, what do you do?

-> Add $ before the cell

7. If you have a repetitive set of tasks that you perform on an Excel worksheet, what is the fastest way to get it done?

-> Use Macros

8. When you write a formula in Excel, the references in the formula are limited to that worksheet only.

-> False

9. We've all done copying and pasting text. What if you copy and paste a cell format? What is the name of the tool provided to this?

-> Format Painter

10. If you want to insert the current date and time into a cell, the function to do this is ___

-> NOW()





source:
www.braingle.com

Ab$olute Reference$

An absolute cell reference is used when you want a cell reference to stay fixed on a specific cell.
This means that as a formula or function is copied and pasted to other cells, the cell references in the formula or function do not change.

That is what we used in our activity.

To have only one formula for many cells and gets the correct or the answer that you want, we use the dollar sign ($) to express the absolute reference.

Example is B$6 which means that only the column of the formula can change following the pattern.

We're Back!

After the Christmas/New Year vacation, we are now back to regular classes.
Almost all of us forgot our lessons.
But nicely, all of us done what we must do, like projects, home works and others, even if they were too busy during the vacation because of the reunions and etc.

Subtraction (-)

1. Click on the cell where you want the difference to be shown with the mouse pointer to make it an active cell.

2. Type the equal sign ( = ) in the cell to begin the formula
    * Formulas in Excel always begin with the equal sign.

3. Click on the cell of the minuend with the mouse pointer to add that cell reference to the formula or just type the name of the cell after the equal sign.

4. Type a minus sign ( - ) in the cell after the cell reference.

5. Click the cell of he subtrahend with the mouse pointer to add that cell reference to the formula or just type the name of the cell after the minus sign.

6. Press the ENTER key on the keyboard to show the answer.




source:
spreadsheets.about.com