1.
____________is a visual element that acts as a filter for tables and PivotTables, allowing users to quickly filter data by clicking on buttons.
2.
Which function returns the current date & time?
3.
The default number of worksheets in a new Excel workbook is:
4.
What is the minimum & maximum zooming level in Powerpoint?
5.
Which feature helps you see hidden formatting marks in Word like spaces or paragraph breaks?
6.
Which of the following is an example of an office automation software?
7.
Which feature creates a list of image or table titles in your document?
8.
What is the shortcut key for Quick Parts?
9.
Which feature is used to add explanatory notes at the bottom of a page?
10.
Which key starts a slideshow from the beginning?
11.
What does the VLOOKUP function do?
12.
In conditional formatting, you can format cells based on:
13.
Which symbol is used to fix a cell reference in Excel?
15.
Which of the following groups is NOT available under the Data tab
16.
Which option is used to insert a list of chapter or section headings?
17.
The shortcut key for Delete Slides-
19.
Where do Endnotes appear in a document?
20.
What is the purpose of the $ symbol in a formula?
21.
What is the default alignment for text in a cell?
22.
Which Excel function combines the contents of multiple cells into one cell?
23.
In PowerPoint, which view is used to rearrange slides?
24.
What is the intersection of a row and a column in Excel called?
25.
The function used to look up a value horizontally in a table is:
26.
What must be added to an image before it can appear in a Table of Figures?
27.
What is the purpose of a formula bar?
28.
What does the function =NOW() return?
29.
Which file extension is used for Microsoft Word documents by default (Word 2016 and later)?
30.
What is the correct syntax for VLOOKUP?