Logo 
Search:

MS Office Interview FAQs

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

What is a range? How can you name ranges?

Range is the group of two or more adjacent or non adjacent cell in a worksheet.
When you define a name that refers to a cell or range of cells in another workbook, you create a link known as an external reference. When you do this procedure, make su...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

How can you copy an entire worksheet to another worksheet ?

a. To move or copy sheets to another existing workbook, open the workbook that will receive the sheets.
b. Switch to the workbook that contains the sheets you want to move or copy, and then select the sheets.
c. On the Edit menu, click Move or Cop...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is the difference between a workbook and worksheet?

Workbooks A workbook is the file in which you work and store your data. Because each workbook can contain many sheets, you can organize various kinds of related information in a single file.

Worksheets (Spread sheet) is a primary document used ...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

How can you select a row, a column or an entire sheet in Excel?

To select entire row/column click on the row heading/column heading. To select entire sheet click sheet tab. Click the tab for the first sheet, and then hold down SHIFT and click the tab for the last sheet to select two or more adjacent sheets. To se...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

What is a cell reference? How many different types of cell references exist? Explain.

A reference identifies a cell or a range of cells on a worksheet and tells where to look for the values or data you want to use in a formula. With references, you can use data contained in different parts of a worksheet in one formula or use the valu...
Posted By:Shruti Sharma      Posted On: Jan 20

MS Office
Comments: 0

Distinguish between paste and paste special.

Paste copies data from the clipboard to the location of insertion point. While Paste special allows you to copy and paste specific aspect of the item such as formula, value or result.
Posted By:Shruti Sharma      Posted On: Jan 20

  1  2  3  4  5  6