Moore Computer Chapter 6
cwilia
GradeforChapter6.docx|
Step |
Instruction |
Earned |
Possible |
|
1 |
Start Excel. Download and open the file named TIA_Ch6_Start.xlsx. |
|
0 |
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 |
15 |
|
|
|
|
|
|
|
3 |
Sort the data by multiple levels: Style (A to Z), Processor Speed (Largest to Smallest), and RAM (Largest to Smallest) |
|
0 |
15 |
|
|
|
|
|
|
|
4 |
Filter the data to display Intel i7 processors and 12 and 16 GB RAM. |
|
15 |
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. |
|
10.455 |
15 |
|
|
|
|
|
|
|
6 |
On the Choices worksheet, wrap the text in cells A1:M1. |
|
0 |
10 |
|
|
|
|
|
|
|
7 |
On the Choices worksheet, change the width of columns C, H, I, J, K, L to 9 |
|
7 |
7 |
|
|
|
|
|
|
|
8 |
On the Choices worksheet, resize the width of columns D, E, G, and M to 12. |
|
7 |
7 |
|
|
|
|
|
|
|
9 |
Select cells A5:M5, and change the Fill Color to Yellow. |
|
3 |
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 |
10 |
|
|
|
|
|
|
|
11 |
Save and close the file and then exit Excel. Submit the file as directed. |
|
|
|
