1. Cells arranged horizontally across the screen are called
✓ columns
rows
grids
2. The Cell address can be read from the
address box
name box
3. The Tab key can be used to move
type box
down the rows
across the columns
up the ra
4. Which of the following data is not included in numeric data?
Numbers
Symbols
Formula
5.
feature fills data or a series of data into a selected range of
Fill
Auto
O Autofil
Fill in the blanks.
Answers
Answer:
The first step of learning about spreadsheets is understanding the terminology you will encounter as you work through this lesson. The glossary below lists terms that are specific to spreadsheet applications. Terminology that we learned when we looked at wordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet applications.
-A-
Back To Top
Absolute Cell Reference: An absolute cell reference is one that does not change when it is copied. To make a cell reference absolute, you must include a $ before the reference (ex: $C$4).The other type of reference is a Relative Reference..
Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard. The current active cell can be identified as being the one that has a darker black border around it. Also, the active cell reference is listed in the Name Box directly above the spreadsheet's column headings.
Anchor Cell: The anchor cell is the first cell that is highlighted in a range. When a range of cells is selected, they appear as highlighted in black. The anchor cell, however, remains white. If only one cell is selected in the sheet, it is the anchor cell.
-B-
Back To Top
Bar / Column Chart: A bar or column chart is a style of chart that is used to summarize and compare categorical data. The length of each bar represents the aggregate value (ex: sum) of that particular category. Bars run horizontally and columns run vertically.
-C-
Back To Top
Cell: A cell is a rectangular area formed by the intersection of a column and a row. Cells are identified by the Cell Name (or Reference, which is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3. Cells may contain Labels, Numbers, Formulas or Functions.
Cell Name: By default, the name of a cell is the cell reference. You may, however, define a particular cell or range of cells with an alternative name. This alternative name can then be used in formulas and functions and provide a quick way to jump to a particular area of the spreadsheet.
Cell Reference: A cell reference is the name of the cell that is found by combining the Column Letter with the Row Number. For example the cell in Column "C" in Row "3" would be cell C3.
Column: Columns run vertically on the spreadsheet screen. An Excel spreadsheet contains 256 columns that are labeled with the letters of the alphabet. When the column labels reach letter "Z" they continue on with AA, AB, AC...... AZ and then BA, BB, BC.....BZ etc.
Column / Bar Chart: A column or bar chart is a style of chart that is used to summarize and compare categorical data. The length of each bar represents the aggregate value (ex: sum) of that particular category. Columns run vertically and Bars run horizontally.
-D-
Back To Top
Data: Data refers to the type of information that can be stored in the cells of a spreadsheet. Spreadsheet data types include values (numbers), labels, formulas and functions.
-E-
Back To Top
Enter key: The Enter Key on the keyboard is used to accept any data that has been typed in a cell and move the active cell down vertically to the next one in a column.
-F-
Explanation:
is a collection of continuous cells selected