Excel Unit A Vocab
cell
A cell is the intersection between a row and a column on a spreadsheet that starts with cell
workbook
A workbook is the MS Excel file in which you enter and store related data.
active cell
Active cell. Alternatively referred to as a cell pointer or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet.
worksheet
An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns.
electronic spreadsheet
An electronic spreadsheet is a computer application that displays and organizes data. Each data is stored in a cell of a worksheet and can be manipulated using formulas to calculate or change the data in other cells.
formula prefix
Another acceptable formula prefix is the plus sign (+), as in "+ 2 + 2.
formula bar
By clicking the Formula Bar, or when you type an equal (=) symbol in a cell, the Formula Bar will activate.
calculation operators
Following the equal sign are the elements to be calculated (the operands), which are separated by calculation operators.
what if analysis
What-if analysis is the process of changing the values in cells to see how those changes will affect the outcome of formulas on the worksheet.
arguments
arguments The syntax of an Excel or Google Spreadsheet function refers to the layout and order of the function and its arguments
arithmetic operators
arithmetic Operators. Operators are the symbols used to tell Excel what type of calculation the formula is to perform. For basic mathematical operations, such as addition, subtraction, or multiplication, use the arithmetic operators shown in Table 7-1.
cell adress
cell address
cell pointer
cell pointer or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet.
cloud computing
cloud computing
text concatenation operators
concatenation operators, and reference. ... Arithmetic operator. Meaning. Example ...
edit
edit
values
efinition and use of the term "value" as it pertains to Excel and Google Spreadsheets.
formula
formula Image result for formula excel definition Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet
function
function You can type in a formula (though you have to be sure it's exactly right) or you can use Excel's preset formulas called functions
labels
labels Labels and values. Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data. All words describing the values (numbers) are called labels.Mar 21, 2012
mode indicator
mode indicator on the status bar, this specifies the current mode of Excel, such as Enter or Ready
insertion point
n graphics-based programs, the insertion point is the point where the next characters typed from the keyboard will appear on the display screen. The insertion point is usually represented by a blinking vertical line. You can reposition the insertion point by pressing arrow keys or by moving the I-beam pointer.
range
range
scroll bars
scroll bars A bar that appears on the side or bottom of a window to control which part of a list or document is currently in the window 's frame.
sheets tab
sheets tab
sheets tab scrolling buttons
sheets tab scrolling buttons These are the four buttons that appear to the left of the sheet tabs. They are used to bring hidden sheet tabs into view if they are not already visible. sheets tab scrolling button
status bar
status bar. noun, Computers. 1. a row at the bottom of a window that displays information about the window, as the status of a Web page load or details of an open document. British Dictionary definitions for status bar Expand.
name box
the Name Box is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet.
comparison operators
two values in the formula and the result of that comparison can only ever be either comparison operators