wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

STS101-Final Exam

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

What is Photo Imaging?

a)
Photo imaging is the same as video editing.
b)
Photo imaging refers to the process of creating 3D models.
c)
Photo imaging is exclusively about digital art creation.
d)
Photo imaging is the process of capturing and processing images using photographic techniques.
2.

What is Graphic Design?

a)
Graphic design is the art of visual communication through the use of typography, imagery, color, and layout.
b)
Graphic design is only concerned with photography.
c)
Graphic design is a form of digital painting.
d)
Graphic design is solely about creating logos.
3.

What are the key features of Canva?

a)
Key features of Canva include a drag-and-drop interface, a library of templates, stock photos, collaboration tools, and multiple export options.
b)
Only available on mobile devices
c)
Limited design tools
d)
No collaboration features
4.

What are the basic tools for photo editing in Canva?

a)
Color saturation adjustment
b)
Layer blending modes
c)
Image rotation tools
d)
Basic tools for photo editing in Canva include cropping, resizing, brightness and contrast adjustment, filters, text addition, and elements.
5.

What are the core principles of graphic design?

a)

None of the above

b)
Symmetry, simplicity, clarity, texture.
c)


Only Layout and Color Theory

d)

Layout, Color Theory, Typography, Composition

6.

What does good layout follow?

a)
Irrelevant text placement
b)

Visual flow, alignment, balance

c)
Random color choices
d)
Ignoring white space usage
7.

What do warm colors evoke?

a)
Warm colors evoke feelings of calm and tranquility.
b)
Warm colors are associated with sadness and melancholy.
c)
Warm colors represent coolness and detachment.
d)
Warm colors evoke feelings of warmth, energy, and excitement.
8.

What is the purpose of a mood board in design?

a)
To create a detailed project timeline.
b)
To provide a budget estimate for the design.
c)
To list all the materials needed for a project.
d)
The purpose of a mood board in design is to visually convey the style and direction of a project.
9.
Which operation in data processing arranges data in a specific order?
a)
Sorting
b)
Merging
c)
Storing
d)
Retrieving
10.
The arithmetic manipulation of data is known as:
a)
Calculating
b)
Sorting
c)
Merging
d)
Summarizing
11.
When a collection of data is condensed and certain conclusions are represented in a meaningful format, this is called:
a)
Summarizing and reporting
b)
Merging
c)
Storing
d)
Recording
12.
What is the operation that involves taking two or more sets of data and combining them?
a)
Merging
b)
Sorting
c)
Verifying
d)
Summarizing
13.
Which operation involves placing similar data into files for future reference?
a)
Storing
b)
Recording
c)
Verifying
d)
Calculating
14.
Retrieving in data processing refers to:
a)
Recovering stored data when needed
b)
Classifying data into categories
c)
Recording data onto a form
d)
Storing data into files
15.
Feedback in data processing is the comparison of the outputs and:
a)
The goal set in advance
b)
The inputs
c)
The stored data
d)
The processing cycle
16.
What method of data processing groups data to permit efficient and serial processing?
a)
Batch Processing
b)
Real-time Processing
c)
Online Processing
d)
Distributed Processing
17.
Online processing refers to:
a)
Grouping data for processing
b)
Fast-response data processing
c)
Combining multiple data sets
d)

Manual data processing

