Electronic Spreadsheets for Class 7,10 Students

 Electronic Spreadsheets for Class 7,10 Students

Introduction

In this article, you will be able to know and learn about some essential terminologies related to electronic spreadsheets (Open Office calc) that are frequently asked while learning and teaching computer science.

Spreadsheet

·       Spreadsheet refers to a computer program that represents information in a two-dimensional data grid, along with formulas that relate to the data.

·       A spreadsheet is designed to hold numerical data and short text strings.

·       A spreadsheet can capture, display, and manipulate data arranged in rows and columns.

·       Some common examples of spreadsheet programs are Google Sheets (online and free), LibreOffice-calc (free), Microsoft Excel, and OpenOffice- calc (free).

Open Office calc

·       Open Office calc is the spreadsheet part of the Open Office software package.

·       Open Office calc provides extensive language support.

·       Open Office calc auto sum, list auto-fill, charts, functions, and database function features.

·       Open Office calc is free for anyone to use and distribute at no cost.

Google sheets

·       Google sheet is a spreadsheet program included in the free, web-based Google Docs Editors suite offered by Google.

·       Using Google Sheets, you can create and edit spreadsheets directly in your web browser- no special software is required.

Microsoft Excel

·       Microsoft Excel is a spreadsheet program used to save and analyze numerical data.

·       Microsoft Excel allows calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for applications.

·       Microsoft Excel is a commonly used Microsoft Office application developed by Microsoft for Windows, macOS, Android, and iOS.

Workbook

A workbook refers to a file in which multiple worksheets are stored.

Worksheet

·       Worksheet is a collection of cells organized in rows and columns in which you can enter and calculate data.

·       A worksheet is always stored in a workbook.

Formatting

Formatting refers to the process of making the worksheet data look more presentable and attractive by changing its appearance.

Alignment

Alignment refers to the position where data is placed within the boundary of a cell.

Indentation

Indentation refers to the distance between the vertical cell boundary and the text.

Orientation

Orientation refers to the rotation of the text at different angles inside the cell.

Data consolidation

Data consolidation is a process of collecting and integrating data from multiple sources into a single destination while applying a specific function such as sum, average, count, max, min, etc.

What-if Analysis

What-if Analysis refers to the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.

Scenario

A scenario is a What-if Analysis tool that helps build a model wherein changes made in values are reflected in the possible outcome, which is based on some formula using these values.

Goal seek

The goal seeking refers to a What-if Analysis tool that calculates backward to obtain an input that would yield a given output.

Solver tool

·       Solver tool is an advanced form of goal seeking.

·       Solver tool deals with equations with multiple unknown variables.

·       Solver tool is used to find the maximum or minimum result from multiple unknown variables.

Document hyperlink

A document hyperlink refers to a link, clicking on which opens the linked document such as a spreadsheet or a text document or an

image file.

Macro

A macro is a saved, named sequence of commands or keystrokes that are stored for later use.

Arguments

Arguments refer to the values passed to a macro.

Write a difference between relative hyperlinks and absolute hyperlinks.

·       Relative hyperlinks refer to hyperlinks that tell the path of a document with respect to the currently active location.

·       Absolute hyperlinks refer to hyperlinks that tell the path to reach a document starting from the topmost folder.

 

Click the link given below to download

 MCQ Set-1

To know more visit https://zueducator.blogspot.com