Select the range E6:E11, and then use the Flash Fill button (in the Editing group on the Home tab)

Name: Steps 2-4 of Module 1: End of Module Project 1
Uploaded: 2024-02-17T01:31:08Z

Question

Enter the values shown in Table 1 into the corresponding cells in the range B8:C11.

Table 1: Data for the Range B8:C11

 	B	C
8	Yvonne Byrom	2018
9	Fiona Hernandez	2020
10	Taisha Zygmont	2021
11	Jared Sandor	2021

Adjust the width of Column B using AutoFit.
In cell E6, enter the following: AFS51EZ21

Select the range E6:E11, and then use the Flash Fill button (in the Editing group on the Home tab) to automatically enter codes into the remaining cells in the range. (Hint: You must use the Flash Fill button to properly receive credit for this step.)

davidap · Answer

Fill in the value in respective cells and given in table. Type Yvonne Byrom in cell B8, 2018 in C8 and so on as shown in video below.
Move your mouse at the top of column B. Hover between column B and C and double click.
Enter AFS51EZ21 in cell E6. Now select cell E6, hold shift key and click E11 to select E6:E11. Go to Home tab > Under Editing ground, select Fill button > Click flash fill

here is a video tutorial

Select the range E6:E11, and then use the Flash Fill button (in the Editing group on the Home tab)

Answers

Post your answer

Recommended Books