When we apply a formula in Excel which refers to another range or cell, the cell or range reference can be wither relative or absolute. The relative cell reference adjusts to its new location when the formula is copies and pasted in to new cell or range. An Absolute cell reference does not changes even when the formula is copy pasted elsewhere. An Absolute reference is specified with two doller($) signs. For example as mentioned below. Examples for Absolute references: =$C$10 =SUM($A$1:$G$25) Examples for relative references: =C10 =SUM(A1:S25) Normally when we use cell or range references which will be relative references. Excel by default creates relative cell references in formulas except when the formula includes cells in different worksheet or workbook. So where Absolute references are useful? I simple words, this is useful when we need to copy paste the formulas in different cells or ranges.
The formula in the above example table D2 range which multiplies with quantity by the unit price is B2*C2. This formula uses the relative reference. Hence when we copy paste this formula to the next cell D3 it becomes B3*C3. If we use absolute reference in this formula that is instead of B2*C2, D2*$C$2, copying the formula to the below produces incorrect results. The formula in cell D3 is exactly the same as the formula in Cell D2 and returns the total for laptops and not desktops. Now let us use the same tablet to calculate sales tax. The sales tax rate is stored in cell B7. Here formula in Cell E2 is D2*$B$7.
The total is multiplied by the tax rate stored in cell B7. As this is constant for all the items, we need to give absolute references. This reference do not change when we copy the cell. When the same formula in E2 is pasted to Cell E3, the formula becomes D3*$B$7. Here D3 is relative reference hence it changes but B7 remains same.
Samsung Galaxy Chat B5330 is a budget touch and type Android smartphone. The device runs on Android ICS OS. The device come with 850Mhz processor with 512MB of RAM. Galaxy Chat sports 3 inch TFT capacitive touch screen with QVGA screen resolution. It has physical QWERTY keypad.
Samsung Galaxy Chat come with 2MP primary camera with video recording capability. Internal memory of the device is 4GB in that only 2GB is available for apps. Memory can be expanded through microSD card upto 32GB.
For connectivity, Galaxy Chat supports GPRS,EDGE, 3G, Bluetoth and WiFi. It is interesting fact that this phone is going to get update to Jelly Bean in the coming month according to a blog post on Samsung mobile which receives Jelly Bean Update. Samsung Galaxy Chat is available in Black, White and in pink colors.
Overall it is a good phone considering the price tag and features. The other budget smartphones from Samsung such as Galaxy Y, Galaxy Y Pro or even Samsung Galaxy Ace Duos runs on Android Gingerbread OS and comes with 256MB or 370MB of RAM. Except camera, this is the best buy considering the price.
Samsung Galaxy Chat B5330 Features:
Android v4.0 (Ice Cream Sandwich) OS
2 MP Primary Camera
3-inch TFT Capacitive Touchscreen
850 MHz Processor
Physical QWERTY Keypad
GPRS,EDGE, 3G, Bluetoth and WiFi
Expandable Storage Capacity of 32 GB
Advantages and Disadvantages of Samsung Galaxy Chat B5330:
Pros of Samsung Galaxy Chat:
Touch and type interface with decent well spaced QWERTY keypad and capacitive touch screen
Sony Xperia Tipo Dual is identical to the Xperia Tipo. However this model comes with the Dual sim support. Running on Android ICS, the device come with 800MHz scorpion processor with 512MB of RAM and dedicated Adreno 200 GPU. This is one of the most economical Dual sim Android ICS running smartphone from Sony. Sony Xperia Tipo Dual price in India is ₹10,299.
Sony Xperia Tipo Dual sports 3.2 MP fixed focus primary camera. However this device do not feature LED flash, auto focus and secondary camera which is a slight con. Battery of Xperia Tipo Dual is Li-1500 mAh which is rated to provide talk time upto 5 hours and standby time upto 350 hours. Internal memory is 2.5GB and memory can be added upto 32GB through microSD card. Connectivity front, the Xperia Tipo Dual supports GPRS,EDGE, 3G, WiFi, USB and Bluetooth. There are three sensors in the devices namely Accelerometer, Proximity Sensor, Compass.
As the device runs on Android ICS, it supports tethering feature through which users can share the data connection with WiFi enabled devices through WiFi tethering or using USB tethering to non WiFi devices. Summary of Sony Xperia Tipo Dual:
Android v4.0 (Ice Cream Sandwich) OS
3.2 MP fixed focus Primary Camera
Dual SIM (GSM + GSM)
3.2-inch TFT Capacitive Touchscreen
800 MHz Scorpion Processor with 512MB RAM
Adreno 200 GPU
GPRS,EDGE, 3G, WiFi, USB and Bluetooth
2.5GB internal storage
Expandable Storage Capacity of 32 GB
Advantages and Disadvantages of Sony Xperia Tipo Dual:
Pros of Xperia Tipo Dual:
Very attractive price tag
Decent performance
Good connectivity features
Excellent storage capacity for the price
Stylish design and Solid 1500 mAh battery
Dual sim
Cons of Xperia Tipo Dual:
Fixed focus primary camera and there is no LED flash
Low resolution small display screen
Cramped keypad due to small screen size
Sony Xperia Tipo Dual sales box content:Handset, Battery, Charger, Headset, Data Cable, Screen Protector, SIM Card Adaptor
Camera Features:Geo-tagging, Self Timer, Send to Web
Battery:Li-Ion, 1500 mAh
Talktime:5 hrs (2G), 6 hrs (3G)
Standby Time:350 hrs (2G), 360 hrs (3G)
Internal storage:2.5 GB
Expandable Memory Slot:microSD, upto 32 GB
Memory:512 MB RAM
GPRS:Yes, 86 kbps
EDGE:Yes, 237 kbps
3G:Yes, 7.2 Mbps HSDPA, 5.76 Mbps HSUPA
Wifi:Yes, 802.11 b/g/n
USB connectivity:Yes, micro USB, v2
Tethering:USB, Wi-fi Hotspot
GPS Support:Yes, A-GPS with Google Maps
Bluetooth:Yes, v2.1, Supported Profiles (A2DP 1.2, EDR, AVRCP 1.0, HFP 1.5, HSP 1.1, OPP 1.1, PAP 1.0)
Audio Jack:3.5 mm
Music Player:Yes, Supports MP3, WAV, eAAC+
Video Player:Yes, Supports MP4, 3GPP, H.264, WMV, H.263
FM:Yes
Sound Enhancements:xLOUD Audio Filter Technology, TrackID Music Recognition
Ringtone:MP3
Sensors:Accelerometer, Proximity Sensor, Compass
Other Features:Predictive Text Input, MMS Enabled, Google Sync, 3D Gaming, Audio Recording, Street View and Latitude, Pan and Zoom, Alarm, Airplane Mode, Calculator, Calendar, Setup Wizard, Voice Input
Pre-Installed Apps:Facebook, Google, Google Voice Search, Google Talk, Google Mail, Instant Messaging, YouTube, Twitter
This article is deprecated! Any technical information contained herein likely refers to software versions that are now obsolete. Please visit our new post on How to download Smart Switch Latest Samsung PC Suite for the updated post of this.
Samsung PC suite are convenient tools which helps in doing multiple tasks such as syncing contacts, Data, Multimedia files etc. Samsung PC suite are useful in updating the firmwares of the Samsung Devices. With slight difference in features and compatibility of the device Samsung is providing four types of PC suites names Samsung Kies, Samsung PC Studio, New PC Studio and Samsung Kies Air. Below are the features of these PC suites along with the system requirements. Samsung Kies: Samsung Kies latest version is 2.3. However depending the phone you have you need to select compatible version of the Samsung Kies. Below are the some of the key features of Samsung Kies.
Key Features of Samsung Kies Mobile PC Suite
Connect your mobile without wire to the PC: One of the features added to latest Samsung Kies is connecting mobile to PC through WiFi and Sync between the two.
Mobile Firmware Updates: Whenever, the Samsung Mobile is connected to Kies either by USB or WiFi, Kies automatically notifies if any latest firmware available to the device.
Sync Contacts with Outlook or Google or Yahoo: This functionality provides more control over in syncing the contacts with outlook,Google or Yahoo. This also helps to add or edit the contacts in the convenient of PC.
Organize Music Files and Sync: With Samsung Kies, it is easier to organize the music playlist and sync them with the mobile.
Backup Photos and Videos from Mobile to PC: Samsung Kies provides easy ways to back up your precious photo and videos which are available on your mobile phone to PC.
System requirement to Install Samsung Kies on Windows based PC:
Compatible OS:Windows XP, Windows Vista, Windows 7 (32/64bit are supported)
CPU:Intel Core 2 Duo 2.0GHz or above (recommended)
Minimum memory size (RAM):1.00GB (recommended)
Free hard drive space:At least 500MB (recommended)
Screen resolution:1024 x 768(600), 32 bit or above
Required software:Net Framework 3.5 SP1 or above, Windows Media Player 10 or above, DirectX 9.0C
* For Windows Mobile, ActiveSync (Windows XP) or Device Centre (Windows Vista/7)
Update: Samsung has release newer version of Kies. The latest Samsung PC suite is Kies 3.0. This is compatible with the devices running on Android 4.3 or later. Samsung Kies for Mac Systems: Samsung Kies is available for Mac system too. The System requirements for installing Samsung Kies on Mac is given below.
OS:MacOS X version 10.5 or later
CPU:1.8GHz Intel or faster processor
Minimum memory size (RAM):512MB or more
Free hard drive space:At least 100MB (recommended)
Free download for Samsung Kies are available for both PC and Mac. For Download the latest Samsung Kies Click Here. Samsung PC Studio 3: Samsung PC Studio is another tool with additional features to enhance the experience. Key Features of Samsung PC Studio 3: PC Studio Launcher: Provides the shortcut icons to start the PC studio applications Phone Editor (Manage contacts and more):Allows you to view, edit and organize the personal information in your phone on your PC. Also lets your copy and move information between your phone and your PC. Message Manager (Manage messages):View, edit and organize your phone messages on your PC. You can also send text messages or multimedia messages with this application when it is connected to the phone PC Sync (Synchronize):Synchronize personal information data (names and contact information) in your phone. The programmes supported are Microsoft ® Outlook® and Outlook Express Phone Explorer (Manage files):Manage multimedia files in your phone on your PC and to transfer files between your phone and PC Networking Wizard (Manage Internet connections):Access the Internet using the connected Phone as a modem MMS Composer (Compose Multiimedia messages):Make and edit multimedia using photos, movies, sounds and text. The messages can be saved or sent via the connected phone. Multimedia Manager (Manage multiimedia files):Modify various media files (below) imported from your mobile phone, PC or CD and create a new one. This also has a play function.
Video – Import 3gp, 3g2, mpeg, mpg, mp4, avi, divx, asf, wmv. Convert to mp4, 3gp
Music – Import mp3, aac, mp4, 3gp, 3g2, m4a, mmf, midi, amr. Save as mp3, wav, amr, aac, m4a
Photo – Import jpeg, bmp, gif, png, wbmp, tif. Save as jpeg, bmp, png, gif
Multimedia Player (Play multimedia files)
Play multimedia files (compatible with your phone) such as movies and sounds.
Live Update – You can update your Samsung PC Studio to the latest version.
Live Update can be performed as follows.
Run Samsung PC Studio. In the Launcher window, select the Tools > Live Update menu. (Make sure the PC is connected to the internet.)
When the Welcome window appears, click the Start button.
The available programme update list appears. Click the Next button.
Save all unsaved tasks and close all PC Studio applications. Click the OK button to proceed to the update process.
When the update is done, click the Finish button to close Live Update. (In case the Live Update programme itself has been updated, click the Start button to repeat steps 3 to 5 for updating other components.)
System Requirements to install Samsung PC Studio 3:
Windows 2000 (with Service pack 4 or higher), Windows XP or Vista
At least 300 MB of free disk space
Connection with the phone must be through USB, IrDA or Bluetooth
Samsung PC Studio can be downloaded free from Samsung Support page Here.. New PC Studio:ew PC Studio is a program that helps you to use the data inside your PC and mobile phone better. New PC Studio allows users to manage not only the music, photos and videos in their PC but also the important personal information such as the phonebook, messages and schedules in their mobile phones by exporting them to PC. System Requirements for installing Samsung PC Studio:
One of the following ways is needed to connect the mobile phone to a PC.
USB cable and compatible port
Bluetooth device and software
One of the following programs must be installed to connect Bluetooth.
Microsoft Stack : Windows XP Service Pack 2 or higher
Widcomm Stack : 1.4.2.10 SP5 or higher
Bluesoleil Stack : 1.6.0 or higher
Toshiba Stack : 3.0 or higher
Samsung New PC Studio(NPC) free download is available in the Samsung Support page.
Samsung has launched Galaxy Note II in India, Germany,Australia and in South Korea. Samsung Galaxy Note II price in India is ₹39,990(Approximately $750) where as in Germany it costs €699.
Samsung Galaxy Note 2 is the successor of original Samsung Phablet Galaxy Note. This new Note II comes with 5.5 inch Super AMOLED capacitive touch screen with 720*1280 pixels(~267 ppi pixel density) . The display screen has Gorilla Glass 2 protections. Samsung Galaxy Note II is powered by 1.6GHz Cortex A9 quad core processor with Exynos 4412 Quad Chipset and Mali-400MP GPU. The phone houses 2GB RAM and has options chose between inbuilt storage capacity between 16/32/64GB. Samsung Galaxy Note 2 also support microSD card upto 64GB.
Samsung Galaxy Note 2 runs on latest Android Jelly Bean OS. For connectivity, it supports GPRS,EDGE, HSDPA, 21 Mbps; HSUPA, 5.76 Mbps; LTE, Cat3, 50 Mbps UL, 100 Mbps DL, Bluetooth, NFC and WiFi. Note 2 sports 8MP primary camera with auto focus and LED flash. For video calling, there is a 1.9MP front facing camera. The battery of the device is Li-3100 mAh.
