Spreadsheet Quiz#01

Which of the following is capable of producing a spreadsheet? Tick all that apply.

• Microsoft Office Excel

• Google Docs

• Microsoft Office Word

In a cell reference, for example, A1, what does the letter refer to?

• The worksheet the cell is in

• The row the cell is in

• The column the cells is in

Which of the following tasks would a spreadsheet be best used for (tick all that apply)?

• Present promotional information about a new television channel

• To write a letter of complaint

• Creating a budget for a party

• Keep track of money raised at a charity event.

Which tool is best used to duplicate information from cell to cell?

• Fill Handle

• Autosum

• Filter

Wrap text is an option which can be applied to cells in order to do what (tick all that apply)?

• Resize a cell to fit the text inside

• Put a border around a cell containing text

• Put a background on a cell containing text

• Put text that is longer than the width of the cell on more than one line within the cell.

What term describes changing the horizontal or vertical position of text.

• Alignment

• Format

• Font

When we select a group of cells together to use in a formula this is called a...?

• Block

• Sheet

• Range

What function do we use to join a group of cells together to make a larger cell?

• Verge

• Combine

• Merge

Which is larger: A worksheet or a workbook?

• Workbook

• Worksheet

What are THREE benefits of using a spreadsheets?

• Automatic recalculation

• You can drag it down.

• Spreadsheets can take a long time to complete

• Graphs and charts can be drawn using the data.

• Replication: Once the data is correctly entered.