Understanding Averages and Formatting in Spreadsheets

What is the first step to perform a mathematical operation in a spreadsheet?

• Use the toolbar to select a function

• Highlight the cells and press the equals sign

• Right-click the cell and choose 'Calculate'

• Type the operation directly into the cell

How do you specify which cells to include in an average calculation?

• By using the 'Select All' button

• By highlighting the cells you want to average

• By typing the cell addresses manually

• By entering the cell values directly

Why is it important to close the formula with a bracket when calculating an average?

• To ensure the formula is complete

• To make the spreadsheet look neat

• To prevent the spreadsheet from crashing

• To automatically save the document

How can you apply the same formula to multiple cells quickly?

• By dragging the formula down from the corner of the cell

• By copying and pasting the formula

• By typing the formula in each cell

• By using the 'AutoFill' button

What is the purpose of formatting numbers to two decimal places in a spreadsheet?

• To make the numbers easier to read

• To make the spreadsheet more colorful

• To save space in the spreadsheet

• To ensure accuracy when measuring time