Secrets of the AutoSum Function in Excel!

Every MS Excel user knows well how to use the SUM function.

Simply you type =SUM into a cell, use the Shortcut ALT+= and click the AutoSum (Ʃ) command found on the right side of the Home Tab.

AUTOSUMAUTOSUM

As you know well, when you are not on the Home Tab the AutoSum command is not visible and if you want to always use the AutoSum you may add the AutoSum command to your Quick Access Toolbar, so it will be always accessible to you.

I thought you never noticed that the AutoSum command on the home Tab has a tiny drop down arrow next to it, click on the tiny drop down arrow and you will discover some other function instead of Sum, you can chose to calculate AVERAGE, COUNT NUMBERS, MAX and MINS in the same way you use SUM, choice is yours.

AUTOSUM

You can also use keyboard shortcuts, press ALT+H to activate the Home Tab, press U to activate AutoSum options and then press shortcut keys for which function you want to use:

S = Sum

A = Average

C = Count Numbers

M = Max

I =  Min

F = More Functions

Excel will suggest you a range for use the same way with the SUM, press Enter to accept the range or select other range.

If you know any other things about AutoSum, Let me know!

Advertisements

Translate Selected Text In Excel!

If you are working on a worksheet for a client based in another country that they speaks another language like mine, you might have difficulty understanding what you are working with.

To translate this, you can utilize Excel’s Translate feature.

Select the cell with the text you wish to translate, click the Review tab and then click Translate.

tran-1

In the Research pane, select Translation to Language as I selected URDU , click again Translate in Review Tab.

tran-2

Your selected text translated in Research Pane Click on Insert drop down list Click Insert to insert translated word in selected cell or Click Copy to copy translated text in clipboard and then paste in your selected cell.

tran-3

Following image is my finally translated copied text.

tran-4

Awesome Translation Feature In Excel Try Yourself!

BE AWESOME IN EXCEL!!!

Quick Current Date and Time in Excel

Excel-Quick-Date-Time

  • To enter Current Date in a cell Press Ctrl+; (semicolon ) it will inserts Current Date in your current Cell.
  • To enter Current Time  in a cell Press Ctrl+Shift+: (colon ) it will inserts Current Time in your current Cell.

Know you know, how to insert Current Date and Time Microsoft Excel, next time when need to insert Current Date and Time in any cell of worksheet and format the cell for Date and Time as like try these Keyboard Shortcuts.

This works in almost all the Excel versions.

Enjoy Microsoft Excel.

ILYAS QASIM

Dictionary of File Types Starting with A And B

Dictionary of File Types Starting with A And B

Author: ILYAS QASIM
These file extensions are collected from various sources and will be updated as we found more extensions.
FILE EXTENSIONS STARTING WITH A

  • ABKCorel Draw AutoBackup
  • ACL Corel Draw 6 keyboard accelerator
  • ACM Used by Windows in the system directory
  • ACPMicrosoftOffice Assistant Preview file
  • ACT Microsoft Office Assistant Actor file
  • ACV OS/2 drivers that compress and decompress audio data
  • AD After Dark screensaver
  • ADB Appointment database used by HP 100LX organizer
  • ADD OS/2 adapter drivers used in the boot process
  • ADM After Dark MultiModule screensaver
  • ADP Used by FaxWorks to do setup for fax modem interaction
  • ADR After Dark Randomizer screensaver
  • AF2 ABC Flowchart file
  • AF3 ABC Flowchart file
  • AFMAdobe font metrics
  • AIAdobe Illustrator drawing
  • AIF Apple Mac AIFF sound
  • ALB JASC Image Commander album
  • ALL Arts & Letters Library
  • AMS Velvert Studio music module (MOD) file
  • ANC Canon Computer Pattern Maker file that is a selectable list of pattern colors
  • ANI Animated Cursor
  • ANS ANSI text
  • APIApplication Program Interface file; used by Adobe Acrobat
  • APR Lotus Approach 97 file
  • APS Microsoft Visual C file
  • ARC LH ARC (old version) compressed archive
  • ARJ Robert Jung ARJ compressed archive
  • ART Canon Crayola art file
  • ART Xara Studio drawing
  • ASA Microsoft Visual InterDev file
  • ASCASCII text
  • ASD WinWord AutoSave
  • ASM Assembler language source file
  • ASP Active Server Page (an HTML file containing a Microsoft server-processed script)
  • ASP Procomm Plus setup and connection script
  • AST Claris Works ‘assistant’ file
  • ATT AT&T Group 4 bitmap
  • AVI Microsoft Video for Windows movie
  • AWD FaxView document

FILE EXTENSIONS STARTING WITH B

  • B4 Helix Nuts and Bolts file
  • BAKBackup file
  • BASBASIC code
  • BAT Batch file
  • BFCWindows 95 Briefcase document
  • BG Backgammon for Windows game
  • BIBinary file
  • BIFGroupWise initialization file
  • BIN Binary file
  • BK Sometimes used to denote backup versions
  • BK$ Also sometimes used to denote backup versions
  • BKS An IBM BookManager Read bookshelf
  • BM1 Apogee BioMenace data file
  • BMK An A bookmark file
  • BMP Windows or OS/2 bitmap
  • BRX A file for browsing an index of multimedia options
  • BS1 Apogee Blake Stone data file
  • BSP Quake map
  • BTM Batch file used by Norton Utilities

In meantime enjoy this listing and enhance your knowledge with our efforts.
Article Source: http://www.articlesbase.com/file-types-articles/dictionary-of-file-types-starting-with-a-4420516.html
About the Author
ILYAS QASIM

%d bloggers like this: