C268 Spreadsheet Midterm Exam 2025

Spreadsheet Model - -Represents the logic of a more complicated logical process through functions Absolute Cell Reference - -A cell reference that remains constant when a formula is pasted into a new cell, containing a $. Whenever possible, it is often best to use an absolute cell reference Algorithm - -The level of confidence that we want to have with our estimate. Calculated as 1, so 95% confidence is noted as .05(or 1-95%). Arguments - -The inputs of a function Arrays - -A set of values made of at least two numbers Boolean Logic - -Based on Boolean algebra and functions with only two values:0 and 1 Cells - -Rectangular boxes in a worksheet that store individual pieces of data or calculations Column_index_number - -Column in the lookup table that contains the information that will be returned by the function Column Charts - -A chat that compares different categories of items or the same category over time. They depict the types of item (or different times) across the horizontal axis and the values for each category as a pillar rising into the vertical axis Conditional Functions - -Calculations where the cell references used to complete the calculations depend on the values of other cells in a worksheet Confidence Intervals - -The range of values within which we believe the true value for the population falls Correlation Coefficient - -A statistical relationship between two things. Ranges between 1 and 1. Data Series - -A set of data that you want to include on your chart Data Tables - -An analysis tool that allows users to specify a number of different possible states for one or two input variables and construct a table in a worksheet that calculates an outcome for our model based on each state of the input variables. C268 C268 Dependent variable - -The value we are trying to predict. Direct circular reference - -A cell that contains a reference to itself Filter - -To screen the data used in a pivot table Forecasting - -Making predictions about one set of values in your spreadsheet using information you know about another set of values Function wizard - -The function arguments window in excel. Allows for the selection of inputs (arguments), provides descriptions of the functions of arguments, and lists the function result based on inputs entered. Goal Seek - -In analysis tool that allows users to work backwards, specifying the desired value for an outcome cell and selecting an input sell the Excel should modify to achieve the desired outcome. Independent variable - -The value that we are using to predict the other variable Indirect circular reference - -Cell references another cell that eventually references back to its self Line chart - -Compares the values of a particular category overtime. By connecting the dots of the individual data series values, these charts are particularly helpful for uncovering trends in a data set. Logical test - -A condition test on a cell value to see if it's true or false Look up value - -First argument in a look up function, holds the information that function will look for in the look up table Measure - -The part of a calculation to which end algorithm is applied. Example; gas price Negative correlation - -Wind values for one thing decrease the values of the other increase. Optimization model - -A model used to find out the optimal solution for a problem. The three major elements are (1) the objective, which represents the best possible outcome for the model or optimal solution, (2) decisions, which are the elements of the model that can change it to arrive at the optimal solution, and (3) one or more constraints, which must be satisfied by the optimal solution. C268 C268 Page orientation - -The layout of the paper when the worksheet is printed. "Portrait" orientation means that the worksheets will be printed on the page with the widest part of the page running from the top to the bottom. "Landscape" orientation means that the worksheet will be printed with the wides part of the page running from side to side Pie chart - -Used to compare the parts of category to the hole. Typically each of the parts is expressed as a percentage of the whole Pivot Tables - -Used to organize and summarize large amounts of data. Also allows users to change how they summarize the data And to look at it in different ways Population - -The complete set of entities for an item of interest Positive correlation - -When values for one thing increase values for the other also increase Qualitative - -Data that are descriptive, such as name, location, gender, etc.; often used to classify data into groups Quantitative - -Numerical data, generally used as the basis for calculations Range - -A group of cells in a continuous block Reference functions - -Functions to allow you to look up frequently used values on a reference table in Excel Relative cell references - -Cell references that automatically update when a formula is basted to a new cell Row_index_num - -Wrote in the look up table that contains the information returned by the function Sample - -A part of a population or set of entities Scenario manager - -In analysis that examines the impact of several inputs to a spreadsheet model changing at the same time. It is sophisticated enough to allow you to create a number of different scenarios based on different states of the same set of inputs. In this way, you can compare a number of different hypothetical situations at the same time. Slicer - -A visual method for applying a filter to a pivot a table Solver - -An Excel add -in that you can use to solve optimization problems C268 Stacked column chart - -A column chart that breaks the column bars into segments that represent subcategories that are consistent across the columns Standard deviation - -A measure of how diverse the elements in our data set are Table_array - -A grouping of rows or columns that defines the location of the reference table used in a function Themes - -Built-in colors and styles that can be applied to entire worksheets Value_If_falls - -The value that will be reported if the logical test is false Value_If_true - -The value that will be reported if the logical test is true Values - -Define which data will be displayed on the pivot table. Can display more than one field at a time Workbook - -An Excel file that stores all the information, previous calculations, and analysis, that you may have already completed. Must contain at least one worksheet Worksheet - -Contains data and calculations and is organized into a collection of cells arrange in the form of a table Range_look up - -Optional True or false argument that specifies if an exact match is required. True (default) allows for an approximate match. False will return a value o