Elsie is quizzing herself on the different chart types in preparation for her spreadsheets exam. The flashcard she is looking at states, "Which type of chart is used to represent data as segments of a whole". What term is written on the other side of Elsie's flash card?

Consider the data in the example spreadsheet:

What can you determine about the highlighted data in Rows 2, 3, and 5?

Braydon is working with a partner building a spreadsheet. The partner uses the cell reference $B7 in one of his formulas. What would not change in the formula cell if it is copied and moved by Braydon?

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

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?

Rows within a spreadsheet are identified by:

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

Study the image. Which function is calculating the value in cell B6?

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?

Garret wants to add all of the values from cell C7 through C21. Which spreadsheet function should he use?

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?

Gwen has a great idea for documenting the growth of the bean sprout she planted in her science class. She wants to create a chart that tracks vertical plant growth on a weekly measurement schedule. Which type of chart would be best for Gwen to use to track the plant growth?

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

Derrick has created a spreadsheet that displays the results of a science experiment for Mrs. Blue's class. He needs to write a formula that displays the highest cell value within a data range. Which formula would produce the correct result?

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?

Carlos has created a large spreadsheet for class. The spreadsheet contains multiple columns and rows of data. Some of the data has not been entered and is therefore blank. What can Carlos do so that the empty cells will be highlighted in yellow until data is entered?

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

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

Bjorn has created a large spreadsheet that contains multiple columns and rows of data. His boss has requested that he ensure there are no duplicate values in the spreadsheet. What could Bjorn use to automatically highlight cells containing specific text within his spreadsheet?

Chris has taken a complete inventory of the student store. For each inventory item he has documented the item name, initial count of the item at the beginning of the school year, current count, purchase price, selling price, total value of inventory of the item, and the source it was purchased from. The principal wants to know how many pencils are available. What can Chris use that easily sorts, filters and calculates the spreadsheet data?

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

What value would be the result of the formula =A2/B2 in the spreadsheet shown?

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:

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?

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?

Which statement about charts is true?

This entry is an example of which data format?

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?

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?

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?

Consider the following formula:

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

Helen used a formula to calculate values using the data in Column A and the data in Column B. Which formula did Helen use in Column C to produce the result in Cell C1?

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?

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:

Which example would be formatted as text in a spreadsheet?

Which of the following is an example of an absolute cell reference?

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?

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

Rosie's group has done some conditional formatting to their budget project. Which rows display the results of the conditional formatting?

Column A contains 12 student names. Column B contains each student's weight. Which formula would calculate the average weight of all 12 of the students?

Which example is a spreadsheet time format?

Jude is unsure what the data in his group's column chart represents. There are two colored columns and he is unsure which color represents his data set. Which chart element would Jude use to identify what each color represents on the chart?

Which chart element identifies the data series that each color represents on the chart?

Which formula would produce the average of the values in cells D5 through D9?

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

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

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?

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?

Which of the following allows a user to easily sort multiple series of data?

Which type of chart would be appropriate if you want to show how some particular data changes over time to illustrate a trend?

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?

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?

Which function is used to total the values of a series of cells?

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 formula would calculate the average number of shots taken, as shown in the spreadsheet?

Which type of chart compares the quantities or amounts in a series of cells?

Which formula would produce an exponent?

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:

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?

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:

What is a spreadsheet?

Serena wants to add the numbers appearing in cells D3:D9 and then place the result in cell D10. What function should she use in cell D10 to get the desired result?

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?

Gary wants a graphical representation of his project data that illustrates the relationships between time and height. What should Gary use to represent this data?

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?

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 column shown is sorted numerically?

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:

Sharla wants the cube of the number from C5 to be displayed in D5. Which formula would she use in D5 to produce the number using the exponent?

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

Study the image.

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

Study the example. Which type of chart is shown?

Study the example. Which type of chart is shown?

Columns within a spreadsheet are identified by:

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.

Tyrell has a spreadsheet consisting of four colu...be all the data. How can Tyrell accomplish this?

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 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?

Which type of chart is divided into portions representing data percentages?

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?

Which example is an absolute cell reference that would not change the column and row when moved?

Charles is working with several team members on the same spreadsheet. He wants to use an absolute cell reference for the data in cell C7 in one of his formulas. Which of the following is an example of how he would make this absolute cell reference?

Which row in this spreadsheet has been merged?

Darryl found this formula in his group's science spreadsheet.

Which menu is used to create a new spreadsheet?

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

Ella has recorded monthly expenses in her budget spreadsheet project. She needs to add all of the dollar amounts in the cell range of F4:F14 and then display the results in cell F16. What should Ella do to perform this task?

Mr. Robinson has asked his class to give an example of how to find the sum from data ranges. Felix raises his hand. When called upon, he states that:

Aman wants to multiply the values in cells B2 and B3, and then divide the total by the value in cell D7. Which of the following would be the correct formula?

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?

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

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

Which example is a spreadsheet date format?

Which choice correctly identifies the label of the horizontal axis on the chart shown?

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?

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?

What will be the result of this function?

Study the example. Which of the following is displayed?

Which value would produce the widest column?

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?

In a horizontal bar chart, which bar represents the greatest amount or value of the data being illustrated?

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?

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?

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?

Which value would produce the shortest row?

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

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

Study the following example table:

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:

Which formula would produce the sum of cells J5 through J9?

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

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

Benjamin needs to create a table with employee information regarding only Bryan, Ashley, and Andrew using the data shown. Which cell range should he select in order to create a table that includes the required data located in this spreadsheet?

Which of the following lists the types of charts shown in the correct order?

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

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

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?

Macey has a spreadsheet containing data about the total number of students participating in different sports in her school. She wants to graphically show the relative popularity of each sport. Which type of chart should she choose?

Which toolbar button is used to add borders to a cell or series of cells 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?