BITM 215
Latest uploads at BITM 215. Looking for notes at BITM 215? We have lots of notes, study guides and study notes available for your school.
-
102
- 0
-
6
All courses for BITM 215
-
BITM 215 102
Latest content BITM 215
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Range Name 
word or string of characters assigned to one or more cells; avoid special characters, spaces, and can't begin with a number 
New Name Dialog Box 
used to name a single range and specify the address range 
Create Names 
several range names can be created at the same time if the worksheet includes ranges with values and descriptive labels 
Name Manager Dialog Box 
used to edit, delete, and create range names 
Data Tabl...
- Package deal
- Exam (elaborations)
- • 12 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Which what-if analysis tool is the best option for complex calculations requiring constrained optimization? 
A)Goal Seek 
B)Scenario Manager 
C)Data Tables 
D)Solver 
D) Solver 
Which of the following is not a capability of the Name Manager? 
A)Create a new name range 
B)Edit a name range 
C)Delete a name range 
D)Paste a name range 
C)Delete a name range 
Which tool is most effective when comparing the impact of various combinatio...
- Package deal
- Exam (elaborations)
- • 9 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
 
Cell (Excel) 
The intersection of a row and a column 
cell reference 
the column letter and row number that intersect at the cell's location 
active cell 
a selected worksheet cell that is ready for data entry 
Name Box 
Area in the formula bar that displays the cell address of the active cell 
Range (Excel) 
a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells. 
Formula 
A calculation ent...
- Package deal
- Exam (elaborations)
- • 4 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Subtotal 
Displays summary calculation of values for a category in a column. MUST SORT FIRST before calculating. 
grouping 
A process of joining related rows or columns of related data into a single entity so that groups can be collapsed or expanded by data analysis. 
data mining 
the process of analyzing large volumes of data to discover patterns and identify trends in the data. 
Data Mining Steps 
1. Define the problem 2. Identif...
- Package deal
- Exam (elaborations)
- • 3 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Group and Ungroup Data 
Group rows or columns of related data into an outline 
 
Expand or collapse groups depending on your focus 
 
Excel will not create an outline or group data if the dataset does not contain a formula 
Subtotaling Data 
The Subtotal feature creates an outline, where categories can be collapsed or expanded. Outline buttons are used to determine which values are displayed. 
 
Outline—hierarchical data structur...
- Package deal
- Exam (elaborations)
- • 3 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Ideation 
Develop : Strategy 
Plan of Action 
A business plan 
Start--Grow 
Idea to Business 
Name it 
Define your business 
Register business ( start up costs, licenses/permits ) 
Defining Business Idea 
What is my product/service? 
How will I distribute it? 
Location? 
Who is my competition? 
Developing Business Idea 
How much money do I need? 
Why will customers buy from me? 
When will I open my business? 
Business Plan 
Serves ...
- Package deal
- Exam (elaborations)
- • 3 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Microsoft Excel 
- a spreadsheet software for creating an electronic workbook 
- create a simple to complex personal or business workbooks 
what does a Workbook consist of? 
Consist of rows and columns to organize data, perform calculations, print reports, and build charts. 
-named BookN with numbers assigned in order throughout a work session 
Workbook 
the file you open, edit and save 
What does a workbook contain? 
worksheets 
 ...
- Package deal
- Exam (elaborations)
- • 13 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
 
Database 
data organized and stored on a computer that can be searched and retrieved. 
Data 
collection of unprocessed items (text, numbers, images, video, audio) 
Information 
processed data from a data base, the finished product of a database. (The information is used to create documents, images, audio) 
Database Management System (DBMS) 
creates a computerized database. Sorts and retrieve data, add, modify, and deletes data. cre...
- Package deal
- Exam (elaborations)
- • 5 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED 
 
sert a function in cell B2 to display the current date from your system. 
Formulas - Date and Time - TODAY - Press Ok 
With cell B2 selected, set the width of column B to AutoFit. 
Home - Format - Auto Fit Column Width 
Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. The cost of the ring type should be an exact match. Use appropriate relative and absolute cell references. 
Formula - Lookup & Refer...
- Package deal
- Exam (elaborations)
- • 1 pages's •
-
BITM 215•BITM 215
-
BUNDLED-BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED• By TopGradeSolutions
BITM 215 COMPREHENSIVE QUESTIONS AND VERIFIED CORRECT ANSWERS 2024 UPDATE
- Exam (elaborations)
- • 8 pages's •
-
BITM 215•BITM 215