Papersbyjol

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...

You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first step you need to do? (a) Filter the dataset by salaries (b) Select the function to be used for the subtotal (c) Insert new rows where you want the subtotal rows within the dataset (d) Sort the data by a field containing categories - ANSWER-(d): sort the data by a field containing categories Why would you click the collapse outline symbol above a column of outlined data? (a) You wa...

Workbook - ANSWER-An Excel file with one or more worksheets. cell - ANSWER-The intersection of a column and a row in a worksheet. Active Cell - ANSWER-a selected worksheet cell that is ready for data entry cell reference - ANSWER-The column letter and the row number. Example: B12 range - ANSWER-a rectangular group of cells such as A1:B3 label - ANSWER-text data in a worksheet that is not used in calculations value - ANSWER-numerical data in a worksheet

Data - ANSWER-collection of unprocessed items Database - ANSWER-collection of data organized as meaningful info that can be accessed, managed, stored, queried, sorted and reported Information - ANSWER-processed data from a database. The finished product of a database objects - ANSWER-main components that are created and used to make the database function tables - ANSWER-include data...made up of records and fields about one type of entity. Ex of entity: student, DVD, CD, piece of fur...

How many hours will a Class One Brake test once your train is off air? - ANSWER24 Hours T/F When performing a Class One Brake test, you must make sure that the brakes apply and release on each car. - ANSWERTrue To what, do you arm the EOT? - ANSWERHTD What is a branch pipe cut out valve use for? - ANSWERTo cut air brakes in and out What speed must not be exceeded when doing an roll by inspection? - ANSWER10 mph Telemetry can be use to perform air brake checks and to meet 2 way equip...