Suggest the solution for given situation in one word / line:-
a) Rohit is preparing monthly sales report with the help of spreadsheet.While typing the text is not accommodate within the column width. Which option should he use to make the text appear properly?
b) A mandrel wants to use shortcut tool for adding the values of a range of cells .Name this tool.
c) Deepaks wants to enter a value in the cell address formed by the intersection of the fifth column and the ninth row .Name the cell address.
Answers
Answer:
answer as below
Explanation:
option b
Explanation:
When you add text to a cell in your business spreadsheet, that cell will not widen automatically to accommodate your text unless you change a few settings. This behavior can be frustrating when you need to type long data values in a column in the column is too narrow to display all the data. Excel has several methods you can use to make columns wider using your mouse or by typing values into a dialog window.
Resize Using Dialog Window
1
Launch Microsoft Excel and open a spreadsheet that has data.
2
Click the column you would like to make wider. If you want to resize more than one column, press "Ctrl" and click additional columns to select them.
3
Click the ribbon's "Home" tab and find the ribbon’s Cells section. Click "Format" to display a format menu that displays multiple formatting options