Rows within a spreadsheet are identified by:

Consider the following entry in a spreadsheet cell:

December 25, 2015

This entry is an example of which data format?

Patricia's partner Alex has shared a spreadsheet he created. On the first row he has given the spreadsheet a title. The title appears in the cell located in the first column even though the spreadsheet is five columns wide. What can Patricia do so that the title appears centered in the first row above the five columns?

Which value would produce the shortest row?

Which example represents cell data with the date format applied to it?

Allison and her group have completed the data entry for their spreadsheet project. They are in the process of formatting the data to make it easier to read and understand. The title is located in cell A5. The group has decided to merge cells A3:A7 to attempt to center the title over the data. After the merge, Allison points out that it is not centered and looks bad. Where would the title appear if Allison unmerged the cells in an attempt to fix the title problem?

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?

Yolanda has created a spreadsheet containing student information about her homeroom class. She wants to color-code various parts of the spreadsheet so that the title in Row 1 appears on a blue background, the column headers in Row 2 appear on a pale green background, and the student data appears on a pale yellow background. How can she accomplish this task?

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

Study the image.

Which example shows a number formatted as text by entering a single quote at the start of the cell value?

You have entered a date function in a cell. Now you want to change the format to display the day of the week rather than the date, month and year. In what part of a spreadsheet can you display the function in order to make the necessary changes?

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:

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:

The spreadsheet that Anthony has created contains a great deal of data. The first time he prints the sheet he is disappointed. The lines separating the cells that appear on his screen do not appear on the print out. How can Anthony apply visible lines to his spreadsheet that separate the cells that contain?

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?

What is the quickest way to resize a column in your spreadsheet to fit the largest item in that column?

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?

Mr. Ibanez has shared a spreadsheet with his students. The first column is blank. The second column contains names in random order in cells B3:B13. Additional data is located in columns C and D. He asks the students to alphabetize the names in descending order while maintaining the correlating data. The students correctly highlight cell range B3:D13 and then:

Dora is reviewing her completed spreadsheet and decides she needs to add another column of information between the existing Columns C and D. What is the quickest way for Dora to insert the new column?

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?

James needs to select multiple cells that are directly next to one another. Identify which key James should press and hold that will allow him to select multiple adjacent cells at once.

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?

When you insert a column in a spreadsheet, where does the new column appear?

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?

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

Columns within a spreadsheet are identified by:

Which of the following examples has been formatted as a time in the active cell?

Which tool allows a user to display specific criteria within a cell range?

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 menu is used to create a new spreadsheet?

Which example is a spreadsheet time format?

Victor has selected the cell range A3:D7 in this worksheet. Which option would allow Victor to sort the data in descending alphabetical order according to state?

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

You want to copy data from one cell or range to an adjacent cell or range in your spreadsheet, without using a shortcut key. Which of the following can you drag on your spreadsheet to do this?

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?

Mr. Trumbull has shared a spreadsheet with the class. He has asked the students to shade every other row light grey to make the data easier to read. What should his students do in order to complete this task?

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

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?

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:

Finn creates a spreadsheet of simple information about the students in his class. The data includes name, eye color, hair color, age and height. For which task would Finn use the Filter function to display desired results from his spreadsheet?

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?

Todd overwrote data in a spreadsheet cell, then realized he needed it. He used the Undo feature to change it back to the original value. Then he decided that he wanted the newer value after all. How can Todd most quickly redisplay the newer value?

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?

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?

Kara has selected the cell range A1:D8 in the worksheet shown. Which option would allow Kara to sort the data in alphabetical order according to the employees' first names?

Identify the keyboard shortcut that will allow a user to copy data within a cell.

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:

Which toolbar button is used to add borders to a cell or series of cells in a spreadsheet?

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

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

Which value would produce the widest column?

Which choice contains only numeric data (except for the commas)?

Which example would be formatted as text in a spreadsheet?

Tyrell has a spreadsheet consisting of four columns (A, B, C, and D) and 30 rows. He wants to make Row 1 a header row that contains Columns A through D so that he can add a title to describe all the data. How can Tyrell accomplish this?

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

Carla’s group is working on a spreadsheet of experiment data for her science class. She wants to add a new column of additional data in the middle of the existing eight columns, A through H. Which of the following columns should Carla select to insert the new column in the middle?

Which example shows a number formatted with two decimal places within a spreadsheet?

What is a spreadsheet?

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:

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

Ahmed needs to restock the student store at his school. He is going to the local warehouse store and wants to find out what items have come from there. The inventory is a spreadsheet. He has an alphabetical list of items from the school store in column A. In Column B, he has the name of the store that the items were purchased from. Which option would allow Ahmed to sort the data in alphabetical order according to the name of the store from which the items were purchased?

Isabelle needs to select cells A2, C2 and D2, and change them to the Currency format. Which key does Isabelle need to press and hold while selecting the cells so she can format all of the cells at one time?

Which example is a spreadsheet date format?

Rosalind needs to undo a change she just made in her spreadsheet. Which toolbar button should she use?

Hilda has created a spreadsheet of the inventory of her family's kitchen. She wants to make a grocery list based on items that are at zero. Which tool allows Hilda to display specific criteria (such as items that are at zero) within a cell range of her inventory?

Which row in this spreadsheet has been merged?

Shannon is trying to make everything on her spreadsheet more compact. There is a lot of empty space in her cells. What is quick way Shannon can resize a whole column to only be as wide as the largest item in that column?

Ellen highlights the data in the range A10:A20 in her spreadsheet. She presses CTRL+X. She then uses the mouse to select cells H10:H20, and presses CTRL+V. What operation did Ellen just perform?

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?

Which column shown is sorted numerically?

Which example represents cell data with the currency format applied to it?

Aaron merged cells A1:G1 in his spreadsheet, and entered text in the resulting cell. Aaron then unmerged the cell. What happened to the text that was in the merged cell?

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?

Ringo is helping Paul re-create a spreadsheet that was handed out by Mrs. Leonard. Paul realizes that he forgot to add a whole column of data. He needs to add the missing column between column E and F. What would Ringo recommend that Paul do?

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:

Where should you right click to add more rows or columns to your spreadsheet?

Which of the following precedes numbers that are formatted as US currency?

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?