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+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+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+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.

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

Spreadsheets are very useful for manipulating videos and animations.

Spreadsheets are very useful for organizing large amounts of written text.

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

Click the tab at the bottom of the file that represents the worksheet you want to view.

Create a named custom view and open it for each sheet.

Select New Worksheet to access the worksheet you want to view.

Open multiple copies of the spreadsheet file and display a different worksheet in each copy of the file.

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

It will be aligned to the left side of the cell.

It will be aligned to the right side of the cell.

It will be aligned at the bottom of the cell.

It will be aligned in the center of the cell.

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

Select restore from the drop-down menu.

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

Display a list of the students who have brown eyes.

Display the list of students in her class.

Display cells that have spelling or grammar errors.

Reorder the list of students by name in ascending order.

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

Delete the original value and re-enter the newer value.

Highlight the cell and press CTRL+X.

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?

You want to display a list of the students who live in a particular city.

You want to reorder the list of students by last name in ascending order.

You want to reorder the list of students by date of birth in descending order.

You want to display the list of students in your class.

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

She moved the data from the range A10:A20 to the range H10:H20.

She deleted the data in both ranges A10:A20 and H10:H20.

She copied the data from the range A10:A20 to the range H10:H20.

She copied the data from the range H10:H20 to the range A10:A20.

Spreadsheet Essentials Lesson 1 Test Prep

Authored by Melissa Emschweiler

Computers

6th - 8th Grade

Used 16+ times

Spreadsheet Essentials Lesson 1 Test Prep

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View
Student View

56 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

123.0

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Record

Cell

Row

Range

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

ALT

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Microsoft

or continue with

Facebook

Apple

Others

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

53 questions

LATIHAN SOAL PTS

Quiz

•

7th Grade

54 questions

Ôn tập IC3 GS6 Level 1 (4)

Quiz

•

6th - 8th Grade

52 questions

Ulangkaji ASK Ting 2 Bab 3.1 Persekitaran Kod Arahan

Quiz

•

1st - 12th Grade

53 questions

الصف الثاني الإعدادي الترم الأول الفصل الثالث

Quiz

•

8th Grade

61 questions

Soal Ujian Informatika Kelas VIII

Quiz

•

8th Grade

60 questions

UNIT 4 TEST OS, Hardware and Software Systems

Quiz

•

5th - 9th Grade

51 questions

Belajar Bersama PAS Ganjil Kelas 7

Quiz

•

7th Grade

52 questions

KISI KISI Soal Ujian Struktur Data dan Logika

Quiz

•

8th Grade

Popular Resources on Wayground

21 questions

Continents and Oceans

Quiz

•

6th Grade

20 questions

Parts of Speech

Quiz

•

5th Grade

16 questions

Subject & Predicate

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

12 questions

Map Skills

Quiz

•

3rd Grade

22 questions

Continents and Oceans

Quiz

•

5th Grade

15 questions

Rounding Decimals

Quiz

•

5th Grade

20 questions

Brand Labels

Quiz

•

5th - 12th Grade

Discover more resources for Computers

20 questions

Digital Citizenship Review

Quiz

•

6th Grade

10 questions

Exploring Digital Citizenship Essentials

Interactive video

•

6th - 10th Grade

40 questions

Introduction to Microsoft Word

Quiz

•

8th - 12th Grade

20 questions

HTML Basics

Quiz

•

7th Grade

10 questions

Exploring Cybersecurity Techniques and Threats

Interactive video

•

6th - 10th Grade

15 questions

Keybaording

Quiz

•

7th Grade

18 questions

Company Logos

Quiz

•

6th - 8th Grade

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?

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?

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

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

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?

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

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?

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

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?

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers