COMPUTER STUDIES QUESTIONS WITH ANSWERS
Explain the following internet related terms (4 marks)
0 Comments
Difference between 'count' and 'count if functions as used in spreadsheets
Difference between a primary key and a a foreign key while designing a database
Name three facilities that are needed to connect to the Internet.
What is a Website?
Explain the meaning of each of the following with reference to computer crime:
A worksheet contains the data as shown below.
The table below shows how a kiosk owner uses a spread sheet to keep records in a shop. Write a function to calculate the total buying price. =product(B2:C2) or =product(B2,C2) Write a formula to calculate the Profit. =E2-D2 The total buying prices of all items was increased by 12% and the value 12% is placed in cell B6. Using cell addresses with absolute referencing, write a formula to calculate the Total Selling Price in cell E2. =($B$6/100)*D2 State the output of the expression =SUMIF(F2:F5,"<1 500")would return.
2530 Define the following terms as used in charts. Legend
Data range
Change case is where a user applies so that the text can have some contrast in size. Write the word 'Digital SIGNAL' in:
Title case Digital Signal Toggle case dIGITAL signal State the importance of Column breaks as used in word processor.
The figure below shows a picture tool bar Name and state the functions of the features marked A, B and C: A Name: Cropping tool Function: Used to trim the unwanted parts of graphics B Name: Rotate left 900 Function: Used to rotate objects through an angle of 900 to the left C
Name: Text wrap tool Function: Used to place text arround graphics State three responsibility of a Database administrator in an organization.
State two ways in which users in an organization can be a security threat to data in an information system.
The figure below shows an extract of an e-mail application What is meant by each of the following terms: Trash Acts as a dust bin for your e-mail account where all deleted mails are stored before being permanently removed from the account Spam This is a folder in your account where all junk and suspicious mails received are stored Inbox
This is a folder in your account where all genuine mails received are stored With an aid of a diagram, explain one-to-one database relationship. A one-to-one relationship is created if and only if the relating field in both tables are primary keys
Meaning of “what if analysis”
Distinguish between workbook and a worksheet
Reasons why DTP is preferred over word processors
Definition of: Internet
Piconet
What is thesaurus?
Distinguish between autocomplete and the autocorrect feature
|
Categories
All
Archives
December 2024
|
We Would Love to Have You Visit Soon! |
Hours24 HR Service
|
Telephone0728 450425
|
|
8-4-4 materialsLevels
Subjects
|
cbc materialsE.C.D.E
Lower Primary
Upper Primary
Lower Secondary
Upper Secondary
|
teacher support
Other Blogs
|