18.
Equipment or devices directly interacting with the computer’s CPU for immediate processing
a)
A fast-response capability that affects the outcome of an activity
b)
Equipment directly controlled by the CPU
c)
Grouped data for serial processing
d)
Remote terminals linked to a central computer
19.
Distributed processing typically involves:
a)
Remote terminals linked to a central computer system
b)
Grouped data for efficient processing
c)
Direct control by the CPU
d)
Fast-response computation
20.
In data processing, which method is the most complex?
a)
Distributed Processing
b)
Batch Processing
c)
Real-time Processing
d)
Online Processing
21.
What is the main characteristic of scientific data processing (SDP)?
a)
Involves a limited volume of input and many logical or arithmetic calculations
b)
Focuses on establishing and processing files for producing useful information
c)
Requires fast-response times
d)
Involves grouping data for processing
22.
Which step is not part of the basic data processing cycle?
a)
Distribution
b)
Input
c)
Processing
d)
Output
23.
What term refers to the creation of initial data in the expanded data processing cycle?
a)
Origination
b)
Input
c)
Processing
d)
Distribution
24.
Which operation is responsible for arranging data in specific categories?
a)
Classifying
b)
Recording
c)
Verifying
d)
Calculating
25.
Which of the following describes the purpose of feedback in data processing?
a)
To compare the output with the initial goal
b)
To arrange data in a specific order
c)
To combine multiple data sets
d)
To place data into files for storage
26.
What is the role of the Central Processing Unit (CPU) in a computer system?
a)
It is the brain of the computer responsible for performing calculations and data processing.
b)
It stores data for long-term use.
c)
It connects the computer to external devices.
d)
It supplies power to the computer components.
27.
Which component is central to any computer system and allows other components to work together?
a)
Motherboard
b)
Power Supply Unit
c)
Hard Disk Drive
d)
RAM
28.
What type of memory is volatile and loses its data when the computer is turned off?
a)
RAM (Random Access Memory)
b)
ROM (Read Only Memory)
c)
Hard Disk Drive
d)
Solid State Drive
29.
Which type of memory permanently stores instructions that tell the computer how to boot up?
a)
ROM (Read Only Memory)
b)
RAM (Random Access Memory)
c)
Internal Hard Disk Drive
d)
External Storage
30.
What is the primary function of a graphics card in a computer system?
a)
Enables the computer to display images on the monitor.
b)
Processes sound for output devices.
c)
Stores large amounts of data.
d)
Provides power to other components.
31.
A sound card is responsible for:
a)
Allowing the computer to produce sound and input sound through microphones.
b)
Storing sound files permanently.
c)
Processing video data.
d)
Connecting the computer to the internet.
32.
Which cable is typically used to connect a computer to a network router?
a)
Ethernet Cable
b)
VGA Cable
c)
HDMI Cable
d)
DVI Cable
33.
What is the primary function of the motherboard in a computer system?
a)
It connects all the components and allows them to communicate with each other.
b)
It processes data and performs calculations.
c)
It stores data temporarily while the computer is in use.
d)
It provides power to the components.
34.
Which component is known as the "brain" of the computer?
a)
Central Processing Unit (CPU)
b)
Motherboard
c)
RAM
d)
Hard Disk Drive
35.
Which type of memory is used to temporarily store information currently in use by the computer?
a)
RAM (Random Access Memory)
b)
ROM (Read Only Memory)
c)
Solid State Drive (SSD)
d)
Internal Hard Disk Drive
36.
Why is it important for a computer technician to ensure that all components are compatible when building a computer?
a)
To ensure the system runs smoothly and avoids hardware conflicts.
b)
To make the computer look aesthetically pleasing.
c)
To increase the speed of internet browsing.
d)
To reduce the need for software updates.
37.
When a computer technician installs software on a computer, what is their primary goal?
a)
To ensure the software functions correctly and meets the user's needs.
b)
To increase the computer's hardware performance.
c)
To delete unnecessary files on the computer.
d)
To install as many programs as possible for the user.
38.
What is the role of a computer technician when removing a virus from a computer?
a)
To identify, isolate, and eliminate the virus without harming the system.
b)
To back up all data before reformatting the hard drive.
c)
To replace the infected hardware components.
d)
To install a new operating system.
39.
How does a computer technician ensure the longevity of a computer during the cleaning process?
a)
By regularly removing dust and debris that could cause overheating.
b)
By upgrading the CPU and GPU.
c)
By installing new software applications.
d)
By deleting temporary files and clearing the cache.
40.
What is the significance of a computer technician updating antivirus software before scanning a computer?
a)
To ensure the latest virus definitions are used, increasing the chances of detecting and removing threats.
b)
To improve the computer's overall speed.
c)
To allow the software to scan faster.
d)
To delete old virus definitions from the system.
41.
When assembling a computer, why does a technician need to carefully manage cable connections?
a)
To improve airflow and prevent overheating within the case.
b)
To ensure the computer is quiet when in operation.
c)
To make the computer easier to transport.
d)
To increase the amount of available storage space.
42.
During a software installation, why might a computer technician choose a custom installation instead of the default settings?
a)
To tailor the installation to the specific needs and preferences of the user.
b)
To reduce the installation time.
c)
To avoid installing the software entirely.
d)
To increase the software's file size.
43.
What is the benefit of a computer technician performing regular maintenance on a computer?
a)
To prevent hardware issues and keep the system running efficiently.
b)
To ensure the computer always has the latest games installed.
c)
To avoid the need for future software updates.
d)
To decrease the computer's power consumption.
44.
Selects all text.
a)
CTRL+A
b)
CTRL+B
c)
CTRL+C
d)
CTRL+D
45.
Cuts the selected item.
a)
CTRL+V
b)
CTRL+P
c)
CTRL+X
d)
CTRL+A
46.
Paste the selected item.
a)
CTRL+V
b)
CTRL+P
c)
CTRL+C
d)
CTRL+D
47.
Copy the selected item.
a)
CTRL+C
b)
CTRL+O
c)
CTRL+P
d)
CTRL+Y
48.
Align selected text to the right.
a)
CTRL+R
b)
CTRL+I
c)
CTRL+G
d)
CTRL+D
49.
Align selected text to the left.
a)
CTRL+L
b)
CTRL+E
c)
CTRL+R
d)
CTRL+J
50.
Align selected text to the center.
a)
CTRL+L
b)
CTRL+E
c)
CTRL+R
d)
CTRL+J
51.
Lower case "ñ"
a)
alt+164
b)
alt+165
c)
alt+161
d)
alt+163
52.
Upper case "Ñ"
a)
alt+165
b)
alt+164
c)
alt+161
d)
alt+163
53.
Insert peso sign
a)
alt+8369
b)
alt+8639
c)
alt+8936
d)
alt+8396
54.
Insert or start a new page
a)
CTRL+enter
b)
CTRL+home
c)
CTRL+end
d)
CTRL+page up
55.
Open print window.
a)
CTRL+O
b)
CTRL+E
c)
CTRL+P
d)
CTRL+N
56.
Italicize highlighted selection.
a)
CTRL+I
b)
CTRL+E
c)
CTRL+R
d)
CTRL+J
57.
Justify paragraph alignment.
a)
CTRL+L
b)
CTRL+E
c)
CTRL+R
d)
CTRL+J
58.
To save the document.
a)
CTRL+S
b)
CTRL+E
c)
CTRL+A
d)
CTRL+V
59.

