Logo 
Search:

MS Office Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » MS OfficeRSS Feeds
MS Office
Comments: 0

Explain the following terms giving suitable examples:

i) Pivot table : A PivotTable report is an interactive table that you can use to quickly summarize large amounts of data. You can rotate its rows and columns to see different summaries of the source data, filter the data by displaying different pages...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What are the different types of charts available in Excel?

Area, Column, Bar, Line, Pie, Doughnut, Stock, XY (scatter), Bubble, Radar, Surface, Cone, Cylinder, and Pyramid
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

Explain IF ,Vlookup, Hlookup function.

IF : The IF worksheet function checks a condition that must be either true or false. If the condition is true, the function returns one value; if the condition is false, the function returns another value. The function has three arguments: the condit...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is the different between SUM and SUMIF?

SUM : Adds all the numbers in a range of cells. E,g SUM(3, 2) equals 5, If cells A2:E2 contain 5, 15, 30, 40, and 50: SUM(A2:C2) equals 50, SUM(B2:E2, 15) equals 150.

SUMIF : The SUMIF worksheet function checks for a value within a range and then ...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is the significance of the fill handle in Excel?

The small black square in the corner of the selection. When you point to the fill handle, the pointer changes to a black cross. To copy contents to adjacent cells or to fill in a series such as dates, drag the fill handle.

To display a shortcut me...
Posted By:Shruti Sharma      Posted On: Jan 20

  1  2  3  4  5  6