Computer Science > QUESTIONS & ANSWERS > Exam 2 SIMNET Questions (All)

Exam 2 SIMNET Questions

Document Content and Description Below

Exam 2 SIMNET Questions Imported content in a worksheet that originated in another program or format is called: - ✔✔External Data The Statistical function that does computations only after data ... meets multiple criteria is - ✔✔COUNTIFS Database functions all follow the same syntax and have three: - ✔✔Arguments The database function that counts the cells in the field that are not empty and that meet the criteria is - ✔✔DCOUNTA The Math & Trig function that totals cells only if they meet specified criteria, including cells from more than one column, is - ✔✔SUMIFS This function displays the contents of the cell at the intersection of an identified column and row - ✔✔INDEX A range of cells that you select in which to apply a function is called an - ✔✔Array In a calculation, the difference between actual values and predicted values is called - ✔✔Forecast error Which type of function would you use to format a value as a label - ✔✔Text In a financial function, nper stands for: - ✔✔Number of payments 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):` - ✔✔Objective Cell A forecast sheet inserts functions into its tables from which function category? - ✔✔Statistical A saved set of values in a worksheet that functions as a "what-if" analysis tool is a(n) - ✔✔Scenario What settings determine how data is summarized in a PivotTable? - ✔✔Value field A generated worksheet that displays values for changing and result cells for each scenario in a workbook is called a(n): - ✔✔Scenario summary report An Excel add-in with statistical and engineering functions is the - ✔✔Analysis toolpak A series of scenes created by 3D map that will visualize your data is an - ✔✔Tour A problem-solving method that starts with a result and calculates the value to reach that result is: - ✔✔Backsolving A range of cells that shows calculated results of one or more formulas is called a(n): - ✔✔Data table A column chart that illustrates the frequency of each data point in a data set is called a(n): - ✔✔Histogram A forecast sheet calculates: - ✔✔Future Values How many scenarios can be displayed in a worksheet at any one time? - ✔✔One A COM add-in that enables you to use millions of records in the data model for a PivotTable is a(n): - ✔✔Power pivot The Slicer tool creates an on-screen window that acts as a(n): - ✔✔Filter Available Add-ins for Excel are found in the: - ✔✔Excel options dialogue box A collection of tables and queries in a workbook is called a: - ✔✔Data model To create a slicer, click the Insert Slicer button in the Filter group on the: - ✔✔PivotTable Tools Analyze tab. ec 1: what is the name of the seminole indian leader that one selected fsu portrays at various fsu events? - ✔✔osceola ec 2: how many different fsu students have portrayed this famous seminole? - ✔✔16 ec 3: what is the name of the horse he rides? - ✔✔renegade ec 4: what is the breed of the horse? - ✔✔Appaloosa ec 5: how many different horses have had this honor since the tradition started in 1978? - ✔✔6 [Show More]

Last updated: 2 years ago

Preview 1 out of 4 pages

Buy Now

Instant download

We Accept: