Working with Multiple Sheets and References MCQs

1. Which symbol is used in Excel to refer to a cell from another worksheet?
(A) #
(B) !
(C) $
(D) &

2. How can you rename a worksheet in Excel?
(A) Double-click the sheet tab and type a new name
(B) Right-click the sheet tab → Delete
(C) Go to File → Rename Sheet
(D) Use Ctrl + R shortcut

3. If you want to create a reference from Sheet1 cell A1 to Sheet2 cell B2, which is correct?
(A) =A1!Sheet2
(B) =Sheet1!B2
(C) =Sheet2!B2
(D) =B2!Sheet1

4. Which shortcut key is used to quickly insert a new worksheet in Excel?
(A) Shift + F11
(B) Ctrl + N
(C) Ctrl + Shift + N
(D) Alt + Insert

5. What does 3D referencing in Excel mean?
(A) Referring to charts with 3D effect
(B) Protecting sheets with passwords
(C) Using 3D models in Excel
(D) Linking cells across multiple worksheets

6. Which of the following allows you to group multiple worksheets together?
(A) Press Shift and select sheets
(B) All of the above
(C) Right-click and choose “Select All Sheets”
(D) Press Ctrl and select sheets

7. When multiple sheets are grouped in Excel, any changes made to one sheet will:
(A) Apply to all grouped sheets
(B) Apply only to that sheet
(C) Delete the grouped sheets
(D) Protect the sheets automatically

8. To move a worksheet to another workbook, you use:
(A) Data → Move Sheet
(B) View → Switch Windows
(C) Right-click sheet tab → Move or Copy
(D) File → Export