Get premium membership and access questions with answers, video lessons as well as revision papers.
• To Insert a New Worksheet: Click the Insert Worksheet tab next to the sheet tabs at the bottom of the program screen. Or, press Shift + F11.
• To Delete a Worksheet: Select the sheet want to delete, click the Delete button in the Cells group on the Home tab, and select Delete Sheet. Or, right-click the sheet tab and select Delete from the contextual menu.
• To Rename a Worksheet: Double-click the sheet tab, enter a new name for the worksheet, and press Enter.
• To Change a Worksheet’s Tab Color: Right-click the sheet tab, select Tab Color, and choose the color you want to apply.
• To Move or Copy a Worksheet: Click and drag a tab to move a worksheet. Hold down the Ctrl key while clicking and dragging to copy the worksheet.
• To Split a Window: Drag either the vertical or horizontal split bar (located near the scroll bars) onto the worksheet.
•To Freeze Panes: Place the cell pointer where you want to freeze the window, click the View tab on the Ribbon, click the Freeze Panes button in the Window group, and select an option from the list.
• To Select a Print Area: Select the cell range you want to print, click the Page Layout tab on the Ribbon, click the Print Area button in the Page Setup group, and select Set Print Area.
• To Adjust Page Margins, Orientation, Size, and Breaks: Click the Page Layout tab on the Ribbon and use the commands in the Page Setup group, or click the Dialog Box Launcher in the Page Setup group to open the Page Setup dialog box.
• To Protect or Share a Workbook: Click the Review tab on the Ribbon and use the commands in the Changes group.
• To Recover AutoSaved Versions: Click the File tab on the Ribbon and select Info. Select an AutoSaved version from the Versions list. Or, click the Manage Versions button and select Recover Draft Versions.
Mwalimu Bonface answered the question on April 14, 2018 at 09:40
- State the basic keyboard shortcut keys used to format and edit a spreadsheet.(Solved)
State the basic keyboard shortcut keys used to format and edit a spreadsheet.
Date posted: April 14, 2018. Answers (1)
- State the keyboard shortcuts used in navigating through a spreadsheet.(Solved)
State the keyboard shortcuts used in navigating through a spreadsheet.
Date posted: April 14, 2018. Answers (1)
- Explain the most fundamental keyboard shortcuts when dealing with spreadsheets.(Solved)
Explain the most fundamental keyboard shortcuts when working with spreadsheets.
Date posted: April 14, 2018. Answers (1)
- What is the use of WAP and WML with regard to telephone messaging in handsets?(Solved)
Discuss the use of WAP and WML with regard to telephone messaging in handsets.
Date posted: April 14, 2018. Answers (1)
- Three methods of detecting system errors(Solved)
Three methods of detecting system errors.
Date posted: April 14, 2018. Answers (1)
- What are the features of an e-mail document?(Solved)
Highlight the features of any e-mail document.
Date posted: April 14, 2018. Answers (1)
- What are the parts of an email document?(Solved)
Highlight the parts of an email document.
Date posted: April 14, 2018. Answers (1)
- Explain properly the meaning of the term Data Mining and explain the benefits of data mining.(Solved)
Explain properly the meaning of the term Data Mining and explain the benefits of data mining.
Date posted: April 14, 2018. Answers (1)
- Outline the four major symbols used by functional modelling perspective to describe a process.(Solved)
Outline the four major symbols used by functional modelling perspective to describe a process.
Date posted: April 14, 2018. Answers (1)
- Briefly explain the concept of functional modeling in DBMS.(Solved)
Briefly explain the concept of functional modeling in DBMS.
Date posted: April 14, 2018. Answers (1)
- Briefly discuss the history of the evolution of the internet.(Solved)
Briefly discuss the history of the evolution of the internet.
Date posted: April 14, 2018. Answers (1)
- Briefly write short notes on the 5 classes of IPv4 addressing system.(Solved)
Briefly write short notes on the 5 classes of IPv4 addressing system.
Date posted: April 14, 2018. Answers (1)
- Differentiate between absolute URL and relative URL.(Solved)
Differentiate between absolute URL and relative URL.
Date posted: April 14, 2018. Answers (1)
- A school not being aware of the various threats that their computers networks are exposed to, advice and discuss with the management the ways and...(Solved)
A school not being aware of the various threats that their computers networks are exposed to, advice and discuss with the management the ways and means of protecting online website operations from hackers.
Date posted: April 14, 2018. Answers (1)
- You have been posted to a new school having graduated from a Kenyan university. The school being aware of your IT skills, they have requested...(Solved)
You have been posted to a new school having graduated from a Kenyan university. The school being aware of your IT skills, they have requested you to advise them on their new project of coming up with a computer network for the school to connect to the internet. Advice the school on what is required.
Date posted: April 14, 2018. Answers (1)
- What is the difference between e-mail and e-mail software?(Solved)
Differentiate between e-mail and e-mail software.
Date posted: April 14, 2018. Answers (1)
- Explain each of the following technologies.
a. Network technology.
b. Client technologies.
c. Server technology.
d. Operating system technology.(Solved)
Explain each of the following technologies.
a. Network technology.
b. Client technologies.
c. Server technology.
d. Operating system technology.
Date posted: April 14, 2018. Answers (1)
- What is the procedure of downloading and saving a web page having contents of interest from a particular site?(Solved)
Explain the procedure of downloading and saving a web page having contents of interest from a particular site.
Date posted: April 14, 2018. Answers (1)
- What is IT infrastructure?(Solved)
What is IT infrastructure?
Date posted: April 14, 2018. Answers (1)
- Why is it important to consider users while developing systems?(Solved)
Why is it important to consider users while developing systems?
Date posted: April 14, 2018. Answers (1)