1.
What does the VLOOKUP function do?
2.
Which is an example of a formula?
3.
Which area in an Excel window allows entering values and formulas?
5.
If 4/6 entered in a cell without applying any formates,Excel will treat this as__________________.
6.
What MS-Excel feature can you use if you want to work with one record at a time?
7.
Preset animation effects allow you to
8.
Excel print by default with grid lines.
9.
Slide Sorter of PowerPoint is available on
10.
Which of the following methods can not be used to enter data in a cell?
11.
In MS excel value used in a formula that does not change is called as?
12.
By default, Excel Users ______________ Alignment for aligning the number
13.
In MS-Excel which is used to perform what if analysis?
14.
The shortcut key to insert a slide in MS PowerPoint is ____________
15.
In MS-Excel what chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?
16.
You can keep the sum([Sales]) to calculate the totals for each month in
17.
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
18.
A file which contains readymade styles that can be used for a presentation is called________.
19.
In MS Office 2007, Menu bars are replaced by__________.
21.
Excel displays the current cell address in the_____________.
22.
In MS Excel which of the following is an absolute cell reference?
23.
Auto filter is a feature in Excel
25.
Which of the following displays the contents of the active cell?
26.
In Microsoft PowerPoint to add a header or footer to your handout, you can use
27.
In normal view,this tab displays the content of each Slide.
28.
How are the data organized in a spreedsheet?
29.
Except for the ________ function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result.
30.
What is the shortcut Key to hide entire row?
31.
How do you display current date and time in MS Excel?
32.
The intersection of a row and column is called as a____________.
33.
To Open the existing presentation,press_________
34.
67 If 4/6 entered in a cell without applying any formats, Excel will treat this as _______.
35.
You can jump to the next column by?
36.
What is the shortcut key to highlight the entire column?
37.
Ctrl + Z is used to _________ In MS excel.
38.
To place something in the same position on every slide of presentation automatically, insert into
39.
Which of the following correct regarding the background of slides
40.
The Shortcut key to insert a slide in MS powerpoint is ______________.
41.
Spreedsheet are created in?
42.
In MS-Excel two common wildcard characters that MS-Excel recognizes are
43.
Which are the two macro language in MS excel?
44.
What is the maximum zoom percentage in Microsoft Powerpoint?
Call Now Button
