Question

Please Do not spam its emergency question

a) Differentiate relative and absolute Cell Reference?
b) How is the average and sum of numbers calculated in Microsoft excel?
c) Explain pivot tables and its use.
d) How is the formatting of data achieved in MS Excel cells?
e) What is the difference between function and formula in MS-Excel?
f) What is the difference between Single Clicking and Double Clicking and
can I change it?
g) What is the difference between window and windows?
h) How to add, delete and view fonts in window 7 ?
i) Can you sort multiple columns at one time? Explain with suitable
example?
j) What is Goal Seek ? Explain with suitable example?

Answer 1

Answer:

Ans.a)There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.

Ans.b)Calculate the average of numbers in a contiguous row or column

• Click a cell below, or to the right, of the numbers for which you want to find the average.

• On the Home tab, in the Editing group, click the arrow next to AutoSum , click Average, and then press Enter.

Ans.c) A Pivot Table is used to summarise, sort, reorganise, group, count, total or average data stored in a table. It allows us to transform columns into rows and rows into columns. It allows grouping by any field (column), and using advanced calculations on them.