Topic Exploration

Computer Application

Master all past questions related to Computer Application.

97 questions across all exams

Filter by exam

Word processing

21 Questions

In word processing, the icon in Fig. 4 is used for

paging

Line spacing

numbering

bulleting

Which of the following items is not located on the MS Word menu bar?

Home

Open

View

Mailings

In Microsoft word, the background of word document is

always the same for the entire document

always white in colour

automatically given any colour

either white or black colour

By default, in Microsoft Word, your document prints in ……... mode.

landscape

page setup

portrait

print view

In Microsoft word, CTRL + ESC ………. the start menu

Closes

Cuts

Opens

Redo

The editing features in Microsoft Word include the following, except

animation

format painter

go to

thesaurus

The keyboard command used to copy text in MS- word document is

Shift+ C

Ctrl + N

Ctrl + C

Ctrl +Alt + C

In order to get to the symbol dialog box in MS- Word, click on the

Home ta

B. Insert tab

Page Layout tab

View tab

In word processing, an efficient way to move the second paragraph and place it after the fourth paragraph is.

copy and paste

copy, cut and paste

cut and paste

cut, copy and paste

In order to locate a particular word in a document, an easy way to do this is to use the

Find command

Go To command

Replace command

Search command

A block of text that is marked by the tab key when the enter key is pressed can be referred to as

margin

paragraph

white space

word wrap

Principal uses of word processing software packages include: I. preparing draft articles for publication: II preparing reports for top management; III preparing accounts: IV preparing organization’s newsletter.

I, II and IV only

I, III and IV only

II, III and IV only

I, II, Ill and lV

The available page orientations in Microsoft word are

portrait and justify

justify and right align

left align and landscape

portrait and landscape

A predesigned document that already has coordinating fonts, a layout and a background is known as

guide

model

ruler

template

The figure, 2, in the number 11012 is indicated in MS Word using a feature called

superscript

subscript

root

exponentiation

The part of the MS Word interface labeled II in the figure below is called

Read mode

Print Layout

Proofing error

Web layout

The shortcut key for the Open dialog box in MS Word is

Alt + F12

Ctrl + F12

F12

Shift + F12

Personalized form of letters which can be sent to many people can be achieved using

macros

mail merge

query

template

Headers and footers are used in Microsoft Word documents to

make large document more readable

allow text to appear at the top of the first page

enhance the overall appearance of the document

allow text to appear at the top and bottom of every page

The usage of the keys CTRL + W in MS Word

saves the current file

opens the print dialog box

closes the current document

updates the current web page

The art of checking for errors in a Word document before publishing is referred to as

editing

formatting

modifying

proofreading

Spreadsheet

40 Questions

(\begin{matrix} \placeholder & A & B & C & D & E \\ 1 & B O O K S S U P P L I E D T O S E N I O R H I G H S C H O O L S & \placeholder & \placeholder & \placeholder \\ 2 & \placeholder & M A T H S & I C T & E N G L I S H \\ 3 & S H S I & 3450 & 4500 & 5678 \\ 4 & S H S I I & 8765 & 6580 & 9000 \\ 5 & S H S I I I & 2456 & 4009 & 4400 \end{matrix})

The content of cell C5 is

2456

4009

4400

3450

The number of cells that contain data in row 1 is

Which of the cells contains numeric data with the least value?

What displays the content of the active cell in excel?

Formula bar

Name box

Range

Task pane

(\begin{matrix} \placeholder & A & B & C & D \\ 1 & B O O K S S U P P L I E D T O S E N I O R H I G H S C H O O L S \\ 2 & F O R M & M A T H S & I C T & E N G L I S H L A N G U A G E \\ 3 & S H S I & 2456 & 6580 & 5678 \\ 4 & S H S I I & 3450 & 4009 & 9000 \\ 5 & S H S I I I & 8765 & 4500 & 4400 \end{matrix})

The content of cell D3 is

3450

4400

4500

5678

The number of cells that contain data in row I is

The number of cells that contain numeric data in the table are

The default number of sheets of a workbook is

one

two

three

four

The chart type that does not have the X and Y axes display is the

area chart

bar chart

pie chart

scatter diagram

When a worksheet is deleted from a workbook, it is

lost forever

sent to the recycle bin

sent to the original folder

stored permanently in main memory

In MS Excel, comments used in cells are called

cell tip

smart tip

soft tip

web tip

The absolute address of cell G5 in a spreadsheet application is represented by

$G5

G$5

$G$ 5

$G5$

The largest component in a spreadsheet is

cell

range

workbook

worksheet

Which of the following charts does not display the X and Y axes?

Bar chart

Bubble chart

Doughnut chart

X, Y graph

The uses of spreadsheet packages include: I. - Preparing organization’s logo; II. - Performing sensitivity analysis III. - Preparing reports for senior management; IV. - Preparation of profit forecasts. Which of the following options is true?

II and IV only

Ill and IV only

I, II, and III only

