References Page:

-Wikipedia.com

-Youtube.com

-Google.com

10 ICDL Exam Questions & Answers:


Q1.Open the samples.xls workbook that is in the My Documents folder.

A. File -> open ->select the samples.xls -> open


Q2. Create a new, blank workbook

A. click new tool from the standard tool bar > Workbook


Q3. Save this workbook (which is currently a Microsoft Excel 2000 file) in a format suitable for users with a previous version of Excel.

A. File -> save as -> select from save as type (Microsoft excel 5./95 work book-> click save

Q4. Use Microsoft Excel Help to access information on advanced filter

A. Help -> Microsoft excel help -> type advanced filters -> click search

Q5.Change the user name for this application to Carla Banks

A. Tool > Options >  select General tab > in user name type Carla Banks

Q6. Enter the value 521 in cell B5
Click any other cell when you have finished

A. Select B5 cell > type 521 > click any other cell

Q7.Click on the location that selects all of the cells in row 4.

A. Click on the gray area of the row 4

Q8.Automatically adjust the height of Row 2 to fit its tallest contents.

A. Format > Row > auto fit or Double click on the gray area between Row 2 and Row 3

Q9.You wish to reverse the last change you have made to this worksheet.

A . Click on the undo tool from the standard tool bar Or from menu bar select edit > undo.

Q10. Change the contents of cell B2 to the word Cost. Press enter when you have finished.

A . Select cell b > type Cost > press enter

What Is ICDL Exam?

The ICDL is recognized 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.

 

 

 

 

General office suite: LibreOffice vs. Microsoft Office

Major Feature Differences	LibreOffice 4.2	MS Office 2013
Cross-platform availability	Windows, Mac OS X, Linux and FreeBSD (based on the same code base).	Windows and Mac OS X (based on different code bases resulting in some format compatibility problems and differences in the user interface. Mac OS X Version is old version "Office 2011" and no MS Access.)
Supported versions of MS Windows	Windows XP, Vista, 7, 8 (8.1, Server 2008 R2, Server 2012 also reported to work (fdo#71690))	Windows 7, 8, 8.1, Server 2008 R2, Server 2012, Windows RT (few features missing, no MS Access and not Metro-compliant)
Portable version that runs on USB flash disks (without installation)	yes	no (discontinued MS Office Starter 2010 edition runs on USB flash disks)
Open Source	yes, licensed under GNU LGPL Version 3	no, proprietary and closed-source
Full integration of all office components	supported, StartCenter with recently used files. Creation and opening of files of other office components.	not supported
Availability free of charge	yes	no, proprietary software plus additional charges for language packs. 30-day trial version available.
Eco-system of extensions	complex ecosystem of valuable extensions (over 190 on extensions.libreoffice.org and over 750 on extensions.services.openoffice.org) for LibreOffice (including automatic updates).	partly, no centralized extension system for add-ins and macros. Office Apps store for Office 2013.
Localization	111 languages (detailed list)	96 languages (52 main languages for purchase, 44 more languages (in total 60) from Language Interface Packs (LIPs) for free download)
Changing language of the user interface on the fly	supported	supported, but requires additional purchase of language packs / download of local LIPs
Additional writing aids	extended support (spell-check dictionaries, hyphenation patterns, thesaurus and grammar check, specialized dictionaries as extensions (1. 2, 3, 4, 5, 6, 7)). Overview list.	limited, requires additional purchase of language packs
Support of complex languages and special font features (ligatures, true small caps, old style numbers, proportional or mono-spaced numbers, capital spacing, true superscript/subscript)	comprehensive support of SIL Graphite font technology (not available of Mac OS X). Support of OpenType optional features limited to localized forms (locl) (fdo#58941).	limited via OpenType supporting ligatures, stylistic sets, number spacing options, number forms, contextual alternates.
Easy access to vector clip art	yes via LO Gallery (clipart extensions (1 or 2))	selection more limited
Macro scripting languages	multiple languages, support for wide variety of languages (LibreOffice Basic, JavaScript, BeanShell and Python).	single language, support for Visual Basic for Applications (VBA). Indirectly also Visual Basic or Visual C# by using automation.
CMIS protocol support to access Document Management Systems	support for Alfresco, GDrive, Nuxeo, SharePoint, IBM FileNet Lotus Live Files, Lotus Quickr Domino, OpenDataSpace and OpenText ELS.	inbuilt support only for SharePoint and Skydrive
Support of ISO standardized OpenDocument (ODF) format	advanced support, v. 1.2 extended	limited (Windows), v. 1.2, no ODF support on MacOS X
PDF export extended options	multiple options (Additional options: detailed image settings, watermarks, HybridPDF, transition effects, tagged pdf, extended security and permission options, PDF forms, initial view settings, extended handling of URLs, digital signatures)	High or low quality PDF, page and markup to print in Access, Word, Excel and PowerPoint 1; pictures resolution and non-printing informations in Publisher.
Creation of HybridPDFs (ODF file embedded in PDF for full editing)	supported	not supported
Import of graphics formats: SVG vector graphics, Adobe Photoshop (.psd)	supported	not supported
Import from vector graphics software: CorelDraw, Corel Presentation Exchange, Adobe/Macromedia Freehand	supported	not supported
Import of MS Visio files	supported (Visio 2000-2013)	not supported (only via MS Visio which is not part of MS Office)
Import of video and audio formats FLAC Audio flac, Flash Video (flv), Matroska Media, OGG Audio, Ogg Video, Quicktime Video and WebM Video	supported	not supported
Drawing program	LibreOffice Draw	no
PIM and email program	not part of office suite, referring to Mozilla Thunderbird with Mozilla Lightning.	MS Outlook
Import & Export of Microsoft OOXML files	Good support of real life OOXML files (e.g. .xlsx, .docx, .pptx) as well as standardized OOXML files	Advanced support of transitional (default) and strict OOXML files.
PDF Import	partial, into Draw with the limitation that text is imported line-based (fdo#32249).	supported, into MS Word
User Interface approach	Classic UI; New Sidebar (default in Impress, in Writer and Calc not enabled by default). Customization possible: several icon sets, Firefox themes, customization of toolbars.	Ribbon UI; Classic UI available as third-party paid extension
Available as native 64-bit application on OS	Linux, MacOS X	Windows
User interface improved to enable use on touch screen devices on desktop operating systems	no	Slightly adjusted user interface for touch screen devices, but no redesign
Versions of office suite for mobile operating systems	no, ports for Android and iOS in development (1,2,3, 4)	Versions for iOS, Android and Windows Phone 8 with heavily restricted feature set, good viewing capabilities but very limited editing abilities. Mobile versions are restricted to smartphones (not on tablets). Android and iOS versions only available if subscribed to Microsoft 365 Cloud services at a monthly fee.
Online/cloud version of office suite	no, in development: experimental version.	Office web apps, with reduced functionality. (1)
Synchronous collaborative editing	no, in development: experimental version, presentation (PDF)	supported
Minor Feature Differences	LibreOffice 4.2	MS Office 2013
Import of graphics formats DXF, MET, PBM, PCD, PCX, PGM, PPM, PPM, RAS, SGF, SVM, TGA, XBM, XPM	supported	not supported
Import of additional video and audio formats: CD Audio, Vivo Video.	supported	not supported
Document converter wizard	supported	not supported
Euro currency converter wizard	supported	not supported
Expert config to access a multitude of settings from UI	supported	not supported
Enhanced list of recent files and folders	partial (fdo#61174, fdo#60743). Option to clear list of recent documents.	supported (option to set recent files as permanent)
Digital signatures / Signature Line	single signature without visual features (fdo#63001)	supported
Custom colours in formula editor	Set of 8 colours (fdo#40436)	supported
Ink annotations (e.g. on a windows tablet computer)	not supported, (only support for import of existing ink annotations from MS Word file format)	supported
Live preview while formatting	not supported (fdo#37048)	supported
Import of graphics formats: MEZ, WMZ, PCZ, CGM	not supported	supported
Export to XPS format	not supported	supported

Click on the link to watch the Video :D

http://www.youtube.com/watch?feature=player_detailpage&v=0-TJtYoVnak

1. Excel Office

Microsoft Excel is one of our top contenders for the best spreadsheet software..Naturally, you’ll find that Excel is compatible with itself; therefore if you want to forego the issues of compatibility, go with Microsoft and you’ll know that what you produce will be consumable by any user accessing your work.

2. Lotus 1-2-3

Lotus 1-2-3 is an exciting product and is very different than its competitors, but definitely one of the best spreadsheet software programs out there. Lotus 1-2-3 is definitely compatible with Excel products since we had no problems saving spreadsheets in Excel formats nor did we have trouble opening Excel spreadsheets with Lotus 1-2-3.The Lotus 1-2-3 interface is refreshing since it’s different than all of the other interfaces.

3. Ability Office

Ability Spreadsheet is compatible with both the 2003 and 2007 versions of Excel, however you do have to download a plug-in .It’s compatible with Excel and it offers a nice interface and a responsiveness to customers that lets us know this company is one to watch. These are only a few of the reasons we have chosen Ability Spreadsheet as one of the best spreadsheet software.

4. PlanMaker Office

We’re pleased to report that PlanMaker, a relatively unheard of brand turned out to be a nice spreadsheet product. PlanMaker is part of SoftMaker, which is a suite of office products that also contains TextMaker, SoftMaker Presentations, and BasicMaker .PlanMaker may not be the very best, but it has some very unique features, including the ability to build forms with checkboxes and radio buttons.

5. StarOffice Calc

StarOffice 9 Calc is available in lots of languages – more languages than any of the other spreadsheet competitors. In addition, StarOffice 9 Calc is compatible with not only Windows operating systems, but Solaris, Mac and Linux as well. The Sun website stated that StarOffice 9 Calc has the ability to add programming, but we never could find evidence of this capability.

6. Resolver One

Users who need to share files with others may be very interested in a cut-down version of Resolver One called Resolver One Player, that lets others view the spreadsheets in the Resolver One format Resolver One is a standalone product that is designed for power users who want to use the Python scripting language for analyzing data. You can also use Ironclad and you can use NumPy, CPython, and C libraries.

7 Calculate Home Office

Corel makes it very easy to find the format you want to save in since they are all specified on the right side of the interface. The formula section of Calculate is easy to work with, but it did not shine like some of the rest of the programs. For example, they do not have the option to use programming Corel excels in their ability to make presentation-ready documents, complete with background colors, images and nice layouts.

8. GoBe Productive

GoBe Productive, like many of the products, relies on drop-down menus to find all of the controls, but it does have many icons immediately visible GoBe Productive Spreadsheet is a nice product with some surprising little features you may want. It doesn’t have all the bells and whistles, but it does have some qualities the other products don’t have.

9. GS-Calc

GS-Calc relies on drop-downs rather than icons, but offered a really handy left navigation area right in the interface. This lets you know hierarchically exactly which files you’re working with.
GS-Calc is a stand-alone spreadsheet program that has some very interesting features. You just might find out it’s exactly what you’re looking for in a spreadsheet program.

Top 10 Spreadsheet applications:

10. Easy Spreadsheet EasyOffice Premium

EasySpreadSheet has a feature that is called Ancestors which is an automatic backup and archival system built into the program.EasySpreadSheet is just one of the products that comes in EasyOffice Premium. You can listen to the entries being read to you or you can read them off the screen. This product specializes in taxes, prices, and profit margin calculations. Loan and investment calculations are automatically displayed in a spreadsheet-like format.

What is a Spreadsheet?

-A computer program in which figures arranged in the rows and columns of a grid can be manipulated and used in calculations.