Page 2 of 4
Olufemi S.A. Bayode on 05 Aug 2020 @ 12:55:09 with 20 comments
I'm sincerely sorry for not posting any article yesterday. My PC and I were not feeling too well yesterday. I had a stomach ache while my computer had a booting palava. I was unable to attend to it until late in the night when I was better. Please, do bear with me.
It’s highly important to ensure easy readability of a Microsoft Office Excel Worksheet while creating one for the use of individuals with visual impairment. They need to know which cell holds which data as well as establish relationship between the cell and the column or row regardless their position in the Worksheet. Hence, the best guide for accessibility tailored Worksheet is wrapped knowledge of the ...
Olufemi S. A. Bayode on 05 Aug 2020 @ 12:48:40 with 20 comments
Highlighting is a process of marking a cell or range of cells for the purpose of adjustment or change. This change includes bolding, copying, cutting, italicising, alignment, deleting, etc. it should be noted that highlighting text, figures or formulae is necessary before performing any of the earlier listed changes in the Microsoft Excel.
You may follow the standard Windows’ technique using the SHIFT key in conjunction with any navigation pattern for highlighting purpose. However, Excel also has some of its own specialised method of highlighting and selecting cell or range of cells in a worksheet. This will be discussed in this post with example.
Olufemi S. A. Bayode on 05 Aug 2020 @ 12:44:12 with 20 comments
You can analyse data through many sheets in a workbook by using a 3D reference. In other words, if you have many worksheets in a workbook with a single cell or range of cells with data in them which you want to sum, multiply, use a function on, etc, you can do this by referring to the range of worksheets to be included followed by the range of cells to be acted on. The cells must be in the same place in the workbook on all worksheets. For example, with your cursor in the cell you want the result to appear in on the worksheet you want it on, to sum all of the figures in cell C3 in worksheets 5 to 40 you would use the formula:
=SUM(SHEET5:SHEET40!c3)
Therefore, if the figures in all of the 35 referenced sheets ...
Olufemi S. A. Bayode on 05 AUg 2020 @ 12:39:40 with 20 comments
Web pages are best described as rooms that makes up a building using our existing analogy for website. They are html documents which serve as online or web resources accessible through web browser and html editors. The collection of these various html documents constitute a website; better still, they are bits that forms the main structure called website.
Web pages are connected together on a website through links. This links are analogy of doors of different rooms in a building. You go in and out of a room through the door and in and out of another room the same way; and so also with links on a website. For example, there are various links on the home page of this website such as ...
Olufemi S.A. Bayode on 05 Aug 2020 @ 12:36:20 with 20 comments
We have houses with home addresses on the street, and we have shops in shopping mall with their various shop numbers or ID; they direct us to the specific house or shop we want to go. So also, web addresses take us straight to our desired websites holding on to the fact that they are buildings as explained in the previous post. For example, www.slnconline.com.ng/store directs you to the store’s web page on this website where you can purchase and order for different materials. But typing just www.slnconline.com.ng into the web browser will only take you to the home page.