Mastering Office 2019 Skills

What is the shortcut to bold text in Word?

• Ctrl + U

• Ctrl + I

• Ctrl + B

• Ctrl + A

How do you create a pie chart in Excel?

• Select your data, go to 'File' > 'New Chart', and choose a template.

• Select your data, go to 'Insert' > 'Pie Chart', and choose a style.

• Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.

• Highlight your data, click on 'Data' > 'Chart Options', and pick a design.

What feature allows you to add animations to slides in PowerPoint?

• Slide Show tab

• Transitions tab

• Animations tab

• Design tab

Where can you find templates in Word?

• In the 'Edit' menu under 'Templates'.

• In the 'View' menu under 'Layouts'.

• In the 'File' menu under 'New'.

• In the 'Help' menu under 'Resources'.

What function would you use to calculate the average in Excel?

• COUNT

• AVERAGE

• SUM

• MAX

How do you apply a slide transition in PowerPoint?

• Click on the 'File' tab and select 'Save As' to apply transitions.

• Go to the 'Design' tab and choose a background style.

• Right-click the slide and select 'Add Transition' from the menu.

• Select the slide, go to the 'Transitions' tab, choose a transition effect, and apply it.

What is the purpose of the ribbon tool in Office applications?

• The purpose of the ribbon tool is to organize and provide easy access to commands and features in Office applications.

• To save documents automatically without user input.

• To create new documents in Office applications.

• To change the color scheme of the application interface.

How do you save a document in Word?

• Click 'Edit', then 'Save', and choose a template.

• Click 'File', then 'Save' or 'Save As', choose location, enter file name, and click 'Save'.

• Select 'View', then 'Export' to save the document.

• Press 'Ctrl + P' to print the document.

What steps do you take to open an existing Excel file?

• Select 'New' from the 'File' menu.

• Click on 'Save As' to open a file.

• Open an existing Excel file by using the 'File' menu and selecting 'Open'.

• Use the 'Insert' tab to access existing files.

How do you exit the PowerPoint application?

• Click 'Edit' > 'Close'

• Click 'File' > 'Exit' or use 'Alt + F4'.

• Select 'Help' > 'About'

• Press 'Ctrl + S' to save and exit