IT DIGEST
Fill formulas into adjacent cells Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right […]
In Microsoft Excel and other spreadsheet programs, pressing Ctrl+Z will undo any change made in the spreadsheet. Why Ctrl Z is undo? Control-Z as a text editing command for “undo” dates back to software designers at Xerox PARC, which pioneered many user interface conventions in the 1970’s and 1980’s. Other text editing keyboard shortcuts are […]
Touchpads use relative motion, similar to a computer mouse. Relative motion enables you to move your finger or stylus across the surface and a cursor will move on the screen.There is a location on the touchpad called a hot spot that enables this function. How does a touchpad work only with fingers? When a capacitive […]
The formula and calculations are as follows: Effective annual interest rate = (1 + (nominal rate / number of compounding periods)) ^ (number of compounding periods) – 1. For investment A, this would be: 10.47% = (1 + (10% / 12)) ^ 12 – 1. What is the effective annual rate of 12% compounded monthly? […]
To read an encrypted file, you must have access to a secret key or password that enables you to decrypt it. To encrypt data on your Mac, go to Finder > Applications > Utilities folder. Locate and open the Disk Utility. Go to the File menu and choose New > “Disk Image from Folder…” (or […]
In the Finder on your Mac, open a window, then Control-click the item you want to encrypt in the sidebar. Choose Encrypt [item name] from the shortcut menu. Create a password for the disk and click Encrypt Disk. Important: Be sure to record and keep this password in a safe place. How do I encrypt […]
To password protect and/or encrypt a document using Microsoft Excel for Mac: Open the MS Excel for Mac file you want to encrypt and password protect. Select File > Passwords. In the Password to open field, type a password. Click OK. Reenter the same password. Click OK. How do I encrypt an Excel file? Protect […]
How can I make my phone bigger? You can zoom or magnify to see your Android device’s screen better. Step 1: Turn on magnification. Open your device’s Settings app . Tap Accessibility, then tap Magnification. Turn on Magnification shortcut. Step 2: Use magnification. Zoom in and make everything bigger. Tap the accessibility button. . Do […]
Select Start > Settings > Accounts > Email & accounts. Select the account you wish to remove, then select Remove. Select Yes to confirm your actions. How do I delete user accounts? Delete user accounts in Windows 10 Open the Settings app. Select the Accounts Option. Select Family and Other Users. Select the user and […]
If you need to remove that person’s sign-in information from your PC: Select Start > Settings > Accounts > Other users. Select the person’s name or email address, then select Remove. Read the disclosure and select Delete account and data. How do I delete a user profile in Windows 10? How To Delete User Profile […]