Quiz › Excel Basics › Sheets and workbooks

Sheets and workbooks: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

Can two sheets in one workbook have the same name?
- A. Yes
- B. No
Show the answer
B — No. Every sheet name in a workbook must be different.
Can a formula use a cell from another sheet?
- A. Yes
- B. No
Show the answer
A — Yes. Yes. For example =Sheet2!A1.
Can you hide a column without deleting it?
- A. Yes
- B. No
Show the answer
A — Yes. Right-click the column letter → Hide. Unhide brings it back.
Does =sum(a1:a5) in small letters still work?
- A. Yes
- B. No
Show the answer
A — Yes. Excel does not mind small or capital letters in a formula.
Can you move a sheet into another workbook?
- A. Yes
- B. No
Show the answer
A — Yes. Right-click the sheet tab → Move or Copy.