the-spreadsheet - Tumblr blog

the-spreadsheet · 2 years

Text

TOPIC - ELECTROIC SPREADSHEET What is a spreadsheet Software?

Spreadsheet is a computer software that provides the facility to manage and arrange data in the form of Row and Column means as Table. It is also used to make numerical calculations and charts.

Questions on the chapter- Electronic Spreadsheet

Q1. Write any three Spreadsheet software. Ans. Three Spreadsheet software are : Microsoft Excel LibreOffice Calc OpenOfficeCalc

Q2. List any four activities which can be done accurately or efficiently on Libre Office Calc. Ans. Four activities are : Filtering the required data. Calculations using formula and functions. Check the validity of data. Arranging data in ascending and descending order

Q3. Write three uses of spreadsheet. Ans. Spreadsheet is used for: Managing financial and accounting documents. Creating data reports, generating invoices. Data analysis from scientific and statistical researches.

Q4. Name and explain in brief any two toolbars which provide a wide range of common commands and functions in Libre Office Calc. Ans. Two toolbars are : 1. Standard Toolbar : The standard tool bar shows the icons for most common operations, such as editing, arranging, filtering, etc. 2. Formatting Toolbar : It includes buttons for font selection, size of text, alignment, cell value formatting and indentation, etc.

Q5. Differentiate between Row and Column. Ans. Differences are: ROW- The horizontal lines in worksheet are called rows. Row headings are represented by numbers like 1, 2, 3 etc. COLUMNS- The vertical lines in worksheet are called columns. Column headings are shown by Capital Alphabet like A, B, C etc.

Q6. Name any three components of Libre Office. Ans. Three components of Libre Office are:

LibreOffice Calc LibreOffice Writer LibreOffice Impress

Q7. Name any seven parts of User interface of Libre Office Calc. Ans. Seven parts of User interface of Libre Office Calc are: Quick Access Tool bar Title bar Ribbon Control Buttons Name Box Formula bar Formatting Tool bar Zoom Control Column Heading Row Heading.

Q8. What do you mean by Active Cell? Ans. The selected cell is called Active Cell. It is always highlighted, with a thick border. The address of the active cell is displayed in the name box.

THANK YOU FOR READING OUR BLOG.

#Group no.2

2 notes · View notes