Font size
WorksheetsProfessional IT Practice 25
Total questions: 100
Worksheet time: 3hrs 20mins
What does the "game loop" describe in a digital game?
The shape of a character path
The process of coding animation
The constant cycle of input, process, and output
A type of code repetition
Which term refers to how the player experiences the game emotionally?
Mechanics
Dynamics
Aesthetics
Algorithms
In Scratch or Unity, what is a “sprite”?
A type of score
A visual object controlled by code
A sound effect
A menu option
Why is iteration important in game development?
It helps reduce graphics
It speeds up character movement
It allows testing and refining based on feedback
It removes the need for debugging
What is the purpose of the input() function in Python?
To return a value
To display text
To receive data from the user
To define a function
What would the following code output? x = 5 if x > 3: print("High") else: print("Low")
High
Low
Error
5
What is the main difference between a list and a dictionary in Python?
A dictionary holds functions
Lists are only for strings
Dictionaries store key-value pairs
They are exactly the same
Which keyword defines a function in Python?
class
def
func
return
What is the purpose of the BIOS/UEFI in a PC?
Manage Wi-Fi
Store games
Run startup diagnostics and hand off to OS
Launch Excel
What component temporarily holds data while a computer is on?
SSD
CPU
RAM
PSU
Which tool would you use to find your computer’s IP address in Windows?
ipconfig
chkdsk
netstat
ping
A user reports their screen is flickering. What is the most logical first step?
Replace the hard drive
Check the cable connection and refresh rate
Reinstall the OS
Delete system32
Which of the following assigns IP addresses to devices automatically?
DNS
DHCP
FTP
RDP
What is the purpose of a router in a network?
Connects a PC to a printer
Translates website names
Directs traffic between networks
Charges devices
What is a MAC address used for?
Identifying a computer's physical location
Assigning internet speeds
Identifying a device’s hardware on a network
Managing password access
What does the ping command help diagnose?
Internet connection speed
Physical memory
Device-to-device connectivity
Malware
Which formula finds the average of values in cells A1 through A5?
=TOTAL(A1:A5)
=ADD(A1:A5)
=AVERAGE(A1:A5)
=MEAN(A1:A5)
What does conditional formatting do in Excel?
Sort columns
Protect files
Change cell appearance based on values
Convert files to PDF
What is the difference between relative and absolute cell references?
There is none
Absolute references change when copied
Relative references use a “$” to stay fixed
Absolute references do not change when copied
What tool is best for summarizing large data sets in Excel?
Filter
PivotTable
Chart Wizard
Border Settings
Many games allow the player to ______________ as they work through.
Cry
Run
Score
Spin
Explain the concept of game mechanics with an example.
In the game 'Super Mario Bros', the mechanic of jumping on enemies to defeat them and collecting coins to earn points are examples of game mechanics.
In the game 'Call of Duty', the mechanic of shooting enemies to progress through levels is an example of game mechanics.
In the game 'The Sims', the mechanic of controlling the daily activities and needs of virtual characters is an example of game mechanics.
In the game 'Tetris', the mechanic of rotating falling blocks to fit them together is an example of game mechanics.
How do you rename a worksheet in Excel?
Double-click the sheet tab and type a new name
Go to File and select "Rename Sheet"
Richt-click on any cell in the worksheet and select "Rename"
Click on "Insert" and choose "New Sheet"
What happens when you press Ctrl (or Cmd on Mac) + Z in Excel?
Saves the file
None of these
Undoes the last action
Deletes the selected cell
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
The Excel punctuation that is used to show formulas in a cell is
~ or `
+
=
#
The Excel punctuation that shows a range is a
:
$
*
+
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
f you want to freeze the top row in Excel, which option should you use?
Hide Row
Split Window
Freeze Panes
Autofill
The Excel punctuation that shows "Not Equal to"
<
>
>=
<>
The intersection of a row and column
Active Cell
Sort
Cell Range
Cell
A preprogrammed formula is called a _______. Ex: =SUM(B3*B2)
Formula
Spreadsheet
Function
Cell Range
To put data in a certain order is to _____________.
Label
Sort
Cell Range
Select data
Mathematical calculation where you begin by putting an = sign. Ex: =B3*B4
Formula
Spreadsheet
Function
Cell Range
The intersection of a row and column
Active Cell
Sort
Cell Range
Cell
Margins are the white space on the spreadsheet where nothing prints.
True
False
The Excel punctuation that is the Greater Than symbol
<
>
<>
None of these
What does "###" in a cell mean?
The formula is incorrect
The cell is empty
The column is too narrow to display the content
There is a hidden formula in the cell
If you click on a letter at the top of an Excel spreadsheet, for example the "A", what have you done?
selected a cell
selected a range of cells
selected a row of data
selected a column of data
What is the purpose of the AutoSum button?
To insert the SUM function quickly
To format numbers as currency
To create a chart automatically
To delete blank rows
What does the "Merge & Center" button do?
Deletes the contents of selected cells
Moves text to the right side of the cell
Splits a cell into multiple columns
Joins multiple cells into one and centers the text
What is the default file extension for an Excel workbook?
.docx
.xlsx
.pptx
Which of the following laptop features allows users to overcome keyboard size restrictions?
Touchpad
Fn key
Digitizer
Numeric Key
Which of the following is a type of internal hard drive used in laptop computers? (Select all that apply)
Flash drives
USB drives
Magnetic disks
SSDs
SSHDs
Which of the following can be used to describe the features of Solid-State Drives (SSDs)? (Select 3 answers)
Low performance
Relatively high device cost
Lower capacity in comparison to magnetic drives
High performance
Relatively low device cost
Which type of internal laptop hard drive combines high performance and capacity at a relatively low device cost?
SSD
Flash drive
Magnetic drive
USB drive
SSHD
Which of the following are characteristic features of traditional magnetic drives? (Select 3 answers)
High capacity
Low device cost
High performance
Low capacity
Low performance
Which of the following sizes is the most common magnetic hard disk drive form factor used in laptops?
3.5 inch
5.25 inch
1.8 inch
2.5 inch
Which of the following are SSD form factors used in laptop computers? (Select 2 answers)
1.5 inch
5.25 inch
1.8 inch
2.5 inch
1.3 inch
What is the function of a laptop's smart card reader?
Storage expansion
Access control
Theft prevention
Data encryption
Due to size restrictions and the compact nature of laptop devices, this type of storage media has become less commonly found on new laptops?
Flash drives
Optical drives
Magnetic drives
Solid-state drives
Due to the compact nature of laptop devices, all laptop GPUs come in the form of CPU-integrated graphics.
True
False
What type of power jack can be found on a laptop case?
AC
PFC
DC
A/V
Which of the following describes the function of a digitizer? (Select 3 answers)
A device that translates analog data into a format suitable for computer processing
A type of output device
A component of a mobile device's screen that allows users to control the device with a fingertip
An example of a media converter
A type of input device
A technician is setting up a computer that was shipped. After everything is plugged in, the computer will not turn on. Which of the following should the technician do FIRST to identify
the issue?
Check for physical damage on the computer.
Search for a solution on the Internet.
Reference the manufacturer’s documentation.
Ensure the power supply is set at the correct voltage.
A home computer that has been in operation for more than five years is now suffering from random shutdowns during the day. The PC is set up in an enclosed cubby built into the
home office desk. Which of the following is MOST likely plaguing the PC?
The PC was switched over to 240v operation mode
Dust accumulation
The PC’s BIOS is severely out-of-date, causing PSU issues
EMI
What is the first layer of the OSI Model
Network
Application
Physical
Transport
Where MAC addressing and physical components of the network exist
Application
Transport
Internet
Network Access
What is a protocol
A set of rules
A set of packets
A wiring method
The proper way to put in a CPU
What types of server software can a single server provide
File
Web
Application
What is the practical limit on the number of devices for a peer to peer network
20
1-10
2
1-5
How many layers are in the OSI model
4
7
11
8
How many layers are in the TCP/IP model
7
4
11
8
What type of device is a switch
Intermediary Device
Host
Monitor
Multimedia Device
Current latest wireless standard
802.11ac
802.11c
802.11b
802.11abc
Which standards body developed the ethernet standards
IEEE
HTTP
UDP
TCP
What does HTTP stand for
Hyper Text Transfer Protocol
Hydro Texting Time Pension
Huge Time Trial Program
There is no meaning behind it
Which layer contains standards for wiring and signal standards
Application
Transport
Physical
Presentation
What is this
Hub
Fridge
Server
Power Supply
Why do hackers create viruses and spyware?
They want to steal money
They want to steal your private info
They want to harm your computer
All of these answers are correct
Why is it important to have antivirus software installed on your computer?
To track your finances
To stop others from plagiarizing your work
to prevent others from stealing your device
To stop hackers from harming your computer
Which of the following are malware?
spyware
Trojan Horse
viruses
All these answers are correct
Your computer won't turn on. What should you do first?
Don't Panic
Check Power cords
Check cable connections
Why is it important to know how to troubleshoot your computer?
You can help others
All these answers are correct
To save money
There may not always be someone to help you.
Computer viruses are
Programs that hackers use to harm your computers or steal info.
A sickness that humans catch from computers
can only be acquired through the internet
can only be acquired through email
What keyboard command closes a pop-up window?
Alt F4
Ctrl C
Alt C
Ctrl F4
Why is it better to use a keyboard command to close a pop-up window?
It works faster
Computers only understand keyboard commands
The X or close button may actually be programmed to install
There is no benefit
Which of the following is considered malware?
spyware
anti-virus software
open source software
Apps
You computer is running slow and you are having trouble connecting to websites. What should you do?
Check power source and internet cables
Check internet cables and network connections, and do a virus scan
Check power cords, internet connections, and do a virus scan
Check power cords, all cables going in and out of the computer, check internet connections, check network connections, do a virus scan and restart.
this picture means?
the computer does not give out a sound
the sound is to loud
do talking in the classroom
You can't get on your school's network(not internet). What should you check first?
Your cable company
cables going into and out of your computer
your internet connection
cable connected to your monitor
Fill in the blanks.
From the tag example above, What is the command tag?
From the text above, What is the command tag?
From the text above, What is the command tag?
