Case: Poke Mart, Styling
Excel Case: Poke Mart, Styling
In this instance, the Poke Mart merchant needs assistance styling the shop cart overview. The formatting and stylistic techniques you have studied in the chapters will be put to use.
Have you resolved the initial case involving the Shop Cart? We’ll make use of that information again. Take a look at it right here.
The computations are not necessary to finish the case. Enter the information below:
Merchant: Whoa, what a blast! I am appreciative of your assistance. Sales have been dropping because of this boring shop cart. Let’s help it get up!
In order to finish this case, you must:
- Hide grids
- Add colors
- Change fonts
- Format numbers
- Finish the last calculation
Ready?
Start by removing the grids
- Click view
- Uncheck gridlines
Like this:
Make space for the heading by creating a new row 1.
- Right click row 1
- Insert new row
That’s the beginning! A new row 1 has been created by you.
The row height should be increased to 40 pixels to accommodate the header.
Note: When you begin to drag the border, you will see the border size box that shows the pixels.
- Set the boundary of Row 1 to 40 pixels.
Merge A1:D1 to create one big cell for the header.
- Select A1:D1
- Click the Merge button in the Ribbon
Great job! Now there is a big merged cell ready for the header.
Type Poke Mart in the merged range A1:D1
- Select A1:D1(click the merged range)
- Type Poke Mart
- Hit enter
The header font is a bit small, huh?
Change the header font to size 20 and make it Bold
- Select A1:D1 (the merged range)
- Change to font size 20
- Click the Bold command or use keyboard shortcut CTRL + B or Command + B
That is the method! The header looks better now.
Set the font for all cells to Arial and center the text for A2:F14.
- Click the angle icon in the sheet’s upper left corner to select all of the cells.
- Transform every font to Arial.
- Mark A2:F14
- Select the Ribbon’s Align button.
- Select the Align Center option.
Well done! All content has been retyped in Arial font and centered using A2:F14 alignment.
Now is the time to add some color.
- Select range A1:D1 (the merged cells)
- Apply standard Red color
- Select A2:D2
- Apply HEX code 2a75bb
- Select D3:D9
- Apply RGB code 255 203 5
- Select F12
- Apply HEX code ffcb05
The final two hues utilized are identical. RGB and HEX represent different color spaces.
For individuals who will be using the spreadsheet, it may be useful to color the input fields. In this instance, we used the color ffcb05 to indicate the input fields.
Next, change text colors
- Select A1:D4
- Change text color to white
- Select A2:A4
- Change text color to white
That is great! You got this.
Change the Number formats for the prices to Currency and remove the decimals.
- Select B3:C14
- Change Number format to Currency
- Click decrease decimals two times (2)
The final touch!
Add borders to make the numbers more readable.
- B11: Underline
- B14: Double bottom border
- E12:F12: Thick outside borders
- Select B11
- Add Underline border
- Select B14
- Add Double bottom border
- Select E12:F12
- Add Thick outside borders
Almost there!
Do the final calculation for total and add the final Bold fonts.
- Select B14
- Type =
- Select B11
- Type –
- Select B12
- Hit enter
- Select A14:B14
- Make the range bold
- Select A2:D2
- Make the range bold
Add test values:
- Type D3(5)
- Type D4(2)
- Type D6(5)
- Type D9(10)
Congratulations! You have successfully completed all tasks for the Poke Mart merchant.
- Hide grids – Check
- Add colors – Check
- Change fonts – Check
- Format numbers – Check
- Finish the last calculation – Check
Before and After
Before styling:
After styling:
Well done!
