55 result found with tag "spreadsheet"

• Introduction

  In this activity we create a graph which in...

  06-06-2016
• Tabulating Bill: 3-Formula and Auto-complete

  Calculating "Amount(Rs.)" column values:  ...

  05-06-2016
• Homework

  We hope that you have already done the homework...

  06-06-2016
• Exploring options of chart window - 5

  Moving and Re-sizing chart windows: Movin...

  06-06-2016
• Cell address

  Locating Cell: Locating cell means unique...

  06-06-2016
• Opening a spreadsheet (Calc)

  For opening a spreadsheet go to start menu a...

  05-06-2016
• Collecting data - 1

  Collecting Data We will collect the data fro...

  06-06-2016
• Entering the data in the spreadsheet

  Now enter this data in form of two columns in t...

  06-06-2016
• Drawing pie chart

  Pie charts represent subcategories, by breaking...

  06-06-2016
• Adding runs per ball per over

  Start adding runs for each ball in every ove...

  05-06-2016
• Basic elements of spreadsheet

  Column in Spreadsheet: A column in...

  05-06-2016
• Sorting the data

  We will use the Sort functions to arrange the d...

  06-06-2016
• Tabulating Bill: 1-Prepare Sheet

  Preparing spreadsheet structure for data entry:...

  05-06-2016
• Data in spreadsheet

  Data is information stored in spreadsheet in...

  06-06-2016
• Exploring options of chart window - 3

  Data Series: Data series gives options: ...

  06-06-2016
• Entering data into spreadsheet

  In this activity, we are going to add sample bi...

  05-06-2016
• T10 cricket match data

    We all may have seen a T20 cricket ma...

  05-06-2016
• Data in spreadsheet

  Data is information stored in spreadsheet in...

  05-06-2016
• Calculating innings total runs after each over

  To calculate innings total runs after each o...

  05-06-2016
• Opening a new spreadsheet

  Now we will put this data in a spreadsheet. ...

  06-06-2016
• Tabulating Bill: 4-Calculating Final Total

  Calculating Final Total: We have calculated ...

  05-06-2016
• Plotting graphs

  Use the bar graph tool to create a bar graph fr...

  06-06-2016
• Starting with spreadsheet

  In this module we will be using LibreOf...

  05-06-2016
• Scores and Scorecards

  How are the scores recorded during a cricke...

  05-06-2016
• Making data entry into table

  Table in a spreadsheet means, combination of ro...

  05-06-2016
• Drawing bar chart

  Bar charts present data in linear form as di...

  06-06-2016
• Formatting cell for decimal points

  After calculating run rate,  for each o...

  06-06-2016
• Column chart

  Creating Column chart for Total Runs per Over: ...

  06-06-2016
• Basic elements of spreadsheet

  Column in Spreadsheet: A column in...

  06-06-2016
• Things to notice

  When you plot the data with a graph you can ans...

  06-06-2016
• Cell address

  Locating Cell: Locating cell means unique...

  05-06-2016
• Exporting graphs

  We have created different types of graphs in...

  06-06-2016
• Calculate run rate

  Run rate is nothing but average runs per ove...

  06-06-2016
• Drawing pie chart for singles, doubles, ...etc.

  Pie charts represent subcategories, by break...

  06-06-2016
• Calculating total runs per over

  We can use inbuilt "SUM" function for summation...

  05-06-2016
• Editing graph

  We can edit already created graphs/charts...

  06-06-2016
• Wrapping column names

  As we can see, some of the columns have more...

  06-06-2016
• Saving spreadsheet file (Calc)

  Whenever we create new spreadsheet, we shoul...

  05-06-2016
• Why graphs?

  Graphs helps in summarizing and displaying d...

  06-06-2016
• Exporting and Uploading - 5

  Export your graph to an image. Right click on t...

  06-06-2016
• Exploring options of chart window - 1

  Chart Type: Chart type gives options like...

  06-06-2016
• Entering data in spreadsheet

  Now we will enter the data that we have coll...

  06-06-2016
• Drawing graph/charts

  As we know commentary data of T20 cricket ma...

  06-06-2016
• Tabulating Bill: 2-Data Entry

  Making data entry into spreadsheet tabular stru...

  05-06-2016
• Exploring options of chart window - 4

  Chart Elements: ​In chart elements, we ge...

  06-06-2016
• Plotting data

  We can plot various values in our data to ge...

  06-06-2016
• Navigating between spreadsheet cells

  For entering, editing data into a cell of the s...

  05-06-2016
• Introduction to matchbox activity

  In this activity we will use matchbox as a data...

  06-06-2016
• Exploring Options of Chart Window - 2

  Data Range selection: Data range option p...

  06-06-2016
• Exporting and Uploading

  Once the graph is finalised export the graph...

  06-06-2016
• Inserting column

  Inserting new column between existing columns, ...

  05-06-2016
• Calculating Singles, Doubles, Triples, ...., etc

  For calculating singles, doubles, triples,.....

  06-06-2016
• Tabulating T-10 cricket match

  We have raw data of the T10 cricket match. ...

  05-06-2016
• Adding extra runs

  As we entered runs for each ball in a over, ...

  05-06-2016
• Drawing line graph

  Creating line graph for run rate: Line gr...

  06-06-2016