wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Pretest BSME A-F

Total questions: 95

Worksheet time: 45mins

Name
Class
Date
1.

James is trying to understand different types of software for his computer. He wants to know which one of the following is an example of an Operating System.

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft Access

d)

Microsoft Windows

2.

During a computer science class, Rohan asked his teacher, "The term 'memory' applies to which one of the following?"

a)

Logic

b)

Storage

c)

Input Device

d)

Output Device

3.


Which of the following refers to the memory in your computer?

a)

RAM

b)

DSL

c)

USB

d)

LAN

4.

While Isla is working on her research paper on her PC, where is the document temporarily stored?

a)

RAM

b)

ROM

c)

CPU

d)

FLASH MEMORY

5.
What does the acronym RAM stand for?
a)
Random Alignment Memory
b)
Read Access Memory
c)
Random Access Memory
d)
Read All Memory
6.
ROM stands for...
a)
Read Optical Memory
b)
Random Only Memory
c)
Read Only Memory
d)
Random Optical Memory
7.

Which of these is a Hard Disk Drive (HDD)?

a)
b)
c)
d)
8.

Grace is studying in school and her teacher asked the class, "What is ICT?"

a)

Information Communication technology

b)

Integrating communication technologhy

c)

Information Connecting Technology

d)

Information communication technique

9.

What is hardware

a)

Hardware is an electronic device you can touch

b)

Hardware is an electronic device you can not touch

c)

Hardware is any device you can touch

d)

Hardware is any device you can NOT touch

10.

Information is ............

a)
None of the below
b)
meanless
c)
numbers and characters 
d)

Processed Data 

11.

Isla is setting up her new computer for school. She wonders, what part of the computer is this?

a)

Screen

b)

TV

c)

Desktop

d)

Monitor

12.
A laptop is considered a portable device.  
a)
True
b)
False
13.
What is it?
a)
Pen drive
b)
Portable Disk
c)
Flash drive
d)
Hard disk
14.

What is not communication devices

a)

Radio

b)

Cell phone

c)

Refrigerator

d)

Satellite system

15.

What icon is this

a)

Volume

b)

Bluetooth

c)

WiFi

d)

All of the above

16.

Avery is using her computer to complete her homework and access personal information. Why does she need security on her computer?

a)

To protect personal information from dangerous sources.

b)

To share everything with everyone

c)

To speed up the computer.

17.

Which of these is NOT an input device?

a)

Monitor

b)

Microphone

c)

Scanner

d)

Keyboard

18.
a)
Fax
b)
Printer
c)
Paper
d)
Copier
19.

Kai is sharpening his pencil for the art class. Identify the step.

a)

Process

b)

Output

c)

Input

20.

Laptop computers can work without electricity

a)

True

b)

False

21.

What is a computer?

a)

A computer is case that manipulates information or data.

b)

A computer is an electronic device that manipulates information or data.

c)

A computer is powered box that manipulates information or data.

22.

We can use laptops to write emails

a)

TRUE

b)

FALSE

23.

What does a printer do?

a)

show what you are doing on a computer

b)

used for entering information

c)

copies information from a computer to paper

d)

used for navigating

24.

There are 4 main types of computers.

What type of computer is shown in the picture?

a)

laptop

b)

desktop

c)

tablet

d)

smartphone

25.

There are 4 main types of computers.

What type of computer is shown in the picture?

a)

laptop

b)

desktop

c)

tablet

d)

smartphone

26.

CPU stands for?

a)

Control Processing Unit

b)

Call Processing Unit

c)

Central Processing Unit

d)

Cost Processing Unit

27.

Name the computer part that helps a user to hear information from the system.

a)

Speaker

b)

Monitor

c)

Keyboard

d)

Mouse

28.

Computer can be termed as __________

a)

Data Processor

b)

Micro Processor

c)

Calculator

d)

Mini Processor

29.

What is software?

a)

Flexible parts of a computer case

b)

Instructions that tell the hardware what to do

c)

Clothing designed to be worn by computer users

30.
Which of these modes best describes a computer system?
a)
Input-output-process
b)
Process-input-output
c)
Input-process-output
31.

Software which controls internal operations of a computer is called

a)

Utility software

b)

Application software

c)

System software

d)

Interpreter

32.

Software is __________ component of computer system

a)

intangible

b)

tangible

c)

virtual

d)

physical

33.
What happens to RAM when the computer is switched off?
a)
Data is lost
b)
Data is stored
c)
Data is retained for 10 seconds
34.

USB stands for what?

a)

Universal Serial Bass

b)

