Saturday, March 8, 2014

10 ICDL questions & answers.

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
Posted by at No comments:

Tuesday, March 4, 2014

Microsoft Excel Tutorial - Making a Basic Spreadsheet in Excel


video: http://www.youtube.com/watch?feature=player_embedded&v=qeMSV9T1PoI

A spreadsheet is a great tool for adding the total of a series of items. This article explains how to make a basic spreadsheet in Microsoft Excel, using a simple expense report as an example.

Step 1: Open Excel.
Make a Spreadsheet in Excel Step 2 Version 2.jpg


  2. Notice there are rows and columns.
    • Each column has a capital letter on the top to show what column it is.
      Make a Spreadsheet in Excel Step 2Bullet1 Version 2.jpg
    • Each row has a number to the immediate left of the first column, to show what row it is. For example, the address of the cell in the first column, first row is A1. The address of the cell in the second column, third row is B3.
      Make a Spreadsheet in Excel Step 2Bullet2 Version 2.jpg
    • Each cell is identified by a unique address consisting of the column letter followed by the row number. For example, the address of the cell in the first column, first row is A1. The address of the cell in the second column, third row is B3.
      Make a Spreadsheet in Excel Step 2Bullet3 Version 2.jpg
    • If you click a cell, the cell address appears just above column A.
      Make a Spreadsheet in Excel Step 2Bullet4 Version 2.jpg
  3. Make a Spreadsheet in Excel Step 3 Version 2.jpg
    3
    Click cell A1 and type: Item.
  4. Make a Spreadsheet in Excel Step 4 Version 2.jpg
    4
    Click cell B1 and type: Cost.
  5. Make a Spreadsheet in Excel Step 5 Version 2.jpg
    5
    Click cell A2 and type: Printing.
  6. Make a Spreadsheet in Excel Step 6 Version 2.jpg
    6
    Click in cell B2 and type 80.00.
    • After you click outside of cell B2, 80 will show in cell B2.
      Make a Spreadsheet in Excel Step 6Bullet1 Version 2.jpg
  7. Make a Spreadsheet in Excel Step 7 Version 2.jpg
    7
    Click cell A3 and type: Postage.
  8. Make a Spreadsheet in Excel Step 8 Version 2.jpg
    8
    Click cell B3 and type: 75.55.
    • After you click outside of cell B3, 75.55 will show in cell B3.
      Make a Spreadsheet in Excel Step 8Bullet1 Version 2.jpg
  9. Make a Spreadsheet in Excel Step 9 Version 2.jpg
    9
    Click cell A4 and type: Envelopes.
  10. Make a Spreadsheet in Excel Step 10 Version 2.jpg
    10
    Click cell B4 and type: 6.00.
    • After you click outside of the cell B4, 6 will show in cell B4.
      Make a Spreadsheet in Excel Step 10Bullet1 Version 2.jpg
  11. Make a Spreadsheet in Excel Step 11 Version 2.jpg
    11
    Click cell A5 and type: Total.
  12. Make a Spreadsheet in Excel Step 12 Version 2.jpg
    12
    Click cell B5 and type: =SUM(B2:B4).
  13. Make a Spreadsheet in Excel Step 13 Version 2.jpg
    13
    Click in another cell. A total of 161.55 will show in cell B5.
    • SUM(B2:B4) is a formula. Formulas are used to perform math functions in Excel. It is essential to put equals sign (=) just before a formula, so that Excel knows that it is a formula.
  14. Make a Spreadsheet in Excel Step 14 Version 2.jpg
    14 click save


SOURCE:http://www.wikihow.com/Make-a-Spreadsheet-in-Excel

Posted by at No comments:

Monday, March 3, 2014

Spreadsheet comparison tools

Looking for changes in spreadsheets or checking to see if two copies of a spreadsheet have identical content can be a mind-numbing exercise, especially for the larger and more complex spreadsheets. For Microsoft Excel, at least, the data file is amended each time the file is opened, even if there are no actual changes in the spreadsheet itself. For this reason; using file comparison will always show differences if the two files have different viewing (file opened) histories, even if the contents are identical. The following tools are helpful to find if there are any actual differences between different spreadsheet files.

CreatorDevelopment startedFirst public releaseLatest stable versionCost (USD)License
DiffEngineXDiffEngineX LLC199719972.28 / 2012-09-05$44 to $100 (30-day trial)Proprietary
Spreadsheet Compare2004 ?1.16 / 2010-11-10FreeGPL
Compare Excel filesSpreadsheet Advantage ? ? ? / ?$299 (30-day trial)Proprietary
SynkronizerSynkronizer2000-07 ?9.5 / 2008-02€29 to €149Proprietary
Spreadsheet ProfessionalMiricle Solutions ? ? ? / ? ? (30-day trial)Proprietary
Excel Diff - Excel Compare Tool -SUNTRAP SYSTEMS200520054.2.0 / 2013-04-03$78 to $98 (30-day trial)Proprietary

SOURCE: http://en.wikipedia.org/wiki/Comparison_of_spreadsheet_software
Posted by at No comments:

