Aptech Finals

(Inside Microsoft Office-A671)

Which option can be used to prioritize notes in

OneNote?

• Sort the notes

• Tagging the notes

• Adding Links to the notebook

• Filter the notes

(Inside Microsoft Office-A671)

Which option of PowerPoint should a user use in case the same picture needs to be on all slides?

• Select all and CTRL + V

• Insert picture in each slide

• Handout Master

• Slide Master

(Inside Microsoft Office-A671)

Identify which of them is a part of exciting transition in

PowerPoint.

• Honeycomb

• Split

• Blinds

• Random Bars

(Inside Microsoft Office•A671)

Which option allows user to change the theme of the slide?

• Slide Master

• Animation

• Design

• Slide Sorter

(inside Microsoft Office-A671)

Which the PivotTable form displays subtotals at the top of each

group?

• Compact

• Tabular

• Collapse

• Outline

(Inside Microsoft Office-A671)

Which method allows user to analyse results or outcomes in different scenarios with the same set Of data?

• What-if analysis

• Pivot Table

• Conditional Formatting

• Sort and Filter

(Inside Microsoft Office•A671)

Which shortcut can be used to make any changes to the formula in Excel?

• Press F3

• Press Esc

• Press Alt+X

• Press F2

(Inside Microsoft Office-A671)

Identify the three types of sheet views available in MS

• Normal Layout View

• Page Layout View

• Zoom View

• Page Break Preview

(Inside Microsoft Office-A671)

What does Data Label in a chart specify?

• Names of the horizontal and axis

• Details of each data series

• Details Of each data series and enables to select the position Of values

• States what each data series stands for and also enables to decide the position of values and data

(Inside Microsoft Office-A671)

How can user prevent any external and unauthorized access to the PC?

• User Account Control

• Windows Firewall

• Windows Defender

• External Anti-Virus