Papersbyjol

Spreadsheet - ANSWER-an electronic file used to organize related data and perform calculations Worksheet - ANSWER-a spreadsheet that contains formulas, values, text, and visual aids Workbook - ANSWER-a file containing related worksheets - identified by a sheet tab What are two of the basic components of a spreadsheet? - ANSWER-Workbooks and worksheets Formula Bar - ANSWER-The contents of the active cell are displayed here Active Cell - ANSWER-Represented by black/dark border, cel...

Alignment - ANSWER-The position of data between the cell margins Auto Fill - ANSWER-Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells Cell - ANSWER-The intersection of a column and row Column Width - ANSWER-The horizontal measurement of a column Fill Color - ANSWER-The background color appearing behind data in a cell Fill Handle - ANSWER-A small green square at the bottom-right cor...

Subtotal - ANSWER-Displays summary calculation of values for a category in a column. MUST SORT FIRST before calculating. grouping - ANSWER-A process of joining related rows or columns of related data into a single entity so that groups can be collapsed or expanded by data analysis. data mining - ANSWER-the process of analyzing large volumes of data to discover patterns and identify trends in the data. COLUMNS area (Pivot Table) - ANSWER-Displays columns of summarized data for the select...

Worksheet - ANSWER-A spreadsheet that contains formulas, functions, values, text & visual aids Workbook - ANSWER-A file containing related worksheets Name Box - ANSWER-Identifies the address of the current cell Fill Handle - ANSWER-A small green square at the bottom-right corner of a cell Value - ANSWER-A number that represents a quantity or amount Formula - ANSWER-A combination of cell references, operators, values, and functions Formula Bar - ANSWER-Displays the contents st...

when do you use structured references? - ANSWER-w/ respect to tables with data ***must specifically name a data table what is the difference btwn a qualified and unqualified structured reference? - ANSWER-if you use a structured reference within a table, unqualified if you use a structured reference outside a table, fully qualified reference qualified has table name in formula what is analysis of variance used for? - ANSWER-Test to determine if samples of data were taken from the sa...

grouping - ANSWER--selecting 2 or more worksheets so you can perform the dame action at the same time, the worksheets will have identical structure and formatting -can group and ungroup What does grouping worksheets improve? - ANSWER--productivity, can perform data entry, structural changes (add,deleting,widening rows/columns), formatting page layouts, and printing -You can copy worksheets from one workbook to another Worksheet refrences - ANSWER-Allows you to reference cells in other wo...

• Database - ANSWER-Collection of data organized in a manner that allows access, retrieval, and use of that data • Garbage in, garbage out (GIGO) - ANSWER-computer phrase that means you cannot create correct information from incorrect data • Data - ANSWER-Collection of unprocessed items. Text, Numbers, Images, Audio, Video • Information - ANSWER-Processed data. Documents, Audio, Images, Video • Database software/Database Management System (DBMS) - ANSWER-provides means to e...

• Database - ANSWER-Collection of data organized in a manner that allows access, retrieval, and use of that data • Data - ANSWER-Collection of unprocessed items. Text, Numbers, Images, Audio, Video • Database software/Database Management System (DBMS) - ANSWER-provides means to ensure that only authorized users access data at permitted times • Data Integrity - ANSWER-Defines the quality of the data • Garbage in, garbage out (GIGO) - ANSWER-computer phrase that means you can...

Microsoft Excel - ANSWER-- a spreadsheet software for creating an electronic workbook - create a simple to complex personal or business workbooks what does a Workbook consist of? - ANSWER-Consist of rows and columns to organize data, perform calculations, print reports, and build charts. -named BookN with numbers assigned in order throughout a work session Workbook - ANSWER-the file you open, edit and save What does a workbook contain? - ANSWER-worksheets -AKA (spreadsheets or a sh...

Grouping - ANSWER-Process of selecting two or more worksheets to perform the same action at the same time Ungrouping - ANSWER-Process od deselecting worksheets that were grouped Hyperlink - ANSWER-Electronic marker to another location in a worksheet, workbook, file, web page or email Precedent Cell - ANSWER-Cell referenced by a formula in another cell Dependent Cell - ANSWER-Cell containing a formula that is dependent on other cells to obtain its value IFERROR - ANSWER-Checks a va...