Class VI

Class VI - Chapter 7 4. Answer the following questions:     a) Explain the two different types of data present in Excel. The two different types of data present in Excel are i)      Constants: the values which are directly entered in the cell are called contants ii)     Formula: it is a sequence of cell reference, mathematical   functions or operators of existing      value to give new value b) Define the following: i) Cell reference                                                ii) Cell range i) Cell reference is the unique address of a cell in a worksheet. ii) Cell range is a group of related cells in a worksheet. c) What are operators? Name the different...

Class VI - Chapter 6 4. Answer the following questions: a) What do you mean by formatting? Formatting means displaying the worksheet in an attractive and more legible outlook. It is done by changing the font and size of data, adding colour and shading, etc. b) Why do we need to do conditional formatting in Ms-Excel? We need to do conditional formatting in Ms-Excel to highlight data which matches a specific criteria. c) Define alignment. Name different alignment buttons. Alignment means to arrange the data in a specific way. The different alignment buttons are left, center and right. d) Describe different number formats The different number formats are General                 :                It is the default category with no specific formatting Number          ...