Question

Answer the following questions in same file.
1: In which tab, password protection button is present in excel?
2: Which key is used to change data in an active cell?
3: Write steps to apply conditional formatting.
4: How do you save a spreadsheet?
5: How will you write a formula in a cell? Give example.
6: What is the difference between cut- paste and copy- paste?
7: Write shortcut keys for moving the data.
8: Which tab contains Font group?

Answer 1

protect sheet :- from this option we can lock the sheet by a password 2. To move the active cell down, use the enter key, and to move it up, use shift + enter. To move the active cell right, use tab. And to move the active cell left, use shift + tab. You can rotate the active cell through the 4 corners of your selection using Control + period 3.conditional formating from this option we can show the records to the condition that apply in the condition formating box 4.Right-click the worksheet name tab.

Click select Move or Copy.

Click on the Move selected sheets to Book drop-down menu. Select (new book).

Click OK. Your new workbook opens with your moved worksheet. ...

Click File > Save in your new workbook.