SP_Lesson1 Modern Spreadsheets

Monica is learning about spreadsheets. Which of the following describes where each piece of data exists in a spreadsheet?

• database

• cell

• name box

• c

How are rows identified in a spreadsheet?

• numbers

• letters

• Roman numerals

• colors

Lee is working in a spreadsheet. His boss told him to change the data in C23. Which part of the cell address represents the column?

• C2

• 3

• C

• 23

Rod is working with his partner on a spreadsheet project for Science class. His partner wants him to make changes to some data. What does Rod need to know to change the correct data?

• column heading

• row heading name

• cell reference

• Cell range

What feature should Sheila use so that all cell data in column B looks like a 1/24/2024?

• Time

• Date

• Number

• Text

Mario needs to rearrange the rows by placing the last names of each American president in Column D in alphabetical order. What feature should he use?

• Sorting

• Centering

• Filtering

• Aligning

How can users customize spreadsheets to only display data that meets certain criteria?

• Copy the data

• filter the data

• align the data

• sort the data

Bill needs to fix a problem in his spreadsheet. The content in a few cells spills over into the next cell. He doesn't want to change the column width or use the clip feature. What other feature can he use?

• Paint

• Formatting

• Text wrapping

• Filtering

Imagine you want to select many random cells across your spreadsheet. What key do you need to press while clicking each cell with your mouse to do this?

• Shift

• Ctrl

• Alt

• Ent

What is one thing Autofill can do?

• Populate cells with a series of content.

• Copy the format of another cell.

• Overwrite copied content.

• Copy cell content