Q.1 Which tool in PowerPoint should a user apply to align objects on slides while creating presentations?
A. Align
B. Grid
C. Guides
D. Gridlines
Q.2 Which
option of PowerPoint should a user use in case the same picture needs to be
displayed on all slides?
A. Select all and
Ctrl+V
B. Insert a picture
in each slide
C. Handout
Master
D. Slide Master
Q.3 Which
option can be used to prioritize notes in OneNote?
A. Sort the
Notes
B. Tagging Notes
C. Adding links to
the Notebook
D. Filter the Notes
Q.4 Which
option of Outlook should a user use in case he wants to follow up on an email
later?
A. Groups
B. Add-ins
C. Quick Steps
D. Tag
Q.5 Which
option allows the user to change the theme of the slide?
A. Slide Master
B. Animation
C. Design
D. Slide Sorter
Q.6
_________ allows the user to organize slides in the presentation.
A. Slide navigation
pane
B. Sort
C. Rearrange
D. Backstage view
Q.7 Which
command can be used to replace the text in PowerPoint?
A. CTRL+R
B. CTRL+D
C. CTRL+A
D. CTRL+H
Q.8 Which
command allows the user to add sections between two slides?
A. Left-click and
select Add Section
B. Right-click and select Add
Section
C. Left-click and
select Reset Slide
D. Right-click and
select Reset Slide
Q.9 Where
can the user find the notebook pages in OneNote?
A. Left Pane
B. Home Tab
C. View Tab
D. Search Tab
Q.10 Identify
which is part of exciting Transitions in PowerPoint?
A. Honeycomb
B. Splits
C. Blind
D. Random Bars
Q.11
Smart messaging feature allows users to perform which of these tasks?
A. To conduct a
video call
B. To react to a
message with-fantastic reactions
C. To use @ mention to grab the
attention of other users
D. To share your
photos and videos while on call
Q.12
Suppose there are 15 members in your team and you have to mail them frequently.
Which option in MS Outlook would you choose to avoid typing their names every
day?
A. Create a Rule for
your team
B. Create a Group for your team
C. Create a Category
for your team
D. Create an Address
book for your team
Q.13
Where are the frequently used accessed folders are found in MS Outlook?
A. Inbox
B. Achieve
C. Favorites
D. Filter
Q.14
Which option of Skype should a user choose in case he/she wants to share the
document while on call?
A. Share your
desktop
B. Share your document
C. Share your
PowerPoint files
D. Share a window
Q.15
Which option would you choose if you are using Teams meeting when you have a
few members who are specially abled?
A. Translator
B. Immersive reader
C. Whiteboard
D. Poll
Q.16
OneDrive provides _______ GB of free storage.
A. 5
B. 2
C. 10
D. 20
Q.17
Identify the task that is part of reviewing a document in Word.
A. To track changes made in the
document
B. To correct
spelling errors
C. To add comments to
the document
D. To add text
effects
Q.18 How
can a single word be replaced in a Word document?
A. Double-click the
word and start typing
B. Cut the word and
start typing
C. Left-click the word and replace it
with the new one
D. Right-click the
word, cut it, and start typing
Q.19 xlsb
is an extension of which type of Excel file?
A. Excel Workbook
B. Excel Binary Workbook
C. Excel Add-in
D. DIF
Q.20
Identify the 3 types of sheet views available in MS Excel.
A. Normal layout view
B. Page layout view
C. Zoom view
D. Page break
preview
Q.21 In the
case of the
user’s system, which option should the user choose to activate it should the user
choose to get it activated?
A. Ask the
administrator to switch in ON remotely
C. The user should
check the Windows update and then reinstall Cortana
B. The user should
not accept the system if Cortana is not activated
D. The user can click the settings
icon on the left pane of Cortana and enable it by switching
the toggle to ON
Q.22 How the
can user prevent any external and unauthorized access to the PC?
A. User account
Control B.
Windows Firewall
C. Windows Defender D. External
Anti-Virus
Q.23
Which tab will be displayed when a specific object type is selected?
A. Quick Access Toolbar
B. Core Tabs
C. Contextual Tabs
D. Dialog Box
Launchers
Q.24
Which tab should a user use in case he/she wants to accommodate the content on
a page?
A. Document Area
B. Scales
C. Layout
D. Zoom Controls
Q.25
Which features of MS Word allow a user to change the theme of the document?
A. Theme
B. Design
C. Styles
D. Insert
Q.26
Which option of MS Word will a user use to illustrate a process?
A. Layout
B. List
C. SmartArt
D. Table
Q.27
Which option of the format tab allows the user to add a frame to the picture?
A. Adjust
B. Picture Styles
C. Arrange
D. Size
Q.28
Which extension indicates the saved file in a Word template file?
A. .dotx
B . . .docx
C. .dotm
D . . .doc
Q.29
Which command allows the user to format text and apply Bold or Italics to the
text?
A. Design
B. Rich text
Control
C. Plain text
Control
D. Format Painter
Q.30 How
will you use the Morph feature to improve your PowerPoint slides?
A. By adding
animation
B. By adding motion
C. By adding
Transition
D. By adding animation, motion, and
transitions
Q.31
Which feature of MSWord is used to organize the items of the same category?
A. Sort
B. Filter
C. Create Table
D. Create Lists
Q.32 What
is the function of File Explorer in Windows 10?
A. To access recent
files
B. To navigate to other folders and
documents stored in the computer
C. To manage the
file locations
D. To only access
frequently used images
Q.33
Identify the correct option that can be used to duplicate slides in PowerPoint.
A. Add a new slide
and select a similar layout
B. Right-click and select the duplicate
slide
C. Left-click and select
the duplicate slide
D. Insert duplicate
slide
Q.34
Select options that a user can use to protect data from tampering in Excel.
A. File Encryption
B. Restrict Access
C. Digital Signature
D. Restrict Sharing
Q.35
Which formatting option should be used to save zip codes in an Excel file?
A. Number
B. Custom
C. Text
D. Special
Q.36
Which operator produces a range that is the union of two ranges?
A. (+)
B. (:)
C. (,)
D. (*)
Q.37
Which method allows the user to analyze results or outcomes in different
scenarios with the same set of data?
A. What-If analysis
B. Pivot table
C. Conditional
formatting
D. Sort and Filter
Q.38
Which of the pivot table form displays subtotals at the top of each group?
A. Compact
B. Tabular
C. Collapse
D. Outline
Q.39 What
does Data Label in a chart specify?
A. Names of the
horizontal and vertical axis
B. Details of each
data series
C. Details of each data series and
enables to select of the position of values
D. States what each
data series stands for and also enables to decide the position of values and
data
Q.40 If
the user wants to get an answer for all numbers that are greater than 115 in
red color, which of these should he/she should apply?
A. Conditional formatting command
on the Format menu
B. Select all
numbers one by one that is greater than 115 and apply the red color
C. Use =if()
function
D. None of these
Q.41 How
can one use Microsoft Teams to collaborate with other participants?
A. By Sharing screen
B. By adding a poll option
C. By using a whiteboard
D. By sharing files and documents
Q.42
Which shortcut can be used to make any changes to the formula in Excel?
A. Press F3
B. Press ESC
C. Press Alt + X
D. Press F2
Q.43
Identify the newly introduced functions in Excel 2019.
A. MINIFS
B. CONCAT
C. BAHTTEXT
D. IFS
Q.44
Identify advantages of Analysis ToolPak.
A. For adding charts
B. For applying
pivot
C. For financial data analysis
D. For comparing the
data
Q.45 What
is the shortcut that can be used to add mathematical equations in your
document?
A. Ctrl+=
B. Ctrl+(Equation)=
C. Alt+(Equation)=
D. Alt+=
%20with%20answers%20and%20detailed%20solutions..jpg)
0 Comments