C268 Spreadsheets TEST QUESTIONS WITH
VERIFIED ANSWERS
Fill Feature - ✔✔Select cell, Home tab, Edit Group, Fill Button, Series button
AutoFill Feature - ✔✔Similar to Fill Feature; Select chosen cells, Home tab, Edit Group, Fill
Button, Series Button, AutoFill Feature
Resize Cells - ✔✔Select cell, Home tab, Cell Group, Format Button
Hide & Unhide Feature - ✔✔Select Column/Row, Home Tab, Cell Group, Format Button, Hide
& Unhide Button
Insert Worksheet Feature - ✔✔Home Tab, Cell Group, Insert Button, Insert Sheet Button
Delete Worksheet Feature - ✔✔Select Cell in Worksheet, Home Tab, Cell Group, Delete
Button, Delete Sheet
Reuse Cell Format Feature - ✔✔Select Cell, Home Tab, Clipboard Group, Format Painter
Button, Select Destination Cell
Clear Cell Format Feature - ✔✔Select Cell, Home Tab, Editing Group, Clear Formats Button
Page Headers/Footers Feature - ✔✔Page Layout Tab, Page Setup Group, Print Titles Button,
Header/Footer tab in popup window
Sorting Feature - ✔✔Select Cell, Data Tab, Sort & Filter group, Quick Sort Ascending Button
OR Sort Button (for multiple sorts)
VERIFIED ANSWERS
Fill Feature - ✔✔Select cell, Home tab, Edit Group, Fill Button, Series button
AutoFill Feature - ✔✔Similar to Fill Feature; Select chosen cells, Home tab, Edit Group, Fill
Button, Series Button, AutoFill Feature
Resize Cells - ✔✔Select cell, Home tab, Cell Group, Format Button
Hide & Unhide Feature - ✔✔Select Column/Row, Home Tab, Cell Group, Format Button, Hide
& Unhide Button
Insert Worksheet Feature - ✔✔Home Tab, Cell Group, Insert Button, Insert Sheet Button
Delete Worksheet Feature - ✔✔Select Cell in Worksheet, Home Tab, Cell Group, Delete
Button, Delete Sheet
Reuse Cell Format Feature - ✔✔Select Cell, Home Tab, Clipboard Group, Format Painter
Button, Select Destination Cell
Clear Cell Format Feature - ✔✔Select Cell, Home Tab, Editing Group, Clear Formats Button
Page Headers/Footers Feature - ✔✔Page Layout Tab, Page Setup Group, Print Titles Button,
Header/Footer tab in popup window
Sorting Feature - ✔✔Select Cell, Data Tab, Sort & Filter group, Quick Sort Ascending Button
OR Sort Button (for multiple sorts)
