Charts and graphs. Who uses spreadsheets? A spreadsheet is a piece of software which is used to work out calculations. Click and drag the fill handle over the cells you want the duplicate data or series to fill. Numbers 1 to 10 is an example of a series.
How spreadsheets work The most popular spreadsheet program is Microsoft Office Excel. Workbooks and worksheets A spreadsheet file is made up of one workbook and multiple worksheets. Columns, rows and cells Every cell in a spreadsheet or worksheet has a unique cell reference, which consists of a letter and a number.
It makes calculations much easier than working things out yourself. State the uses of a spreadsheet. Excel can be used to create analysis, Explain. What is an active cell? What are the contents in a spreadsheet?
A cell can also reference another cell in the same…….. A spreadsheet can be used for data analysis and…………making. The cell that is been currently worked upon is known as …… cell. A ……….. Should you have any further question, feel free to ask in the comment section below and trust us to respond as soon as possible. We are eager to meet you there. Your email address will not be published. If a spreadsheet contains many rows, you can freeze the rows containing your heading labels so that as you scroll down in the sheet the headings stay at the top and line up with the appropriate data.
Likewise, if your spreadsheet contains many columns, the leftmost columns may be frozen so that they stay with the data as you scroll to the right. Function: Functions are built-in formulas that are used to enter either commonly used or very complex formulas.
One commonly used function is the Sum function, which will add up the values in a range. Gridlines typically do not print unless the option is set in the layout options of the spreadsheet. Labels have no numeric value and cannot be used in a formula or function.. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.
Print Area: The print area is used to specify a range of cells that will be printed, rather than printing an entire worksheet. This is particularly useful for very large worksheets with multiple columns and rows. Print Titles : Print titles are used to repeat column or row titles on each page. That way, if a spreadsheet prints on multiple pages, each page will contain the appropriate headings to identify the data. If the cells are all together in a rectangular or square shape, it is an adjacent range.
An adjacent range is identified by the cell reference in the upper left and lower right corners of the selection separated by a colon. Example: A3:B5.
In this example, the range would include all cells in the rectangular area formed by beginning the highlighting in cell A3 and dragging down to B5. You can consider the colon as the word "through".
In this case, the range would include cells A3 through B5. If there are gaps between selected cells cells are separated by rows or columns the range is a non-adjacent range. Areas of a non-adjacent range are separated by commas when referenced in a formula.
0コメント