Spreadsheets L1 - Final Review

Data stored in a series of rows and columns is called a:

• text document.

• presentation.

• graphics file.

• spreadsheet.

Which toolbar button is used to format cell data to a currency value?

• The button with a $ symbol

• The button with a % symbol

• The button with the italicized "I"

• The button with AZ and a downward arrow.

Alexandra has been asked to select cells C5:K5 during her spreadsheet lesson. What has Alexander's teacher asked her to select?

• A row range

• A column

• A column range

• A row

Oliver's teacher has shared multiple worksheets in the same spreadsheet file titled "Spreadsheets_Labs". The teacher asks Oliver to go to the "Budget" worksheet. When he opens the "Spreadsheets_Labs" file he initially sees the "Science Data" worksheet. How can Oliver go to the "Budget" worksheet?

• He must select the new worksheet tab to see the "Budget" worksheet.

• He needs to close the file and look for the "Budget" file in his directory.

• He can click the tab at the bottom of the file that represents the "Budget" worksheet.

• He can not view the "Budget" worksheet because there is only one worksheet allowed per spreadsheet file.

Genesis wants the data in C3 through C13 to be copied into D3 through D13. Her partner shows her she can quickly do this by dragging the black dot or square known as the:

• paste pointer.

• row header

• fill handle.

• column header.

Francis must select cells A1 through A62. Which key would he press and hold if he wanted to select the range by clicking only the first and last cells?

• ESC

• CONTROL

• TAB

• SHIFT

Mr. Fielding has requested that all data in the science project spreadsheets display a number formatted with only one decimal place. Which of the following would be the correct way for his students to display data in the project?

• 234.10

• 2.12

• 234.1

• 23

Horatio has made a mistake with his spreadsheet. He has accidentally deleted the data in a cell. How would you describe the button that he could click on the toolbar to undo this mistake?

• A paint brush or roller.

• A backward-pointing arrow.

• A bold letter B.

• A forward-pointing arrow.

Maria is inputting a birthday into a cell for a spreadsheet about her friends and family. She types in:

May 7, 1975

What is the default display for this date in most popular spreadsheet programs?

• 5-7-1975

• May-7-1975

• 7 May 1975

• 7-May-75

You created a spreadsheet with a list of the students in your class and contact information for them. For which task should you use the Filter function to display the desired result?

• You want to display the list of students in your class.

• You want to reorder the list of students by last name in ascending order.

• You want to reorder the list of students by date of birth in descending order.

• You want to display a list of the students who live in a particular city