What is a spreadsheet?

Vera is an accountant. She decides to use a spreadsheet program to keep track of profit and loss data for her customer. Why did she make this choice?

Rows within a spreadsheet are identified by:

Columns within a spreadsheet are identified by:

You have created a spreadsheet containing information about each of your classmates. You have included each person's name, home address, phone number and age. One such record for a person would typically be contained in:

Which menu is used to create a new spreadsheet?

Tina has selected cells A1 through A25. Which of the following has Tina selected?

What is the most efficient way to access multiple worksheets in the same spreadsheet file?

What is the most efficient way to select multiple adjacent cells in your spreadsheet?

Abigail opens an attachment sent from one of her friends related to their science project. The document has their experiment data stored in a series of rows and columns. This is referred to as a:

Bernard is creating an inventory of his comic book collection. He has documented the title, publisher name, production year, and series number for each comic in his collection. He creates a spreadsheet of this information. Typically, each one of these categories, such as production year, would be contained in:

Christina wants to add a new worksheet to the workbook she has created to track her soccer team's statistics. The button she will use contains:

Abraham and his partner, Angela are developing a new card game. Abraham has written a long list of rules for the game. Each rule is written in a separate cell in a spreadsheet. Angela explains that this is not a good way to organize this information. She suggests that Abraham should use the spreadsheet to identify the points assigned to each card, and the points earned for each move in the game. Why would Angela suggest this?

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

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?

Which example would be formatted as text in a spreadsheet?

Denise has been asked to check the formatting on the spreadsheet that her group has completed. She needs to confirm that all field titles are formatted as text. Which of the following has she correctly formatted?

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?

Isaiah is collecting data on trains for a project at school. He is documenting each time a train passes by and blocks traffic. How should the data in his cells look if he has formatted the data as time?

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?

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:

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?

Jermaine has started an inventory spreadsheet for all of the items in the school store. He is unsure of any of the individual item costs, so he will set all of them at zero and input the correct data later. How would the cost of each item be displayed if he has formatted the cost field as US currency?

Charlotte selects the cell A1, types her name, and presses enter. How will Charlotte see her name aligned in the cell A1?

Stewart's teacher says that he may only use data that is numeric in the shared template for his project spreadsheet. Which of the following may he NOT use if he is restricted to numeric data?

Harold is working on a science project that includes a spreadsheet containing calculated results based on the data. An obviously incorrect result is being calculated and displayed. The data is correct, but the formula must be flawed. To get the correct information, Harold clicks on the cell containing the incorrect results and adjusts information contained in the:

Troy wants to select multiple cells, including adjacent and nonadjacent cells, using the mouse and keyboard in his spreadsheet. He then plans on shading them yellow for emphasis. Which key does he need to press and hold while selecting the desired cells so he can shade all of the cells at one time?

Noah is trying to clean up his partner's spreadsheet. Noah wants to move the data from the range B1:B13 to the range C5:C18. What keystrokes should he make to quickly make this move?

Austin has independently selected individual cells in his spreadsheet and then, as a group, shaded them all pink. It took a long time to select the cells. He then wants to put new data in cell A1. After inputting the data he realizes that the data is not needed. Austin then accidentally clicks the Undo button twice. This not only removes the data from A1 but also all of the pink shading. What can Austin do to quickly restore the pink shading to the cells?