Warm Up: Basic Spreadsheet Functions and Formulas Assessment

What is the correct way to write a basic addition formula in a spreadsheet?

• =A1+B1

• +A1+B1

• (A1+B1)

• A1+B1=

How can you quickly resize a column width to fit its contents?

• Press the Delete key

• Double-click the right border of the column header

• Right-click and select "Format Cells"

• Click and drag the column header

Which symbol must always come first when writing a formula in a spreadsheet?

• #

• $

• =

• @

How do you create a sequence of numbers (like 2, 4, 6, 8) using the drag handle?

• Enter only the last number and drag

• Enter the first two numbers, select them, then drag the handle

• Right-click and select "Create Series"

• Double-click the cell corner

What is wrong with the function =Multiply(A2:A3)?

• The range should be separated by a comma, not a colon

• MULTIPLY is not a valid function, use * instead

• The parentheses are unnecessary

• The cell references are incorrect

Which formula would correctly multiply cells A1 and B1?

• A1xB1

• =A1B1

• =A1*B1

• =MULTIPLY(A1:B1)

To resize multiple columns to the same width simultaneously, you should:

• Press Ctrl+A first

• Select the columns, then double-click any divider between selected column headers

• Right-click and select "Standard Width"

• Use the Format menu only

What happens when you drag the fill handle of a cell containing "Monday"?

• It copies "Monday" to all cells

• It creates a series of weekdays

• It leaves the cells blank

• It shows an error message

Which formula would calculate the average of cells A1 through A5?

• =SUM(A1:A5)/5

• =AVERAGE(A1:A5)

• =MEAN(A1-A5)

• =(A1+A2+A3+A4+A5)/5

How can you make a cell wider by using only the mouse?

• Click the cell once and wait

• Right-click the cell border

• Click and drag the right border of the cell

• Double-click inside the cell