Moore Computer Chapter 6
cwilia
TIA_E_CH06_Laptop_Alternatives_Instructions.docxGrader - Instructions Excel 2019 Project
TIA_E_CH06_Laptop_Alternatives
Project Description:
You are in need of a new laptop that is lightweight, but that has enough power to edit the videos you produce for your YouTube channel. You have asked a few of your friends for some suggestions. One friend put together a list of possible computers in an Excel workbook. You will sort the data, then filter the data to display only those computers you are interested in.
Steps to Perform:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel. Download and open the file named TIA_Ch6_Start.xlsx. |
0 |
|
2 |
On the Data worksheet, format the range A1:M41 as a Table, with Blue, Table Style Medium 9. Select Yes when asked to convert the selection to a table and remove all external connections. |
15 |
|
3 |
Sort the data by multiple levels: Style (A to Z), Processor Speed (Largest to Smallest), and RAM (Largest to Smallest) |
15 |
|
4 |
Filter the data to display Intel i7 processors and 12 and 16 GB RAM. |
15 |
|
5 |
Copy the header row and four rows that display after all filters have been applied. Open a new worksheet, and paste the copied data in Cell A1. Rename the worksheet Choices. Click the Data worksheet and press ESC to clear the selection. |
15 |
|
6 |
On the Choices worksheet, wrap the text in cells A1:M1. |
10 |
|
7 |
On the Choices worksheet, change the width of columns C, H, I, J, K, L to 9 |
7 |
|
8 |
On the Choices worksheet, resize the width of columns D, E, G, and M to 12. |
7 |
|
9 |
Select cells A5:M5, and change the Fill Color to Yellow. |
6 |
|
10 |
In cell A8, type The Toshiba Ultrabook is my choice as it has the most RAM, greatest storage capacity, and the best wireless standard of the four choices. |
10 |
|
11 |
Save and close the file and then exit Excel. Submit the file as directed. |
0 |
|
Total Points |
100 |
Created On: 03/26/2020 1 TIA16_E_CH06 - Laptop Alternatives 1.1
