Fun with Spreadsheets

What is a spreadsheet used for?

• Writing code

• Designing websites

• A spreadsheet is used for organizing and analyzing data.

• Creating presentations

Name one common software used for spreadsheets.

• Notepad

• Microsoft Word

• Microsoft Excel

• Adobe Photoshop

What is a cell in a spreadsheet?

• A cell is a graphical representation of data.

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

• A cell is a type of spreadsheet formula.

• A cell is a section of a spreadsheet that cannot hold data.

How do you add numbers in a spreadsheet?

• Drag and drop numbers into the cell to sum them.

• Use the SUM function or type '=' followed by numbers separated by '+'.

• Click on the cell and press 'Add' from the toolbar.

• Use the AVERAGE function to add numbers.

What symbol is used to start a formula?

• *

• =

• +

• -

What is the purpose of a header row?

• To provide a footer for the table.

• To summarize the data in the table.

• To display images related to the data.

• To label the columns of a table and provide context for the data.

How can you sort data in a spreadsheet?

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

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

• Copy the data to a new document and rearrange it manually.

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

What does the SUM function do?

• The SUM function sorts a list of numbers in ascending order.

• The SUM function finds the average of a set of numbers.

• The SUM function counts the number of entries in a dataset.

• The SUM function calculates the total of a set of numbers.

How do you change the color of a cell?

• Double-click the cell to open a color palette.

• Use the keyboard shortcut Ctrl + C to copy the cell color.

• Right-click the cell and select 'Change Color' from the menu.

• Select the cell, then choose a fill color from the formatting options.

What is a chart in a spreadsheet?

• A method for sorting data in a spreadsheet.

• A visual representation of data in a spreadsheet.

• A type of formula used in calculations.

• A tool for creating text documents within a spreadsheet.