Spreadsheet Explorers

What is the purpose of a spreadsheet?

• To bake cookies

• To organize and analyze data

• To write a novel

• To fly a plane

Name three basic functions of a spreadsheet.

• Data visualization, sorting, and formatting

• Word processing, graphic design, and database management

• Data storage, calculation, and analysis

• Communication, project management, and scheduling

How do you create a new cell in a spreadsheet?

• Right-click on the cell and select 'Delete'

• Double-click on the cell and press the 'Backspace' key

• Click on the cell and press the 'Insert' key

• Press the 'Enter' key to create a new cell below the current one

Explain the process of formatting a cell in a spreadsheet.

• Use a calculator to change the cell content

• Use the formatting options in the toolbar or right-click menu to change the visual properties of the cell.

• Delete the cell instead of formatting it

• Ask a colleague to format the cell for you

What is the function of the 'sum' formula in a spreadsheet?

• To find the average of a range of numbers

• To multiply a range of numbers

• To add up a range of numbers

• To sort a range of numbers

How can you change the font style and size of a cell in a spreadsheet?

• Change the font style and size in the 'Page Layout' tab

• Use the 'Paint' option in the toolbar

• Use the 'Font' or 'Format' options in the toolbar or menu

• Double-click on the cell to change the font style and size

What is the purpose of merging cells in a spreadsheet?

• To separate data into different cells

• To delete the cells from the spreadsheet

• To combine multiple cells into one larger cell

• To change the font style of the cells

Explain the process of adding a border to a cell in a spreadsheet.

• Select the cell or range of cells, then go to the 'Borders' option in the formatting toolbar and choose the type of border you want to apply.

• Open a new spreadsheet to add a border

• Use the 'Fill Color' option to create a border

• Right-click on the cell and select 'Add Border'

How can you apply conditional formatting to a range of cells in a spreadsheet?

• Type the conditions directly into the cells

• Use the 'Insert' menu to add conditional formatting

• Apply conditional formatting individually to each cell

• Select the range of cells, then go to the 'Format' or 'Conditional Formatting' menu to apply the conditions and formatting options.