Microsoft Excel 면접 질문과 답변
Ques 6. Is it possible to prevent someone from copying the cell from your worksheet?
Yes, it is possible. In order to protect your worksheet from getting copied, you need to go into Menu bar >Review > Protect sheet > Password. By entering password, you can secure your worksheet from getting copied by others.
Ques 7. How you can sum up the Rows and Column number quickly in the excel sheet?
By using SUM function you can get the total sum of the rows and columns, in an excel worksheet.
Ques 8. How you can add a new excel worksheet?
To add a new Excel worksheet you have to insert worksheet tab at the bottom of the screen.
Ques 9. How you can resize the column in MS Excel?
To resize the column you have to change the width of one column and then drag the boundary on the right side of the column heading till the width you want. The other way of doing it is to select the Format from the home tab, and in Format you have to select AUTOFIT COLUMN WIDTH under cell section. On clicking on this the cell size will get formatted.
Ques 10. What are three report formats that are available in Excel?
- Compact
- Report
- Tabular
Most helpful rated by users:
- What is Microsoft Excel?
- What is ribbon?
- How can I hide or show the ribbon?
- How can you wrap the text within a cell?
- Is it possible to prevent someone from copying the cell from your worksheet?