Articles under category: Tools.
If you type more than one word in Google search, the default is that it will search for web pages containing all the words provided. What if you want Google to return pages that contain at least one of these words? What if you want to remove from search results pages that contain certain words?
Difficulty in finding the information that you want? Explore the different syntaxes that you can use to find what you need using the search engine Google.
LibreOffice and OpenOffice looks and functions almost similar. They even have the same set of names for their programs: Writer, Calc, Impress, Base, Draw and Math. Allow me to clarify what’s the difference and what’s the connection between these two free and open source office suites.
Part V of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This post is about formatting date and time as seen in the cells. Format codes that are used in date and time is discussed extensively in this entry.
Part IV of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting currency or money. The red and other color(s) formatting for negative numbers is also discussed in this post.
Part III of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting cell data as fractions, percentages and scientific notations.
Part II of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This entry is about formatting numbers in general and the meaning of Format code made of zeroes and hashes. Also discussed are the different formats of thousands separator and decimal marker.
Part I of serial post about formatting cell data in OpenOffice / LibreOffice Calc. This is the introduction part and also covers how to select cells to be formatted and how to open the Format Cells option window.
Date and time are information that can appear in word problems but are not readily convertible to numerical data that we can subject in mathematical computation. Of course, we know how to do it. It is one of the daily life tasks that the students need to learn. Constructing a spreadsheet problem generator with date and clock time as given values are a little more complicated than the usual numerical data but very much feasible.
In my previous post, I discussed how to make problem generators using spreadsheet software but did not discuss special formatting requirements such as percentage, currency and units, and other conventions that while easy to write in paper, can be difficult to format in a spreadsheet-based problem generator. While not all mathematical conventions can be readily implemented in a spreadsheet, I discuss in this post how to come close as possible.