1.
What is the purpose of the $ symbol in a formula?
2.
You can rename a worksheet by:
3.
What does the function =TODAY() return?
4.
Which view shows all the slides in thumbnail form?
5.
What does the AutoSum button do?
6.
Office automation mainly helps in:
7.
___________are mini charts embedded within a single cell, used to visually represent data trends, patterns, or fluctuations.
8.
What is the shortcut key for Quick Parts?
9.
The “Data Validation” feature is used to:
10.
Which of the following groups is NOT available under the Data tab
11.
Which function finds the position of a value in a range?
12.
What does the function =NOW() return?
13.
What is the correct syntax for VLOOKUP?
14.
Which feature helps you see hidden formatting marks in Word like spaces or paragraph breaks?
15.
The “Subtotal” feature works best with:
16.
Which function returns the current date & time?
17.
In MS Excel, the intersection of a row and a column is called a:
18.
Which feature is used to add explanatory notes at the bottom of a page?
19.
Which option is used to insert a list of chapter or section headings?
20.
The “PivotTable” feature is used for:
21.
The function used to look up a value horizontally in a table is:
22.
Where do Endnotes appear in a document?
23.
What does Goal Seek do in Excel?
24.
What is the default file extension of PowerPoint presentations?
25.
Which of the following groups is NOT found on the References tab?
26.
Which command on the References tab is used to add a citation source (book, journal, website, etc.)?
27.
To select the entire column, press
28.
Which Excel function combines the contents of multiple cells into one cell?
29.
Which feature creates a list of image or table titles in your document?
30.
What is the minimum & maximum zooming level in Powerpoint?