Universal Series Box

c)

Universal Serial Bus

d)

Universal Series Bits

35.

Select the CPU

a)
b)
c)
d)
36.

Which does not belong to the group?

a)
b)
c)
d)
37.

Select three input devices your computer uses:

a)

Mouse, keyboard, monitor

b)

Mouse, keyboard, scanner

c)

Mouse, printer, CPU

d)

Mouse, scanner, printer Mouse, scanner, printer

38.

A _____ device is one that is attached to a computer to expand its ability to perform more.

a)

Input

b)

Output

c)

Storage

d)

Peripheral

39.

Jenna, a project manager at a tech company, has been tasked with overseeing the data analysis of a recent customer satisfaction survey. To effectively present her findings to the executive team, she needs to illustrate the Data Processing Cycle (DPC) in the context of Information and Communication Technology (ICT). If you were Jenna, using the blank canvass draw the DPC.

40.

The primary goal of a computer is to turn data into...........................

a)

ideas

b)

suggestions

c)

information

d)

reports

41.

What is the operating system of smartphones called?

(a)  

42.

Which of the following refers to loading two or more programs in the computer main memory and executing them concurrently?

a)

Multitasking

b)

Multiprogramming

c)

Time sharing

d)


Batch processing

43.

Discuss the various roles that humans play within an ICT (Information and Communication Technology) system. Highlight the importance of these roles in ensuring the effective functioning of ICT systems.

4 lines
44.

What is cybersecurity?

a)

The physical security of computer hardware

b)

The practice of protecting systems, networks, and programs from digital attacks

c)

The study of computer science and technology

d)

The process of building computer networks

45.

How many major functions are there of the computing cycle?

a)

2

b)

3

c)

4

d)

5

46.

What type of operating system does the logo represents

a)

Machintosh

b)

Linux

c)

Windows

d)

Android

47.

ICT, when incorporated in teaching, will make teaching and learning process more efficient. Which aspect is this?

a)

Communication

b)

Education

c)

Job Opportunities

d)

Socializing

48.

7. computers can be used for research, sharing information with other specialists both locally and internationally, as well as collecting, categorizing, analyzing, and storing data. Computers also play a vital role in launching, controlling, and maintaining space craft, as well as operating other advanced technology.

This is an ICT applications for:

a)

a.Business

b)

b.Education

c)

c.Health

d)

d.Science

49.

Which of the following is the Operating System of Iphone and Ipads?

a)

b)

c)

d)

50.

Which of the following CPUs is most suitable for gaming on a desktop computer?

a)

b)

c)

d)

51.
Rio wants to create an attendance sheet for her class. The worksheet includes the names of the students, class number and dates for the school days. What data type will not be of used for the said worksheet?
a)
Numbers
b)
Texts
c)
Date and Time
d)
Currency
52.
This data type can be any type like whole integers or with decimals.
a)
Numbers
b)
Date and Time
c)
Text
d)
Currency
53.
This data type is used to label values or sometimes part of data.
a)
Numbers
b)
Texts
c)
Date and Time
d)
Currency
54.
Alfred is calculating his monthly budget for the month of October. What data type will he used for the value of money?
a)
Number
b)
Text
c)
Currency
d)
Date and Time
55.
What data type is used in the labels for the given worksheet?
a)
Number
b)
Text
c)
Currency
d)
Date and Time
56.

What is the cell address of the red cell?

a)

F6

b)

6F

c)

E6

d)

F7

57.

What is the cell address of the red cell?

a)

A1

b)

1A

c)

C3

d)

3C

58.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
59.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
60.

A cell is the intersection of a row and column?

a)

True

b)

False

61.

Multiplication symbol in Microsoft Excel

a)

&

b)

*

c)

^

62.

Rows are__________groups of cells.

a)

Diagonal

b)

Horizontal

c)

Slant

d)

Vertical

63.

Letters and ______ are accepted as contents of the cell.

a)

Numbers

b)

Letters

c)

Words

d)

Symbols

64.

The Filter function icon can be found in _____________ tab.

a)

Home

b)

Insert

c)

Data

d)

View

65.

The ______________ function is used to determine how many pupils were able to get a passing score in a test.

a)

COUNT

b)

COUNTA

c)

IF

d)

COUNTBLANK

66.

What function Is used to find the highest data ?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

67.

To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula

a)

@

b)

=

c)

'

d)

#

68.

The function that lets you add up a range of cells or values

a)

AVERAGE

b)

SUM

c)

MIN

d)

MAX

69.

What's the Operation?

/

a)

Subtraction

b)

