FBLA Information Technology 2

Question 1

In a spreadsheet application, which formula would correctly calculate the sum of values in cells A1 through A10?

Accepted Answer

=SUM(A1:A10)

Answer

=ADD(A1,A10)

Answer

=TOTAL(A1:A10)

Answer

=CALCULATE(A1+A10)

Question 2

What is a 'database' in the context of information technology?

Accepted Answer

An organized collection of structured data stored electronically

Answer

A program used to browse the internet

Answer

A type of computer processor

Answer

A wireless networking protocol

Question 3

Which of the following is a presentation software application?

Accepted Answer

Microsoft PowerPoint

Answer

Microsoft Excel

Answer

Adobe Photoshop

Answer

MySQL

Question 4

What does 'URL' stand for in web technology?

Accepted Answer

Uniform Resource Locator

Answer

Universal Remote Link

Answer

Unified Resource Language

Answer

User Request Line

Question 5

Which programming concept refers to the reuse of code by creating a template that other objects can inherit properties from?

Accepted Answer

Object-Oriented Programming (OOP)

Answer

Procedural programming

Answer

Machine language coding

Answer

Assembly language

Question 6

In a relational database, what is a 'primary key'?

Accepted Answer

A unique identifier for each record in a table

Answer

The first field listed in a table

Answer

A field that links two tables together

Answer

The most important piece of data in a record

Question 7

Which of the following best describes 'open-source software'?

Accepted Answer

Software whose source code is freely available for anyone to view, modify, and distribute

Answer

Software that can only be used on open networks

Answer

Software that requires no installation

Answer

Software purchased at open retail stores