Fill in the blanks.
1) Spreadsheet is a collection of_____________and________
2)A rectangular block formed by the intersection of a row and a column is called_____
3) Excel 2010 is a_____
software package.
4) ________is a unique reference to the cell in the worksheet.
5)Numbers in a cell are
aligned by default.
6) There are_______
rows and________
columns in an Excel 2010 worksheets.
7)The default row height and column width in Excel 2010 worksheet is________
and_________
respectively.
8)________ is a predefined formula used to perform complex calculations.
9). ___, ____or____can be the type of function
arguments.
10)Pictorial representation of worksheet data is known as___
11). The chart added as an object on the worksheet is called_____
12). ____are the chart components used to recognise the different data series plotted
in a chart.
Answers
Answer:
1. rows and columns
2.cell
3.
Answer:
1) Spreadsheet is a collection of rows and columns.
2)A rectangular block formed by the intersection of a row and a column is called a cell.
3) Excel 2010 is a Microsoft software package.
4) cell number is a unique reference to the cell in the worksheet.
5)Numbers in a cell are left-aligned by default.
6) There are 1,048,576 rows and 16,384 columns in an Excel 2010 worksheets.
7)The default row height and column width in Excel 2010 worksheet are 409 points and 255 characters respectively.
8) A Function is a predefined formula used to perform complex calculations.
10)Pictorial representation of worksheet data is known as Graph
11). The chart added as an object on the worksheet is called a Chart sheet
12). Data series are the chart components used to recognize the different data series plotted in a chart.
Explanation:
1) Spreadsheet is a collection of rows and columns. By default, Excel has 3 worksheets. You can add as many worksheets as you want. Collectively, they are called workbook.
2)A rectangular block formed by the intersection of a row and a column is called a cell. The cell contains data that can be numeric or alphanumeric.
3) Excel 2010 is a Microsoft software package. Microsoft software package has some other important software like Word, Excel, MS Access, PowerPoint, etc.
4) cell number is a unique reference to the cell in the worksheet. It is specifically useful when we want to target a particular cell data.
5)Numbers in a cell are left-aligned by default. Alignment can be changed by aligning tab present on the home page of excel.
6) There are 1,048,576 rows and 16,384 columns in an Excel 2010 worksheets.
7)The default row height and column width in Excel 2010 worksheet are 409 points and 255 characters respectively.
8) A Function is a predefined formula used to perform complex calculations. Functions save the time as well as the effort of the user. There are many pre-defined functions are available for day-to-day tasks.
10)Pictorial representation of worksheet data is known as Graph. They can be inserted by clicking on the insert tab and then adding the graph or chart option.
11). The chart added as an object on the worksheet is called a Chart sheet. The chart helps to better illustrate the data.
12). Data series are the chart components used to recognize the different data series plotted in a chart. Generally, different colors are used to map different data series for better understanding.
#SPJ2