DQ: Getting Familiar With Excel (graded)
Excel was
introduced in 1985. Since then, it has become a standard business tool.1. Discuss and explain at least six different (unique)
features of Excel that make it a valuable business tool.2. Discuss what type of Excel skills would be
important in today’s job market and why. Be specific.
Note: In addition to the Microsoft Excel 2016 overview
in the Course Home section, there are many Excel resources in addition to your
text on the Web...
Workbook on Mountain Sports Village Shop Sales to Data
Description
Scenario/Summary
You are new to the staff of Summit
Ridge Mountain Resort. One of the benefits to your employment is a free
mountain ski pass. You are anxious to complete your work and enjoy a run down
the mountain but know management is looking to you for important details and
analysis for the ski resort overall. This week, management has asked that you
begin to prepare a report for the Village Shop Sales. The re..
Quiz 1
1. Question: (TCO 1) An Output Area (as it
applies to Excel 2016) is defined as _____.2. Question: (TCO 1) In Excel 2016, a cell
is best described by which of the following?3. Question: (TCO 1) Which of the following
best describes the AutoComplete function?4. Question: (TCO 1) In Excel a formula
_____.5. Question: (TCO 1) Which of the following
best describes the result of using the fill handle on a cell containing a
form..
DQ: Formulas and Functions (graded) - Version 1
One of
the benefits of Excel is the ability to use formulas and functions. 1. Discuss the differences between formulas and
functions. Pick a function in Excel and discuss how that function is used to
calculate results in your worksheets. Review your classmates’ posts to make
sure that you’re not duplicating formulas or functions already discussed. Using
the following scenarios, discuss how you would apply the Excel functions or
..
DQ: Formulas and Functions (graded) - Version 2
One of
the benefits of Excel is the ability to use formulas and functions. 1. Discuss the differences between formulas and
functions. Pick a function in Excel and discuss how that function is used to
calculate results in your worksheets. Review your classmates’ posts to make
sure that you’re not duplicating formulas or functions already discussed. Using
the following scenarios, discuss how you would apply the Excel functions or
..
Workbook on Mountain Sports Village Shop Sales to Data
Note: There are two versions of this iLab in order to learn one point from two different angles.Description
Scenario/SummaryManagement at Summit Ridge Mountain Resort is very pleased
with your initial report. This week, management has asked that you add to the
prior analysis and incorporate some visual images concerning the Village Shop
sales. This new analysis will require the use of new formulas, new functions,
and several charts to..
Quiz 2: Excel's Advanced Formulas, Functions, and Charts
1. Question:
(TCO 2)
A(n) _____ is tested in an IF function to determine if it is true or false.2. Question:
(TCO 2)
Which of the following steps can be used to insert a SUM function?3. Question:
(TCO 2)
The _____ function displays the current date in a cell.4. Question:
(TCO 2)
The PMT function is best described by which of the following?5. Question:
(TCO 3)
A data series is a gr..
DQ: Data Analysis Tools (graded)
1. Excel provides many different ways in which to
analyze data. Discuss the different methods by which you can analyze data in
your spreadsheet. That is, try an Internet search for “data analysis with
excel,” or use some of the methods you learned in this week’s lesson. (Please
don’t use the same methods. Show your research h and creativity skills.) 2. Assume the role of a regional manager for a retail
organization looking ..
Analyze the claim made by the Condos at Summit Ridge Mountain.
Description
Scenario/Summary
You are becoming more confident in your new position at
Summit Ridge Mountain Resort. You are still meeting new coworkers and slowly
but surely being asked to use more of your Excel skills for different
departments at the resort. The manager handling sales for all of the condos in
the Summit Ridge Mountain Village needs some help with his sales analysis. This
report needs to clearly list and summarize ..
Quiz 3: Data Analysis Functions
1. Question:
(TCO 4)
How many possibilities exist when thinking about the freeze options?2. Question:
(TCO 4)
In Excel, a table is defined as _____.3. Question:
(TCO 4)
To create a table from an existing range of data, _____.4. Question:
(TCO 4)
Filtering the Cost column (field) to show only records greater than $10,000 is
an application of _____.5. Question:
(TCO 4)
To apply a red background color to..
DQ: Data Consolidation (graded)
1. Discuss and compare the group
summations and consolidation tools used with Excel. You may need to look up
(research) the group summations.
2. Under what circumstances would you use
each of these features? Do they both serve the same purpose, or is each one
used under different scenarios? Give examples of how each can be used...
Warming Hut Income, Seasonal Activities and X Games
Description
Scenario/Summary
Summit Ridge Mountain Resort has three full-service warming huts on its majestic mountains.
The Summit View, the Bunny Den, and the Mogul Hill Samurai warming huts are rest stops that provide skiing customers a
place to relax, eat, and warm up. At the end of the month, the manager of each warming hut prepares a worksheet that summarizes
the monthly income.
Please note that during the summer months,..
Quiz 4: Consolidating Data
1. Question:
(TCO 5)
Excel's multiple worksheet abilities can do all of the following except2. Question:
(TCO 5)
In Excel, which of the following would you perform to group nonadjacent
worksheets?3. Question:
(TCO 5)
If the active cell is in column A, but not in row 1, when you click the Split
command, the worksheet will appear in two ________ panes.4. Question:
(TCO 5)
In Excel, which of the following is not a method for r..
DQ: Specialized and Statistical Functions (graded)
1. Discuss and compare the the specialized and
statistical functions in Excel. You may need to research your answer.2. Under what circumstances would you use logical and
lookup functions? What financial and statistical functions exist for use? Give
examples of how each can be used.
Please
include your research references in APA format...
Detailed analysis concerning Stay A While Longer Apartments
Description
Scenario/Summary
Summit Ridge Mountain Resorts has decided to expand. Because of the popularity of the resort among the business community and families, Summit Ridge has decided to purchase some apartments for guests and seasonal employees to have an extended stay. Because these will prove to be a long-term investment, Summit Ridge has decided to put all complexes on a remodeling rotation to ensure the apartments each h..
Quiz 5: Excel's Advanced Functions and Statistical Functions
1. Question:
(TCO 9)
Which of the following is a nested function?2. Question:
(TCO 9)
If there are four possible outcomes, how many logical tests are required?3. Question:
(TCO 9)
When using the MATCH function looking for the largest value that is less than
or equal to the match lookup_value, the match type must be set to _____.4. Question:
(TCO 9)
Which of the following functions will return the interest paym..
DQ: What-If Analysis (graded)
Life is full of questions and each question deserves a good answer. Let’s explore the What-If Analysis tools available in Excel.
Explain how these tools are used to assist with solid decision making. Give examples of how each of the What-If Analysis tools can be used practically.
Please include your research references in APA format...
SRMR Income Statement Variables and Warming Hut Sales - changes in Condominium Rental Fees, Ski Lift Tickets, and X Game Tickets and Pricing.
Description
Scenario/Summary
This week it seems like everyone needs an answer to a question. The Accounting Manager for Operations has asked you to update some analysis prepared earlier in the year. In an attempt to predict year-end changes in net income, you have been asked to prepare some reports on changes in condominium rental fees, ski lift ticke..
Week 6 iLab 7 - Analysis of a Business Scenario and Do 3 Different Types of Analysis on a Memo Template
Description
Scenario/Summary
The
purpose of this exercise is to use the Excel skills you have acquired thus far,
and apply them to an analysis of a business scenario, of your choice. This will
consist of preparing the groundwork in Excel (importing data, preparing the
analysis using tables, charts, graphs, pivot tables, etc.) and preparing a memo
to your management, explaining your thre..
Quiz 6: What-If Analysis
1. Question (TCO 6) Which of the following tools is an add-in?
2. Question (TCO 6) Which of the following is NOT in the What-If Analysis command in the
Data Tools group on the Data tab?
3. Question (TCO 6) In a data table, the _____ number format is used to disguise the
formula references in thefirst row as labels.
4. Question (TCO 6) A series of ______ indicates that which of a column is too narrow
to display the complete number
5. ..
Expert Tools (graded)
1. Excel shares very well with other applications. Why
does it import data so easily from other external sources? What features make
it easy to manipulate this imported data?
2. Adding a macro to an Excel workbook is almost like clicking the “Easy”
button. They can automate very simple tasks. Why are people often intimidated
by macros?..
Utilizing "expert" features in Excel such as text importing (outstanding condo sales results for Jesse Gonzales), cell protection and macro generation (X Game Calculator).
Description
Scenario/Summary
Your manager could not be happier with the help you’ve provided to all of those departments requesting Excel assistance within the resort. He is now very confident handing over complex tasks to your capable hands. This week he is requesting that you exercise some expert skills. It seems he h..
Quiz 7: Importing and Macros
1. Question
(TCO 8)
Which of the following is a file type that cannot be imported into Excel?
(Points : 2) 2. Question
(TCO 8)
Which of the following file types uses tabs to separate data into columns?
(Points : 2) 3. Question
(TCO 8)
Where are web query tools and options located? (Points : 2) 4. Question
(TCO 8)
Which of the following are settings that control how imported data in cells
connect to their source data..
Practical Problems: Car Parts Service (Exam v5)
Complete the tasks below using Microsoft Excel. You may refer to your
notes, the textbook, or other resources (for example, you may search the Web
for information). You may not get interactive help from any other person
(either in person or via e-mail, text messaging, instant messaging, or other
communications channels). Save your work frequently using CTL + S. You have 4 hours to complete this exam. Note: Be sure you spell-che..
Practical Problems: Music On Demand (Exam v3)
Question 1: Formatting and charts (TCOs 1, 2, and 3; 30 points)
1. Adjust
the widths of the columns so all data is visible.2. Center
the title “Music on Demand – Sales by Product” across columns A-D.3. Increase
the font size to 16, and change the font color to red.4. Bold
the column headings “Product”, “Unit Price”, “Quantity”, and “Total Sales”.5. Add
formulas to the Total Sales column to calculate the total sales fo..
Practical Problems: Final Exam 3 Instructions V2 - Super Shoes, Inc. (Exam 3v2)
Complete
the tasks below using Microsoft Excel. You may refer to your notes, the
textbook, or other resources (for example, you may search the Web for
information). You may not get interactive help from any other person
(either in person, via email, text messaging, IM, or other communications
channels).Save your
work frequently using CTL+s. You have
4 hours to complete this exam.NOTE: Be
sure you SP..
Objectives
Your company is currently planning to automate many different system administration tasks. Your manager has asked you to research a system administration task and implement it using VBScript. In addition, your manager would like to see both a proposal that describes the system administration task and a complete VBScript solution with sample output runs.
COMP 230 all weeks Course Projects are bundled in this product. It contains week 3 and week 6 course projects.
Course Project (..
Questions: 1-61. (TCO 1) Which one of the following Windows net commands
are NOT used to control services with the net ServiceName?2. (TCO 1) Which of the following Windows commands will shutdown and
restart your computer in 2 minutes?3. (TCO 1) Which of the following Windows commands will shutdown and
restart the computer FileServer in 2 minutes?4. (TCO 1) Which Windows shutdown-command switch is used to shutdown
and turn off a local or remote computer?5.&..
Questions: 1-81. (TCO 2) ____ data items may involve displaying numbers or text to
the screen.2. (TCO 2) The process of walking through a program's logic on paper……
____.3. (TCO 2) What is the problem with the following statement? 60 + 5 =
grade4. (TCO 2) What is the problem with the following statement? LastName =
"smith5. (TCO 2) What is the assignment operator?6. (TCO 2) String constants and _____ refer to the same concept.7. (TCO 2) If a variable hol..
COMP 230 Week 3 Course Project is relating to Automating Administrative Tasks.In this week a proposal has to be made and submitted regarding any topic. In subsequent weeks, a full-fledged course project is to be made and submitted in week 6. ScholarlyProjects.com offers a proposal relating network automation that means to create a task which is performed automatically; Tasks that a system administrator performs frequently should be automated...
Questions: 1-81. (TCO 3) What statement best describes the following pseudocode?2. (TCO 3) What decision structure is logically equivalent to the
following?3. (TCO 3) What logic operator could be used to replace the nested
selection….?4. (TCO 3) Which logical operator has the lowest precedence?5. (TCO 3) Every Boolean expression must be true in order for the
entire…._____.6. (TCO 3) Only one of the Boolean expressions must be false in order
for…____.7.&nb..
Question: 1-111. (TCO 4) A variable that determines if a loop will continue is known
as a ____. 2. (TCO 4) What is the name for the statements that are repeated during
loop…..?3. (TCO 4) Which piece of pseudocode represents incrementing the loop-control…?4. (TCO 4) When a value is incremented by 1, ____.5. (TCO 4) When a loop-control variable is not altered during loop….
______ loop....6. (TCO 4) Which of the following is NOT automatically handled by the
for l..
Questions: 1-61. (TCO 5) Although it is not a requirement of any programming
language, it frequently makes sense to use a(n) ____ as all or as part of a
module's name because modules....2. (TCO 5) A variable that is used in all program modules is ____.3. (TCO 5) What statement is not an advantage of using modularization?4. (TCO 5) Variables declared within a module have what scope?5. (TCO 5) In what way do named constants differ from variables?
6. (TC..
COMP 230 Week 6 Course Project; Complete course project relating to the topic "Utilizing VBScript for the Removal of Spam from Email in Outlook" has been made.Week 6: Complete Course Project (140 points)The following is a list of guidelines for your Course Project, due in Week 6.The complete proposal should include the following:IntroductionDescription of program (script)Source Code with detailed commentsSource Code should contain a minimum 5 out of 6 topics learned during this session.Explain ..
Questions: 1-61. (TCO 6) When you create a VBScript Scripting.FileSystemObject, you
must start the code line with _____.2. (TCO 6) Which one of the following is NOT a Windows file attribute?3. (TCO 6) To test to see if a file exists before you overwrite it in
VBScript, use the following command (assuming that fso is a
Scripting.FileSystemObject).4. (TCO 6) To move the file C:\Data\CustData.txt to
C:\BackUp\CustData.txt in VBScript, use the following command (assum..
Questions: 1-61. (TCO 7) What is the most common database query language?2. (TCO 7) What is the name for a column that uniquely identifies a
record?3. (TCO 7) The __ in a table is the column that makes each record
different from….4. (TCO 7) Which of the following is not a database-security issue?5. (TCO 7) When two tables in a database contain related data, the data
in…. _____.
6. (TCO 7) The general syntax of an SQL select statement is _____...