An overview of application packages – Questions and Answers

Subject Title: ICT Revision Kit
TOPIC: An overview of application packages

QUESTION 1
April 2022 Question One A
Explain five factors to consider when selecting a spreadsheet software. (5 marks)

QUESTION 2
April 2022 Question Three D
State two challenges of using computerised accounting software in an organisation.
(2 marks)

QUESTION 3
December 2021 Question four E
(e) (i) Define “cell referencing” in the context of spreadsheet applications. (2 marks)
(ii) Using an example, explain one type of cell referencing. (2 marks)

QUESTION 4
December 2021 Question Five D and E
(d) Study the worksheet given below and answer the questions that follow:

Interpret the function displayed in cell G1.                                                     (2 marks)
(ii) State the value to be displayed in cell G1 on execution of the function
Required:
(i) Interpret the function displayed in cell G1. (2 marks)
(ii) State the value to be displayed in cell G1 on execution of the function. (2 marks)

(e) Veronica would like to display the progress of her project to a panel of examiners using a presentation application.
Outline two ways in which she could display her presentation in slide show mode.
(2 marks)

QUESTION 5
December 2021 Question Six C
Using an example, demonstrate how you would use a formula to link data between two worksheets. (4 marks)

QUESTION 6
December 2021 Question Seven D
Outline two features of a word processing program. (2 marks)

QUESTION 7
November 2019 Question Four C
Describe the following word processing features:
i. Print preview.
ii. Watermark.
iii. Indent.

QUESTION 8
November 2018 Question Four C
Describe three documents created during mail merging in word processing

QUESTION 9
November 2018 Question Five C
Suggest four business processes that could be supported by spreadsheet software.

QUESTION 10
November 2018 Question Seven A and B
State six basic types of desktop applications.
With the aid of diagrams, illustrate three types of charts that might be used to analyse business trends in spreadsheets

QUESTION 11
May 2018 Question Three A
Explain the term “conditional formatting” as used in spreadsheets.
Highlight two benefits of electronic spreadsheets over manual worksheets.

QUESTION 12
November 2017 Question Five B
Outline five main features of a spreadsheet program.

QUESTION 13
November 2016 Question Two A
Explain the meaning of the following terms as used in word processing software:
i. Mail merge.
ii. Thesaurus.
iii. Spell checker.
iv. Zoom

QUESTION 14
May 2016 Question Six B
i. List four types of paragraph alignment used in a presentation program.
ii. State three ways of fitting overflowing word processing content on a single page.
iii. Highlight five advantages of using word processor.

QUESTION 15
May 2016 Question Five C, D and E
a) Highlight four benefits of using social networking sites as a means of communication.
b) Describe the three buses in a computer system unit.
c) List four advantages of a presentation software.

QUESTION 16
November 2015 Question Six D and E
Describe three advantages of computerised accounting software.
Differentiate between “absolute referencing” and “relative referencing” as used in a spreadsheet.

QUESTION 17
Pilot paper Question Four B
Outline five features of an accounting software.

QUESTION 18
Pilot paper 2015 Question Five A
Describe two features of each of the following application softwares:
i. Word processing.
ii. Spreedsheets.
iii. Database package.

(Visited 10 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *