USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
F1
|
|
|
F4
|
|
|
F8
|
|
|
F10
|
Detailed explanation-1: -Ctrl +F1 – Displays or hide the ribbon of Excel. By hiding the ribbon only tab names will be displayed on the ribbon. Alternate way of obtaining this result is by clicking on the ribbon display button on the Excel spreadsheet.
Detailed explanation-2: -F12 Key. “F12” key opens the “Save As” dialog box to save your current open excel workbook. You can also use “Alt + F2” for same output.
Detailed explanation-3: -Press CTRL+A. Note If the worksheet contains data, and the active cell is above or to the right of the data, pressing CTRL+A selects the current region. Pressing CTRL+A a second time selects the entire worksheet.
Detailed explanation-4: -Finally, if you want to quickly move to the first or last sheet in a workbook, you can press Ctrl+Home or Ctrl+End, respectively. These shortcuts will take you to the first or last cell in the worksheet, but you can press Ctrl+PgUp or Ctrl+PgDn to move to the first or last sheet, respectively.