4. Answer the following questions: a) How will you change the font type of a selected cell? b) How will you add border to a cell? c) Differentiate between font colour and fill colour options. d) Discuss the various horizontal alignment options present in MS Excel. e) Define functions. Discuss about the text functions present in MS excel
Answers
- Answer:
- 1) Select the cell(s) you want to modify. Selecting a cell.
- 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. ...
- The text will change to the selected font.
2)
Follow these steps to add cell borders:
Select the cells you want to format.
Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. ...
Click the type of line you want to apply to the selected cells.
3} : The fill colour is the same as highlight and the font colour changes the colour of the words. Font color is the color of the letters. Highlight color is the color of a word or words that also includes the white spaces between the letters
4)The Alignment tab of the Format Cells dialog box. There are eight different settings you can use for horizontal alignment, each of which deserves explanation.
Setting Horizontal Alignment
General.
Left.
Center.
Right.
Fill.
Justify.
Center Across Selection. ...
Distributed.
.5}Microsoft Excel provides 3 text functions to convert between UPPER, lower and Proper case. UPPER(text) - converts all characters in a specified text string to upper case. LOWER(text) - changes all uppercase letters in a text string to lowercase.
pls thank me and mark me brainiest please