What are the six formatting command available in exel 2016
Answers
Answer:
MARK me as the brainiest if satisfactory and follow me for more better answers ☺️
Explanation:
To change the font size:
Select the cell(s) you want to modify.
Selecting a cell
On the Home tab, click the drop-down arrow next to the Font Size command, then select the desired font size. In our example, we will choose 24 to make the text larger.
Selecting a font size in the dropdown menu
The text will change to the selected font size.
The selected cell is a larger font size now
You can also use the Increase Font Size and Decrease Font Size commands or enter a custom font size using your keyboard.
The custom font box, increase font size button, and decrease font size button
To 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.
Selecting a cell
On the Home tab, click the drop-down arrow next to the Font command, then select the desired font. In our example, we'll choose Century Gothic.
Selecting a font in the dropdown menu
The text will change to the selected font.
The selected cell is a different font now
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 color:
Select the cell(s) you want to modify.
Selecting a cell
On the Home tab, click the drop-down arrow next to the Font Color command, then select the desired font color. In our example, we'll choose Green.
Selecting a color in the dropdown menu
The text will change to the selected font color.
The selected cell is a different color now
Select More Colors at the bottom of the menu to access additional color options. We've changed the font color to a bright pink.
Selecting more colors.
To use the Bold, Italic, and Underline commands:
Select the cell(s) you want to modify.
Selecting a cell
Click the Bold (B), Italic (I), or Underline (U) command on the Home tab. In our example, we'll make the selected cells bold.
Clicking the Bold button
The selected style will be applied to the text.
The selected cell is now bold
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.
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 fill color:
Select the cell(s) you want to modify.
Selecting cells
On the Home tab, click the drop-down arrow next to the Fill Color command, then select the fill color you want to use. In our example, we'll choose a dark gray.
The Fill Color dropdown menu
The selected fill color will appear in the selected cells. We've also changed the font color to white to make it more readable with this dark fill color.
The fill color has been applied to the selected cells
To add a border:
Select the cell(s) you want to modify.
Selecting cells
On the Home tab, click the drop-down arrow next to the Borders command, then select the border style you want to use. In our example, we'll choose to display All Borders.
Borders dropdown menu
The selected border style will appear.
The borders have been applied to the selected cells
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.
The Draw Borders submenu
Cell styles
Instead of formatting cells manually, you can use Excel's predesigned cell styles. Cell styles are a quick way to include professional formatting for different parts of your workbook, such as titles and headers.
To apply a cell style:
In our example, we'll apply a new cell style to our existing title and header cells.
Select the cell(s) you want to modify.
Selecting cells
Click the Cell Styles command on the Home tab, then choose the desired style from the drop-down menu.
The cell styles dropdown menu
The selected cell style will appear.
The cell style has been applied to the selected cells
Applying a cell style will replace any existing cell formatting except for text alignment. You may not want to use cell styles if you've already added a lot of formatting to your workbook.
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.
Answer:
hope it helps you
Explanation:
mark my answer as brainlist