Bitm - Study guides, Class notes & Summaries

_________ are small charts that appear in a single cell? A. Bar chart B. Column chart C. Sparklines D. Pie chart - C. sparklines _________ change(s) the appearance of cells based on user criteria. A. Sorting B. Filtering C. Structured references D. Conditional formatting - D. conditional formatting

Bitm chpt 5 Questions &Exam (elaborations) answers 100% satisfaction guarantee

BITM 215 Questions with 100% Correct Answers Graded A+ | Verified | Latest Update 2024, Actual Complete Solutions ,Garanteed Distinction

BITM 215 Questions &Exam (elaborations) answers 100% satisfaction guarantee

External Reference Syntax - ANS a reference to a cell or range of cells in another workbook. Precedent Cell - ANS Cells referenced by a formula in another cell Use Trace Precedents command to graphically display, using tracer arrows, the relationship between these cells and formulas Select the cell that contains the formula for which you will find the precedent cells Click Trace Precedents in the Formula Auditing group on the Formulas Tab PROPER function - ANS Ca...

You want to apply a subtotal to a dataset containing names, departments, and salaries. What is the first step you need to do? (a) Filter the dataset by salaries (b) Select the function to be used for the subtotal (c) Insert new rows where you want the subtotal rows within the dataset (d) Sort the data by a field containing categories - (d): sort the data by a field containing categories

Workbook - An Excel file with one or more worksheets. cell - The intersection of a column and a row in a worksheet. cell reference - The column letter and the row number. Example: B12 range - a rectangular group of cells such as A1:B3 label - text data in a worksheet that is not used in calculations value - numerical data in a worksheet

consolidated worksheet - combines data from multiple worksheets using a mathematical or statistical function A static data consolidation - places a non-changing result in the consolidation sheet. If the source data is edited, the consolidated sheet is not updated. The Consolidate button is located - on the Data tab in the Data Tools group. A dynamic data consolidation places - formulas in the consolidation worksheet. If the source data is edited, the consolidated sheet is automatically upd...

Database - Collection of data organized in a manner that allows access, retrieval, and use of that data • Data - Collection of unprocessed items. Text, Numbers, Images, Audio, Video • Information - Processed data. Documents, Audio, Images, Video • Database software/Database Management System (DBMS) - provides means to ensure that only authorized users access data at permitted times

What is Grouping? - Selecting two or more worksheets so you can perform the same action at the same time. T/F: You must ungroup the worksheets if you want to perform a task only on one worksheet. - TRUE Data Entry - Entering labels, values, dates, and formulas Structural Changes - Inserting and deleting rows and widening columns. Formatting - Changing fonts, alignment, and number formats. Page Layouts - Inserting headers and changing page orientation.