Hiding a column does not remove the data

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. You hide column C, which has phone numbers, then email the spreadsheet. Are the phone numbers still in the file?

A Yes, hidden data is still stored in the file

B No, hiding a column removes the data

2. Which action really removes a column of personal data from a spreadsheet?

A Hide the column

B Delete the column

3. Your friend receives a spreadsheet with column B hidden. Can they see the data in column B?

A Yes, they can unhide the column

B No, hidden columns can never be shown again

4. What is the safest way to share a class list WITHOUT home addresses?

A Delete the address column from a copy, then share the copy

B Hide the address column, then share the file

5. Column D is hidden. How can you tell a column is hidden?

A The column is deleted, so nothing is missing

B The column letters skip from C to E

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Right-click column C > Hide		ASelect columns B to D > Right-click > Unhide
2Right-click column C > Delete		BMakes column C invisible on screen, but all of its data is still stored in the file
3Anyone who receives the file can bring a hidden column back into view		CRemoves column C and all of its data from the file for good
4A hidden sheet and rows hidden by a filter still hold their data in the file		DHiding does not remove data. The phone numbers are still in the file and anyone can unhide the column.
5Hide the Phone column, then email the file. Phone numbers are now removed.		EA filter only hides rows from view. The data for those students is still in the file.
6Filter out rows for students under 13, then share the file. Their data is deleted.		FHidden sheet: Phones \| Filter: House = Red

Definitions

hidden column

Fill in the Blanks

Complete each line of code by filling in the missing parts.

HIDE column C dataInFile = ____

DELETE column C dataInFile = _____

HIDE column C =___(C2:C9) result is still calculated

HIDE column C SHARE file recipient can ______ column C

FILTER rows where year = 7 other rows are ______, not deleted

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Column D holds home addresses

B Hide column D

C D's data is gone from the file

Question 2

A Hide column C to remove data

B Save the file

C Column C is no longer in it

Question 3

A Right-click column B

B Unhide cannot show it again

C The data was there all along

Question 4

A Hide the sheet called Names

B Names sheet is now empty

C Anyone can unhide the sheet

Question 5

A Filter to hide rows for Year 7

B Share the file

C Filtered rows are deleted

Answer Key

Hiding a column does not remove the data

Section A: Quick Questions

A — Yes, hidden data is still stored in the file

B — Delete the column

A — Yes, they can unhide the column

A — Delete the address column from a copy, then share the copy

B — The column letters skip from C to E

Section B: Match the Pairs

Right-click column C > Hide → Makes column C invisible on screen, but all of its data is still stored in the file

Right-click column C > Delete → Removes column C and all of its data from the file for good

Anyone who receives the file can bring a hidden column back into view → Select columns B to D > Right-click > Unhide

A hidden sheet and rows hidden by a filter still hold their data in the file → Hidden sheet: Phones | Filter: House = Red

Hide the Phone column, then email the file. Phone numbers are now removed. → Hiding does not remove data. The phone numbers are still in the file and anyone can unhide the column.

Filter out rows for students under 13, then share the file. Their data is deleted. → A filter only hides rows from view. The data for those students is still in the file.

Section C: Definitions

hidden column — A hidden column is only out of sight. Its data stays in the file and is shared with it, and anyone can unhide it. Delete the column to really remove the data.

Section D: Fill in the Blanks

HIDE column C
dataInFile = TRUE

DELETE column C
dataInFile = FALSE

HIDE column C
=SUM(C2:C9)
result is still calculated

HIDE column C
SHARE file
recipient can UNHIDE column C

FILTER rows where year = 7
other rows are hidden, not deleted

Section E: Spot the Error

C — Hiding a column only puts it out of sight. The data is still in the file, so line 3 should say D's data is still in the file.

A — Hiding does not remove data. To really remove it you must delete the column, so line 1 should say Delete column C.

B — Anyone can unhide a hidden column and see its data again. Line 2 should say Choose Unhide to see it again.

B — A hidden sheet still holds all of its data. It is only out of sight, so line 2 should say the sheet still holds data.

C — Filtering only hides rows from view. The rows are still in the file and are shared with it, so line 3 should say they still hold data.