Explain three types of cell referencing techniques.


Answer:

-Cell addressing: this refers to naming the cell in relation to the column name and the row number. By default, the A1 cell addressing style is used.
-Absolute cell referencing: this refers to a particular cell in a formula regardless of its position in the worksheet.
The name of the column and row is preceded by a dollar sign (),
-Relative cell referencing: this is reference to the cell in a formula based on the position of the cell that contains the formula.
-Mixed cell referencing: it is a combination of relative and absolute cell reference.
Examples =$H18. H is absolute while 18 is relative.
-Named cell referencing: it is creating descriptive names in a worksheet to represent range of cells. For example, the name TOTALS can be used to refer to cells A1:D1.


Share To Friends Via:
        





More Questions For Computer Applications:



  Define the term word processing as used in computing. (Answered)
Define the term word processing as used in computing. .
Posted On:Mon 15, March 2021 13:22:01 pm
  List four examples of word processors. (Answered)
List four examples of word processors. .
Posted On:Mon 15, March 2021 13:22:52 pm
  Distinguish between Save and Save As command. (Answered)
Distinguish between Save and Save As command. .
Posted On:Mon 15, March 2021 13:24:43 pm
  Distinguish between a page break and a selection break as used in word processing. (Answered)
Distinguish between a page break and a selection break as used in word processing. .
Posted On:Mon 15, March 2021 13:27:06 pm
  Differentiate between a footer and a footnote. (Answered)
Differentiate between a footer and a footnote. .
Posted On:Mon 15, March 2021 13:27:46 pm
  Distinguish between small caps and all caps as used in word processing (Answered)
Distinguish between small caps and all caps as used in word processing .
Posted On:Mon 15, March 2021 13:28:28 pm
  Explain the function of each of these keys combination as used in word processing. (i)CTRL+V: (ii)CTRL+X: (Answered)
Explain the function of each of these keys combination as used in word processing. (i)CTRL+V: (ii)CTRL+X: .
Posted On:Mon 15, March 2021 16:28:56 pm
  Differentiate between overtype mode and insert mode as used in word processing. (Answered)
Differentiate between overtype mode and insert mode as used in word processing. .
Posted On:Mon 15, March 2021 16:30:02 pm
  A student typed the word centre in a word processing document and realized that it was underlined with red wavy line. The student considered the word to be correctly spelled. Explain the possible reasons why the program responded in this manner. (Answered)
A student typed the word centre in a word processing document and realized that it was underlined with red wavy line. The student considered the word to be correctly spelled. Explain the possible reasons why the program responded in this manner. .
Posted On:Mon 15, March 2021 16:31:07 pm
  State ways of creating a table in word processor. (Answered)
State ways of creating a table in word processor. .
Posted On:Mon 15, March 2021 16:31:50 pm
  Distinguish between term dropped cap and in margin cap as used in word processing. (Answered)
Distinguish between term dropped cap and in margin cap as used in word processing. .
Posted On:Mon 15, March 2021 16:32:38 pm
  Differentiate between autocorrect and autocomplete features. (Answered)
Differentiate between autocorrect and autocomplete features. .
Posted On:Mon 15, March 2021 16:33:36 pm
  List four types of proof reading tools in a word processing. (Answered)
List four types of proof reading tools in a word processing. .
Posted On:Mon 15, March 2021 16:35:22 pm
  State five features of word processor. (Answered)
State five features of word processor. .
Posted On:Mon 15, March 2021 16:36:02 pm
  Explain the term collate as used in printing. (Answered)
Explain the term collate as used in printing. .
Posted On:Mon 15, March 2021 16:36:54 pm
  Define the term indent. (Answered)
Define the term indent. .
Posted On:Mon 15, March 2021 16:37:31 pm
  List three methods of indenting in word processing. (Answered)
List three methods of indenting in word processing. .
Posted On:Mon 15, March 2021 16:38:17 pm
  Define the term word wrap. (Answered)
Define the term word wrap. .
Posted On:Mon 15, March 2021 16:39:02 pm
  State two examples of icons found in each of the following. (i)Formatting toolbar: (ii)standard toolbar: (Answered)
State two examples of icons found in each of the following. (i)Formatting toolbar: (ii)standard toolbar: .
Posted On:Mon 15, March 2021 16:40:16 pm
  List four types of page formatting features (Answered)
List four types of page formatting features .
Posted On:Mon 15, March 2021 16:40:48 pm
  Write the formula for adding numbers in a table using word processor. (Answered)
Write the formula for adding numbers in a table using word processor. .
Posted On:Mon 15, March 2021 16:41:27 pm
  Define the term clipart. (Answered)
Define the term clipart. .
Posted On:Mon 15, March 2021 16:42:13 pm
  Outline the steps followed to crop a picture (Answered)
Outline the steps followed to crop a picture .
Posted On:Mon 15, March 2021 16:42:51 pm
  With aid of an example, define the term symbol as used in word processing. (Answered)
With aid of an example, define the term symbol as used in word processing. .
Posted On:Tue 16, March 2021 05:20:25 am
  Give two factors to consider when choosing a word processor. (Answered)
Give two factors to consider when choosing a word processor. .
Posted On:Tue 16, March 2021 05:22:10 am
  Explain the use of tab key in a word processor table. (Answered)
Explain the use of tab key in a word processor table. .
Posted On:Tue 16, March 2021 05:22:45 am
  Describe the term text box. (Answered)
Describe the term text box. .
Posted On:Tue 16, March 2021 05:23:25 am
  Define the term orientation as used in computers. (Answered)
Define the term orientation as used in computers. .
Posted On:Tue 16, March 2021 05:23:57 am
  Give two types of page orientation (Answered)
Give two types of page orientation .
Posted On:Tue 16, March 2021 05:24:34 am
  Outline the steps followed in applying bullets to a typed text. (Answered)
Outline the steps followed in applying bullets to a typed text. .
Posted On:Tue 16, March 2021 05:25:03 am

More Questions Categories:


About Us

Contact us

Terms of use | Privacy policy

Follow Us:               

All Rights Reserved © 2024; pscustudies.com