You have a list of monthly expenses in cells B2. What formula would you use to calculate the total expenses for the year?

a)
=TOTAL(B2:B12)
b)
=SUM(B2:B13)
c)
=AVERAGE(B2:B13)
d)
=SUMIF(B2:B13, ">0")
60.

If you want to calculate the total revenue from sales in cells C5 to C10, what formula should you use?

a)
=AVERAGE(C5:C10)
b)
=COUNT(C5:C10)
c)
=MAX(C5:C10)
d)
=SUM(C5:C10)
61.

You have a list of expenses in column E and the corresponding category in column F. What formula would you use to sum the expenses related to "Marketing"?

a)
=SUM(F:F, E:E)
b)
=SUMIF(E:E, 'Marketing', F:F)
c)
=COUNTIF(F:F, 'Marketing')
d)
=SUMIF(F:F, 'Marketing', E:E)
62.

To sum the values in column H where the corresponding value in column I is "Approved," which formula would you use?

a)
=SUM(H:H)
b)
=SUMIF(I:I, "Approved", H:H)
c)
=AVERAGEIF(I:I, 'Approved', H:H)
d)
=COUNTIF(I:I, 'Approved')
63.

If you need to sum expenses in column G where the department in column H is "HR" and the expense type in column I is "Training," which formula should you use?

a)
=SUMIF(G:G, H:H, 'HR')
b)
=SUMIFS(G:G, H:H, 'HR', I:I)
c)
=SUM(G:G, H:H, I:I)
d)
=SUMIFS(G:G, H:H, "HR", I:I, "Training")
64.

You want to count the number of transactions in column C. Which function should you use?

a)
COUNT
b)
MAX
c)
AVERAGE
d)
SUM
65.

To count the number of numeric values in a range D2

representing sales, which function is appropriate?

