Introduction to Spreadsheets Quiz

What is a spreadsheet used for?

• Drawing pictures

• Organizing and calculating data

• Making phone calls

• Writing essays

Which symbol is used to start a formula in most spreadsheet programs?

• +

• =

• #

• *

What is a cell in a spreadsheet?

• A type of chart

• The name of a sheet

• A single box where a row and column meet

• A heading

What is a row in a spreadsheet?

• A vertical group of cells

• A diagonal set of boxes

• A horizontal group of cells

• A title box

What is a column in a spreadsheet?

• A set of numbers

• A vertical group of cells

• A paragraph

• A chart

Which function is used to add several numbers together?

• ADD

• TOTAL

• SUM

• PLUS

What does the formula =A1+B1 do?

• Deletes values in A1 and B1

• Multiplies the values

• Adds the values in cells A1 and B1

• Divides the values

Which symbol is used to subtract one number from another in a spreadsheet?

• /

• -

• =

• *

Which symbol is used for division in spreadsheet formulas?

• :

• *

• ÷

• /

What is the fill handle used for?

• Deleting content in cells

• Copying and extending formulas or values

• Changing the background color

• Highlighting rows