Shahi Limos wants that Total profit for each car and Net profit should be shown
distinctively in the worksheet. What would you suggest them to do?
Answers
o change the font:
By default, the font of each new workbook is set to Calibri. However, Excel provides many other fonts you can use to customize your cell text. In the example below, we'll format our title cell to help distinguish it from the rest of the worksheet.
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Click the drop-down arrow next to the Font command on the Home tab. The Font drop-down menu will appear.
Select the desired font. A live preview of the new font will appear as you hover the mouse over different options. In our example, we'll choose Georgia.
Screenshot of Excel 2013
The text will change to the selected font.
Screenshot of Excel 2013
When creating a workbook in the workplace, you'll want to select a font that is easy to read. Along with Calibri, standard reading fonts include Cambria, Times New Roman, and Arial.
To change the font size:
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Click the drop-down arrow next to the Font Size command on the Home tab. The Font Size drop-down menu will appear.
Select the desired font size. A live preview of the new font size will appear as you hover the mouse over different options. In our example, we will choose 16 to make the text larger.
Screenshot of Excel 2013
The text will change to the selected font size.
Screenshot of Excel 2013
You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard.
Screenshot of Excel 2013
To change the font color:
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Click the drop-down arrow next to the Font Color command on the Home tab. The Color menu will appear.
Select the desired font color. A live preview of the new font color will appear as you hover the mouse over different options. In our example, we'll choose Green.
Screenshot of Excel 2013
The text will change to the selected font color.
Screenshot of Excel 2013
Select More Colors at the bottom of the menu to access additional color options.
Screenshot of Excel 2013
To use the Bold, Italic, and Underline commands:
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Click the Bold (B), Italic (I), or Underline (U) command on the Home tab. In our example, we'll make the selected cells bold.
Screenshot of Excel 2013
The selected style will be applied to the text.
Screenshot of Excel 2013
You can also press Ctrl+B on your keyboard to make selected text bold, Ctrl+I to apply italics, and Ctrl+U to apply an underline.
Text alignment
By default, any text entered into your worksheet will be aligned to the bottom-left of a cell, while any numbers will be aligned to the bottom-right. Changing the alignment of your cell content allows you to choose how the content is displayed in any cell, which can make your cell content easier to read.
Click the arrows in the slideshow below to learn more about the different text alignment options.
Screenshot of Excel 2013
Left align: Aligns content to the left border of the cell
123456
To change horizontal text alignment:
In our example below, we'll modify the alignment of our title cell to create a more polished look and further distinguish it from the rest of the worksheet.
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Select one of the three horizontal alignment commands on the Home tab. In our example, we'll choose Center Align.
Screenshot of Excel 2013
The text will realign.
Screenshot of Excel 2013
To change vertical text alignment:
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Select one of the three vertical alignment commands on the Home tab. In our example, we'll choose Middle Align.
Screenshot of Excel 2013
The text will realign.
Screenshot of Excel 2013
You can apply both vertical and horizontal alignment settings to any cell.
Cell borders and fill colors
Cell borders and fill colors allow you to create clear and defined boundaries for different sections of your worksheet. Below, we'll add cell borders and fill color to our header cells to help distinguish them from the rest of the worksheet.
To add a border:
Select the cell(s) you want to modify.
Screenshot of Excel 2013
Click the drop-down arrow next to the Borders command on the Home tab. The Borders drop-down menu will appear.
Select the border style you want to use. In our example, we will choose to display All Borders.
Screenshot of Excel 2013
The selected border style will appear.
Screenshot of Excel 2013
You can draw borders and change the line style and color of borders with the Draw Borders tools at the bottom of the Borders drop-down menu.
Answer:
in cell i5 you should type the formula =G5- H5 and copy this formula from I6 to I8