FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
A
Close
B
Save
C
Save As
D
Exit
Explanation: 

Detailed explanation-1: -Click File > Save in your new workbook. Tip: You can also save your Excel workbook with the keyboard shortcut, Ctrl + S.

Detailed explanation-2: -If you want to rename a workbook, first locate it in Windows Explorer, then you can press F2, or right-click and select Rename, then type the new name. If your workbook is already open, then you can go to File > Save As to save the workbook with a different name. This will create a copy of the existing workbook.

Detailed explanation-3: -On the File tab, click Save As. To save the workbook to a different location, specify the drive and location in the file path and folder boxes. In the File name box, accept the suggested name or type a new name for the workbook. In the Save as type list, click the format that you know you can open in the other program.

Detailed explanation-4: -Press and release Alt+H+O+R, type a new name, and press Enter to rename the active worksheet. Double-click the current worksheet’s name, type a new name, and press the Enter key. Right-click the current worksheet’s name, select Rename, type a new name, and press the Enter key.

There is 1 question to complete.