click below
click below
Normal Size Small Size show me how
Lesson 1
Excel
Question | Answer |
---|---|
workbook | an excel file with one or more worksheet |
worksheet | the work area for entering and calculating data made up of columns and row separated by grid lines. also called a spreadsheet |
cell | the intersection of a column and a row on a worksheet. you enter data into cells to create a worksheet |
active cell | the active cell contains the cell pointer there is a dark outline around the active cell |
formula bar | as you enter data into a cell, it simultaneously appears in the formula |
cell reference | the location |
scroll | a way to view locations on the worksheet without changing the active cell |
sheet tabs | tabs that appear at the bottom of the worksheet without changing the active cell |
tab scrolling buttons | buttons that appears just to the left of the sheets tabs, which allow you to scroll hidden tabs into view |
label | text in the first row or column of a worksheet that identifies the type of data contained there |
defaults | the standard settings excel uses in its software, such as column width or number of worksheets in a workbook |
Auto Complete, | a feature used to complete an entry based on previous entries entries made in the column containing the active cell |
autocorrect | order of mathematical operations |
series | a lists of sequential numbers, data, time,or text |
label prefix | an apostrophe(') used to indicate that a numbers is a label and not a value |
numeric label | a number entered in the worksheet as a label, not as a value such as the year 2005 use ad as a column |
formula | an instruction excel uses to calculate a number. |
mathematical operators | symbols used in mathematical operations. |
order of mathematical operations | the order in which excel performs the calculations specified in a formula. |
value | a number entered in the worksheet |