Scribd
Upload
4 views2 pages

7 2

The document provides an overview of spreadsheets, detailing their structure including rows, columns, and cells, as well as key features like the File button and Ribbon Tab. It outlines steps for creating and opening workbooks, types of text alignment, sorting data, and various chart types in Excel. Additionally, it describes built-in functions and specific text functions available in Excel.

Uploaded by

anishariya2008
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
4 views2 pages

7 2

The document provides an overview of spreadsheets, detailing their structure including rows, columns, and cells, as well as key features like the File button and Ribbon Tab. It outlines steps for creating and opening workbooks, types of text alignment, sorting data, and various chart types in Excel. Additionally, it describes built-in functions and specific text functions available in Excel.

Uploaded by

anishariya2008
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

1.

Spreadsheet is a tabular representation of any statistical,


mathematical, scientific or accountable data.
2. The contents of worksheet are-
i. Rows- Rows are numbered from top to bottom(1 to
1048576)
ii. Columns- Columns are labelled from left to right (A – XFD)
for a total of 16384.
iii. Cell – Cell are the intersection of row and column. It is
referred by column name and row number.
iv. File button – It contains file functions: New, Open, Save,
Save As, Print etc.
v. Quick Access Toolbar – It contains shortcut for commands
that are frequently used (Save, Undo, Redo)
vi. Ribbon Tab - It provides a set of tool group corresponding to
selected menu option.
vii. Formula Bar – It is the space for typing or editing cell data.
viii. Name Box – It displays the name of active cell.
ix. Status Bar – It displays the information like current mode or
option, keyboard status and the result of Auto calculate
option.
3. Steps to create workbook –
i. Click on New option from File tab.
ii. Click on Blank Workbook and then click on Create
Steps to open workbook –
a. Click on the Open option from File tab.
b. Select the document and then click on Open.
4. Types of text alignment in Excel 2010 –
i. Vertical Align
ii. Horizontal Align
iii. Orientation
iv. Indent
v. Wrap text
vi. Merge and Center
vii. Diagonal Arrow
5. Sort is formatting of data with respect to order. We use sort in Excel
to arrange our data in specific order.
6. Types of charts in Excel –
i. Column : Emphasizes the difference between items.
ii. Line : Displays the trend and change of values over time.
iii. Pie : Shows relationship between parts of a whole.
iv. Bar : Compares values.
v. Area : Distinguishes between several sets of data over a
period of time.
7. Functions are built-in special formulas that perform calculations, in a
particular order or structure, on values supplied to it.
8. Types of text functions in Excel-
I. LEN (text) – Returns the number of characters
in the string passed as argument.
II. EXACT (text1,text2) – It compares both the text
values and returns TRUE if they are exactly
same.
III. RIGHT (text, num-chars) – Returns the specified
number of characters from the end of text.
IV. LEFT (text, num-chars) – Returns the specified
number of characters from start of the text.
V. UPPER (text) – Converts text to UPPERCASE.
VI. LOWER (text) – Converts text to lowercase.
9.

You might also like