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...

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 ...

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?...

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...

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...

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...

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...

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 ...

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, ...

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...