SECTION 1 — Microsoft Office Fundamentals (1–50)

No Question Options
In MS Word, which shortcut is used to copy
1 A. Ctrl + X B. Ctrl + C C. Ctrl + V D. Ctrl + P
selected text?
The extension of an MS Excel file in Office
2 A. .xls B. .xlsx C. .docx D. .pptx
2019 is:
Which feature in Word repeats the last
3 A. Redo B. Undo C. Repeat D. Replay
action performed?
4 In Excel, a formula always begins with: A. = B. + C. – D. /
Which function is used to count numeric A. COUNT B. COUNTA C. COUNTIF D.
5
values in Excel? COUNTBLANK
The shortcut key to create a new
6 A. Ctrl + N B. Ctrl + M C. Ctrl + P D. Ctrl + O
presentation in PowerPoint is:
Which view in PowerPoint displays all A. Outline View B. Slide Sorter C. Reading View D.
7
slides as thumbnails? Normal View
In Word, the “Mail Merge” feature is used A. Merge two documents B. Print bulk letters C. Save
8
to: document D. Insert tables
Which Excel chart type is best for showing
9 A. Pie B. Line C. Column D. Bar
trends over time?
Shortcut for selecting all text in a Word
10 A. Ctrl + A B. Ctrl + E C. Ctrl + S D. Ctrl + R
document:
In Word, the smallest unit of a table is called
11 A. Column B. Row C. Cell D. Box
a:
What is the default file extension for Word
12 A. .doc B. .txt C. .docx D. .rtf
2016?
In Excel, which symbol locks a cell
13 A. # B. $ C. & D. @
reference?
Which tab in PowerPoint allows you to add
14 A. Insert B. Animations C. Review D. Design
animations?
In Outlook, what is used to store incoming
15 A. Inbox B. Outbox C. Sent Items D. Drafts
mail?
The “Track Changes” feature in Word is
16 A. Review tab B. View tab C. Insert tab D. Home tab
found under:
In Excel, the intersection of a row and a
17 A. Cell B. Field C. Table D. Range
column is called:
Which Excel function adds all the numbers
18 A. SUM B. ADD C. TOTAL D. COUNT
in a range?
PowerPoint files are saved with which
19 A. .pptx B. .xlsx C. .docx D. .mdb
extension?
20 Shortcut to print in any Office program: A. Ctrl + P B. Ctrl + S C. Ctrl + D D. Ctrl + T
In Excel, what does the CONCAT function A. Combines text B. Counts text C. Formats text D.
21
do? Converts text
Which key combination closes an active
22 A. Alt + F4 B. Ctrl + F4 C. Shift + F4 D. F4 only
window?
23 In Word, double-clicking the ruler sets a: A. Tab stop B. Margin C. Indent D. Bullet
24 Which is not an alignment option in Word? A. Left B. Center C. Justify D. Outline
Excel allows a maximum of how many
25 A. 64 B. 128 C. Unlimited (system dependent) D. 256
worksheets per workbook?
A. Formatting all slides uniformly B. Printing slides C.
26 PowerPoint’s “Slide Master” is used for:
Adding sound D. Adding animations
Which feature in Excel arranges data in
27 A. Sort B. Filter C. Group D. Find
ascending order?
28 In Word, the default font in newer versions A. Arial B. Calibri C. Times New Roman D. Verdana
No Question Options
is:
A. Moves to next cell B. Moves to last cell with data C.
29 In Excel, what does Ctrl + Arrow key do?
Deletes row D. Moves to top
30 Shortcut to save a file: A. Ctrl + A B. Ctrl + S C. Ctrl + C D. Ctrl + O
A. Animation for text B. Effect between slides C. Slide
31 “Slide Transition” means:
sound D. Layout format
32 In Word, the default alignment of text is: A. Left B. Center C. Right D. Justify
33 Which tab in Excel contains Chart options? A. Home B. Insert C. Page Layout D. View
Which key inserts a new slide in
34 A. Ctrl + N B. Ctrl + M C. Ctrl + Shift + M D. Alt + N
PowerPoint?
A. Average value B. Maximum value C. Minimum
35 The function =MAX(A1:A10) returns:
value D. Count
36 Which is not a valid data type in Access? A. Text B. Memo C. Currency D. Picture
The intersection of multiple selected cells is
37 A. Range B. Group C. Cluster D. Block
called:
38 Shortcut for pasting text: A. Ctrl + C B. Ctrl + X C. Ctrl + V D. Ctrl + P
A. Are empty B. Meet a condition C. Contain numbers
39 In Excel, COUNTIF counts cells that:
D. Contain text
40 PowerPoint view used for presenting: A. Slide Sorter B. Normal C. Slide Show D. Reading
A. Creating graphs B. Creating decorative text C. Creating
41 WordArt is used for:
charts D. Creating shapes
A. Copying formulas B. Sorting data C. Inserting rows
42 The Fill Handle in Excel is used for:
D. Formatting
A. Preformatted document B. Plain text C. Graph D. File
43 A template in Word is:
backup
A. Merges cells B. Adjusts text within a cell C. Rotates
44 What does “Wrap Text” in Excel do?
text D. Aligns text
45 Shortcut to insert hyperlink: A. Ctrl + H B. Ctrl + K C. Ctrl + L D. Ctrl + T
46 Excel feature used to find specific records: A. Sort B. Filter C. Search D. Lookup
A. Speaker notes B. Animations C. Slide layout D.
47 PowerPoint’s Notes Pane is used for:
Comments
48 Shortcut for “Find” command in Word: A. Ctrl + F B. Ctrl + G C. Ctrl + H D. Ctrl + R
49 In Excel, which function gives current date? A. TODAY() B. NOW() C. DATE() D. TIME()
50 In Word, the default margin size is usually: A. 1 inch B. 0.5 inch C. 1.5 inch D. 2 inch
SECTION 2 — Microsoft Azure Fundamentals (51–100)
No Question Options
Azure is an example of which cloud
51 A. Private B. Public C. Hybrid D. Local
model?
A. Infrastructure as a Service B. Integration as a Service C.
52 The full form of IaaS is:
Interface as a Service D. Internal as a Service
Which model allows users to deploy
53 A. SaaS B. IaaS C. PaaS D. DaaS
applications without managing servers?
Azure Virtual Machines fall under which
54 A. IaaS B. PaaS C. SaaS D. None
service model?
55 Azure pricing is based on: A. Subscription B. Usage C. License only D. Annual fee
The purpose of Azure Resource Manager A. Deploy resources B. Manage databases C. Encrypt
56
(ARM) is to: data D. Create users
Which Azure service provides serverless A. Functions B. Blob Storage C. App Service D. SQL
57
computing? Database
A. File Storage B. Identity Management C. VM Hosting
58 Azure Active Directory (AAD) provides:
D. Data Backup
A. Structured data B. Virtual machines C. Unstructured
59 Azure Blob Storage is used for:
data D. Tables
Which Azure service is for hosting A. Azure SQL Database B. Azure Cosmos DB C. Blob
60
relational databases? Storage D. Data Lake
A. Service Level Agreement B. System Login Access C.
61 The “SLA” term in Azure means:
Service Link Access D. System License Agreement
A. A physical datacenter B. Group of datacenters C. Virtual
62 Azure’s region refers to:
server D. Resource group
A. Command-line management B. Billing C. Networking
63 Azure CLI is used for:
D. Support
Which Azure service analyzes large A. Data Lake Analytics B. App Service C. Functions D.
64
datasets? Key Vault
A. Azure Front Door B. Azure Firewall C. Azure
65 Which service provides global CDN?
DevOps D. Azure Backup
A. Organize related resources B. Encrypt files C. Store
66 Resource groups in Azure are used to:
backups D. Manage users
Which cloud type combines on-premises
67 A. Hybrid B. Private C. Shared D. Public
and public cloud?
A. CI/CD tools B. Machine Learning C. Virtualization D.
68 Azure DevOps provides:
Networking
A. Performance tracking B. Billing C. Encryption D. Data
69 Azure Monitor is used for:
backup
A. Pay only for used services B. Pay fixed cost C. Free
70 Azure’s pay-as-you-go model means:
usage D. Monthly subscription
Which Azure storage type stores key-value
71 A. Blob B. Queue C. Table D. Disk
pairs?
72 Azure availability zones provide: A. Redundancy B. Pricing C. Storage D. Licensing
A. Isolation of resources B. File sharing C. Cloud billing
73 Azure Virtual Network (VNet) allows:
D. API creation
A. Multiple APIs B. Only SQL C. Only JSON D. Only
74 Azure Cosmos DB supports:
Tables
75 Which is not a cloud deployment model? A. Public B. Private C. Distributed D. Hybrid
76 Azure Key Vault is used to store: A. Secrets & Certificates B. Documents C. Logs D. Files
Which Azure service ensures compliance
77 A. Policy B. Monitor C. Backup D. Recovery
and governance?
78 Azure App Service is for: A. Hosting web apps B. Data storage C. ML D. Security
79 Azure ARM templates are written in: A. JSON B. XML C. YAML D. CSV
No Question Options

