Microsoft Office and Block Coding Quiz

What is the primary function of Microsoft Excel?

• Create documents

• Manage email

• Organize and analyze data with spreadsheets

• Design websites

Which of the following is considered part of Excel’s “common tools in a workbook”?

• Slide sorter

• Formula bar

• Animation pane

• Presentation view

Which formula correctly sums the values in cells A1 to A5?

• =SUM(A1-A5)

• =SUM(A1:A5)

• =ADD(A1,A5)

• =TOTAL(A1-A5)

What is Microsoft PowerPoint mainly used for?

• Sending emails

• Calculating budgets

• Creating slide-based presentations

• Writing reports

Which menu allows you to change the design theme or slide orientation?

• File

• Home

• Design or Slide Size settings

• Review

When viewing a presentation, which pane lets you preview all slides in thumb-nail view?

• Slide Show pane

• Notes pane

• Slides navigation pane

• Animation pane

Pro tip for effective slide design includes all EXCEPT:

• Using high-contrast text

• Cluttering slides with too much text

• Applying consistent fonts and styles

• Breaking content into bullet points

How do you add motion to text or objects on a slide?

• File → Animate

• Home → Format

• Animations tab → Select object → Choose effect

• View → Animation

Why is sequencing important in block coding?

• Because sprites must wear costumes

• Because the order of blocks affects how the program runs

• Because all blocks look the same

• Because coding is always random

Which type of block is used to repeat a set of instructions?

• Motion block

• Loop block

• Event block

• Variable block