wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Computer Software Practice Quiz

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.
________________programs that control or maintain the operations of the computer and its devices.
a)
Software
b)
System Software
c)
Application software
d)
Utility program
2.
_________________are programs that designed to help users to be more productive with their personal tasks.
a)
Software
b)
System Software
c)
Application software
d)
Utility program
3.
Function of system software is to serve as the _________ between the user, the application software, and the computer’s hardware
a)
interface
b)
program
c)
application
d)
server
4.
The picture shows a type of user interface as a function of operating system
a)
Command Line
b)
Graphical user interface
5.

The term OS is short for?

a)

Apple

b)

Operating Software

c)

Operating System

d)

Overload System

6.

The GUI was basically designed in order to:

a)
hide the complexities of the machine from the user
b)
Guide the user
c)
to make the screen look nice
7.
A computer can function without an operating system
a)
True
b)
False
8.
Which of the following is not one of the most common operating systems for personal computers?
a)
Microsoft Windows
b)
IBM
c)
Linux
d)
Mac OS X
9.
What is the purpose of an operating system?
a)
Manage software on computer
b)
Manage hardware on computer
c)
Manage all hardware & software on computer
10.

Which of these is not a function of an OS:

a)

Provide a user interface

b)

Communicate with hardware

c)

Allow the computer to multi-task

d)

Improves CPU performance

11.

What does GUI stand for?

a)

Genuine Umpire Impressions

b)

Graphical User Interface

c)

Graphic Up Industry

12.

A computer needs both hardware and software to work

a)

true

b)

false

13.

It is the bar at the bottom of any application window.

(a)  

14.

On any program window, these are bars to one side or at the bottom of the window that allow you to move around the viewable area.

(a)  

15.

Teacher Pau needs to create and print the test papers for her class examination. What productivity tool will she use?

a)

Microsoft Powerpoint

b)

Microsoft Word

c)

Microsoft Publisher

d)

Microsoft Access

16.

This application provides a single place to store, access, create, edit, and share documents, files, and folders of all types.

a)

Bing Drive

b)

Yahoo Drive

c)

Playstation Drive

d)

Google Drive

17.

On any program window, this is where you can find the file name.

a)

Status Line

b)

Formatting Toolbar

c)

Title bar

d)

Page Break

18.

What spreadsheet function adds up a range/group of cells?

a)

NAME

b)

SUM

c)

AVERAGE

d)

VLOOKUP

19.

Which of the following objects can be inserted in a word processing document?

a)

Pictures

b)

Shape

c)

Chart

d)

All of the above

20.

Name THREE (3) types of software that are typically bundled in an office productivity suite such as Microsoft Office.

4 lines
21.

Give ONE example of an Operating System.

4 lines
22.
The program that allows you to create letters, tables, insert graphics and change the fonts etc is:
a)
Spreadsheet
b)
Database
c)
Word Processing
d)
Presentation Software
23.
What are programs that organize, analyze, and graph numeric data such as budgets and financial reports.
a)
suites
b)
DBMS
c)
spreadsheets
d)
word processors
24.
Which of the following is an application?
a)
Web Browser
b)
Desktop
c)
IOS
d)

Apple

25.
What type of software uses columns, rows and cells to represent data that can be manipulated by formulas in other cells?
a)
Database
b)
Spreadsheets
c)
Graphics Editor
d)

Programming IDEs

26.

Using this in creating formula in Excel the cell references do not change when copied or filled by inserting $. You can use this to keep the row or column constant.

a)

absolute reference

b)

cell reference

c)

relative reference

d)

function

27.

Applications are used on... (select ALL correct answers)

a)

desktop computers

b)

mobile/cell phones

c)

tablets

d)

laptop computers

28.

What do all spreadsheet formulas start with?

a)

=

b)

(

c)

-

d)

\

29.

What is the name of each "box" on a spreadsheet?

a)

Cell

b)

Box

c)

Column

d)

Row

30.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
31.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
32.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
33.

What is the difference between a formula and a function?

a)

A function deals with a whole range of cells in one go and has a function name at the beginning, whereas a formula lists each cell individually and puts the correct mathematical operator between them

b)

A formula deals with a whole range of cells in one go and has a function name at the beginning, whereas a function lists each cell individually and puts the correct mathematical operator between them

c)

There is no difference between a formula and a function, they are the same

d)

A formula is something we use in maths, whereas a function is something we use in ICT

34.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
35.
Which of the following is an example of a cell reference?
a)
a. Column C
b)

b. =SUM( )

c)
c. Row 1
d)
d. A5
36.

In a database, a _______ is the interface that is used to collect information from user.

a)

Table

b)

Form

c)

Report

d)

Query

37.

Tables are organized in the form of ___________ and______________.

a)

Report

b)

Rows

c)

Query

d)

Columns

38.

A Database consists of different objects like_________,____________ and___________.

a)

Table

b)

Information

c)

Project

d)

Report

e)

Query

39.
What is a database?
a)
A piece of software to do calculations
b)
A device to load information onto the computer.
c)
A structured collection of information
d)
A calculator
40.
A sports club needs to store information about each member.  The individual information about each member is called a:
a)
Field
b)
File
c)
Table
d)
Record
41.
How many records are in this database?
a)
8
b)
5
c)
10
d)
12
42.
A tool used to organize, store, retrieve, and communicate groups of related information. 
a)
Spreadsheet
b)
Word
c)
Presentations
d)
Database
43.

The four main objects of a database consist of:

a)
form, table, query, report
b)
form, table, database, query, report
c)
form, sort, table, query
d)
form, column, row, report
44.
I give one the ability to present information in an easy-to-read format. I summarize and print information from the  query search.
a)
form
b)
table
c)
query
d)
report
45.
I can perform an advanced search. I am very similar to asking a detailed question. 
a)
report
b)
query
c)
table
d)
form
46.
If I am placed between terms I will retrieve data that contain both of the terms. Which connector am I?
Example: candy ____ soda
a)
And
b)
Or
c)
Not
d)
But
47.
If I am placed between terms, I will retrieve data that contain either of the terms.
Example: candy ___ soda
a)
And
b)
Or
c)
But
d)
Not
48.

___________, ___________ & ___________ are fields.

a)

S. No, Product Code & Description

b)

1021, Beverages & Soft drinks, coffees, teas

c)

Dairy Products, Beverages & Seafood.

d)

All of these are fields.

49.
A quick way to find data in a database is to use _____.
a)
queries
b)
quandries
c)
questions
d)
file folders
50.

Which of the following defines the term 'file' in relation to databases?

a)

A file is all of the information about one person or one thing

b)

A file is one type or piece of information

c)

A file is the collection of all the database records on one topic or subject

d)

A file is a location in computer memory where data is stored.