Multiplication

c)

Addition

d)

Division

70.

What's the Operation?

+

a)

Subtraction

b)

Multiplication

c)

Addition

d)

Division

71.

Which of the following shows the accurate formula to determine the total budget?

a)

=1+2

b)

=B3

c)

=A1+A2

d)

=B1+B2

72.

What cell contains an Excel formula?

a)

A4

b)

B4

c)

C4

d)

D4

73.

What is the cell range of the yellow highlighted cells?

a)

C1:C3

b)

C1:D3

c)

D3:C1

d)

D1:D3

74.

What cell contains the word Excel?

a)

A4

b)

B4

c)

C4

d)

D4

75.
What is the first operation you need to perform in the problem shown?
a)
addition
b)
subtraction
c)
parenthesis
d)
exponents
76.
In PEMDAS, what does the M stand for?
a)
Masterful
b)
Mad
c)
Math
d)
Multiplication
77.
Solve the problem shown
a)
4
b)
11
c)
24
d)
10
78.

Which is an example of a Comparison Operator?

a)

>

b)

*

c)

/

79.

Which of the formula's would output the price of the CHEAPEST item in the bakery?

a)

=MIN(B2:B7)

b)

=LOW(B2:B7)

c)

=SML(B2:B7)

d)

=BOTTOM(B2:B7)

80.

Which of the formula's would output the price of the MOST EXPENSIVE item in the bakery?

a)

=MAX(B2:B7)

b)

=HIGH(B2:B7)

c)

=LRG(B2:B7)

d)

=TOP(B2:B7)

81.

Answer =2+3*3-2

a)

9

b)

10

c)

11

d)

12

82.

Which formula will calculate the average?

a)

average

b)

countif

c)

averageif

d)

sumif

83.

What feature is particularly useful when you want to add all numbers in a row or column

a)

Autosum

b)

Product

c)

Operators

d)

Hierarchy

84.

Liam is working on a budget spreadsheet in Excel, but he encounters an issue when he tries to calculate the total expenses. What is the error value that is displayed on Excel when the formula contains invalid data?

a)

Autosum

b)

#VALUE!

c)

Arguments

d)

operators

85.
Which formula appears when you click the AUTOSUM button?
a)
=SUM
b)
=AUTOSUM()
c)
=SUM()
d)
=AUTOSUM
86.
To accept a formula in a cell, press the _________ key.  
a)
Tab
b)
Enter
c)
Ctrl
d)
Shift
87.

In Excel, columns are labeled by

a)

Letters

b)

Numbers

c)

Letters and numbers

88.

Excel refers to files as

a)

Databases

b)

Workbook

c)

Document

89.

(a)   calculates the sum of the values of a range of a cell

90.

(a)   calculates the arithmetic Mean of a range of values.

91.

(a)   gives the maximum value in a range of cells or values

92.

(a)   shows a series of calculations using the same formula but a different value for each calculation to determine whether the formula is true or false.

93.

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?

a)

=(A1+A2+A3)/4

b)

A1+A2+A3/4

c)

=A1+A2+A3^4

d)

(A1+A2) + A3/4

94.

If you want to compare parts to the whole, which type of graph/chart would work the best?

a)

Pie

b)

Bar

c)

Column

d)

Line

95.

Identify the formula for

IF

a)

=IF(logical_test, [value_if_true], [value_if_false])

b)

=IF(logical_test, [value_if_true], [value_if_true])

c)

=IF(logical_test, [value_if_false], [value_if_false])

d)

=IF([value_if_true], [value_if_false], logical_test)

Similar Resources on Wayground

computer basics 3

100 questions

computer basics 3

quiz

Worksheet

•

University - Professi...

BTEC IT U2: Exam Prep

99 questions

BTEC IT U2: Exam Prep

quiz

Worksheet

•

11th Grade - University

security system quiz

99 questions

security system quiz

quiz

Worksheet

•

University

QUIZ SEMESTER 1

100 questions

QUIZ SEMESTER 1

quiz

Worksheet

•

University

Statistics and R Basics Questions 1-17

99 questions

Statistics and R Basics Questions 1-17

quiz

Worksheet

•

University

NWC204 module 1-2-3

100 questions

NWC204 module 1-2-3

quiz

Worksheet

•

University

javascript

100 questions

javascript

quiz

Worksheet

•

KG - University

QUIZZ AIJ XII - Latihan PTS Semester Ganjil 2020

100 questions

QUIZZ AIJ XII - Latihan PTS Semester Ganjil 2020

quiz

Worksheet

•

KG - Professional Dev...