Which of these is Platform as a Service A. Azure App Service B. Azure VM C. Azure Backup D.
80
(PaaS)? Azure Blob
A. Best practice recommendations B. Security logs C.
81 Azure Advisor provides:
Performance graphs D. Email alerts
A. Monitoring expenses B. Running code C. Deploying
82 Azure Cost Management helps in:
apps D. None
Which tool gives interactive dashboards A. Azure Portal B. Azure CLI C. Azure Advisor D.
83
for Azure monitoring? PowerShell
84 Azure Backup stores copies in: A. Cloud B. Local C. Hybrid D. Tape
85 Azure Free Tier offers credits for: A. 12 months B. 1 month C. 3 months D. Lifetime
The global Azure architecture is divided
86 A. Regions B. Continents C. Servers D. Groups
into:
A. Prebuilt services & templates B. Storage C. Keys D.
87 Azure Marketplace provides:
Encryption
Which Azure service uses AI and A. Cognitive Services B. Cosmos DB C. Blob Storage D.
88
cognitive capabilities? Functions
A. Automating workflows B. Hosting DB C. Creating
89 Azure Logic Apps are used for:
VMs D. Encrypting data
Which Azure service provides load
90 A. Traffic Manager B. Blob C. Queue D. App Service
balancing?
A. Estimate costs B. Create VMs C. Store files D. Debug
91 Azure Pricing Calculator helps you:
code
92 Azure Virtual Network Peering connects: A. VNets B. Regions C. Users D. Storage
A. Data durability B. Low cost C. Code quality D.
93 Azure Storage replication ensures:
Security only
A. Event-driven environment B. Batch jobs C. Manual
94 Azure Function executes code in:
trigger D. Only web
95 Azure DNS is used for: A. Domain management B. File sharing C. Backup D. AI
96 Azure Load Balancer operates at: A. Layer 4 B. Layer 7 C. Layer 2 D. Layer 3
97 Azure Security Center provides: A. Threat protection B. File storage C. Logs D. Keys
98 Azure Synapse Analytics is for: A. Data warehousing B. App hosting C. VMs D. Email
99 Azure Update Management automates: A. OS updates B. SQL queries C. ML pipelines D. Billing
The default Azure directory domain ends A. .[Link] B. .[Link] C. .[Link]
100
with: D. .[Link]