BITM 215
Las últimas cargas en BITM 215. ¿Buscando notas en BITM 215? Tenemos muchas notas, guias de estudio y notas de estudio disponsible para tu escuela.
-
102
- 0
-
6
All courses for BITM 215
-
BITM 215 102
Último contenido BITM 215
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Importing 
The process of inserting external data into the current application 
External data 
Data created or stored in another format 
Two common file types imported into Excel 
-Text files 
-Access database files 
Two ways to import directly into Excel 
-Opening the file using the Open dialog box 
-Creating a link to the original data source 
Embed data 
When you import external data into Excel but not maintain a link to the ori...
- Package deal
- Examen
- • 4 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Goal Seek is used to 
Work Backwards from a solution to determine one variables required value. A tool that identifies the necessary input value to obtain a goal by changing one variable. Only one variable and one result 
Scenario Manager 
is a What- if analysis tool that enables you to define and manage up to 32 scenarios to compare their effects on calculated results 
scenario summary report 
an organized structured table of the ...
- Package deal
- Examen
- • 4 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
 
What is the purpose of grouped worksheet? 
To apply formatting or data to multiple sheets at the same time. 
What is the purpose of a Watch Window? 
To see how changes in data affect formulas on another table 
What is the purpose of data validation? 
To limit the number of data entry errors 
PowerQuery is used to ____ and PowerPivot is used to ____? 
Get and Transform Data, Analyze Data 
Why would you create and use a data model?...
- Package deal
- Examen
- • 2 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Precedent Cell 
A cell referred to by a formula in another cell. 
Watch Window 
A separate window from the worksheet window that displays cell addresses, values, and formulas so you can monitor and examine formula calculations involving cells not immediately visible on the screen. 
IFERROR Function 
A logic function that checks a cell to determine if that cell contains an error or if a formula will result in an error. If no error e...
- Package deal
- Examen
- • 8 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 CHAPTER 12 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Accessibility Checker 
A tool that detects issues that could hinder a user's ability to use a workbook. 
Collaboration 
A process that occurs when multiple people work together to achieve a common goal by using technology to edit the contents of a file. 
Comment 
1) A notation attached to a cell to pose a question or provide commentary. 
2) A line that documents programming code; starts with an apostrophe and appears...
- Package deal
- Examen
- • 1 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM CHAPTER 11 QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
Comma Separated Values (CSV) File 
A text file that uses commas to separate text into columns and a newline character to separate data into rows. 
CONCATENATE Function 
A text function that joins two or more text strings into one text string. 
Data Range Property 
A setting that controls the format, refresh rate, and other characteristics of a connection to external data. 
Delimiter 
A character, such as a comma or tab, us...
- Package deal
- Examen
- • 2 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
cost structure examples 
Rent, utilites, payroll, etc. 
What does SMAC stand for?(in digital Economy) 
Social Mobile Analytics Cloud 
What does social in SMAC mean? 
Social media, mainly mobile things 
What companies uses analytics in SMAC? 
Uber and grubhub 
What is cloud from SMAC stand for and examples? 
Not a physical place ex: Dropbox, amazon 
What does IoT stand for? 
Internet of Things 
What is an example of an internet of t...
- Package deal
- Examen
- • 4 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
How many people can access Blackstone LaunchPad? 
over 630K students globally 
Who can use LaunchPad? 
Students, staff, alumni 
What is LaunchPad? 
a campus based entrepreneurship program 
Small businesses make up how much of the private economy? 
46% 
what % of total # of businesses are small businesses? 
99% 
small businesses create ___ in 10 new jobs 
6 
from 1996 to 2013, what has been the % change of new entrepreneurs aged 20 ...
- Package deal
- Examen
- • 3 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Database 
is a collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported. 
Data 
is a collection of unprocessed items 
ex. Text, Numbers, Images, Audio, Video 
Information 
- Data is not information, but it is used to make information. 
- Information is processed data from a database. The finished product of a database. 
- This information is used to make documents, ...
- Package deal
- Examen
- • 4 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
when do you use structured references? 
w/ respect to tables with data 
***must specifically name a data table 
what is the difference btwn a qualified and unqualified structured reference? 
if you use a structured reference within a table, unqualified 
 
