1.
Which shortcut is used to insert a new slide?
2.
What is the correct syntax for VLOOKUP?
4.
What is the function of “Forecast Sheet” under the Data tab?
5.
Which Excel function combines the contents of multiple cells into one cell?
6.
The default number of worksheets in a new Excel workbook is:
7.
Which file extension is used for Microsoft Word documents by default (Word 2016 and later)?
8.
Which view shows all the slides in thumbnail form?
9.
The “PivotTable” feature is used for:
10.
Which of the following is an example of an office automation software?
11.
In MS Excel, rows are identified by:
12.
The Shortcut key for Save is-
13.
The Shortcut key for inserting new slide-
14.
What is the default file extension of PowerPoint presentations?
15.
Which function counts numeric values only?
16.
____________is a visual element that acts as a filter for tables and PivotTables, allowing users to quickly filter data by clicking on buttons.
17.
Which of the following displays data from multiple sheets in one place?
18.
What is the purpose of the $ symbol in a formula?
19.
In MS Excel, the intersection of a row and a column is called a:
20.
___________are mini charts embedded within a single cell, used to visually represent data trends, patterns, or fluctuations.
21.
Which function returns the current date & time?
22.
The function =TRIM(A1) is used to:
23.
Which feature helps you see hidden formatting marks in Word like spaces or paragraph breaks?
24.
There of ______ types of views in MS-Word?
25.
Which option is used to insert a list of chapter or section headings?
26.
What is the purpose of a formula bar?
27.
What does the function =NOW() return?
28.
Which symbol is used to fix a cell reference in Excel?
29.
Which shortcut inserts a footnote in Word?
30.
Default column in MS-Word is _________.