IC3 Key Applications Exam Questions And Answers 100% Solved

IC3 Key Applications Exam Questions And Answers 100% Solved AVERAGE - answerA function that averages the numbers in a range. Active Cell - answerThe active cell is the cell that is currently highlighted (chosen) and ready to receive or manipulate data. Bar Chart - answerA graphical representation of data where the information runs left to right. Bar charts show progression, trend, and comparison of different series. Boolean Operators - answerSimple words such as AND, OR, or NOT which are used in formulas to sort or filter data. COUNT - answerA function that counts the entries in a range but does not total the entries. Cells - answerThe single rectangular box which text or data can be inserted into. Cells are the intersecting points of a column and a row. Column Chart - answerA graphical representation of data where the information runs up and down. Column charts show quantity, volume, and comparison of different series. Columns - answerA series of cells which run vertically from top to bottom of a spreadsheet. Columns are identified by a letter in the column header. Copy - answerAn action in word processing, spreadsheet, or presentation programs which allows a user to duplicate text and place the information on the Clipboard. Cut - answerAn action in word processing, spreadsheet, or presentation programs which allows a user to remove data from one area and place it on the Clipboard for use later. Database - answerA collection of data organized into tables which may be used to keep track of information in an easy-to-reference format. Export - answerThe act of sending or transferring a saved database to another application. Field - answerAn area used to separate different groups of data which will be stored in a database. The field is what keeps track of one specific portion of the table, similar to a column or row in a spreadsheet. Filter - answerA selection criteria for the retrieval and display of records in the database where only those data records are shown in a card file window which comply with the chosen filter criteria.