Manipulating Worksheets (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
What Excel preserves when moving/copying cells
What Excel preserves when moving/copying cells
Formulas, formatting, and comments
Best method for moving data within same worksheet
Best method for moving data within same worksheet
Drag-and-drop
Purpose of Paste Special feature
Purpose of Paste Special feature
Copy results of formulas without copying formulas themselves
Purpose of Freeze Top Row
Purpose of Freeze Top Row
Keeps first row visible, perfect for column headers
Purpose of Freeze First Column
Purpose of Freeze First Column
Keeps leftmost column visible, ideal for row labels
Three main freezing options in Excel
Three main freezing options in Excel
Freeze Panes, Freeze Top Row, Freeze First Column
Two steps in protection process
Two steps in protection process
Lock cells first, then protect the worksheet
Default state of cell locking in Excel
Default state of cell locking in Excel
All cells are set to locked by default
Three print scope options in Excel
Three print scope options in Excel
Print Active Sheets, Print Entire Workbook, Print Selection
Best orientation for spreadsheets with many columns
Best orientation for spreadsheets with many columns
Landscape orientation