BOP State Test Review (2025-2026) Questions and
answers already passed
1. What can be added to a presentation to add Images
visual interest and help to convey a
specific message?
Freeze Panes
2. Which feature keeps certain rows or columns
visible while scrolling through a large
worksheet?
3. What is a saved collection of formatting
characteristics Style that can be applied to text,
tables, and lists in a docu- ment?
4. Which symbol is used to indicate an absolute $B$8
cell ref- erence?
5. What feature provides an alternative to using absolute Named
Range
cell references in functions and formulas?
6. What is the process of rearranging Sorting
information in alphabetical, numerical, or
chronological order in a table?
7. What symbol, when pressed with the CTRL
'
key, dis- plays formulas in a worksheet?
8. What is an adjacent group of cells in a
spreadsheet called? Range
9. What is defaulted as the first slide when opening a new Title Slide
presentation file?
10. Which type of break is inserted to force text to 11. What feature
begin on the next page? changes the
appearance
1/
6
, BOP State Test Review (2025-2026) Questions and
answers already passed
of cell content when specified criteria is met? Page Break
Conditional Formatting
2/
6
answers already passed
1. What can be added to a presentation to add Images
visual interest and help to convey a
specific message?
Freeze Panes
2. Which feature keeps certain rows or columns
visible while scrolling through a large
worksheet?
3. What is a saved collection of formatting
characteristics Style that can be applied to text,
tables, and lists in a docu- ment?
4. Which symbol is used to indicate an absolute $B$8
cell ref- erence?
5. What feature provides an alternative to using absolute Named
Range
cell references in functions and formulas?
6. What is the process of rearranging Sorting
information in alphabetical, numerical, or
chronological order in a table?
7. What symbol, when pressed with the CTRL
'
key, dis- plays formulas in a worksheet?
8. What is an adjacent group of cells in a
spreadsheet called? Range
9. What is defaulted as the first slide when opening a new Title Slide
presentation file?
10. Which type of break is inserted to force text to 11. What feature
begin on the next page? changes the
appearance
1/
6
, BOP State Test Review (2025-2026) Questions and
answers already passed
of cell content when specified criteria is met? Page Break
Conditional Formatting
2/
6