II, III and IV only

The common features of formula and function in spreadsheet are: I. - Entry is preceded by = or - symbol. II. - They have fixed formats . III. - They operate with cell address .IV. - Their results are displayed. Which of the following options is/are true?

I, II and III only

I, III and IV only

II, III and IV only

I, II, III and IV

Arrange the following spreadsheet window parts in a hierarchical order by size. I. - Worksheet II. - Cell III. - Workbook IV. - Range.

III, I, IV and II

Ill, IV, II and I

II, III, IV and I

IV, I, III and II

Which of these packages is appropriate for preparing payroll of workers?

CorelDraw

Microsoft access

Microsoft excel

Microsoft word

In a worksheet, a set of data is called

Column range

Database

Data file

Data range

(\begin{matrix} S / N & A & B & C & D \\ 1 & S t o c k L i s t o f T a y o O k e k e a s a t M a y, 2014 \\ 2 & Q u o t e d s t o c k & S h a r e u n i t & C u r r e n t U n i t p r i c e (N) & V a l u e \\ 3 & T a n z e l p i c & 44, 000 & 50 & 2, 200, 000 \\ 4 & k a p t o l & 125, 000 & 80 & # # # # \\ 5 & B a n k K L M & 75, 000 & 140 & # # # # \\ 6 & A r i x O i l & 10, 000 & 250 & 2, 500, 000 \\ 7 & \placeholder & \placeholder & T O T A L V A L U E & \placeholder \end{matrix})

The formula used to compute the TOTAL VALUE in cell D7 is

= sum (D2:D7)

= sum (D3:D7)

= sum ( D2:D6 )

= sum (D3:D6)

Which of the columns needs to be adjusted to accommodate cells contents?

Column A

Column B

Column C

Column D

In MS Excel, the cell that contains the pointer or cursor is called

active cell

current cell

default cell

passive cell

One major difference between paper spreadsheet and electronic spreadsheet is

arrangement of columns

headings formatting

arrangement of rows

speed of processing

To hold row and column titles in places so that they do not scroll when the user scrolls a worksheet, click the

freeze panes command on the windows menu

hold titles command on the edit menu

split command on the windows menu

show grid command on the windows menu

A cell with a red triangle in the top-right corner in a spreadsheet application signifies

an error in the cell

a comment associated with the cell

that the font colour for text in the cell is re

D. that a formula cannot be entered into the cell

Spreadsheet packages can be used for

database and painting

drawing and painting

budgeting and inventory

word processing and drawing

Which of the following is true when data maintained in MS Excel workbook is linked to a word document? The Word document

cannot be edited

must contain a hyperlink

contains a copy of the actual data

contains a reference to the original source application

In MS Excel, the average of 10 numbers given as B1, B2, ... , B10 is

=(B1 + B2 + ... + B10)/10

@SUM(B1:B10)

#SUM(B1:B10)/10

=B1 + B2 + ... + B10/10

To centre worksheet titles across a range of cells in MS Excel, the user must

widen the rows to centre the titles across the range of cells

widen the columns to centre the titles across range of cells

select the cells containing the title text and use the fill handle to centre the text across the range of cells

select any cell containing the title text and use the fill handle to centre the text across a range of cells

In the MS Excel, the cell that contains the pointer or cursor is called the

active cell

current cell

default cell

passive cell

The part of the MS Access interface labeled X in Figure 9 is called

Report view

Report wizard

Query design

Query view

Which of the following formulas will display the current seconds past the minute of the clock in MS Excel?

=MINUTE()

=MINUTE(NOW())

=MINUTE(YEAR())

=MINUTE(HOUR(NOW()))

What will be the result of writing the formula =Year(now()) + 3 in a worksheet of a spreadsheet, if the current calendar date is 14 August, 1960?

17 August, 1960 03.00

14 August, 1963

11 August, 1963

1963

If A is in cell A1 and B is in cell B1 of a worksheet in a spreadsheet application, write a formula to calculate $X = \frac{A^2 + B^{\frac{1}{2}}}{100}$ .

$(A1^2 + (B1^(1/2))) / 100$

$((A 1^2) +(B 1^(1/2)))/100$

$((A 1^2) +(B 1^(1/2))/100$

((A 1^2) +(B 1^(1/2)))/100

If today’s date is 02/02/2008, what will be the result of typing “=today () -1” in a cell of a spreadsheet?

02/01/2008

01/02/2009

01/02/2008

02/02/2007

Which of the following application packages is suitable for making budgets?

Word processor

Spreadsheet package

Graphic package

Database Management System

What happens when a user clicks on the icon in Figure 5 on the Microsoft Excel menu bar?

A copy of the selection is put on the clipboard so that user can paste somewhere else

A label that spans multiple columns is created

Content on the clipboard is added to the document

Selected range of cells is quickly converted to a table with its own style

New comment can be added to a cell in MS Excel by using the procedure

Edit-Comment

File Comment

Insert Comment

Review Comment

Which one of the following software can be used by a company accountant to prepare staff payment?

Microsoft Word

Microsoft Publisher

Microsoft PowerPoint

Microsoft Excel

The Microsoft Excel menu bar icon in the figure below represents a command used to

change the row height or column width, organize sheets, protect or hide cells

continue a series or pattern into neighbouring cells in any direction

remove the selection and put it on the clipboard so that user can paste it somewhere else

wrap extra- long text into multiple lines to allow a user view all of it

Database

20 Questions

Which of the following software is best suitable for keeping records during national population census?

Word Processing

Spreadsheet

Graphic

Database

In a database, a primary key is a field which contains

text only

unique entries

duplicate values

numeric value only

Which of the following views is used to create database objects in Microsoft Access?

Design view

Datasheet view

Layout view

Normal view

A field chosen to uniquely identify every record in a database is

foreign key

local key

primary key

secondary key

A row in a database table is referred to as

attribute

data item

fiel

record

Which of the following application packages is most suitable for database management?

Photoshop

MS Publisher

Macromedia Flash

Fox Pro

The following are functions of database management system except

backup and replication

format operation

rule enforcement

security of data

In database application, the field length determines the

maximum number of characters the field can accommodate

maximum number of operations that can be performed on the field

level of security of the database

maximum number of datatype the field can contain

What type of relationship can you deduce from the statement a department has many employees?

One-to-one

One-to-many

Many-to-many

Many-to-one

The maximum length of a text field in MS’Access is

120

255

265

The number of entries in Figure 8 is

The database model that uses tables with columns and rows is called

hierarchical database

network database

relational database

linear database

The following are functions of database management system except

backup and replication

format operation

rule enforcement

security of data

MS Access is an example of

word processing package

spreadsheet application

graphic software

database management system

Columns in MS Access are referred to as

fields

files

records

tuples

Which of the following statements about index is true? It is a data structure

that reduces the speed of data retrieval operations on a database table

used to quickly locate data without searching every row in a table every time a database table is accessed

created using only two rows of a database table to uniquely identify each recor

D. that allows relational database to split and store data in different tables, while linking disparate items

A record in a database can be identified using

a key field

an attribute key

an entity relationship

an object identifier

In MS Access, the first object to be created which will enable user to create or use other objects is a

Form

Macro

Report

Table

Arrange the following steps in the correct order of creating queries in Microsoft Access. 1. Choose the tables to include in the query II. Choose the fields to include and adjust the criteria III. Click the CREATE > Query Design button on the ribbon IV. Click the RUN button/switch to Data Sheet View

I, II, III, IV

I, II, IV, III

II, I, III, IV

III, I, II, IV

The file structure is represented systematically in ascending order as

data → field → record→ file

record → data→ file → field

field →record → data → file

file → record → field → data

Graphics & Presentation Packages

16 Questions

Which of the following software can be used for graphic production

DOS editor

PC writer

Corel draw

Acrobat reader

The colour palette in Corel Draw allows the user to

arrange colour

draw in colour

pick colour tool

choose different pre-set, palettes

Which of the following is not among the features of presentation package?

Animation

Insertion of range and cell

Insertion of video and audio

Slide

AutoCAD is best used in

educating

engineering

journalism

offices

Which of the following function keys can be used to run slide show in a PowerPoint presentation?

F12

In Microsoft PowerPoint, two kinds of sound effect files that can be added to a presentation are

.wav files and .mid files

.wav files and .gz files

.wav files and .jpg files

.jpg files and .gz files

To make the entire slides in a presentation to have the same “look” in MS PowerPoint, a user should

use the slide layout option

use outline view

use a presentation design template

add a slide option

In graphics, a subscript text refers to a text that is positioned

a little bit above a normal line of text

a little bit below a normal line of text

at the end of a line of text

at the front of a line of text

The part of the graphic interface in Figure 8 labelled V is called

pan

zoom in

zoom out

fit to window

The part of the CorelDraw window labelled II in image above is called

Pan

Zoom In

Zoom Out

Zoom to fit

Which of the following operations will not run a slide show in MS PowerPoint?

Pressing F5

Pressing Shift + F5

Choosing the slide show tab

Clicking the slide show icon on the taskbar

Which of the following actions is not an animation in Microsoft PowerPoint

Dancing

Emphasis

Entrance

Motion paths

What is the function of the CorelDraw Toolbox object shown in Figure 6? It is used to

change the magnification level in drawing window

draw lines and curves

edit the shape of objects

select and transform objects

An advantage of using Computer Aided Manufacturing in car manufacturing industry is that

cost of equipment is low

equipment does not require close supervision

pollution is reduced

products follow consistent standards

The CorelDraw Toolbox object in Figure 4 is used to

select and transform objects

edit the shape of objects

draw lines and curves

change the magnification level in drawing window

Which one of the following statements is true about the Slide Sorter View in Microsoft PowerPoint?