i) A5 Relative reference
ii) $F$5 Absolute row reference (only the row reference is absolute)
iii) H$21 Absolute column reference (only the column reference is absolute)
Kavungya answered the question on April 17, 2019 at 06:37
- An Agrovet Company wants to analyze its employee’s personal details using Microsoft Excel. The company has five employees: Mary Anne, Francis Kihara, Lena Achieng, Hellen...(Solved)
An Agrovet Company wants to analyze its employee’s personal details using Microsoft Excel. The company has five employees: Mary Anne, Francis Kihara, Lena Achieng, Hellen Wanjiku, and mwangi Peter. Their ages are 20, 45, 90, 45 and 34 years respectively. Mary department; Mwangi Peter in finance department and Hellen Wanjiku in Computer department
Mary Anne and Hellen Wanjiku are single whereas Francis Kihara, Lena Achieng and Mwangi Peter are married.
Construct a worksheet showing the above information. Use appropriate column headings
Date posted: April 17, 2019. Answers (1)
- Explain the following concepts as used in spreadsheets:
i) Automatic recalculation
ii) ‘What if’ analysis
iii) Sheet tabs(Solved)
Explain the following concepts as used in spreadsheets:
i) Automatic recalculation
ii) ‘What if’ analysis
iii) Sheet tabs
Date posted: April 17, 2019. Answers (1)
- State two reasons why it is necessary to specify the correct paper size before printing a document?(Solved)
State two reasons why it is necessary to specify the correct paper size before printing a document?
Date posted: April 17, 2019. Answers (1)
- Distinguish between Portrait and Landscape orientations.(Solved)
Distinguish between Portrait and Landscape orientations.
Date posted: April 17, 2019. Answers (1)
- Give two advantages of previewing a document before printing.(Solved)
Give two advantages of previewing a document before printing.
Date posted: April 17, 2019. Answers (1)
- Give two advantages of mail merge over copy and pasting several times to mass mail a document.(Solved)
Give two advantages of mail merge over copy and pasting several times to mass mail a document.
Date posted: April 17, 2019. Answers (1)
- Give a reason why it may be necessary to merge cells in a table.(Solved)
Give a reason why it may be necessary to merge cells in a table.
Date posted: April 17, 2019. Answers (1)
- Explain the concept of graphics that can be used in Microsoft word.(Solved)
Explain the concept of graphics that can be used in Microsoft word.
Date posted: April 17, 2019. Answers (1)
- Explain any three line spacing specification used in Microsoft Word.(Solved)
Explain any three line spacing specification used in Microsoft Word.
Date posted: April 17, 2019. Answers (1)
- Explain how a paragraph can be moved from one page to another using a word processor.(Solved)
Explain how a paragraph can be moved from one page to another using a word processor.
Date posted: April 17, 2019. Answers (1)
- Differentiate between:
a) A Hard page break and a Soft page break.
b) Auto complete and Auto Correct
c) Drawing and inserting a table in a document(Solved)
Differentiate between:
a) A Hard page break and a Soft page break.
b) Auto complete and Auto Correct
c) Drawing and inserting a table in a document
Date posted: April 17, 2019. Answers (1)
- What are page margins?(Solved)
What are page margins?
Date posted: April 17, 2019. Answers (1)
- Give any five document formatting features of a word processor.(Solved)
Give any five document formatting features of a word processor.
Date posted: April 17, 2019. Answers (1)
- What is document formatting?(Solved)
What is document formatting?
Date posted: April 17, 2019. Answers (1)
- Clearly explain the meaning of the following terms as used in word processing:
i) Editing a document
ii) Blocking text
iii) Printing
iv) Saving
v) Italicizing text
vi) Header
vii) Footer(Solved)
Clearly explain the meaning of the following terms as used in word processing:
i) Editing a document
ii) Blocking text
iii) Printing
iv) Saving
v) Italicizing text
vi) Header
vii) Footer
Date posted: April 17, 2019. Answers (1)
- Give the steps you would use to find and replace the occurrence of a particular word in Microsoft Word.(Solved)
Give the steps you would use to find and replace the occurrence of a particular word in Microsoft Word.
Date posted: April 17, 2019. Answers (1)
- Precisely explain the role of the following editing features of a word processor;
i) Find and replace
ii) Undo and redo
iii) Thesaurus
iv) Autocorrect(Solved)
Precisely explain the role of the following editing features of a word processor;
i) Find and replace
ii) Undo and redo
iii) Thesaurus
iv) Autocorrect
Date posted: April 17, 2019. Answers (1)
- Mwikali selected a paragraph in word processing. Explain what happened after pressing the following keys on the keyboard:
i) CTRL + B
ii) CTRL +A
iii) CTRL+ U(Solved)
Mwikali selected a paragraph in word processing. Explain what happened after pressing the following keys on the keyboard:
i) CTRL + B
ii) CTRL +A
iii) CTRL+ U
Date posted: April 17, 2019. Answers (1)
- Veronica tried to retrieve a document file following all the steps correctly. The filename did not appear in file list box. State three causes for...(Solved)
Veronica tried to retrieve a document file following all the steps correctly. The filename did not appear in file list box. State three causes for this.
Date posted: April 17, 2019. Answers (1)
- Explain the difference between overtype and insert mode in word processing(Solved)
Explain the difference between overtype and insert mode in word processing
Date posted: April 16, 2019. Answers (1)