Introduction of Spread Sheet

Introduction - Spread Sheet


A spreadsheet software can also store, manipulate and create graphical representations of data.

User can enter data into a spreadsheet, do the formatting, calculate and analyse the data for decision making. Besides user's data, spreadsheet packages also provide built-in formulae and functions for common mathematical, financial, statistical, and logical operations in a very sophisticated manner. Spreadsheet packages are widely used for data analysis and accounting applications. Because of these abilities the spreadsheet packages are used as a universal programme for structured data preparation and processing.

Title bar: The Title bar, located at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X, where X is a number. The first created spreadsheet takes the name as Untitled 1, second is Untitled 2 and so on.

Menu bar: Menu bar is located just below the Title bar. It contains the menus with commands for various tasks. Each menu item has a submenu called pull-down menu. The various menu items are briefly explained below.

Toolbars: The Calc opens with the Standard and Formatting toolbars at the top of the workspace by default. These toolbar provide a wide range of common commands and functions. Placing the mouse cursor over any icon displays a small box called a tooltip. It gives a brief explanation of the icon function.

Name box: shows the cell reference, for example A1.

Functions wizard: search the function from the list of available functions.


Worksheet: The worksheet in Calc is also referred to as spreadsheet. The spreadsheet can have many sheets. Each sheet can have many individual cells arranged in rows and columns. The sheet tab shows its default name as Sheet1, Sheet2, Sheet3, ….

Rows and columns: The sheet is divided into vertical columns and horizontal rows. Each sheet can have a maximum of 1,048,576 (220) rows and 1024 (210) columns. The rows are numbered as 1,2,3,4,… and columns are numbered as A, B, C, D, …., Z, AA, AB, AC, …., AZ, BA to BZ, CA,…., AMJ.

Cell and cell address: The intersection of a row and column is called a cell. It is the basic element of a spreadsheet. It holds data, such as text, numbers, formulas and so on. A cell address is denoted by its column (letter) and row number. For example, D4, E9, Z89 are the valid example of cell address.


Qus. 1 : What is a spreadsheet in libreoffice?

  1. Draw
  2. Impress
  3. Calc
  4. Writer
Qus. 2 : What is the default file extension for a spreadsheet in Libreoffice Calc?

  1. .odp
  2. .ods
  3. .odd
  4. .odt
Qus. 3 : How many rows and columns in Libreoffice Calc ?

  1. 1048576 Rows & 1024 Columns
  2. 1048576 Rows & 16384 Columns
  3. 16384 Rows & 1048576 Columns
  4. 1024 Rows & 1048576 Columns
Qus. 4 : What is the maximum number of worksheets in Libreoffice Calc

  1. 256
  2. 1028
  3. 10000
  4. None of These
Qus. 5 : Which shortcut key is used for print preview in LibreOffice Calc?

  1. Ctrl + Shift + P
  2. Ctrl + Shift + O
  3. Ctrl + P
  4. None of These
Qus. 6 : What is the default file extension of LibreOffice Calc File ?

  1. .odt
  2. .ods
  3. .odp
  4. .xlsx
Qus. 7 : In which menu is the Merge Cells command found in LibreOffice Calc?

  1. Format
  2. Style
  3. Sheet
  4. Edit
Qus. 8 : The maximum Zoom % in LibreOffice Calc is?

  1. 300%
  2. 200%
  3. 400%
  4. 500%
Qus. 9 : How many number of columns in LibreOffice Calc?

  1. 1024
  2. 1048576
  3. 16384
  4. None
Qus. 10 : What is the default File Name of LibreOffice Clac?

  1. Untitled1
  2. Calc1
  3. Spreadsheet1
  4. None of these
Qus. 11 : Which shortcut key is used to insert comment in LibreOffice?

  1. Ctrl + Shift + C
  2. Ctrl + C
  3. Ctrl + Shift + T
  4. Ctrl + Alt + C
Qus. 12 : Which shortcut key is used to exit from Worksheet in LibreOffice Calc?

  1. Ctrl + W
  2. Ctrl + Q
  3. Ctrl + Shift + C
  4. Shift + W
Qus. 13 : Where is the name box located in LibreOffice Calc?

  1. Bottom left of the menu bar
  2. Top left over menubar
  3. On the status bar
  4. Bottom right side of the menu bar
Qus. 14 : Where the address of a active cell is appear in LibreOffice Calc?

  1. Formula Bar
  2. Address Book
  3. Name box
  4. None
Qus. 15 : What is the last cell address in LinreOffice Calc?

  1. $D$10
  2. AMJ1048575
  3. XFD1048576
  4. $AMD$1048576
Qus. 16 : Which shortcut key is used to select the entire worksheet in LibreOffice Calc?

  1. Ctrl + A
  2. Ctrl + shift + Space
  3. Ctrl + Shift + A
  4. A & B both
Qus. 17 : What you use to break (Split) a merged Cell in Libreoffice Calc

  1. Center
  2. Split Cells
  3. Split and merge
  4. Merge and center
Qus. 18 : What is the address of the last column in LibreOffice Calc?

  1. AMJ
  2. XFD
  3. AMG
  4. EMJ
Qus. 19 : What is the intersection of rows and columns in libreoffice Calc?

  1. Cell
  2. Tabel
  3. Position
  4. Data
