Understanding Spreadsheets

What is a spreadsheet primarily used for?

• Organizing and analyzing data

• Designing websites

• Writing code

• Creating presentations

Which of the following is a common spreadsheet software?

• Google Docs

• Microsoft Word

• Adobe Photoshop

• Microsoft Excel

What does the term 'cell' refer to in a spreadsheet?

• A cell is the basic unit in a spreadsheet where data is entered.

• A cell is a formula that calculates data automatically.

• A cell refers to the entire spreadsheet document.

• A cell is a type of software used for calculations.

How do you create a formula in a spreadsheet?

• Select the cell and click 'Insert Formula' from the menu.

• Type '=' followed by your formula in the desired cell.

• Enter the formula in the header row only.

• Use '!' to start your formula in any cell.

What symbol is used to start a formula in a spreadsheet?

• *

• -

• +

• =

Which function would you use to find the average of a set of numbers?

• mean

• mode

• median

• total

What is the purpose of a 'row' in a spreadsheet?

• To display data vertically in a spreadsheet.

• To represent categories of data without specific records.

• To organize and display data horizontally, representing individual records.

• To create formulas and calculations only.

What is the purpose of a 'column' in a spreadsheet?

• To format text in different colors.

• To create formulas for calculations.

• To display data horizontally.

• To organize and categorize data vertically.

How can you sort data in a spreadsheet?

• Right-click and select 'Delete' to remove data.

• Use the 'Filter' function in the 'View' menu.

• Select the data range, then use the 'Sort' function in the 'Data' menu.

• Copy and paste the data into a new spreadsheet.

What does the 'SUM' function do in a spreadsheet?

• The 'SUM' function finds the average of numbers.

• The 'SUM' function adds numbers together.

• The 'SUM' function multiplies numbers together.

• The 'SUM' function subtracts one number from another.