a)

  1. =COUNT(D2:D20)

b)

  1. =COUNTA(D2:D20)

c)

  1. =SUM(D2:D20)

d)

  1. =AVERAGE(D2:D20)

66.

Which of the following is the correct formula to add values from cells A1 and B1?

a)
A1+B1+0
b)
=A1+B1
c)
A1-B1
d)
SUM(A1,B1)
67.

What symbol is used to begin a formula in Excel?

a)
=
b)
*
c)
-
d)
+
68.

Which function would you use to find the highest number in a range of cells?

a)
MAX
b)
AVERAGE
c)
MIN
d)
SUM
69.

Which function would you use to find the lowest number in a range of cells?

a)
SUM
b)
MIN
c)
AVERAGE
d)
MAX
70.

What operator is used for multiplication in Excel?

a)
/
b)
%
c)
*
d)
-
71.

How would you subtract the value in cell B1 from the value in cell A1?

a)
=A1-B1
b)
=B1-A1
c)
=A1+B1
d)
=A1*B1
72.

Which of the following formulas divides the value in cell C1 by the value in cell D1?

a)
=C1/D1
b)
C1-D1
c)
C1*D1
d)
C1+D1
73.

Which function would you use to add a range of cells from A1 to A10?

a)
SUM(A1:A10)
b)
ADD(A1:A10)
c)
TOTAL(A1:A10)
d)
SUMIF(A1:A10)
74.

How would you calculate the average of the values in cells B1 to B5?

a)
=AVERAGE(B1:B5)
b)
=COUNT(B1:B5)
c)
=MEDIAN(B1:B5)
d)
=SUM(B1:B5)
75.

If you wanted to multiply the values in cells E1 and F1, which formula would you use?

a)
=E1*F1
b)
=E1/F1
c)
=E1-F1
d)
=E1+F1
76.

What does the SUMIF function do?

a)
The SUMIF function counts the number of cells that meet a condition.
b)
The SUMIF function averages values based on a specified condition.
c)
The SUMIF function sums values based on a specified condition.
d)
The SUMIF function finds the maximum value in a range of cells.
77.

How would you perform a calculation to divide cell G1 by 10 and then subtract 2?

a)
=G1*10 - 2
b)
=G1/5 + 2
c)
=G1 - 10 / 2
d)
=G1/10 - 2
78.

Which Excel function would you use to add up all values that meet multiple conditions?

a)
SUMIFS
b)
COUNTIFS
c)
ADDIF
d)
SUM
79.

To perform division in Excel, which operator should you use?

a)
*
b)
-
c)
+
d)
/
80.

Which of the following formulas will correctly calculate the product of cells A1, A2, and A3?

a)
=A1*A2+A3
b)
=A1*A2*A3
c)
=SUM(A1,A2,A3)
d)
=A1+A2+A3
81.

You need to count how many transactions in column J are marked as "Refunded." Which function do you use?

a)
AVERAGEIF(J:J, "Refunded")
b)
SUMIF(J:J, "Refunded")
c)
COUNT(J:J)
d)
COUNTIF(J:J, "Refunded")
82.

    To count the number of payments in column E that are greater than $500, which formula should be used?

a)
=SUMIF(E:E, ">500")
b)
=COUNT(E:E, ">500")
c)
=AVERAGEIF(E:E, ">500")
d)
=COUNTIF(E:E, ">500")
83.

To calculate the average revenue generated by products in cells B5 through B15, what formula should be used?

a)
=SUM(B5:B15)
b)
=AVERAGE(B5:B15)
c)
=COUNT(B5:B15)
d)
=MAX(B5:B15)
84.

You want to find the average cost per unit listed in column D. What is the correct formula?

a)
=AVERAGE(D:D)
b)
=MAX(D:D)
c)
=COUNT(D:D)
d)
=SUM(D:D)
85.

To find the average revenue in column F where the category in column G is "Luxury," which formula should you use?

a)
=AVERAGE(G:G)
b)
=COUNTIF(G:G, "Luxury", F:F)
c)
=SUMIF(G:G, "Luxury", F:F)
d)
=AVERAGEIF(G:G, "Luxury", F:F)
86.

