FBLA Information Technology 2 — Questions and Answers
Question 1: In a spreadsheet application, which formula would correctly calculate the sum of values in cells A1 through A10?
- =SUM(A1:A10) (Correct answer)
- =ADD(A1,A10)
- =TOTAL(A1:A10)
- =CALCULATE(A1+A10)
Correct answer: =SUM(A1:A10)
=SUM(A1:A10) is the correct syntax in spreadsheet applications like Microsoft Excel to sum a range of cells.
Question 2: What is a 'database' in the context of information technology?
- An organized collection of structured data stored electronically (Correct answer)
- A program used to browse the internet
- A type of computer processor
- A wireless networking protocol
Correct answer: An organized collection of structured data stored electronically
A database is an organized collection of structured data that allows for efficient storage, retrieval, and management of information.
Question 3: Which of the following is a presentation software application?
- Microsoft PowerPoint (Correct answer)
- Microsoft Excel
- Adobe Photoshop
- MySQL
Correct answer: Microsoft PowerPoint
Microsoft PowerPoint is a presentation software application used to create slideshows; Excel is a spreadsheet tool, Photoshop is image editing software, and MySQL is a database system.
Question 4: What does 'URL' stand for in web technology?
- Uniform Resource Locator (Correct answer)
- Universal Remote Link
- Unified Resource Language
- User Request Line
Correct answer: Uniform Resource Locator
URL stands for Uniform Resource Locator, which is the web address used to locate specific resources on the internet.
Question 5: Which programming concept refers to the reuse of code by creating a template that other objects can inherit properties from?
- Object-Oriented Programming (OOP) (Correct answer)
- Procedural programming
- Machine language coding
- Assembly language
Correct answer: Object-Oriented Programming (OOP)
Object-Oriented Programming (OOP) uses concepts like classes and inheritance to allow code reuse and modular design.
Question 6: In a relational database, what is a 'primary key'?
- A unique identifier for each record in a table (Correct answer)
- The first field listed in a table
- A field that links two tables together
- The most important piece of data in a record
Correct answer: A unique identifier for each record in a table
A primary key is a unique identifier assigned to each record in a database table, ensuring no two records are identical.
Question 7: Which of the following best describes 'open-source software'?
- Software whose source code is freely available for anyone to view, modify, and distribute (Correct answer)
- Software that can only be used on open networks
- Software that requires no installation
- Software purchased at open retail stores
Correct answer: Software whose source code is freely available for anyone to view, modify, and distribute
Open-source software has publicly available source code, allowing developers to freely inspect, modify, and redistribute it under an open license.
FBLA Information Technology 2
In a spreadsheet application, which formula would correctly calculate the sum of values in cells A1 through A10?