Lucindajohns

Solver is an enhanced Excel tool that is an example of an Excel: - Add-In A solver problem has three components, known as.... - Parameters A cell with a formula that will be solved for specific results is called a(n) - Object Cell A forecast sheet inserts functions into its tables from which function category - Statistical A saved set of values in a worksheet that function as "what-if" analysis tools are called: - Scenarios

syntax error - Occurs when formula or function construction rules are violated hyperlink - an electronic marker that, when clicked, connects to another location in the same or a different worksheet, opens another file, opens a webpage in a web browser, or opens an email client and inserts an email address into the To box validation rule - rules that dictate the type of data that can be entered in a cell IF ERROR function - checks a cell and returns the result, if possible, or returns an err...

3-D formula - A formula or function that refers to the same range in multiple worksheets Data validation - Requires that rules be followed in order to allow data to be entered in a cell Dependent cell - A cell containing a formula that is dependent on other cells to obtain its value Destination file - A file that contains a pointer to the source fi

Grouping - selecting two or more worksheets so you can perform the same action at the same time White - When worksheets are grouped: Worksheet tabs display a _______ background color Title - When worksheets are grouped: [Group] appears in the ______ bar

You have a workbook that contains sales data for different regional sales reps of a company. Which task is the least likely to be done while the worksheets are grouped? - Enter specific values for the first sales rep. Your manager sent you a workbook that contains data validation rules. One rule specifies a maximum value of 15% with a warning alert. You try to enter 22% in that cell. What happens? - Excel displays a message box informing you the value is above the maximum value and lets you...

An error that occurs when formula construction rules are violated - Syntax Error An electronic marker to another location in a worksheet, workbook, file, Web page, or email. - Hyperlink Rules that dictate the data to enter in a cell. - Validation criteria A logical function that checks a value and returns the result if possible or an error message. - IFERROR function

Describe the plum pudding model - A ball of positive charge with negative electrons in embedded in it Who disproved the plum pudding model and how? - Rutherford and Geiger + Marsden By conducting the gold foil experiment. Positively charged alpha particles were fired at a very thin sheet of gold foil. If the plum pudding model was correct then the charged particles would have mostly deflected off the gold foil, but most of the particles passed straight through

What does DNA stand for? - Deoxyribonucleic acid What does RNA stand for? - Ribonucleic acid What does DNA store? - Genetic information - all the instructions needed to grow and develop. What is the main function of RNA? - To transfer genetic information from the DNA to the ribosomes. What are ribosomes? - The site at which protein synthesis takes place - read RNA molecules to make polypeptides (proteins) in translation. What are ribosomes made of? - RNA and proteins

Topic One - Biological Molecules 3.1.1 - monomers and polymers Most carbohydrates are... - Polymers What are polymers - Polymers are large molecules composed of many smaller units called monomers What are monomers - A monomer is a small molecule that reacts with a similar molecule to form a larger molecule. Polymer examples - potiens, nucleic acids

test for Carbon Dioxide (CO2 ) - turns limewater milky (sparingly soluble Ca(OH) 2 forms insoluble CaCO3 ) Chlorine (Cl2 ) test - bleaches damp litmus paper (Cl2 reacts with water to form HCl and HOCl) Hydrogen (H2 ) test - pops with a lighted splint Oxygen (O2 ) test - relights a glowing splint Carbonate (CO 3 2- ) test - add dilute acid; effervescence, carbon dioxide produced Sulfate (SO4 2- ) test - add dilute nitric acid then aqueous barium nitrate. Gives white precipitate Chloride (C...