To calculate the average profit in column H for transactions exceeding $1,000, which formula would be correct?

a)

=AVERAGEIF(H:H, ">1000")

b)
=AVERAGE(A:A)
c)
=COUNTIF(A:A, '>1000', H:H)
d)
=SUMIF(A:A, '>1000', H:H)
87.

To calculate the total interest on a loan by multiplying the principal in cell C1 by the interest rate in cell D1, what would the formula be?

a)

=D1/C1

b)
=C1-D1
c)
=C1+D1
d)
=C1*D1
88.

You need to calculate the net income by subtracting total expenses in cell B4 from total revenue in cell A4. Which formula would you use?

a)
=A4-B4
b)
=A4+B4
c)
=A4*B4
d)

=B4/A4

89.

To calculate the earnings per share (EPS) by dividing the total earnings in cell F5 by the number of shares in cell G5, which formula should you use?

a)
=F5/G5
b)
=F5*G5
c)

=G5-F5

d)
=F5+G5
90.

To find the profit by subtracting the cost in column C from the sales price in column D for each row, what formula should you enter in column E?

a)
=D1-C1
b)
=D1*C1
c)

=C1/D1

d)
=D1+C1
91.

Select the formula to add the values in cells A1, A2, and A3. *do not insert space between text/number

a)
=A1+A2+A3
b)

=A1-A2-A3

c)


=A1*A2*A3


d)


=A1/A2/A3


92.

Write the formula to subtract the value in cell B2 from the value in cell B1. *do not insert space between text/number

a)
=B1-B2
b)

=B1+B2

c)

=B1/B2

93.

Write the formula to multiply the values in cells C1 and C2. *do not insert space between text/number

a)
=C1*C2
b)

=C1xC2

c)

=C1+C2

94.

Write the formula to divide the value in cell D1 by the value in cell D2. *do not insert space between text/number

a)
=D1/D2
b)

=D1+D2

c)

=D1*D2

95.

Write the formula to calculate the total of the values from cell E1 to E10. *DO NOT INSERT SPACE

a)
=SUM(E1:E10)
b)

=ADD(E1:E10)

96.

Write the formula to find the average of the values from F1 to F5. *DO NOT INSERT SPACE

a)
=AVERAGE(F1:F5)
b)

=AVERAGEIF(F1:F5)

97.

Write the formula to find the maximum value in the range G1 to G10. *DO NOT INSERT SPACE

a)
=MAX(G1:G10)
b)

=MIN(G1:G10)

98.

Write the formula to find the minimum value in the range H1 to H5. *DO NOT INSERT SPACE

a)
=MIN(H1:H5)
b)

=MAX(H1:H5)

99.

Write the formula to count the number of numeric values in the range I1 to I10. *DO NOT INSERT SPACE

a)
=COUNT(I1:I10)
b)

=COUNTIF(I1:I10)

100.

Write the formula to sum the values in the range J1 to J10 only if they are greater than 100. *DO NOT INSERT SPACE

a)
=SUMIF(J1:J10, ">100")
b)

=SUMIF(J1:J10, "<100")

Similar Resources on Wayground

Programming in Java

101 questions

Programming in Java

quiz

Worksheet

•

University

Internet and Mobile Programming Final Review

96 questions

Internet and Mobile Programming Final Review

quiz

Worksheet

•

University

ສອບເສັງກາງພາກ C programming 1CEEE

99 questions

ສອບເສັງກາງພາກ C programming 1CEEE

quiz

Worksheet

•

University

Informatika untuk SMA/MA Kelas XII - Sistem Komputer

100 questions

Informatika untuk SMA/MA Kelas XII - Sistem Komputer

quiz

Worksheet

•

University

Tes LCTK Lanjutan

100 questions

Tes LCTK Lanjutan

quiz

Worksheet

•

10th Grade - University

UAS Manajemen Proyek TI

100 questions

UAS Manajemen Proyek TI

quiz

Worksheet

•

University

AI QUIZ

100 questions

AI QUIZ

quiz

Worksheet

•

University

UJIAN AKHIR SEMESTER DASAR DESAIN GRAFIS

100 questions

UJIAN AKHIR SEMESTER DASAR DESAIN GRAFIS

quiz

Worksheet

•

University