Chapter 7


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 types of operators with examples.
Operators are used to specify the type of calculation to be performed.
The different types of operators are Arithmetic operators (+, -, *, /, %, ^), Comparison operators (=, >, <, >=, <=, <>)

d) What are functions? Name the different types of functions.
A function is a built-in formula that can be used to perform a calculation on the data in the worksheet.
The different types of functions are Date & Time, Engineering, Financial, Lookup & Reference, Mathematical & Trigonometric, Statistical, Text and Database.

e) How will you perform common calculations in a worksheet?
The common calculations in a worksheet can be performed using Autosum option under Editing group of Home tab.



Comments

Post a Comment

Popular posts from this blog

Chapter 6

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          ...
Read more

CHAPTER 2: COMPUTER MEMORY

CHAPTER 2: COMPUTER MEMORY 1.   Primary Memory and Secondary Memory Primary Memory Secondary Memory 1. It is the main Memory of the computer System. 1. It is the backup memory of the computer System. 2. RAM and ROM are examples of Primary Memory 2. Hard Disk is an example of Secondary Memory   2.   RAM and ROM RAM ROM 1. RAM stands for RANDOM ACCESS MEMORY. 1. ROM stands for READ ONLY MEMORY. 2.   It is Volatile in nature. 2.   It is Non-volatile in nature. 3.   DRAM, SRAM are some examples of RAM. 3. PROM, EPROM are some examples of ROM.   E. 1. Write a short note on memory units. Computer process and store information in form of two digits 0 and 1. They are called binary digits or bits. The other units are nibble, byte, kilobyte, megabyte, gigabyte etc.   2. ...
Read more