BOP State Exam Review | Questions & Answers (100 %Score) Latest Updated 2024/2025
Comprehensive Questions A+ Graded Answers | With Expert Solutions
What can be added to a presentation to add visual interest and help to convey a specific
message? - Images
Which feature keeps certain rows or columns visible while scrolling through a large
worksheet? - Freeze Panes
What is a saved collection of formatting characteristics that can be applied to text,
tables, and lists in a document? - Style
Which symbol is used to indicate an absolute cell reference? - $B$8
What feature provides an alternative to using absolute cell references in functions and
formulas? - Named Range
What is the process of rearranging information in alphabetical, numerical, or
chronological order in a table? - Sorting
What symbol, when pressed with the CTRL key, displays formulas in a worksheet? - '
What is an adjacent group of cells in a spreadsheet called? - Range
What is defaulted as the first slide when opening a new presentation file? - Title Slide
Which type of break is inserted to force text to begin on the next page? - Page Break
What feature changes the appearance of cell content when specified criteria is met? -
Conditional Formatting
In a presentation, where can the style and layout of a slide be changed simultaneously?
- Slide Master
Which page feature enables a worksheet to be printed on a specific number of pages? -
Scaling
Which function allows the user to combine multiple cells into one string? - Concatenate
What is used to change the arrangement of content placeholders? - Slide Layouts
What is used to copy formatting from one place and apply it to another? - Format
Painter
Comprehensive Questions A+ Graded Answers | With Expert Solutions
What can be added to a presentation to add visual interest and help to convey a specific
message? - Images
Which feature keeps certain rows or columns visible while scrolling through a large
worksheet? - Freeze Panes
What is a saved collection of formatting characteristics that can be applied to text,
tables, and lists in a document? - Style
Which symbol is used to indicate an absolute cell reference? - $B$8
What feature provides an alternative to using absolute cell references in functions and
formulas? - Named Range
What is the process of rearranging information in alphabetical, numerical, or
chronological order in a table? - Sorting
What symbol, when pressed with the CTRL key, displays formulas in a worksheet? - '
What is an adjacent group of cells in a spreadsheet called? - Range
What is defaulted as the first slide when opening a new presentation file? - Title Slide
Which type of break is inserted to force text to begin on the next page? - Page Break
What feature changes the appearance of cell content when specified criteria is met? -
Conditional Formatting
In a presentation, where can the style and layout of a slide be changed simultaneously?
- Slide Master
Which page feature enables a worksheet to be printed on a specific number of pages? -
Scaling
Which function allows the user to combine multiple cells into one string? - Concatenate
What is used to change the arrangement of content placeholders? - Slide Layouts
What is used to copy formatting from one place and apply it to another? - Format
Painter
