Logo 
Search:

MS Office FAQ

Submit Interview FAQ
Home » Interview FAQ » MS OfficeRSS Feeds

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

  Shared By: Shruti Sharma    Date: Jan 20    Category: MS Office    Views: 4009

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. When we change the values in the worksheet, reflect the new numbers.
f. Once the chart is created the chart axis can not be changed. no
g. Excel can not be used as database. no
h. Global macros are the macros, which are stored in personal Macro workbook.
i. Linking worksheets is different from simple copy and paste operation.
yes
j. Data of one worksheet can not be used in the formula in another sheet.
no
k. Pivot Table Report shows the graphical summary of the data. yes
l. We use a ‘$’ sign before each element the cell that should not change in order to convert a relative cell reference to absolute cell reference. yes
m. Goal seek is used to find the output result by changing multiple input cells. no
n. A macro is made up of a series of instructions written in Visual Excel. No

Share: 
 



Your Comment
  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].


Tagged: