1.
What does the VLOOKUP function do?
2.
Which feature is used to add explanatory notes at the bottom of a page?
3.
What is the minimum & maximum zooming level in Powerpoint?
4.
The Shortcut key for Save is-
5.
___________are mini charts embedded within a single cell, used to visually represent data trends, patterns, or fluctuations.
6.
In MS Excel, the intersection of a row and a column is called a:
7.
Which of the following groups is NOT found on the References tab?
8.
Office automation mainly helps in:
9.
Which shortcut is used to insert a new slide?
10.
The “Data Validation” feature is used to:
11.
Which function returns the current date & time?
12.
What is the purpose of the $ symbol in a formula?
13.
What is the shortcut key for Quick Parts?
14.
The function used to look up a value horizontally in a table is:
15.
What is the purpose of a formula bar?
16.
In PowerPoint, which view is used to rearrange slides?
17.
Which file extension is used for Microsoft Word documents by default (Word 2016 and later)?
18.
In conditional formatting, you can format cells based on:
19.
In Excel, what does Ctrl + T do?
20.
There of ______ types of views in MS-Word?
21.
What does the function =TODAY() return?
22.
What is the default alignment for text in a cell?
23.
To select the entire column, press
24.
The default number of worksheets in a new Excel workbook is:
25.
Which feature allows you to summarize large data quickly (sum, count, average, etc.)?
26.
Which feature helps you see hidden formatting marks in Word like spaces or paragraph breaks?
27.
What does Goal Seek do in Excel?
28.
Which of the following groups is NOT available under the Data tab
29.
Which option is used to insert a list of chapter or section headings?
30.
Which Excel function combines the contents of multiple cells into one cell?