if you use a structured reference outside a table, fully qualified reference 
 
qualified has table name in formula 
what is analysis of variance used for? 
Test to determine if sam...
- Package deal
- Examen
- • 5 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Spreadsheet 
an electronic file used to organize related data and perform calculations 
Worksheet 
a spreadsheet that contains formulas, values, text, and visual aids 
Workbook 
a file containing related worksheets 
- identified by a sheet tab 
Active Cell 
Represented by black/dark border, cell you are currently working on 
What are two of the basic components of a spreadsheet? 
Workbooks and worksheets 
Formula Bar 
The contents ...
- Package deal
- Examen
- • 4 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Comma-separated values (CSV) 
Uses commas to separate data into columns and a newline character to separate data in to rows 
Data model 
collection of related tables that contain structured data used to create a database; enables you to integrate data from multiple sources within a workbook 
data shaping 
the process of editing information from one or more data sources to desired parameters before importing into an application 
dat...
- Package deal
- Examen
- • 2 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
grouping 
-selecting 2 or more worksheets so you can perform the dame action at the same time, the worksheets will have identical structure and formatting 
-can group and ungroup 
What does grouping worksheets improve? 
-productivity, can perform data entry, structural changes (add,deleting,widening rows/columns), formatting page layouts, and printing 
-You can copy worksheets from one workbook to another 
Worksheet refrences 
Allo...
- Package deal
- Examen
- • 8 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Alignment 
The position of data between the cell margins 
Auto Fill 
Enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells 
Cell 
The intersection of a column and row 
Column Width 
The horizontal measurement of a column 
Fill Color 
The background color appearing behind data in a cell 
Fill Handle 
A small green square at the bottom-ri...
- Package deal
- Examen
- • 5 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
You used the Subtotal feature on a dataset containing states, major cities within each state, and populations. You intended to create one subtotal for each state; however, a subtotal row displays below each city. What caused this result? 
The At a change setting was City within the subtotal dialog box 
Why would you click the collapse outline symbol above a column of outlined data? 
You want to hide the detailed columns to focus on...
- Package deal
- Examen
- • 2 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Accounting Number Format 
A number format that displays $ on the left side of a cell and formats values with commas for the thousands separator and two decimals 
Active Cell 
The current cell in a worksheet. It is indicated by a dark green border onscreen 
Alignment 
Placement of data within cell boundaries 
AutoComplete 
A feature that searches for and automatically displays any other label in that column that matches the letters ...
- Package deal
- Examen
- • 5 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
IOT 
Internet of things 
BRIC 
Brazil, Russia, India and China 
Blackstone 
Private equity company 
Product/Service (Solution) 
how will your business solve their problem. 
Students registered Spring 2017 
2300+ 
The amount of prize money 
$15K 
Number of undeclared students. 
43% 
Number of declared students. 
57% 
Average success rate for restaurants 6+ years 
20% 
Amount of restaurants that fail after 6 months 
Under 50% 
Compan...
- Package deal
- Examen
- • 3 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
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 dat...
- Package deal
- Examen
- • 6 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
DAY function 
=DAY(serial_number) 
MONTH function 
=MONTH(serial_number) 
YEAR function 
=YEAR(serial_number) 
DAYS function 
=DAYS(end_date, start_date) 
NETWORKDAYS function 
=NETWORKDAYS(start_date, end_date, [holidays]) 
YEARFRAC function
- Package deal
- Examen
- • 1 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
what is a visible cue that shows when a table is made? 
Drop down arrows for sorting are visible 
calculated fields 
formulas added to an existing table 
a structured reference contains 
column names from an existing table 
the order in which filters are applied matters 
false 
the order in which sorting fields are applied matters 
true 
conditional formatting 
changes the appearance of cells based on user criteria 
what is the PMT...
- Package deal
- Examen
- • 2 páginas's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• Por TopGradeSolutions