A+
C268 – Spreadsheets 2025/2026 Exam
Questions and Answers | 100% Solved
Fill Feature - 🧠ANSWER ✔✔Select cell, Home tab, Edit Group, Fill Button, Series
button
AutoFill Feature - 🧠ANSWER ✔✔Similar to Fill Feature; Select chosen cells,
Home tab, Edit Group, Fill Button, Series Button, AutoFill Feature
Resize Cells - 🧠ANSWER ✔✔Select cell, Home tab, Cell Group, Format Button
Hide & Unhide Feature - 🧠ANSWER ✔✔Select Column/Row, Home Tab, Cell
Group, Format Button, Hide & Unhide Button
Insert Worksheet Feature - 🧠ANSWER ✔✔Home Tab, Cell Group, Insert Button,
Insert Sheet Button
Delete Worksheet Feature - 🧠ANSWER ✔✔Select Cell in Worksheet, Home Tab,
Cell Group, Delete Button, Delete Sheet
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
Reuse Cell Format Feature - 🧠ANSWER ✔✔Select Cell, Home Tab, Clipboard
Group, Format Painter Button, Select Destination Cell
Clear Cell Format Feature - 🧠ANSWER ✔✔Select Cell, Home Tab, Editing
Group, Clear Formats Button
Page Headers/Footers Feature - 🧠ANSWER ✔✔Page Layout Tab, Page Setup
Group, Print Titles Button, Header/Footer tab in popup window
Sorting Feature - 🧠ANSWER ✔✔Select Cell, Data Tab, Sort & Filter group, Quick
Sort Ascending Button OR Sort Button (for multiple sorts)
Filter Feature - 🧠ANSWER ✔✔Select cell, Data Tab, Sort & Filter group, Filter
button
Relative Cells - 🧠ANSWER ✔✔A1, column and cell will change
Absolute Column Cell - 🧠ANSWER ✔✔$A1, only row is relative and will change
Absolute Row Cell - 🧠ANSWER ✔✔A$1, only column is relative and will change
Absolute Cell - 🧠ANSWER ✔✔$A$1, both column and row are absolute and will
NOT change
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
C268 – Spreadsheets 2025/2026 Exam
Questions and Answers | 100% Solved
Fill Feature - 🧠ANSWER ✔✔Select cell, Home tab, Edit Group, Fill Button, Series
button
AutoFill Feature - 🧠ANSWER ✔✔Similar to Fill Feature; Select chosen cells,
Home tab, Edit Group, Fill Button, Series Button, AutoFill Feature
Resize Cells - 🧠ANSWER ✔✔Select cell, Home tab, Cell Group, Format Button
Hide & Unhide Feature - 🧠ANSWER ✔✔Select Column/Row, Home Tab, Cell
Group, Format Button, Hide & Unhide Button
Insert Worksheet Feature - 🧠ANSWER ✔✔Home Tab, Cell Group, Insert Button,
Insert Sheet Button
Delete Worksheet Feature - 🧠ANSWER ✔✔Select Cell in Worksheet, Home Tab,
Cell Group, Delete Button, Delete Sheet
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
Reuse Cell Format Feature - 🧠ANSWER ✔✔Select Cell, Home Tab, Clipboard
Group, Format Painter Button, Select Destination Cell
Clear Cell Format Feature - 🧠ANSWER ✔✔Select Cell, Home Tab, Editing
Group, Clear Formats Button
Page Headers/Footers Feature - 🧠ANSWER ✔✔Page Layout Tab, Page Setup
Group, Print Titles Button, Header/Footer tab in popup window
Sorting Feature - 🧠ANSWER ✔✔Select Cell, Data Tab, Sort & Filter group, Quick
Sort Ascending Button OR Sort Button (for multiple sorts)
Filter Feature - 🧠ANSWER ✔✔Select cell, Data Tab, Sort & Filter group, Filter
button
Relative Cells - 🧠ANSWER ✔✔A1, column and cell will change
Absolute Column Cell - 🧠ANSWER ✔✔$A1, only row is relative and will change
Absolute Row Cell - 🧠ANSWER ✔✔A$1, only column is relative and will change
Absolute Cell - 🧠ANSWER ✔✔$A$1, both column and row are absolute and will
NOT change
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED