Accenture | Common Applications

1. Common Applications

#### 1. What is a cloud-based application?

A. Software installed on a local server
B. Software hosted on a remote server
C. Application only for mobile devices
D. Software used for graphic design

#### 2. Which of the following is NOT a cloud storage service?

A. Google Drive
B. Dropbox
C. OneDrive
D. Adobe Photoshop

#### 3. Which of these is a popular project management tool?

A. Jira
B. Outlook
C. Chrome
D. Skype

#### 4. ERP stands for:

A. Enterprise Risk Program
B. Enterprise Resource Planning
C. Enhanced Resource Platform
D. Enterprise Return Planning

#### 5. Which tool is primarily used for team communication?

A. Trello
B. Slack
C. Excel
D. Google Sheets

#### 6. Which of the following is used for creating online surveys?

A. Google Forms
B. Excel
C. PowerPoint
D. Jira

#### 7. What is CRM software used for?

A. Managing customer relationships
B. Data storage
C. Designing websites
D. Financial planning

#### 8. Which one of the following is NOT a cloud-based software?

A. O ce 365
B. Google Docs
C. Microsoft Word (desktop)
D. Dropbox

#### 9. Jira is primarily used for:

A. Email communication
B. Task management
C. Video conferencing
D. Word processing
ffi
#### 10. Which of the following is a collaboration tool by Microsoft?
A. Trello
B. Slack
C. Teams
D. Jira

---

### **2. Microsoft Word**

#### 11. Which tab is used to insert a table in MS Word?
A. File
B. Home
C. Insert
D. View

#### 12. What feature allows you to see tracked changes in a Word document?
A. Review
B. Insert
C. Page Layout
D. Design

#### 13. Which shortcut is used to bold text in Word?

A. Ctrl + B
B. Ctrl + I
C. Ctrl + U
D. Ctrl + Shift + B

#### 14. To start a numbered list in MS Word, which tab do you use?
A. Home
B. Insert
C. References
D. Review

#### 15. What does the "Ctrl + E" shortcut do in Word?

A. Left align the text
B. Right align the text
C. Center the text
D. Justify the text

#### 16. Which of the following allows you to merge multiple documents into one in Word?
A. Mail Merge
B. Insert Merge
C. Data Merge
D. Document Merge

#### 17. What le format is typically used to save MS Word documents?

A. .xls
B. .docx
C. .ppt
D. .html

#### 18. Which key combination is used to save a Word document?

A. Ctrl + C
B. Ctrl + S
C. Ctrl + X
D. Ctrl + P

#### 19. How do you insert a header in MS Word?

A. Home -> Header
fi
 B. Insert -> Header
C. Review -> Header
D. View -> Header

#### 20. In MS Word, which feature automatically corrects common typing errors?
A. AutoComplete
B. AutoFormat
C. AutoCorrect
D. Spell Check

---

### **3. Microsoft Excel**

#### 21. Which of the following is used to create charts in Excel?
A. Data
B. Formulas
C. Insert
D. View

#### 22. What is the purpose of VLOOKUP in Excel?

A. Search for a value horizontally
B. Search for a value vertically
C. Add values from multiple cells
D. Format data

#### 23. What does the 'SUM' function do in Excel?

A. Sums all values in a range
B. Multiplies all values
C. Finds the average
D. Counts the number of cells

#### 24. In Excel, which of the following is used to apply a condition-based format to a cell?
A. Data Validation
B. Conditional Formatting
C. Pivot Table
D. Sort and Filter

#### 25. Which formula is used to calculate the average of a range of numbers in Excel?
A. =AVERAGE(A1:A10)
B. =SUM(A1:A10)/COUNT(A1:A10)
C. =AVERAGEIF(A1:A10)
D. =COUNT(A1:A10)

#### 26. What does a pivot table do in Excel?

A. Combines multiple worksheets
B. Summarizes and analyzes data
C. Creates graphs
D. Filters data

#### 27. What is the shortcut to create a new workbook in Excel?

A. Ctrl + N
B. Ctrl + W
C. Ctrl + O
D. Ctrl + S

#### 28. Which of the following is NOT a chart type in Excel?

A. Line Chart
B. Bar Chart
C. Pie Chart
D. Scatter Chart
#### 29. What does the CONCATENATE function do in Excel?
A. Adds two numbers
B. Combines text from multiple cells
C. Finds duplicates
D. Splits text

#### 30. Which key combination is used to insert a new worksheet in Excel?
A. Shift + F11
B. Ctrl + F11
C. Alt + Shift + F11
D. Ctrl + Shift + F11

---

### **4. Microsoft PowerPoint**

#### 31. Which le extension is used for PowerPoint presentations?
A. .pptx
B. .xls
C. .docx
D. .xlsx

#### 32. What is the primary purpose of Slide Master in PowerPoint?

A. To create a template for the presentation
B. To manage animations
C. To add sound e ects
D. To create graphs

#### 33. How do you insert a new slide in PowerPoint?

A. Insert -> Slide
B. Home -> New Slide
C. View -> Slide
D. Design -> Slide

#### 34. What is the shortcut to start a slideshow in PowerPoint?

A. F1
B. F5
C. F12
D. F7

#### 35. Which of the following is used to add transitions between slides in PowerPoint?
A. Transitions Tab
B. Animations Tab
C. Slide Show Tab
D. Design Tab

#### 36. Which of the following can be inserted into a PowerPoint slide?
A. Charts
B. Tables
C. Images
D. All of the above

#### 37. How do you add speaker notes in PowerPoint?

A. Home -> Notes
B. Insert -> Notes
C. View -> Notes
D. Slide Show -> Notes

#### 38. What is the purpose of animation in PowerPoint?

A. Add movement to slide elements
fi
ff
 B. Add themes to the presentation
C. Add sound e ects to the presentation
D. Change the background color

#### 39. Which tab is used to format the background of slides?

A. Home
B. Insert
C. Design
D. View

#### 40. Which key do you press to end a slideshow in PowerPoint?

A. Esc
B. F12
C. Ctrl + X
D. Alt + F4

---

### **5. Microsoft Outlook**

#### 41. What is Microsoft Outlook primarily used for?
A. Word processing
B. Email management
C. Creating spreadsheets
D. Presentations

#### 42. How do you create a new email in Outlook?

A. File -> New -> Mail Message
B. Home -> New Email
C. View -> New Email
D. Insert -> New Message

#### 43. In Outlook, what does the 'Reply All' function do?
A. Sends a reply only to the sender
B. Sends a reply to all recipients of the email
C. Forwards the email to new recipients
D. Deletes the email

#### 44. How do you schedule a meeting in Outlook?

A. File -> Meeting
B. Home -> New Meeting
C. Calendar -> New Meeting
D. Insert -> Meeting

#### 45. Which of the following is NOT a feature of Microsoft Outlook?

A. Calendar management
B. Task scheduling
C. Presentation creation
D. Email communication

#### 46. How can you mark an email as important in Outlook?

A. Right-click the email and choose “Important”
B. Use the red ag icon
C. Move it to the top of the inbox
D. Delete and recreate the email

#### 47. What is the purpose of "Rules" in Outlook?

A. Automatically sort and organize emails
B. Block spam messages
C. Create email signatures
D. Change the email theme
fl
ff
#### 48. What is an "Out of O ce" reply?
A. A scheduled email
B. A response sent automatically when the user is away
C. An email sent to all contacts
D. A template for meeting invites

#### 49. How do you search for an email in Outlook?

A. Go to the "Home" tab and click "Find"
B. Go to the "File" tab and click "Search"
C. Use the search bar at the top of the inbox
D. Go to the "Insert" tab and click "Find"

#### 50. How can you attach a le to an email in Outlook?

A. Home -> Insert
B. File -> Attach
C. Insert -> Attach File
D. View -> Insert File

#### 51. Which of the following is an example of Customer Relationship Management (CRM)
software?
A. Salesforce
B. Trello
C. WordPress
D. Canva

#### 52. What is the primary function of Google Drive?

A. Creating presentations
B. Managing databases
C. Cloud storage and le sharing
D. Task management

#### 53. Trello is best used for:

A. Email management
B. Word processing
C. Task tracking and project management
D. Financial accounting

#### 54. Which of the following is a feature of Slack?

A. Team messaging
B. File sharing
C. Integrating with other apps
D. All of the above

#### 55. Dropbox is mainly used for:

A. Video editing
B. File synchronization and sharing
C. Creating spreadsheets
D. Building websites

#### 56. What type of software is QuickBooks?

A. ERP
B. CRM
C. Accounting software
D. Database software

#### 57. Which of the following is not an example of collaboration software?

A. Microsoft Teams
B. Slack
C. Google Docs
fi
ffi
fi
 D. Adobe Illustrator

#### 58. Which of the following applications would you use to make a video call?
A. Jira
B. Zoom
C. WordPress
D. Google Drive

#### 59. A **Gantt chart** is often used in which type of software?

A. Accounting
B. Project management
C. Word processing
D. CRM

#### 60. Asana is commonly used for:

A. Social media marketing
B. Task and project management
C. Graphic design
D. Video conferencing

---

### **2. Microsoft Word**

#### 61. How can you add a hyperlink to text in a Word document?
A. Insert -> Hyperlink
B. View -> Hyperlink
C. Home -> Hyperlink
D. Design -> Hyperlink

#### 62. In MS Word, what does the "Ctrl + Z" shortcut do?
A. Redo the last action
B. Undo the last action
C. Save the document
D. Open a new document

#### 63. Which tab in MS Word would you use to add a watermark?
A. Home
B. Insert
C. Design
D. Review

#### 64. To add page numbers to a Word document, you would go to:
A. File -> Insert -> Page Number
B. Insert -> Page Number
C. Home -> Insert -> Page Number
D. View -> Page Number

#### 65. Which function in MS Word allows you to merge two documents together?
A. Document Merge
B. Combine Documents
C. Track Changes
D. Compare Documents

#### 66. How can you create a bulleted list in MS Word?

A. Review -> Bullets
B. Home -> Bullets
C. Insert -> Bullets
D. Layout -> Bullets

#### 67. How do you insert a footnote in MS Word?

 A. Insert -> Footnote
B. Review -> Footnote
C. References -> Footnote
D. Design -> Footnote

#### 68. How do you convert text into a table in Word?

A. Format -> Text to Table
B. Insert -> Table
C. Layout -> Text to Table
D. Insert -> Text to Table

#### 69. What is the default orientation of a Word document?

A. Portrait
B. Landscape
C. A4
D. Legal

#### 70. Which tab allows you to customize themes in a Word document?
A. View
B. Home
C. Design
D. Layout

---

### **3. Microsoft Excel**

#### 71. Which of the following functions is used to count the number of cells in a range that are
not empty?
A. COUNTIF
B. COUNTA
C. SUM
D. AVERAGE

#### 72. How do you freeze the top row of a worksheet in Excel?
A. View -> Freeze Panes -> Freeze Top Row
B. Insert -> Freeze Top Row
C. Data -> Freeze Top Row
D. Home -> Freeze Panes

#### 73. In Excel, what is the use of the 'IF' function?

A. It adds numbers
B. It applies conditional logic
C. It sorts data
D. It calculates the median

#### 74. What does the "Ctrl + Shift + $" shortcut do in Excel?
A. Converts text to number
B. Applies currency format
C. Calculates sum
D. Applies percentage format

#### 75. Which of the following is an example of a relative reference in Excel?

A. A1
B. $A$1
C. A$1
D. $A1

#### 76. Which Excel function can be used to nd the highest number in a range?
A. SUM
B. MAX
fi
 C. COUNT
D. MIN

#### 77. Which of these Excel features allows you to lter data in a table based on conditions?
A. Data Validation
B. Conditional Formatting
C. AutoFilter
D. Sorting

#### 78. What is the shortcut to select the entire worksheet in Excel?
A. Ctrl + A
B. Ctrl + E
C. Ctrl + Shift + A
D. Ctrl + Shift + E

#### 79. Which Excel function calculates the number of days between two dates?
A. DAYS
B. DATEDIFF
C. NETWORKDAYS
D. COUNTIF

#### 80. In Excel, what is the purpose of the CONCAT function?

A. It adds values
B. It combines text from multiple cells
C. It nds duplicates
D. It calculates an average

---

### **4. Microsoft PowerPoint**

#### 81. Which view allows you to see all slides at once in PowerPoint?
A. Slide Show
B. Outline View
C. Slide Sorter
D. Normal View

#### 82. How can you insert a video into a PowerPoint slide?
A. Insert -> Video
B. Design -> Video
C. File -> Insert Video
D. View -> Insert Video

#### 83. In PowerPoint, which of the following is a transition e ect?

A. Fade
B. Zoom
C. Flash
D. Spin

#### 84. Which tab allows you to add animations to slide elements?
A. Design
B. Transitions
C. Animations
D. Insert

#### 85. What is the use of slide master in PowerPoint?

A. To control the layout and design of all slides
B. To add text to slides
C. To create new slides
D. To insert images
fi
fi
ff
#### 86. Which of the following can be set as the background for a slide?
A. Color
B. Image
C. Texture
D. All of the above

#### 87. What does the "F7" key do in PowerPoint?

A. Opens a new presentation
B. Checks spelling
C. Starts a slideshow
D. Saves the presentation

#### 88. What does the "Ctrl + M" shortcut do in PowerPoint?

A. Open a new presentation
B. Insert a new slide
C. Start slideshow
D. Add animation

#### 89. In PowerPoint, which view is best for reorganizing slides?

A. Slide Sorter
B. Normal
C. Outline
D. Notes Page

#### 90. How do you apply the same transition to all slides in PowerPoint?
A. Select each slide and apply the transition
B. Click "Apply to All" in the Transitions tab
C. Click "Apply to All" in the Animations tab
D. Click "Transition to Slide" in the View tab

---

### **5. Microsoft Outlook**

#### 91. In Outlook, how can you mark an email as spam?
A. Move to the "Deleted" folder
B. Click "Junk" and select "Mark as Junk"
C. Move to the "Inbox" folder
D. Reply to the email with "Spam"

#### 92. How do you create a new folder in Outlook?

A. File -> New Folder
B. Home -> New Folder
C. Right-click on an existing folder and choose "New Folder"
D. View -> New Folder

#### 93. Which of the following can be attached to an Outlook email?

A. Files
B. Calendar invites
C. Images
D. All of the above

#### 94. In Outlook, what is the purpose of the calendar feature?

A. To create presentations
B. To send and receive emails
C. To schedule meetings and events
D. To organize tasks

#### 95. What does the "Ctrl + R" shortcut do in Outlook?

A. Reply to an email
B. Delete an email
 C. Forward an email
D. Refresh the inbox

#### 96. How can you delay sending an email in Outlook?

A. Use the "Delay Delivery" option
B. Use the "Send Later" feature
C. Create a rule to schedule sending
D. It is not possible to delay emails in Outlook

#### 97. How do you search for contacts in Outlook?

A. Click "People" and type the contact name in the search bar
B. Go to "File" -> "Search Contacts"
C. Use "Ctrl + F" in the inbox
D. Search under "Calendar"

#### 98. How can you set a recurring meeting in Outlook?

A. Select "New Meeting" and click "Recurrence"
B. Select "New Appointment" and choose "Repeat"
C. Create a task and click "Repeat"
D. Right-click the calendar and select "Set Recurring"

#### 99. What does the "Archive" function do in Outlook?

A. Deletes old emails
B. Moves emails to a designated archive folder
C. Marks emails as spam
D. Backs up emails to a cloud service

#### 100. How can you create an automatic email signature in Outlook?
A. File -> Options -> Mail -> Signatures
B. Home -> Signatures
C. Insert -> Signature
D. View -> Email Signature

#### 101. What is the primary use of Microsoft OneDrive?

A. Email management
B. File sharing and cloud storage
C. Project management
D. Video conferencing

#### 102. Which of the following is not a cloud storage service?

A. Dropbox
B. OneDrive
C. Google Drive
D. Adobe Reader

#### 103. What type of application is Google Meet?

A. Video conferencing
B. CRM
C. File sharing
D. Accounting software

#### 104. What is the purpose of Google Forms?

A. Creating quizzes and surveys
B. Word processing
C. Task management
D. Video editing

#### 105. Which of the following is a social media scheduling tool?

A. Asana
 B. Bu er
C. Excel
D. Google Calendar

#### 106. What type of software is Adobe Photoshop?

A. Video editing
B. Word processing
C. Image editing
D. Accounting

#### 107. What is the use of GitHub?

A. Storing and sharing code
B. Managing customer relationships
C. Creating presentations
D. Editing videos

#### 108. Which of the following allows for real-time collaboration on documents?
A. Microsoft Paint
B. Google Docs
C. Adobe Reader
D. VLC Media Player

#### 109. Which application is best suited for handling email marketing campaigns?
A. HubSpot
B. Final Cut Pro
C. Google Meet
D. Canva

#### 110. Which of the following is used for remote desktop access?
A. Trello
B. Zoom
C. Google Meet
D. TeamViewer

#### 111. What is the primary function of Adobe Acrobat?

A. Image editing
B. Creating PDF documents
C. Word processing
D. Video conferencing

#### 112. Which application is best for managing complex databases?

A. Microsoft Word
B. Microsoft Access
C. Adobe Photoshop
D. Google Drive

#### 113. What is the use of Evernote?

A. File sharing
B. Taking and organizing notes
C. Video conferencing
D. Creating presentations

#### 114. What type of software is Mailchimp?

A. CRM
B. Social media scheduling
C. Email marketing
D. File storage

#### 115. Which of the following applications is used for creating mind maps?
A. MindMeister
ff
 B. Outlook
C. Dropbox
D. Excel

#### 116. What is the purpose of Basecamp?

A. File storage
B. Video conferencing
C. Project management
D. Image editing

#### 117. Which of the following is an instant messaging app for businesses?
A. Google Slides
B. Slack
C. Gmail
D. Canva

#### 118. Which software allows for creating web-based surveys?

A. Google Forms
B. Zoom
C. Adobe Premiere
D. Excel

#### 119. What is a key feature of Google Sheets?

A. Cloud-based collaboration on spreadsheets
B. Editing videos
C. Creating presentations
D. Task management

#### 120. Which of the following is a website builder?

A. WordPress
B. PowerPoint
C. Outlook
D. Google Forms

---

### **2. Microsoft Word**

#### 121. In Word, which function is used to combine multiple cells in a table?
A. Merge Cells
B. Split Cells
C. Combine Cells
D. Insert Table

#### 122. Which view in MS Word is best for reading documents?

A. Print Layout
B. Web Layout
C. Read Mode
D. Outline View

#### 123. Which tab allows you to insert page breaks in Word?
A. Home
B. Insert
C. Layout
D. Design

#### 124. What does the “Track Changes” feature do in Word?

A. Tracks the word count
B. Highlights spelling mistakes
C. Monitors document revisions
D. Creates bookmarks
 #### 125. Which of the following shortcuts increases font size in Word?
A. Ctrl + B
B. Ctrl + ]
C. Ctrl + [
D. Ctrl + T

#### 126. What does the "Ctrl + F" shortcut do in Word?

A. Finds text in the document
B. Formats the document
C. Opens the save dialog
D. Fills color

#### 127. How can you convert a Word document into PDF format?
A. File -> Save As -> PDF
B. Home -> Convert to PDF
C. Insert -> Export as PDF
D. Layout -> PDF Export

#### 128. How can you add a header in Word?

A. View -> Header
B. Insert -> Header
C. Layout -> Header
D. Review -> Header

#### 129. What does the "Ctrl + P" shortcut do in Word?

A. Prints the document
B. Previews the document
C. Saves the document
D. Opens the Print Layout

#### 130. What does the Mail Merge feature in Word do?
A. Sends emails to multiple contacts
B. Merges multiple Word documents
C. Personalizes documents for multiple recipients
D. Combines multiple tables

---

### **3. Microsoft Excel**

#### 131. How do you quickly select an entire column in Excel?
A. Click the column header
B. Press Ctrl + C
C. Press Ctrl + Space
D. Press Alt + C

#### 132. What is the shortcut to create a new worksheet in Excel?

A. Ctrl + W
B. Ctrl + N
C. Shift + F11
D. Ctrl + Shift + T

#### 133. What does the VLOOKUP function do in Excel?

A. It nds and returns data from a speci c row
B. It searches for data in columns
C. It calculates averages
D. It performs vertical summation

#### 134. How do you create a chart in Excel?

A. Home -> Insert Chart
fi
fi
 B. Insert -> Chart
C. Data -> Chart
D. View -> Insert Chart

#### 135. What is the shortcut for saving a workbook in Excel?

A. Ctrl + S
B. Ctrl + P
C. Ctrl + A
D. Ctrl + X

#### 136. In Excel, which function calculates the minimum value in a range?
A. MIN
B. MAX
C. COUNT
D. SUM

#### 137. How can you apply conditional formatting in Excel?

A. Home -> Conditional Formatting
B. Data -> Conditional Formatting
C. Insert -> Conditional Formatting
D. View -> Conditional Formatting

#### 138. What does the "Ctrl + T" shortcut do in Excel?

A. It opens a new tab
B. It inserts a table
C. It formats text
D. It creates a new worksheet

#### 139. What function can you use to calculate the average in Excel?
A. SUM
B. AVERAGE
C. COUNT
D. MAX

#### 140. How do you insert a pivot table in Excel?

A. Insert -> PivotTable
B. Data -> PivotTable
C. Home -> PivotTable
D. Review -> PivotTable

---

### **4. Microsoft PowerPoint**

#### 141. Which of these is a slide layout option in PowerPoint?
A. Title Slide
B. Title and Content
C. Blank
D. All of the above

#### 142. How can you add speaker notes to a PowerPoint slide?
A. Insert -> Notes
B. View -> Notes
C. Slide Show -> Speaker Notes
D. Design -> Notes

#### 143. What is the purpose of the “Slide Master” in PowerPoint?

A. To manage slide animations
B. To design the layout for all slides
C. To create transitions
D. To insert images
#### 144. What does the "Ctrl + D" shortcut do in PowerPoint?
A. Duplicates a slide
B. Deletes a slide
C. Opens the design tab
D. Starts a slideshow

#### 145. How do you add transitions between slides in PowerPoint?

A. Insert -> Transition
B. Transitions -> Choose Transition
C. Design -> Transition
D. View -> Transition

#### 146. How can you add a hyperlink to text in PowerPoint?

A. Insert -> Hyperlink
B. Design -> Hyperlink
C. View -> Hyperlink
D. Home -> Hyperlink

#### 147. How do you start a slideshow from the current slide in PowerPoint?
A. Shift + F5
B. F5
C. Ctrl + F5
D. Alt + S

### **1. Common Applications**

#### 149. What type of application is Microsoft Project used for?
A. Graphic design
B. Project management
C. Accounting
D. Database management

#### 150. Which of the following is an example of cloud-based note-taking software?

A. Evernote
B. Excel
C. Gmail
D. VLC Media Player

#### 151. What is the primary use of Google Calendar?

A. Managing contacts
B. Organizing events and scheduling
C. Creating documents
D. Editing videos

#### 152. What type of tool is Hootsuite?

A. Video editing
B. Social media management
C. CRM software
D. Presentation software

#### 153. Which software is used for designing logos and graphics?
A. QuickBooks
B. Photoshop
C. Trello
D. Google Docs

#### 154. What type of service does Google Translate provide?

A. Email management
B. File storage
C. Language translation
 D. Spreadsheet editing

#### 155. What is Dropbox used for?

A. Video editing
B. Cloud storage and le sharing
C. Word processing
D. Task tracking

#### 156. What is the purpose of Jira software?

A. Graphic design
B. Task tracking and project management
C. Video conferencing
D. Image editing

#### 157. Which of these applications is commonly used for customer support ticketing?
A. Zendesk
B. Adobe Illustrator
C. Canva
D. Microsoft Word

#### 158. Which of the following is an example of e-commerce software?

A. Magento
B. QuickBooks
C. Slack
D. Google Drive

#### 159. What is the function of Grammarly?

A. Graphic design
B. Grammar and spell-checking
C. File sharing
D. Social media management

#### 160. What is the main function of Google Keep?

A. Task management
B. Online meetings
C. Note-taking
D. Graphic design

#### 161. Which of the following is a common use of Prezi?

A. Word processing
B. Creating interactive presentations
C. Task management
D. Cloud storage

#### 162. Which type of software is Microsoft Visio?

A. Word processing
B. Diagramming and owchart software
C. Email management
D. Project management

#### 163. Which of the following is a popular content management system (CMS)?
A. Trello
B. WordPress
C. Google Forms
D. Google Drive

#### 164. What type of tool is Airtable?

A. File storage
B. CRM software
C. Spreadsheet-database hybrid
fl
fi
 D. Presentation software

#### 165. What is the main purpose of Zoom?

A. Video conferencing
B. Document editing
C. Image editing
D. Social media management

#### 166. Which of the following applications is used for real-time collaboration in coding
projects?
A. Trello
B. GitHub
C. Dropbox
D. Google Docs

#### 167. What is the primary purpose of Adobe InDesign?

A. Video editing
B. Digital publishing and layout design
C. Cloud storage
D. Accounting

#### 168. What type of software is Microsoft Dynamics?

A. Word processing
B. Enterprise resource planning (ERP) and CRM
C. Image editing
D. Cloud storage

#### 169. What type of software is Tableau?

A. Video editing
B. Business intelligence and data visualization
C. Accounting software
D. Word processing

#### 170. Which tool is commonly used for building wireframes and prototypes for apps?
A. Sketch
B. Microsoft Excel
C. Adobe Acrobat
D. Trello

---

### **2. Microsoft Word**

#### 171. What does the “Ctrl + K” shortcut do in Word?
A. Insert a table
B. Insert a hyperlink
C. Add a comment
D. Change font size

#### 172. How do you change the page orientation in MS Word?

A. Home -> Layout
B. Layout -> Orientation
C. Insert -> Page Setup
D. Design -> Orientation

#### 173. What feature allows you to create a list of references or citations in a document?
A. Table of Contents
B. Bibliography
C. Index
D. Footnotes
 #### 174. In Word, which tab allows you to set paragraph spacing?
A. Home
B. Insert
C. Layout
D. Design

#### 175. What is the maximum number of columns you can insert in a Word table?
A. 63
B. 12
C. 45
D. 99

#### 176. Which feature would you use to create a letter template that can be used with multiple
recipients?
A. Track Changes
B. Mail Merge
C. AutoCorrect
D. Page Break

#### 177. What does the "Ctrl + E" shortcut do in Word?

A. Save the document
B. Center align the selected text
C. Open the print dialog
D. Add a table

#### 178. How can you insert a comment in Word?

A. Insert -> Comment
B. Review -> New Comment
C. Home -> Insert Comment
D. View -> Comment

#### 179. Which option would you use to see di erent parts of the same document at once?
A. Split
B. View Side by Side
C. Full Screen Reading
D. Arrange All

#### 180. How can you update a Table of Contents in Word?

A. Right-click the Table of Contents -> Update Field
B. Insert -> Update Table of Contents
C. Review -> Update Table
D. Layout -> Update Table

---

### **3. Microsoft Excel**

#### 181. What does the “Ctrl + ;” shortcut do in Excel?
A. Insert a chart
B. Insert the current date
C. Delete a row
D. Freeze panes

#### 182. What is the purpose of the "Data Validation" feature in Excel?
A. To apply conditional formatting
B. To restrict the type of data entered in a cell
C. To create pivot tables
D. To lter data

#### 183. Which Excel function returns the remainder after division?
A. MOD
fi
ff
 B. ROUND
C. TRUNC
D. FLOOR

#### 184. In Excel, which function is used to join text from two or more cells?
A. CONCATENATE
B. JOIN
C. COMBINE
D. ADDTEXT

#### 185. How do you create a named range in Excel?

A. Home -> Name Range
B. Formulas -> De ne Name
C. Insert -> Name
D. View -> De ne Name

#### 186. Which Excel function would you use to look up values from a table based on a vertical
lookup?
A. HLOOKUP
B. VLOOKUP
C. FIND
D. SEARCH

#### 187. What does the "Ctrl + Shift + L" shortcut do in Excel?
A. Locks the worksheet
B. Applies a lter to the data
C. Logs out of the application
D. Left-aligns the text

#### 188. What is the purpose of using an absolute cell reference in Excel (e.g., $A$1)?
A. To change the cell formatting
B. To ensure the cell reference doesn’t change when copied
C. To lock the entire workbook
D. To automatically sort data

#### 189. How do you insert a new row in Excel using the keyboard?
A. Ctrl + Shift + =
B. Ctrl + Alt + R
C. Ctrl + +
D. Alt + R

#### 190. Which function would you use to count the number of cells that meet a condition in
Excel?
A. COUNT
B. COUNTA
C. COUNTIF
D. COUNTBLANK

#### 191. What is the purpose of the “Slide Sorter” view in PowerPoint?
A. To display slides in sequence for easy rearranging
B. To edit the content of each slide
C. To show slides in full-screen mode
D. To add animations to slides

#### 192. How do you insert a sound le in PowerPoint?

A. Insert -> Audio
B. Insert -> Video -> Sound
C. Design -> Insert Audio
D. Slide Show -> Insert Sound
fi
fi
fi
fi
#### 193. What does the “Rehearse Timings” feature in PowerPoint do?
A. It helps rehearse the animations
B. It records the time spent on each slide during a slideshow
C. It adjusts the text size automatically
D. It times the duration of transitions

#### 194. How do you hide a slide in PowerPoint?

A. Slide Show -> Hide Slide
B. Insert -> Hide Slide
C. Design -> Hide Slide
D. View -> Hide Slide

#### 195. Which of the following is a built-in slide layout in PowerPoint?

A. Title Slide
B. Content with Caption
C. Two Content
D. All of the above

#### 196. How do you duplicate a slide in PowerPoint?

A. Right-click the slide and select “Duplicate Slide”
B. Home -> New Slide -> Duplicate
C. Slide Show -> Duplicate Slide
D. Insert -> Duplicate Slide

#### 197. Which feature allows you to set custom slide transitions in PowerPoint?
A. Animations -> Add Transition
B. Slide Show -> Custom Transitions
C. Transitions -> E ect Options
D. Insert -> Transition Settings

#### 198. What does the "Ctrl + M" shortcut do in PowerPoint?

A. Inserts a new slide
B. Opens the animation pane
C. Starts the slideshow
D. Copies a slide

#### 199. What is the purpose of the "Slide Master" in PowerPoint?

A. To control the design and layout for all slides
B. To add animations
C. To rehearse timings
D. To create a new presentation template

#### 200. How do you compress images in PowerPoint to reduce the le size?
A. Format -> Compress Pictures
B. Design -> Reduce Image Size
C. Insert -> Compress Images
D. Slide Show -> Compress Pictures

#### 201. Which application is used for creating owcharts and diagrams?
A. Microsoft Access
B. Microsoft Visio
C. Microsoft Excel
D. Microsoft OneNote

#### 202. Which of the following is a popular web-based note-taking app?

A. Dropbox
B. Evernote
C. Adobe Premiere
ff
fl
fi
 D. WordPress

#### 203. Which of the following apps is used for web conferencing?
A. Google Sheets
B. Microsoft Teams
C. Adobe Photoshop
D. Grammarly

#### 204. What is the purpose of LastPass?

A. File sharing
B. Password management
C. Email tracking
D. Task scheduling

#### 205. Which of the following is a popular free project management tool?
A. Dropbox
B. Evernote
C. Google Sheets
D. Trello

#### 206. Which cloud storage platform is primarily associated with Apple products?
A. Google Drive
B. Dropbox
C. iCloud
D. OneDrive

#### 207. Which of the following is NOT an online video conferencing tool?
A. Zoom
B. Microsoft Teams
C. WhatsApp
D. Cisco WebEx

#### 208. Which le format is primarily used for presentations?

A. .DOCX
B. .PPTX
C. .PDF
D. .XLSX

#### 209. What is Microsoft Sway used for?

A. Creating interactive reports and presentations
B. Graphic design
C. Project management
D. Video conferencing

#### 210. Which of the following is a Google productivity tool?

A. Google Drive
B. Adobe Photoshop
C. Microsoft OneNote
D. Slack

#### 211. Which of these applications allows real-time chat for team collaboration?
A. Microsoft Word
B. Google Drive
C. Slack
D. PowerPoint

#### 212. What is the main feature of the application "Trello"?

A. Word processing
B. Visual task management
C. Video conferencing
fi
 D. Graphic design

#### 213. Which of the following is a social media management tool?

A. Hootsuite
B. Microsoft Access
C. OneDrive
D. Gmail

#### 214. What does the application "Zapier" allow you to do?
A. Automate work ows between di erent apps
B. Manage projects
C. Edit documents
D. Conduct surveys

#### 215. What type of software is Google Analytics?

A. Web analytics
B. File storage
C. Video editing
D. Word processing

#### 216. Which of the following is a le-sharing application?

A. Google Drive
B. Microsoft Excel
C. Slack
D. Canva

#### 217. What is Microsoft OneNote primarily used for?

A. Creating slides
B. File sharing
C. Note-taking and organization
D. Editing videos

#### 218. Which app is mainly used for storing and managing code repositories?
A. Google Sheets
B. Microsoft Teams
C. GitHub
D. Adobe Illustrator

#### 219. What is Canva used for?

A. Graphic design
B. File management
C. Email marketing
D. Task management

#### 220. Which of the following is a type of task management tool?

A. Basecamp
B. Gmail
C. Google Calendar
D. QuickBooks

---

### **2. Microsoft Word**

#### 221. Which tab in Word contains the "Track Changes" feature?
A. Home
B. Review
C. Insert
D. References

#### 222. What does the "Ctrl + Z" shortcut do in Microsoft Word?
fl
ff
fi
 A. Undo the last action
B. Redo the last action
C. Open the Print dialog
D. Save the document

#### 223. Which of these is used to insert a citation in Word?

A. Review -> Insert Citation
B. References -> Insert Citation
C. Layout -> Citation
D. Insert -> Citation

#### 224. What does the "Ctrl + Y" shortcut do in Microsoft Word?
A. Saves the document
B. Undoes an action
C. Redoes an action
D. Pastes content

#### 225. How do you add a watermark to a Word document?

A. Insert -> Watermark
B. Design -> Watermark
C. Layout -> Watermark
D. View -> Watermark

#### 226. Which of these options allows you to compare two Word documents?
A. Review -> Compare
B. Insert -> Compare
C. View -> Compare
D. File -> Compare

#### 227. What is the default le extension for Word documents?

A. .PDF
B. .DOC
C. .DOCX
D. .TXT

#### 228. Which of the following is a type of break in Word?

A. Line break
B. Column break
C. Page break
D. All of the above

#### 229. Which of the following does the "Ctrl + X" shortcut do in Word?
A. Copies selected text
B. Cuts selected text
C. Pastes text
D. Deletes text

#### 230. How do you change the line spacing in a Word document?
A. Home -> Line and Paragraph Spacing
B. Layout -> Line and Paragraph Spacing
C. Insert -> Line Spacing
D. View -> Spacing

#### 231. What is the function of the Thesaurus in Word?

A. Checks spelling
B. Suggests synonyms
C. Tracks word count
D. Creates a bibliography

#### 232. Which of these tabs in Word contains the "Font" group?
fi
 A. Insert
B. Home
C. Design
D. Review

#### 233. What does the "Ctrl + Shift + F" shortcut do in Word?
A. Changes the font
B. Opens the Find dialog
C. Formats text
D. Inserts a footnote

#### 234. How can you insert a table in Word?

A. Home -> Table
B. Insert -> Table
C. Layout -> Table
D. View -> Table

#### 235. How do you insert a cover page in Word?

A. Insert -> Cover Page
B. Home -> Cover Page
C. Layout -> Cover Page
D. Design -> Cover Page