Desktop spreadsheets

General[edit]

ScreenshotCreatorDevelopment startedFirst public releaseLatest stable versionCost (USD)License
Calligra SheetsCalligra Sheets 2.4 screenshot.pngKOffice KSpread Team2.7.5 (27 October 2013; 4 months ago[1]) [±]FreeLGPL
GnumericGnumericGNOMEcommunity199819981.12.9 (November 2013; 4 months ago[2]) [±]FreeGPL
IBM Lotus SymphonyIBM20081.3 / 2009FreeProprietary
LibreOffice CalcLibreOffice CalcThe Document Foundation20103.3 / 2011-01-254.2.1 (20 February 2014; 10 days ago[3]) [±]
4.1.5 (11 February 2014; 19 days ago[3]) [±]
FreeLGPL
Mariner CalcMariner CalcMariner Software198819895.6.0$49.95Proprietary
MesaP&L Software199019913.1 / 2006-08$34Proprietary
CellProCrystal Office Systems200820081.33FreeProprietary
Microsoft ExcelMicrosoft ExcelMicrosoft1982198515(64-bit) / January 2013$239 (Standalone price; also can be purchased in various Microsoft Office bundles with varying prices)Proprietary
NumbersNumbersApple, Inc.August 7, 20072.1 / July 20, 2011$79 (iWork '09 suite; also includes Pages and Keynote)
$20 on Mac App Store
Proprietary
OpenOffice CalcOpenOffice CalcOracle Corporation2000Build 638c / October 20014.0 (July 23, 2013; 7 months ago) [±]FreeApache Licensev2
PlanMakerSoftMaker Software GmbH1994[4][5]2010Free - SoftMaker Office 2008,
or € 69.95 - SoftMaker Office 2010		Proprietary
PyspreadMartin Manns200820080.2.5 / 2013-09-21FreeGPL
QuantrixQuantrix ?Early 1990s4.0 / 1Q 2011$1,549, or moreProprietary
Quattro ProCorel19881988X6 ?Proprietary
Resolver OneResolver OneResolver Systems20052008-01-161.9 / 2010-06-04Free as part of an open source project or to create open source spreadsheet systems or $99open source / Proprietary
SiagSiag OfficeUlric Eriksson19963.6.1 / 2006FreeGPL
SSuite AccelVan Loo Software200220058.1FreeFreeware
TablesDaniel Schwill2004First Public Beta / 2005-121.5.3 / 2009-05-01$42Proprietary
ScreenshotCreatorDevelopment startedFirst public releaseLatest stable versionCost (USD)License

Operating system support[edit]

The operating systems the software can run on natively (without emulation).
WindowsMac OS XLinuxBSDUnix
GnumericYesYesYesYesYes
IBM Lotus SymphonyYesYesYesNoNo
KSpreadbetabetaYesYesYes
LibreOfficeYesYesYesYesYes
Mariner CalcNoYesNoNoNo
MesaNoYesNoNoNo
CellProYesNoNoNoNo
Microsoft ExcelYesYesNoNoNo
NumbersNoYesNoNoNo
OpenOffice CalcYesYesYesYesYes
PlanMakerYesNoYesNoNo
PyspreadYesNoYesYesYes
SSuite AccelYesNoNoNoNo
Quattro ProYesNoNoNoNo
Resolver OneYesNoNoNoNo
SiagNoYesYesYesYes
TablesNoYesNoNoNo
WindowsMac OS XLinuxBSDUnix

Import/export capabilities[edit]

This table gives a comparison of what file formats each spreadsheet can import and export. "Yes" means can both import and export.
OpenOffice.org XML
(sxc)		CSVExcel
(xls)		HTMLLaTeXODF
(ods)		OOXML
(xlsx)		PDFDIF
GnumericImportYesYesYesExportYesYesExportImport
IBM Lotus SymphonyYesYesYesExportNoYesImportExport
KSpreadYesYesImportExportExportYesNoExport
LibreOffice CalcYesYesYesYesNoYesYesExportYes
Mariner CalcNoYesYesNoNoNoNoExport
MesaNoYesYesNoNoNoNoExport
CellProNoYesYesNoNoNoImportExport
Microsoft ExcelNoYesYesPartialNoYesYesExportImport
NumbersNoYesYesNoNoImportImportExport
OpenOffice CalcYesYesYesYesExport[6]YesYesExportYes
Quattro ProNoYesYesYesNoNoImportExport
PlanMakerNoYesYesExportNoNoImportExport
PyspreadNoYesNoNoNoNoNoNo
Resolver OneNoYesYesNoNoNoNoNo
SiagImport partialYesImport partialYesExportNoNoExport
TablesImport partialYesYesExportExportYesNoExport
OpenOffice.org XMLCSVXLSHTMLLaTeXODF .odsOOXML .xlsxPDFDIF

SOURCE:http://en.wikipedia.org/wiki/Comparison_of_spreadsheet_software
Posted by at No comments:
Subscribe to: Posts (Atom)