4. Introduction to Spreadsheets

Multiple Choice

What is a spreadsheet?

• A spreadsheet is a electronic worksheet or grid that is used to organize and analyze information.

• A spreadsheet is a type of musical instrument played in a band class.

• A spreadsheet is a tool used for drawing and painting.
• A spreadsheet is a type of computer virus.

Multiple Select

What is a spreadsheet used for?

• Finance

• School data analysis

• Presenting data

• Recording results

Multiple Choice

The main file that contains one or more worksheets where you can enter data is called:

• Range

• Cell

• Worksheet

• Workbook

Multiple Choice

For a food truck, name one thing they could use a spreadsheet for.

• Write a research paper for approval options.

• Write a letter to a donor.

• Presenting to customer.

• Keeping inventory prices for the month.

Multiple Choice

Which feature allows multiple tables to be saved in the same spreadsheet file?

• A. Charts

• B. Formatting

• C. Worksheets

• D. Alignment

Multiple Choice

Which of the following is an example of presenting data in a spreadsheet?

• A. Typing text into a cell

• B. Creating charts or graphs

• C. Saving the file

• D. Changing the font size

Multiple Choice

What are the key features of spreadsheet software?

• Data types

• Software applications

• Formatting functions

• All of the above

Multiple Choice

Which of the following is NOT a feature of modern spreadsheets?

• Cell-based layout

• Multiple worksheets

• Graphs

• Text formatting

Multiple Choice

Formulas in a spreadsheet allow calculations to be carried out on stored data.

• True

• False

Multiple Select

What are the different formatting tools mentioned in the text?

• Text

• Cell

• Border

• Alignment

Multiple Choice

In a spreadsheet, what is a cell?

• A. A whole worksheet

• B. The intersection of a row and a column

• C. A type of formula

• D. A chart

Multiple Choice

Which formatting tool is used to place text in the centre of a cell?

• A. Border

• B. Cell colour

• C. Alignment

• D. Cell merging

Multiple Choice

What happens when cells are merged?

• A. Data is deleted

• B. Cells change colour

• C. Multiple cells become one larger cell

• D. A formula is created

Match

Match the data type to the correct example:

• Number

• Percentage

• Date

• Time

• Currency

1.25

75%

04/05/1977

07:30:00

9.99$

• 1.25

• 75%

• 04/05/1977

• 07:30:00

• 9.99$

Poll

How confident do you feel about this topic now?

• Very confident
• Somewhat confident
• Not confident