1.
In PowerPoint, which view is used to rearrange slides?
2.
The “Data Validation” feature is used to:
3.
Where do Endnotes appear in a document?
4.
What does the VLOOKUP function do?
5.
In MS Excel, the intersection of a row and a column is called a:
6.
In MS Excel, rows are identified by:
7.
Which function returns the current date & time?
8.
The Shortcut key for Save is-
9.
Which function counts numeric values only?
10.
The “Subtotal” feature works best with:
11.
Which command on the References tab is used to add a citation source (book, journal, website, etc.)?
12.
Which file extension is used for Microsoft Word documents by default (Word 2016 and later)?
13.
The “PivotTable” feature is used for:
14.
What does the function =TODAY() return?
15.
Which key starts a slideshow from the beginning?
16.
What does the VLOOKUP function do?
17.
Which function finds the position of a value in a range?
18.
What does the AutoSum button do?
19.
The function used to look up a value horizontally in a table is:
20.
What is the intersection of a row and a column in Excel called?
21.
Which feature is used to add explanatory notes at the bottom of a page?
22.
Which feature allows you to summarize large data quickly (sum, count, average, etc.)?
23.
Which of these features can remove duplicate rows?
24.
What is the shortcut key for Quick Parts?
25.
Which of the following groups is NOT found on the References tab?
26.
Which of the following displays data from multiple sheets in one place?
27.
What is the function of “Forecast Sheet” under the Data tab?
28.
Default column in MS-Word is _________.
29.
Which Excel function combines the contents of multiple cells into one cell?
30.
Office automation mainly helps in:
