Logo 
Search:

MS Office Interview FAQs

Submit Interview FAQ
Home » Interview FAQs » MS OfficeRSS Feeds
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

MS Office
Comments: 0

How do we define name in Excel? What is the use of defining names?

If you have information stored on one worksheet that you want to use on other sheets, you can create a name that describes the cell or range. A descriptive name in a formula can make it easier to understand the purpose of the formula. For example, th...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is a template? Explain the use of template.

You can create a template to use when you want several workbooks or worksheets to have similar formatting and styles, or content and functionality. The spread sheet which can be used as basis for those styles, format or functionality is called templa...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

How can you create a style by example? Explain.

a. Select a cell formated with the attributes you like.
b. From the Format menu, select Style to display Style Dialog box.
c. Type the style name in the Style Name drop down list.
d. Select the modify button to modify any of the attributes. The fo...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is the difference between bound and unbound controls?

Controls can be bound, unbound, or calculated. A bound control is tied to a field in an underlying table or query. You use bound controls to display, enter, and update values from fields in your database. An unbound control doesn't have a data source...
Posted By:Shruti Sharma      Posted On: Jan 18

MS Office
Comments: 0

What is a Master/ Detail Form?

A subform is a form within a form. The primary form is called the main form, and the form within the form is called the subform. A form/subform combination is often referred to as a hierarchical form, a master/detail form, or a parent/child form.
Su...
Posted By:Shruti Sharma      Posted On: Jan 20

  1  2  3  4  5  6