DIT Final Exam Review 2

What is a database used for?

• Sending messages
• Storing and organizing data
• Browsing the web
• Designing graphics

Answer explanation

Databases manage large amounts of structured data.

What is cloud storage?

• Saving files online
• Saving to CD
• Clearing browser history
• Printing documents

Answer explanation

Cloud storage keeps files accessible via internet.

Why do people use collaborative documents?

• To remove edits
• To work on the same file together
• To print only
• To lock others out

Answer explanation

Collaboration allows shared editing.

Which tool helps create surveys and quizzes?

• Google Slides
• Excel
• Google Forms
• Photoshop

Answer explanation

Google Forms collects responses easily.

What does a hyperlink do?

• Connects to a webpage or file
• Inserts a table
• Formats text
• Saves data

Answer explanation

Hyperlinks create clickable links.

What is the purpose of the AutoFill feature in Excel?

• It removes duplicate data
• It filters rows based on criteria
• It quickly fills cells with repeated or sequential data
• It formats selected cells automatically

Answer explanation

AutoFill automatically extends a series or pattern to adjacent cells.

Which symbol is used to begin a formula in Excel?

• &
• '=
• #
• $

Answer explanation

All formulas in Excel must begin with the equal sign (=).

What is an example of a formula that calculates the total of cells A1 through A5?

• '=ADD(A1:A5)
• '=TOTAL(A1-A5)
• '=SUM(A1:A5)
• '=A1+A5

Answer explanation

The SUM function adds all values in the range A1 to A5.

Which chart type is best for showing parts of a whole?

• Line chart
• Pie chart
• Bar chart
• Column chart

Answer explanation

Pie charts are used to represent parts of a whole as slices.

What is the main purpose of HTML?

• To edit images
• To organize spreadsheets
• To format and display web content
• To protect computers from viruses

Answer explanation

HTML structures web pages by using tags for content and layout.