Grader - Instructions
Excel 2022 Project
TIA_XL_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
TIA18e_Ch6_SolveThis_Start.xlsx
. Grader has automatically added
your last name to the beginning of the filename.
0
2
On the Data worksheet, format the range A1:M41 as a Table, with
Blue, Table Style Medium 9.
18
3
Sort the data by the following: Style (A to Z), Processor Speed
(Largest to Smallest), and RAM (Largest to Smallest).
17
4
Filter the data to display Intel i7 processors and 12 and 16 GB RAM.
19
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.
15
7
On the Choices worksheet, change the width of columns C, H, I, J, K,
L to
9
0
8
On the Choices worksheet, resize the width of columns D, E, G, and M
to
12
.
0
9
Select cells A5:M5, and change the
Fill Color to Yellow to indicate the
laptop that best fits your needs.
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: 05/05/2023
1
TIA18_XL_CH06 - Laptop Alternatives 1.0
