BOS End of Level State Exam Prep

What option is used to reposition the content placeholders on a slide?

• Styles

• Slide Layouts

• View Options

• Rearrange Slides

What feature in a document processing program (Microsoft Word) has rows, borders, and columns?

• Pictures

• Graphs

• Tables

• SmartArt

In a spreadsheet (Excel) this feature will change one long string of text into multiple lines in ONE cell

• Multiple

• Wrap text

• Repeat

• Double space

To quickly copy formatting (text colors, alignment, font, etc.,) and apply it to other text you use what feature?

• format painter
• cut and paste

• page break

• remove duplicates

In a presentation, where can you customize the style and layout of the entire presentation?

• Slide Layout
• Normal View
• Slide Sorter
• Slide Master

What are each individual "pages" of a Power Point called?

• Sheet
• Page
• Slide
• Paper

What formula would I use to find the minimum value in a specific range?

• =IF(b4:h8)

• =SUM(a1:a5, "Green")

• =MIN(A6:P9)

• =MAX(A9:b4)

What would the formula =IF(A2>50, "Fail", "Pass") do?

• COUNT the numbers in the range

• Check to see if the number in cell A2 is greater than 50. If it is then it will add the word "Fail" in the cell. If it is not greater than 50, it will return the word "Pass".

• Finds the largest number in the range

• Adds the numbers in the range and then makes sure they are larger than "50".

This Excel function returns one or two values based on a logical test

• IF

• Filter

• SUM

• Conditional formatting

This function finds a specific VALUE in a table based on a cell's value

• MIN

• LOOKUP

• FIND

• DATABASE