Wednesday, October 18, 2017

How do you validate data in MS Excel?

For a range of cells that you choose, you can create criteria that must be satisfied for entering data into those cells. Any data outside the criteria will be flagged as an error.

Highlight a number of cells in a column and click the Data Validation toolbar item shown


As seen here a few cells have been highlighted and the Data Validation clicked. This will bring up the Data Validation form as shown. I set up the criteria as shown here allowing whole numbers between 1 and 200.


 Here attempting to enter 30.5 in one of the highlighted cells brings up this error message.


 Here entering a number greater than 200 brings up the message.

 You could also tailor the error message instead of the default one seen above by configuring the Error Alert tab as shown.

 Now you will see your custom message as shown.


This is the Office version used in this post.


What is the fix for the error message, 'Printer is offline'?

There could be many reasons for this error. I have a Canon MX430 series printer.
I could print earlier to this printer via Wi-Fi connection and probably after a Windows Update (usual suspect for something that breaks) I started getting the message, "Printer is offline". I know that the Printer is on and is connected to Wi-fi. Then what is the problem. The device troubleshooter in Windows 10 Professional could not fix it.

I tried to add the printer and to my dismay, I could not find the printer to add.
Then I tried to manually install following these steps.



Voila, I regained by ability to print to this printer. Do you know what? The Add Printer dialog find a networked printer. I am not what the code behind this search printers.
 

Sunday, October 15, 2017

What is the function SUMIF()?

The SUM() function in MS Excel adds up all values in a column as shown. You can indiate the range and hit the sigma function in the menu.

=SUM(A1:A6)


The SUMIF() function is a conditional sum function. In the example show here, the sum takes into value only those values greater than 100.

=SUMIF(A1:A6,">100")

The SUMIF() function is a conditional sum function. In the example show here, the sum takes into value only those values greater than 100.

=SUMIF(A1:A6,">100")


How do the Dubai fonts look like?

A recent Office 365 message referred to a new font in MS Excel called Dubai. The initial design of Dubai font family is supposed to consist of 4 styles:

Dubai Light,
Dubai (regular),
Dubai Medium and
Dubai Bold,
supporting both western European languages as well as the major languages that use the Arabic script.

Things to know about the Dubai font family:
Avoid using italics with any of the Dubai fonts, as we've not yet included true italic styles of the fonts.

The Dubai (regular) style is suited for body text and is “linked” to the Dubai Bold font. To apply the bold effect just select your text and choose bold from the Font group on the ribbon.

Because the Dubai fonts are designed for setting both Arabic and western European languages together, the space between lines is quite generous. You can tighten up this spacing by selecting Line Spacing Options from the Paragraph ribbon menu.

The font automatically installs in Word, Outlook, Excel and PowerPoint. If you'd like to have the font available to you in other programs on Windows like Microsoft Project, or third-party programs you'll need to go to download the Dubai Font Pack from the Microsoft Download Center.

In MS Excel I could find only the following:


This is in MS Word. Dubai Medium is missing and it is the same as Calibri.


In MS Word there were only two.

More here:
https://support.office.com/en-us/article/Using-the-Dubai-Font-in-Microsoft-Office-C862DF16-AE0D-46D9-B117-AA3F41F9706E

Download font from here:

https://www.dubaifont.com/download (Opentype TTF, OpenType CFF, TTF, EOT, WOFF and WOFF2)

History behind the font:
https://www.dubaifont.com/story

Saturday, October 14, 2017

Can I communicate with Lumia 935 with my iPhone6 using Bluetooth?

Microsoft Lumia 935 can pair with the iPhone6 but the Lumia 935 is not seen on iPhone6.

On Microsoft Lumia 935


On iPhone6


On Lumia 935 iPhone6 seems to be paired as well. Trying to send a photo using Bluetooth from Lumia 935 displays a message that the destination does not support the feature.


Thursday, October 12, 2017

Which Bitcoin wallet is good for Windows OS?

There are lots of options and that will depend on the device you will be using (Desktop, web, Smartphone, etc.). For Windows phones there is just one option-

Coin.space

But if you are transacting from desktop there are more options.

I may go for Electrum, a personal choice.

There are lot more options for iPhone and Android phones.

Wednesday, October 11, 2017

What is a DASD?

DASD is an acronym for Direct Access Storage Device. DASD is a secondary storage device (fixed and removable) where each physical record has a discrete storage location. The acronym was coined by IBM to designate disks, magnetic drums and data cells which also includes optical disc drives.

DASDs can be accessed,
Directly
Sequentially
Using Index
Randomly

Hard Disk Drives (HDD) are DASDs.