Geeks Tutorials – Page 14 – Educational Tutorials For Geeks

How to Edit Photos to Fit Your Display in Windows 10

Have you ever set an image as a lock screen or desktop, if yes then you may not be satisfied with the cropping that Windows 10 uses. Luckily there are options by which you can custom-crop images for fitting it to your display. For this all you have to do is to open your image in Windows 10’s Photos application. You can also learn about Inserting Rows and Columns in MS Excel 2003. Now for editing the photos to fit your display you need to follow these simple steps.

1^st of all you have to open your image in Photos and then hover over the top of the window with your cursor.
Now click on Edit from the menu which will appear bu hovering over the top of the window.
After clicking on Edit you need to click on Crop.
Now is the time to click on Aspect Ratio.
Clicking on the Aspect Ratio will unfold different options which include Lock Screen, Custom and Original.
Now you have to click on Lock Screen.
Now adjust the crop box by dragging it and then moving the corner dots for selecting the portion which you want to use and then you need to click Apply.
Now click on Save as Copy.
After this you will notice that there is a … button on the top right corner of the screen.
Now you have to select Set As option.
After this you need to select Set as lock screen or Set as background.
Now you need to repeat last three steps if necessary.

With these simple steps you will successfully crop your image which will fit your display.

Inserting Rows and Columns in MS Excel 2003

At the end of this tutorial you will be able to learn how to insert rows and columns in MS Excel 2003. You can also learn about Grouping and Ungrouping Worksheets in MS Excel 2003.

Inserting a Row in MS Excel 2003:

For inserting rows in MS Excel 2003 you need to follow these steps.

1^st of all you need to click anywhere in the row below where you need to insert the new row.
Now select Insert>Rows from the menu bar.
With this a new row will be included above the cell which you had selected.

You can also add rows in MS Excel 2003 with the following methods.

1^st of all you need to click anywhere in the row below you want to insert the new row.
In the next step you need to right-click and select Insert from the shortcut menu.
An Insert dialog box will open.
Select the Entire Row button from different options.
Now click the OK button.

A new row will be included above the cells which you had selected.

Inserting a Column in MS Excel 2003

For inserting the columns in the worksheet in MS Excel 2003 you need to follow these simple steps.

1^st of all click anywhere in the column where you need to insert a new column.
Now select Insert>Columns from the menu bar.
A new column will be included to the left side of the existing column.

You can also add columns through these simple steps.

1^st off all you need to click anywhere in the column where you need to add the new column.
Now right-click and select the Insert option from the shortcut menu.
An Insert dialog box will be opened.
Now click on the Entire Column button in the Insert dialog box.
Now click on OK button.

A new column will be added to the left side of the existing column.

Grouping and Ungrouping Worksheets in MS Excel 2003

A Workbook is multi page Excel document which has got various worksheets. Most of the time you need to work with multiple workbooks simultaneously. It is possible only if you group these multiple worksheets. With grouping you can apply identical formulas and for formatting across all worksheets in the group. You can also learn about Working with the Worksheets in MS Excel 2003.

Grouping Worksheets:

In order to group multiple worksheets you need to follow these simple steps.

1^st of all you have to click on Sheet tab for selecting one worksheet.
Now in order to select more than one sheet you need to hold down the Control key and then click on multiple sheet tabs in the workbook.
Now in order to select all the worksheets in the workbook you need to right click any worksheet tab and then choose Select All Sheets from the shortcut menu.

With these simple steps you will be able group multiple workbooks. Now when you are done entering, copying, formatting and moving the data you have to ungroup the worksheets.

Ungrouping Worksheets:

Ungrouping the worksheets is also an easy affair and for that you need to follow these simple steps.

1^st of all right click on any of the selected worksheet tabs.
Now select Ungroup Sheets from the shortcut menu.

Moving Worksheets:

Moving a worksheet from one place to another is also very easy and for that you have to follow these steps.

Select the worksheet which you want to move.
Now select Edit>Move or Copy from the menu bar.
Now in the Move or Copy dialog box you have to use drop-down boxes for selecting the name of the workbook which you will move the sheet to.
Now check Create a copy for copying it.
Now click OK button for moving the worksheet to the new location.

Working with the Worksheets in MS Excel 2003

MS Excel is an application from Microsoft which can be used for creating spreadsheets and in this tutorial you will learn about working with the multiple worksheets. You can also learn How to Draw a Square by Using LINE Command in AutoCAD.

Giving Your Worksheet a Name

When you open MS Excel you will notice that the tabs which are displayed at the bottom of the screen are named as Sheet 1, Sheet 2 and Sheet 3. Well these names are not impressive and specified ones so you need to rename them. MS Excel will let you give a meaningful name for every worksheet in a workbook. Now in order to give name to your worksheet you need to follow these simple steps.

