Formatting Cell

Formatting Cell


The cell holds any type of data in the spreadsheet. The cell data can be formatted using formatting toolbar or cell formatting window. It is also possible to format the cell using Format cells dialog box. The Format cells dialog box can be opened using Format→cells using the Format menu, or from context menu opened through right clicking the cell. The various options in the Format→cells dialog.


Tool
Details
Font
Apply different font types on a worksheet
Font Size
Apply different font sizes on a worksheet
Bold
Make the selected text bold
Italic
Italicize the selected text
Underline
Underline the selected text
Left Alignment
Align text in a cell to the left
Center Alignment
Align text in a cell to the center
Right Alignment
Align text in a cell to the right
Increase decimal places
Show more precise value by showing more decimal places
Decreased decimal places
Show less precise decimal places


Use of dialog boxes to format values

The format cells dialog box in the toolbar can be used to find more about formatting a cell or range of cell. You can open this Format Cell dialog box by pressing the shortcut key Ctrl+1


Formatting a range of cells with decimal places

The division of different numbers may result in varied decimal places in the quotient. In such cases it is necessary to format the number to a fixed number of decimal places.

Following are the steps to format a cell to the required number of decimal places:

  • Select the range of cells.
  • Open the ‘format cells dialog’ box
  • Click the ‘Number’ tab
  • Select the ‘Number’
  • Change the decimal places as required
  • Click ‘OK’




Example Programs



Program [1]

1. . Create the worksheet shown above and save the file with name “Employees_Detail”.

EMPLOYEE'S DATABASE
NAME
DEPARTMENT
DESIGNATION
SALARY
ADDRESS
JUHI
 SBI
BM
100000
LKO 
HARISH
 LIC
AD
80000
KANPUR 
ANANYA
SBI
RM
200000
BAREILLY 
GAURAV
LIC
MD
90000
LKO
KAJAL
 FCI
RM
200000
KANPUR
MAYANK
LIC
MD
80000
MEERUT 

Do the followings :

(a) Merge and center the Heading "EMPLOYEE'S DATABASE". Apply the cell style to Accent2.

b) Make the Column headings in BOLD format.

(c) Count the total no. of employees DEPARTMENT WISE.

(d) List the name of employees whose salary is greater than 120000

(e) Count the total no. of employees who have salary greater than 100000

(f) Sort the data DEPARTMENT wise in ascending order

(g) Generate a Column chart and Line chart to highlight employee name and their salary.

(h) Generate a Pie chart along the salary contribution by each DEPARTMENT


View Solution

CCC Online Test 2021 CCC Practice Test Hindi Python Programming Tutorials Best Computer Training Institute in Prayagraj (Allahabad) O Level NIELIT Study material and Quiz Bank SSC Railway TET UPTET Question Bank career counselling in allahabad Website development Company in Allahabad Sarkari Exam Quiz