Spreadsheet Essentials Lesson 1 Test Prep

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

• Spreadsheets are very useful for processing numeric data.
• Spreadsheets are very useful for manipulating HTML code.
• Spreadsheets are very useful for manipulating images and animations.
• Spreadsheets are very useful for processing text data.

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?

• The column header
• The row header
• The shortcut toolbar
• The formula bar

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

• $
• %
• I
• 123.0

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

• Record
• Cell
• Row
• Range

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

• She can click the tab at the bottom of the file that represents the "Budget" worksheet.
• She needs to close the file and look for the "Budget" file in her directory.
• She can not view the "Budget" worksheet because there is only one worksheet allowed per spreadsheet file.
• She must select the new worksheet tab to see the "Budget" worksheet.

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

• Press and hold the SHIFT key while clicking the mouse in each cell you want to select.
• Drag the mouse to select the range you want.
• Press and hold the CTRL key while clicking the mouse to select the range you want.
• Press and hold the ALT key while dragging the mouse to select the range you want.

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

• SHIFT
• CTRL
• FN
• ALT

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

• Sort by: Column D, Z → A
• Sort by: Row 3:7, A → Z
• Sort by: Row 3:7, Z → A
• Sort by: Column D, A → Z

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

• A row
• A row range
• A column
• A column range

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

• She should highlight the data in the range B1:B13 in her spreadsheet. She should then press CTRL+C. Finally, she should use the mouse to select cells C5:C18, and press CTRL+P.
• She should highlight the data in the range B1:B13 in her spreadsheet. She should then press CTRL+X. Finally, she should use the mouse to select cells C5:C18, and press CTRL+V.
• She should highlight the data in the range B1:B13 in her spreadsheet. She should then press CTRL+X. Finally, she should use the mouse to select cells C5:C18, and press CTRL+P.
• She should highlight the data in the range B1:B13 in her spreadsheet. She should then press CTRL+C. Finally, she should use the mouse to select cells C5:C18, and press CTRL+V.