| 3D map |
a type of map that is three dimensional and appears to have all three spatial dimensions including length, width, and depth |
| Absolute |
a cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied and is indicated by the $ sign |
| Accounting Number Format |
an Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, two decimal places and leaves a small amount of space at the right edge of the cell to accommodate parenthesis for negative numbers |
| Active cell |
the cell surrounded by a black border that is ready to have content typed into it or perform a command |
| Auto fill |
an Excel feature that generates and extends values into adjacent cells based on the values of the selected cells |
| Average |
an Excel function that adds a group of values and then divides the result by the number of values in the group |
| Blank workbook |
a file that data has not been entered into it yet and contains one or more worksheets |
| Cell content |
anything typed into a cell |
| Cell styles |
a defined set of formatting characteristics such as font, font size, font color, cell borders, and cell shading |
| Chart editor |
provides options to edit and customize a chart in Google Sheets |
| Chart sheet |
a workbook sheet that contains only a chart |
| Chart title |
a label that describes the chart purpose |
| Clear all |
when selected all formats and comments that are contained in the selected cells will be cleared |
| Clear contents |
when selected clears only the contents in the selected cells while leaving any formats and comments in place |
| Columns |
a vertical group of cells in a spreadsheet, indicated by letters |
| Comma Number Style |
an Excel number format that inserts a thousand comma separators when needed with two decimal places, and leaves a space to the right to accommodate parenthesis for negative numbers |
| Constant value |
a set value that does not change and is directly typed into a cell. There are two types: text and number values |
| COUNTIF |
a statistical Excel function that counts the number of cells within a range that meet the given condition and has two arguments – the range of cells to check and the criteria |
| Ctrl + F2 |
a keyboard shortcut that displays the print preview |
| Data analyst |
an IT professional whose responsibilities include inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making |
| Data labels |
a text that describes and identifies data in a chart |
| Decrease decimal |
for numbers already entered in a worksheet, you can increase or decrease the number of decimal places displayed by using the toolbar buttons |
| F7 |
a function key that runs spelling and grammar check when pressed |
| Fill handle |
the small square in t