There are four questions in this assignment. Answer all the questions. You may use illustrations and diagrams to enhance explanations.
Question 1: (a) What is a worksheet? How to create and format controls on worksheet. (4 Marks)
A worksheet is a sheet of paper, or on a computer, on which problems are worked out or solved and answers recorded.
A worksheet is an object in a spreadsheet program that consists primarily of a grid of cells, organized in rows and column, in which spreadsheet calculations and information are held. A file saved by a spreadsheet program may consist of many worksheets.
Some spreadsheet application
Microsoft Excel
Microsoft Excel is a commercial spreadsheet application written and distributed byMicrosoft for Microsoft Windows and Mac OS X. 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. Excel forms part of Microsoft Office. The current versions are 2010 for Windows and 2011 forMac.
Lotus 123
Lotus 1-2-3 is a spreadsheet program from Lotus Software (now part of IBM). It was the IBM PC's first "killer application"; its huge popularity in the mid-1980s contributed significantly to the success of the IBM PC in the corporate environment.
Open Office Calc
A spreadsheet similar to Microsoft Excel and Lotus 1-2-3. Calc can export spreadsheets to the PDF format. (See ooWriter entry, above, for details of PDF). Calc provides a number of features not present in Excel, including a system which automatically defines series for graphing, based on the layout of the user’s data.
(b) What is need of a web browser? List the advantages and disadvantages of different browsers. (3 Marks)
A web browser or Internet browser is a software application for retrieving, presenting, and traversing information resources on the World Wide Web. An information resource is identified by aUniform Resource Identifier (URI) and may be a web page, image, video, or other piece of content. Hyperlinks present in resources enable users to easily navigate their browsers to related resources.
Although browsers are primarily intended to access the World Wide Web, they can also be used to access information provided by Web servers in private networks or files in file systems. Some browsers can also be used to save information resources to file systems.
Mozilla released Firefox 3.0 on 17 June 2008, with performance improvements, and other new features. Firefox 3.5 followed on 30 June 2009 with further performance improvements, native integration of audio and video, and more privacy features.
Google released the Chrome browser for Microsoft Windows on December 11, 2008, using the same WebKit rendering engine as Safari and a faster JavaScript engine called V8. An open sourced version for the Windows, Mac OS X and Linux platforms was released under the name Chromium. According to Net Applications, Chrome had gained a 3.6% usage share by October 2009. After the release of the beta for Mac OS X and Linux, the market share had increased rapidly.
On March 19, 2009, Microsoft released Internet Explorer 8, which added accelerators, improved privacy protection, a compatibility mode for pages designed for Internet Explorer 7 and improved support for various web standards.
During December 2009 and January 2010, StatCounter reported that its statistics indicated that Firefox 3.5 was the most popular browser, when counting individual browser versions, passing Internet Explorer 7 and 8 by a small margin. This is the first time a global statistic has reported that a non-Internet Explorer browser version has exceeded the top Internet Explorer version in usage share since the fall of Netscape Navigator. This feat, which GeekSmack called the "dethron[ing of] Microsoft and its Internet Explorer 7 browser," can largely be attributed to the fact that it came at a time when IE 8 was replacing IE 7 as the dominant Internet Explorer version. No more than two months later IE 8 had established itself as the most popular browser version, a position which it still holds as of March 2011. It should also be noted that other major statistics, such as Net Applications, never report any non-IE browser version as having a higher usage share than the most popular Internet Explorer version, although Firefox 3.5 was reported as the third most popular browser version between December 2009 and February 2010, to be replaced by Firefox 3.6 since April 2010, each ahead of IE7 and behind IE6 and IE8.
On January 21, 2010, Mozilla released Mozilla Firefox 3.6, which allows support for a new type of theme display, 'Personas', which allows users to change Firefox's appearance with a single click. Version 3.6 also improves JavaScript performance, overall browser responsiveness and startup times.
In October 2010, StatCounter reported that Internet Explorer had for the first time dropped below 50% market share to 49.87% in their figures. Also, StatCounter reported Internet Explorer 8's first drop in usage share in the same month.
On February 3, 2011, Google released Chrome 9. New features introduced include: support for WebGL, Chrome Instant, and the Chrome Web Store.
StatCounter global market share figures were as follows for February 2011. Internet Explorer 45%, Firefox 30%, Chrome 17%, Safari 5% and Opera 2%, leaving all the others sharing the remaining 1%.
HLOOKUP()
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
SYNTAX
HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
Where
Lookup_value :- The value to search in the first column of the table array.
Table_Array :- Two or more columns of data.
row_index :- The row number in table_array from which the matching value must be returned.
Range_lookup :- A logical value that specifies whether you want VLOOKUP to find an exact
match or an approximate match:
If TRUE or omitted, an exact or approximate match is returned. If an exact match is not found, the next largest value that is less than lookup_value is returned.
(b) What is FTP? Explain how it is different from telnet. (3 Marks)
File Transfer Protocol (FTP) is a standard network protocol used to copy a file from one host to another over a TCP-based network, such as the Internet. FTP is built on a client-server architecture and utilizes separate control and data connections between the client and server. FTP users may authenticate themselves using a clear-text sign-in protocol but can connect anonymously if the server is configured to allow it.
The first FTP client applications were interactive command-line tools, implementing standard commands and syntax. Graphical user interface clients have since been developed for many of the popular desktop operating systems in use today.
Both of these applications allow two different computers to communicate with each other. Telnet allows the user to log on to an account on a remote computer and work as if you were there. This is useful if you are traveling or are going to be away from your own computer and your local account but need to have access to the latter. You might be at a conference in another state and suddenly remember that you need some information that is stored on a file in your account back at your home institution. You can log on remotely, telnet to your account, get into your files that are on that server, and retrieve the information. For example, let's say you are at ACTFL and you are supposed to meet some people but you forgot the time and the place. They sent you this information in an e-mail message, and you have that message in your account on the server at your institution. If you can use a computer with Internet access where you are, you can telnet to your account, call up the message, and read the information off the screen. Voilá--you won't miss your dinner date.
Questioon 3: (a) Whhat is Koniggsberg Bridgge problem?? Explain wiith a suitablle diagram. (3 Marks)
0 comments:
Post a Comment