Logo 
Search:

MS Office Interview FAQs

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

Name the function, which can get you the current date.

Today()..........................................
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 1

What is the use of macro? How do we create macro in Excel?

Macro is set of instruction which are stored in Visual Basic module which will make excel to perform commands and actions for you by running them. Excel can repeat a task at any time by using macro. It allows to perform repetitive and complex tasks...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 1

State whether true or false. Give the reasons for your answer.

a. Workbook can have minimum of 16 worksheets in Excel. no
b. It is possible to remove the gridlines in a worksheet. yes
c. Now () + 56 is a valid statement. No
d. It is not possible to copy the format from one cell to another cell in Excel. no
e...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 1

Why does excel display number signs(###) in a cell?

A #### error value occurs when the cell contains a number, date, or time that is wider than the cell or when the cell contains a date and/or time formula that produces a negative result.
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

How would you select group of worksheets?

Two or more adjacent sheets
Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet.

Two or more nonadjacent sheets
Click the tab for the first sheet, and then hold down CTRL and click the tabs for the ...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

List the four ways you can change column width?

• Fit the contents To make the column width fit the contents, double-click the boundary to the right of the column heading. To do the same for all columns on the worksheet, click the Select All button, and then double-click a boundary to the right ...
Posted By:Shruti Sharma      Posted On: Jan 20

1  2  3  4  5  6