CSC 1123 Computer Applications Final Exam Study Guide Questions and Answers

CSC 1123 Computer Applications Final Exam Study Guide Questions and Answers absolute cell reference A reference that does not change when the formula is copied or moved to a new location. Also refers to a cell by its position relative to a cell that contains the formula; automatically adjusts when a formula is copied. Alignment A setting that refers to how text is positioned between the margins. Previous Play Next Rewind 10 seconds Move forward 10 seconds Unmute 0:00 / 0:15 Full screen Brainpower Read More average adds a group of values and then divides the result by the number of values in the group. addition sum Bullets A symbol used to precede text, usually in an outline or a list. Cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. cell reference The column letter and the row number. Example: B12 Chart A visual representation of numerical data. CLOUD Storage / CLOUD Computing Using the internet to store files or access programs that are not on your local machine or local network. Examples are Google Docs, Xdrive, MediaMax and Strongspace. conditional formatting An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed. It changes the appearance of a cell, for example, by adding cell shading or font color- based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted criteria conditions that you specify in a logical function. Count returns the number of cells in a range that contains numbers Datasheet View A spreadsheet-like view of a table in which each record is a row and each field is a column. Or you can understand it by knowing its the Access view that displays data organized in columns and rows similar to an Excel worksheet. Design View An access view that displays that detailed structure of a table, query, form, or report. For forms and reports, it may be the view in which some tasks must be performed, and only the controls and not the data, display in this view. division To divide multiple cells successively, type cell references separated by the division symbol. For example, to divide the number in A2 by the number in B2, and then divide the result by the number in C2, use this formula: =A2/B2/C2. Error message-#DIV/ when a number is divided by zero (0). It happens when you enter a simple formula like =5/0, or when a formula refers to a cell that has 0 or is blank Field A single characteristic of data that appears in a table as a column. In Excel, the top row of a table contains the field names for the table. This row is usually referred to as a header row. Form or "data form" allows you to add, edit and delete records (rows) and display only those records that meet certain criteria. Formatting marks Characters that display on the screen, but do not print, indicating where the Enter key, the Spacebar, and the Tab key were pressed; also called nonprinting characters. The error message ###### means that there is(are) insufficient width in cell to display data, or negative date/time. IF function Function that is used to make a decision based on a comparison. Can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A170,"Pass","Fail"). maxmium Formula is "MAX( number1, [number2], ... )" Median the middle score in a distribution; half the scores are above it and half are below it. Example is "=MEDIAN(1,2,3,4,5)" returns 3. Microsoft Access A Microsoft application used to create a database. Microsoft Excel A Microsoft application that allows users to create spreadsheet documents. Microsoft Office An application package, including applications such as MS Word, MS Excel, MS PowerPoint, MS Publisher, etc. Microsoft PowerPoint A Microsoft application that allows a user to create presentation documents used to display information to enhance the flow of information, such as while giving a speech.