WorksheetsIT Careers, Hard/Soft Skills, & The Spreadsheet window
Total questions: 60
Worksheet time: 30mins
Which of the following is a hard skill?
Team collaboration
Python programming
Conflict resolution
Time management
Soft skills are BEST described as:
Technical certifications
Interpersonal and behavioral traits
Expertise in software tools
Mathematical proficiency
Which skill is critical for resolving workplace conflicts?
Data analysis
Emotional intelligence
Machine operation
Coding
Hard skills are typically:
Innate personality traits
Learned through formal education/training
Related to creativity
Focused on team-building
Which is a soft skill for effective leadership?
Network configuration
Active listening
Database management
CAD design
Why are both hard and soft skills important in the workplace?
Soft skills replace the need for technical expertise.
Hard skills ensure teamwork, while soft skills ensure task completion.
They complement each other for productivity and collaboration.
Hard skills are only relevant for managerial roles.
The area where you type or edit data in a cell is called the:
Formula Bar
Ribbon
Name Box
Status Bar
Which component contains tabs like "Home" and "Insert"?
Quick Access Toolbar
Ribbon
Worksheet Tab
Scroll Bar
What does the Name Box display?
Current cell’s content
Address of the active cell
Formula results
Sheet names
Where are worksheet tabs located?
Top of the Ribbon
Bottom-left of the window
Right of the Formula Bar
In the Status Bar
The Status Bar shows:
Shortcut commands
Average/Sum of selected cells
Cell formatting options
File name
Which part allows you to zoom in/out?
Scroll Bar
Status Bar slider
Ribbon
Name Box
The intersection of a row and column is called a:
Tab
Cell
Range
Pane
Which feature provides undo/redo shortcuts by default?
Formula Bar
Quick Access Toolbar
Ribbon
Status Bar
Columns in Excel are labeled with:
Numbers
Letters
Symbols
Roman numerals
The “Fill Handle” is used to:
Adjust column width
Copy formulas/patterns
Delete cells
Insert charts
Which part displays the current worksheet name?
Title Bar
Formula Bar
Status Bar
Name Box
The “Ctrl + F” shortcut opens a dialog box in the:
Ribbon
Formula Bar
Navigation Pane
Name Box
What does the “Split Box” do?
Divides the window into panes
Merges cells
Splits text into columns
Creates charts
The “Page Layout View” is accessed via the:
Status Bar
Ribbon’s View tab
Quick Access Toolbar
Formula Bar
Who troubleshoots end-user technical issues?
Help Desk
DB Admin
Software Tester
A help desk technician primarily uses:
Network servers
Ticketing systems
SQL databases
Who designs and maintains databases?
Network Admin
DB Admin
System Analyst
Which tool is essential for a DB Admin?
MySQL
Photoshop
AutoCAD
Who monitors mainframe systems?
Computer Operator
Programmer
Software Trainer
A computer operator ensures:
Code debugging
System uptime
User training
Who writes application code?
Programmer
Network Admin
System Admin
A programmer primarily uses:
Java/Python
Cisco routers
Excel
Who designs computer hardware?
Computer Engineer
Software Tester
File Librarian
Computer engineers focus on:
Circuit boards
User manuals
Marketing
Who oversees daily IT workflows?
IT Manager
Operations Manager
System Programmer
Key responsibility of an IT Operations Manager:
Coding apps
Resource allocation
Database design
Who aligns IT strategy with business goals?
IT Manager
Help Desk
Software Trainer
An IT Manager typically requires:
PMP certification
Graphic design skills
CAD expertise
Who develops operating systems?
System Programmer
Network Admin
Software Tester
System programmers work with:
Low-level languages
User interfaces
HR policies
Who trains users on new software?
Software Trainer
System Analyst
File Librarian
A software trainer creates:
User manuals
Firewall rules
Database schemas
Who identifies bugs in applications?
Software Tester
DB Admin
Computer Engineer
A software tester uses tools like:
Selenium
Photoshop
AutoCAD
Who manages firewalls and routers?
Network Admin
Programmer
System Analyst
Key task for a Network Admin:
Writing code
Configuring VPNs
Training users
Who manages software licenses and archives?
File Librarian
System Admin
Help Desk
A file librarian ensures:
Code efficiency
Document version control
Network speed
Who bridges business needs and IT solutions?
System Analyst
Computer Operator
Software Trainer
A system analyst creates:
Technical specifications
Marketing plans
Hardware prototypes
Who maintains servers and user accounts?
System Admin
DB Admin
Software Tester
A system admin uses tools like:
Active Directory
JIRA
MySQL
Which role requires knowledge of SQL queries?
DB Admin
Help Desk
Software Trainer
Who ensures software meets quality standards?
Software Tester
Network Admin
File Librarian
Which role focuses on disaster recovery plans?
Operations Manager
Programmer
System Analyst
Who would troubleshoot a server crash?
System Admin
Software Trainer
Computer Engineer
Which role creates network security policies?
Network Admin
System Programmer
File Librarian
Who writes technical documentation?
System Analyst
Computer Operator
Software Tester
Which role requires knowledge of Linux?
System Admin
DB Admin
Help Desk
Who designs IT infrastructure upgrades?
System Analyst
Computer Engineer
Software Trainer
Which role uses virtualization tools?
System Admin
File Librarian
Software Tester
Who manages cloud storage solutions?
System Admin
Programmer
Network Admin
Which role interacts directly with end-users?
Help Desk
System Programmer
DB Admin
Who optimizes database performance?
DB Admin
Software Tester
Computer Operator