1^st of all you need to double click the sheet tab in order to select it. Once selected the text is highlighted by a black box.
Now you need to type in the new name for the worksheet.
Now press the Enter key in order to confirm it.
Your worksheet has now got a new descriptive name.

Inserting New Workbooks:

In order to add a new worksheet you need to follow these simple steps.

Select Insert>Worksheet from the menu bar.
With this a new worksheet will be added at the bottom of the screen. The new worksheet will be named as Sheet4, Sheet 5 and so on.

Deleting the Worksheets

If you need to remove a worksheet from your workbook you can delete it easily and for deleting the worksheet you need to follow these simple steps.

Click on the Sheets which you want to delete.
Now select Edit>Delete Sheet from the menu bar.
After this a dialog box will appear which will confirm from you for deleting the sheet.
Click on the Delete button for removing the worksheet from your workbook.

There is an alternative for deleting as well as inserting worksheets and for that you need to right click on the sheet which is to be deleted and then select Delete or Insert from the shortcut menu.

Drawing a Square using LINE Command in AutoCAD

AutoCAD is the numero uno choice for creating awesome 2D as well as 3D engineering drawings. It is considered as the essential tool for the engineers to design their projects. In this tutorial you will learn how to draw square in AutoCAD by using Line command. You can also learn about Setting Up Windows Hello Facial Recognition. In order to draw lines by using Line command you need to follow these simple steps.

1^st of all press F8 on keyboard in order to turn on ORTHO.
Now in the Draw toolbar you need to click LINE icon.
Now the LINE icon selected you need to specify 1^st point and for that pick any point on the screen with your mouse.
Now move the cursor to the right side a little bit and do not click down.
Now type in 2 and then press Enter.
Now move the cursor in the upward direction and do not click down.
Now type in 2 and then press Enter.
Now move the cursor in the left direction and do not click down.
Now type in 2 and then press Enter.
Now move the cursor in the downward direction and do not click down
Now type in 2 and then press Enter.
With these steps you will be able to create a perfect square.
Now press Esc key from the upper left corner of your keyboard for canceling the LINE command.

With these simple steps you will be able to create a square shaped object in AutoCAD and can add into your engineering drawing.

Setting Up Windows Hello Facial Recognition

Unauthorized access to someone’s personal data is the main cause of concern for everyone. No one wants his/her personal data to be shared with other without their consent. In such scenarios you need to have proper security measures for protecting your data. Windows 10 has got a Hello feature which will let you log in to your system with various different ways ranging from password, PIN numbers, fingerprint to facial recognition. The fingerprint and facial recognition features are the most secure ones and the facial recognition requires an infrared or Intel RealSense camera. At the moment this features is limited to Microsoft’s own Surface Book and HP’s EliteBook Folio G1 but you can buy some external webcams which will provide this security feature. You can also learn about Formatting Text in MS Word 2016.

In order to setup Windows Hello Facial Recognition you need to follow these simple steps.

1^st of all you have go to Open Settings and then select Accounts.
Now click on Sign-in options from the sidebar and the scroll down to Windows Hello.
Now you need to click “Set up” under the Face.
If you don’t have a PIN you need to set up first which is located directly above Windows Hello.
After this click Get Started.
Now you need to enter your PIN.
In the next step you have Stare into the webcam while your face will be scanned by Windows Hello feature.
For additional scans you need to click Improve Recognition alternatively you can close the setup process.

The facial recognition security set up has been completed and the next time when you will log in your system the Camera will look for your face 1^st and then will proceed further.

Formatting Text in MS Word 2016

Formatted text in any word document will draw the attention of the readers towards the specific part in the document. In MS Word you have got several different options for adjusting the text which includes font, size and color of the text. In this tutorial you will learn about Formatting the text in MS Word 2016. You can also learn about How to Mount and Burn ISO Files in Windows 10.

Changing the Font Size

In order to change the size of the font you need to follow these steps.

1^st of all you need to select the text which you require to modify.
Now on the Home tab you have to click on the drop-down arrow of Font size.
Now select the font size from the menu.
If the desired size is not available in the list you need to type the desired font size in Font size box and then press Enter.
The font size of the selected text will be changed.

Changing the Font of the Text

For changing the font of the text you need to follow these steps.
Select the text which is required to be modified.
On the Home tab you need to click on the drop-down arrow located next to the Font box.
Now select the font style which you need.
This will change the font style.

Changing the Color of the Font

For changing the color of the font you need to follow these steps.

1^st of all you need to select the text which you need to change.
Now go to the Home tab and click on the Font Color drop-down arrow.
A Font Color menu will appear and you need to select the color which you want to use.
The color of the selected text will be changed.

Using Bold, Italic and Underline commands

Select the text which you need to modify.
Go to the Home tab click the Bold, Italic or Underline command in the Font group.
Once you select the command the selected text will be modified.