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

Study the image.

FIGURE: A

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

Which example is a spreadsheet date format?

Which example is a spreadsheet time format?

Consider the following entry in a spreadsheet cell:

December 25, 2015

This entry is an example of which data format?

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

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.

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

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?

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?

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 choice contains only numeric data (except for the commas)?

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?

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?

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

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

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

Which column shown is sorted numerically?

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 tool allows a user to display specific criteria within a cell range?

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?

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?

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?

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:

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?

Which value would produce the widest column?

Which value would produce the shortest row?

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

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