Excel : March 2014

Saturday, 8 March 2014

10 ICDL QUESTIONS"

Q1•Modify the heading meaterials into change item.

•Change ; earise and change text

Q2•Sort in the content of coloum F to acending order

•Home tab> sort> sort (a-z)

Q3•Adjust the size of the table

•Change the size

Q4.when it say CLOSE the file
the x in excel not the one of ICDL

Q5. What does adjust mean ?
it means to change the size

Q6. what does( : )mean?
from a number to the other

Q7.what does every formula starts with ?
=IF(--)

Q8. how to freeze a cell ?
Open excel > go to view tab > in window group >click on freeze

Q9.how to calculate the total cost?
=SUM(---)

Q10.how to count the number of the cell?.
use coulum function in the cell

Monday, 3 March 2014

What is ICDL Exam?

•International Computer Driving Licence (ICDL)The ICDL is recognised as an international standard for end-user computing skills and is endorsed by a number of universities, colleges and schools in S A. To obtain the ICDL, a student must pass seven modules. It certifies that the holder has the knowledge and skill needed to use the most common applications practically and productively.

•CECS is registered with the ICDL Foundation (registration number 60703) since 2004.

The difference between Microsoft Excel and Libre Office Calc

The difference :-

•LibreOffice is an open source office suite originated from Open Office. Oracle’s purchase of Sun Microsystem caused quite it a bit of tension within the developers. A group later formed the Document Foundation. This group eventually broke away and created LibreOffice. It provides similar features to those of other office suites such as Microsoft Office, Google Docs.

•Like its name implies, “Libre” Office is a free office suite software. Microsoft Office is one of the most prevalent office productivity suites available. However, its high prices may shy away those who are on a tight budget. As a result, LibreOffice is your free alternative to premium office suite like Microsoft Office.

4 Reasons Why You Should Use LibreOffice

•It is free. You don’t have to pay a dime to use this excellent Office Suite. LibreOffice offers many features that are only available on premium office suites.

•It has a portable version. You can edit your documents anywhere you go and run it via a Flash Drive.

•It is able to export files to PDF. This is essential because the PDF file is one of the most universally accepted document formats.

•It is fast, light, and stable. It runs smoothly and doesn’t use too much memory.

•How Does LibreOffice Compare to Microsoft Office?

•LibreOffice performs remarkably well. The key differences between Microsoft Office and LibreOffice are the user interface and quality of the services

One Video tutorial about installing Libre Office Calc

Youtube video hyperlink : http://www.youtube.com/watch?v=HdOLxR_NlrQ

Top 10 spreadsheets applications

1.BadBlue.com2.Blist.com3.EditGrid.com4.eXxprssoCorp.com5.Google Docs6.InputWebWizard.com7.JotSpot 8.Numbler.com9.NumSum.com10.Peepel.com

What is a spreadsheet?

A spreadsheet is a grid that organises data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with the data. For example, there is a particular icon that has a formula to sum up numbers that are given. This icon is called auto sum. Information can also be sorted and filtered.
People use spreadsheet programs to learn about different kinds of things, and to make decisions. Spreadsheets are based on different varieties of subjects. This site will highlight the use of spreadsheets in the classroom. You will find ideas for every subject. On this website, we will be using Microsoft Excel.

Excel