CIS 101: Midterm Exam Review
CIS 101: Midterm Exam Review CIS 101
Popular in Introduction to Computing
Popular in ComputerScienence
This 2 page Study Guide was uploaded by Melissa Cirasella on Friday September 18, 2015. The Study Guide belongs to CIS 101 at Pace University taught by Andrea Taylor in Fall 2012. Since its upload, it has received 57 views. For similar materials see Introduction to Computing in ComputerScienence at Pace University.
Reviews for CIS 101: Midterm Exam Review
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 09/18/15
CIS 101 Midterm Review Active cell the cell currently selected in the active worksheet Active sheet the sheet currently displayed in the workbook window Active workbook Adjacent range a group of cells in a single rectangular block ofceHs Nonadjacent range the combination of two or more distinct adjacent ranges AutoComplete the feature that helps make entering repetitive content easier as you type text into the active cell Excel displays text that begins with the same letters as a previous entry in the same column AutoFill ll handle a feature that copies content text values or formulas and formats from a cell or range into an adjacent cell or range AutoFit to eliminate empty space by matching the row height or column width to its tallest or longest cell entry Banded rows a table style in which different ll colors are applied to adjacent rows in an Excel table Cell the intersection of a single row and a single column Cell range a group of cells which can be either adjacent or nonadjacent Cell reference the column and row location that identi es a cell within a worksheet for example the cell reference B6 refers to the cell located where column B intersects row 6 Range reference Absolute cell reference a cell reference that remains xed when the cell formula is copied to a new location Relative cell reference Mixed cell reference a cell reference that contains an absolute row such as D6 or an absolute column such as D6 Chart a visual representation of a set of data values used to show trends or relationships that may not be readily apparent from numbers alone Graphs a visual representation of a set of data values used to show trends or relationships that may not be readily apparent from numbers alone Bar chart a column chart turned on its side so that the length of each bar is proportional to its value Column chart a chart that displays values in different categories as columns the height of each column is based on its value Pie chart a chart in the shape of a circle like a pie that shows data values as a percentage of the whole Embedded chart a chart object placed in a worksheet Chart sheet a sheet that contains only the chart and no worksheet cells Exploded pie chart a pie chart that moves one slice away from the others as if someone where taking the piece away from the pie Line chart a chart that displays data values using a connected line rather than columns or bars Chart area the chart and all of the other chart elements Chart title a descriptive label or name displayed at the top of the chart sheet Tick marks a line that identi es the units at regular intervals on a chart axis Combination chart a chart that combines two or more Excel chart types into a single graph Conditional formatfo rmatti ng that is applied only when a cell39s value meets a speci c condition Data bars a conditional format that adds a horizontal bar to the background of a cell proportional in length to the cell39s value Highligh ting Data Iabel text associated with an individual data marker such as a pie slice Data series a range of values plotted on a chart Data source a range that contains the data displayed in a chart FiII handle a small black square in the lowerright corner of a selected cell or range that you drag over an adjacent cell or range to copy the original content and formatting into the selected range Format painter a feature that copies and pastes formatting from one cell or range to another without copying and pasting the data Formula a mathematical expression that returns a value Formula bar the bar located below the Ribbon that displays the value or formula entered in the active cell Function a named operation that returns a value used to simplify formulas Argument the numbers text or cell references used by the function to return a value NOW function IF function a logical function that tests a condition and then returns one value if the condition is true and another value if the condition is false TODAY function a date function that displays the current date SUM function a function that returns the sum of the values in the range MAX function a function that returns the maximum value of the values in a range MIN function a function that returns the minimum value in the range Live preview an Of ce feature that shows the results that would occur in your le such as the effects of formatting options on document39s appearance if you clicked the option to which you are pointing Merge to combine such as several cells into one cell Center Ready mode Enter mode Edit mode the mode in which you can edit cell contents Point mode Name box the box located at the left side of the formula bar that displays the cell reference of the active cell Portrait orientation the page orientation where the page is taHerthanitis wide Landscape orientationthe page orientation where the page is wider than it is tall Sizing handle a square or dot on the selection box that is used to changethe object39s width and height Theme a collection of formats for text colors images and graphical effects applied throughout a workbook Whatif analysis an approach in which you change one or more values in a spreadsheet and then assess the effect those changes have on the calculated values
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'