Qus. 20 : What is the matching point of row and column

  1. Cell
  2. Column
  3. Row
  4. Sheet
Qus. 21 : How many number of columns in LibreOffice Calc?

  1. 1024
  2. 1048576
  3. 16384
  4. None
Qus. 22 : Where are the options like line, curve, Polygon are available ?

  1. Shape
  2. Object
  3. Chart
  4. Pie
Qus. 23 : Which options are available in scroll button on LibreOffice Calc?

  1. Up and Down scroll
  2. Right and left
  3. Horizontal and Vertical
  4. All of above
Qus. 24 : In which menu the Merge Cells command found in LibreOffice Calc

  1. Format
  2. Style
  3. Sheet
  4. Edit
Qus. 25 : How many columns does LibreOffice Calc contain

  1. 1024
  2. 1048576
  3. 16384
  4. None of These
Qus. 26 : Which shortcut key is used to select the all row

  1. Ctrl + Space
  2. Shift + Space
  3. Ctrl + Shift + Page down
  4. None
Qus. 27 : What is the default name of File in LibreOffice Calc

  1. Untitled1
  2. Calc1
  3. Spreadsheet1
  4. None of These
Qus. 28 : Maximum Zoom in LibreOffice Calc is?

  1. 500%
  2. 400%
  3. 350%
  4. 600%
Qus. 29 : In LibreOffice Calc or Writer, specify the shortcut key for Clear Format

  1. Ctrl + C
  2. Ctrl + M
  3. Ctrl + Shift + M
  4. None
Qus. 30 : How many seats we can insert in Libreoffice Calc?

  1. 32000
  2. 48000
  3. 60000
  4. None of these
Qus. 31 : Which shortcut key is used to open the Cell Format dialog box in Libreoffice Calc?

  1. Ctrl + 4
  2. Ctrl + 3
  3. Ctrl + 2
  4. Ctrl + 1
Qus. 32 : Range from B1- B5 is denote by ?

  1. B1&B5
  2. B1*B5
  3. B1#B5
  4. B1:B5
Qus. 33 : Which shortcut key is used for save as in Libreoffice Calc?

  1. Ctrl + Shift + F
  2. Ctrl + Shift + S
  3. Ctrl + F2
  4. None
Qus. 34 : Which shortcut key is used to select All in Libreoffice Calc?

  1. Ctrl + A
  2. Ctrl+ Shift + A
  3. Ctrl + Shift + Space
  4. A and C Both
Qus. 35 : Which of the following program is a part of LibreOffice suit ?

  1. Calc
  2. Write
  3. Publisher
  4. Excel
Qus. 36 : Which program is used for fast and accurate calculations as well as formatting of data in a document ?

  1. Calc
  2. Base
  3. Writer
  4. Impress
Qus. 37 : LibreOffice Calc is capable for which of the following type of Works ?

  1. Store data
  2. Manipulate data
  3. Create graphical representation of data
  4. All of these
Qus. 38 : In which format, spreadsheet gives permission for entering the data in it ?

  1. Horizontal
  2. Vertical
  3. Both A and B
  4. None of These
Qus. 39 : Which type of facilities does spreadsheet gives to make the work easy ?

  1. To add data
  2. Formatting
  3. To add formula
  4. All of these
Qus. 40 : Before printing we see the document on screen, what is called this process?

  1. Print View
  2. Print Preview
  3. Print Screen
  4. Print Document
Qus. 41 : From the following, which options are available in Edit menu?

  1. Cut, Copy, Paste
  2. Find and Replace
  3. Select All
  4. All of these
Qus. 42 : Which dialog box is open when we click Save As option in file menu ?

  1. Save As
  2. Save
  3. Save File
  4. Save As File
Qus. 43 : When we select Save As options in Calc which information will ask in dialog box ?

  1. File name
  2. Location where the file is to be saved
  3. Both A and B
  4. None of these
Qus. 44 : In Calc, most common commands present in which Bar?

  1. Title bar
  2. Standard Toolbar
  3. Formatting Toolbar
  4. Formula Bar
Qus. 45 : By which menu toolbar can be turn off and on?

  1. File
  2. Edit
  3. View
  4. Insert
Qus. 46 : In LibreOffice Calc which options are available on Standard toolbar ?

  1. Bold, Italics, Underline
  2. Left, Center, Right, Justify
  3. Font Name, Font Size, Font Color
  4. None of These
Qus. 47 : A function should start with

  1. ‘=’ sign
  2. Alphabets
  3. Numbers
  4. All of the these
Qus. 48 : Which of the following combination of column and row of a cell in a libreoffice calc spreadsheet is called _______?

  1. cell reference
  2. cell identify
  3. cell across
  4. cell identification number
Qus. 49 : Extension of LibreOffice Calc file is

  1. .ods
  2. .xls
  3. .odx
  4. .txt

Programs

Create a worksheet employee with the following information

View Solution

Create a Spreadsheet Employee data with following details

View Solution

create worksheet for Employees Details and perform following operations

View Solution

create a worksheet university and perform the following operation

View Solution

create a worksheet for university report

View Solution

create a spreadsheet of Student marks and find the followings

View Solution

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