Excel Scenario's Scenario 1: A business professional calls the support desk looking to use Excel to organize data for the monthly expense report. He has never used Excel prior to this and has inquired about the functions that would support him with his task.
My general approach for this call would be to start off by explaining what Microsoft Excel is to the business professional. Microsoft Excel is an application used to create spreadsheets. It also provides the user with functions such as calculation, graphing tools, pivot tables, and so on. Following the basic description of the software I would then continue on be providing him with an in depth explanation of the features and functions that would be beneficial for his
…show more content…
Press Ctrl + Enter and all of the blank cells will be filled with a zero value. At this point the business professional should be able to calculate his monthly average and get the correct outcome. I would stay on the call with them to ensure the steps I provided worked accordingly. I would also provide a link via e-mail to a Microsoft tutorial to walk he or she through the process again should they run into the same issue at a later date.
Scenario 3: A local grocery store owner has created a spreadsheet containing the types of inventory she carries within the store. The spreadsheet contains 235 different kinds of inventory, defined by price, quantity on hand, ordered quantity, and category. Every time she scrolls through the data set, she loses her placement. She is seeking assistance from the support desk to effectively scroll through the data sheet and manage this large data set.
Again, I would begin the call by letting the business owner know that I could help her get through this with a few simple steps that I would walk her through. This is a common problem a lot of users are confronted with when using Microsoft Excel, especially with large data sets such as the one she is trying to maintain.
What we need to do is walk you through the steps to be able to freeze, or lock rows and columns, which will allow you to keep track of your placement when you scroll through your dataset. To do this we need to use the Freeze Pane option provided with your
I know that providing information of financial reports is the primary objective for useful and productive decision making. This is absolutely critical for a manager in a business. For this ability I will depend on the financial reports to give me an idea of where the profits and losses were for a specific period of time, and it gives me a business look at the past, present and future in regards to expenses of operation. Within these expenses is an array of costs that include; lease or payments of buildings, salaries, utilities, profit margins, product cost, employee expenses, company benefits, comp insurance, supplies, equipment, and any other outgoing expense for the business including accounting and attorney fees.
All the work that needs to be done above needs to be finished and completed within a timescale of 3 weeks with a budget of £1000 the impact this has on the company is that they will have to trust the technicians to work out of hours on the equipment and machines due to the office needing to stay open after closing
Two computer systems that will be considered are McKesson and Epic. In this scenario the facility is using paper charting for documentation. I have worked at a facility with this type of charting. While we had paper charting, we had a computer system for lab results and radiology reports. This computer system was McKesson. Therefore I will use this example for my project.
The purpose of normalization is to create a stable set of relations is representative of the operations of an enterprise. By doing this we are able to reduce redundancy to save space and avoid inconsistencies in data. It also ensures that the design is free of certain updates, insertions, and deletion anomalies (Ricardo, 2012). With normalization as with most anything else there are advantages and disadvantages. The advantages of normalization are: ACID, which stands for atomicity, consistency, isolation, and durability. Atomicity means the transaction is a single unit. Either the entire set of actions is carried out or is not.
In 1994, the New York City Police Department adopted a law enforcement crime fighting strategy known as COMPSTAT (COMPuter STATistics). COMPSTAT uses Geographic Information Systems (GIS) to map the locations of where crimes occur, identify “ hotspots”, and map problem areas. COMPSTAT has amassed a wealth of historical crime data. Mathematicians have designed and developed algorithms that run against the historical data to predict future crimes for police departments. This is known as predictive policing. Predictive policing has led to a drop in burglaries, automobile thefts, and other crimes in some cities.
below by placing the appropriate graph and/or answers in the designated cells of the spreadsheet.
Using either an Excel list or a list imported to Excel, generate form letters and/or mailing labels.
Write a 4-5 page paper in which you create a plan for a low-cost automated inventory system in which
Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.
At the bottom of SPSS, there are options to look at the data in Data View or in Variable View. I clicked on Variable View to name my variables. A list of columns appeared, but I only made changes to rows in the Name column. In row 1 under Name, I typed SubjectNo (no spaces or symbols are allowed when naming variables in SPSS) for Subject Number. I clicked back to Data View. The first column was now named SubjectNo, so I typed the list of subject numbers from 1 to 96 (1 number per row) for the number of "participants" in this study. I go back to Variable View and named row 2 as GroupNo. Under the GroupNo column, within Data View, I typed 1’s in rows 1 thru 48 and typed 2’s in rows 49-96. Group 1 was high need for cognition and group 2 was low need for cognition. I labeled the next 45 rows under GroupNO, in the Variable View, as the different item numbers: Item#1 thru Item#45. In all there was a total of 47 rows in the Variable View and 47 columns in the Data View. I clicked back into random.org and highlighted all 4,320 integers not missing any and right clicked for a menu to pop up. In this menu I clicked COPY, then I went back to the SPSS datasheet in the Data View. Under the column labeled Item#1, I clicked on the cell in row 1 and right clicked for the Paste option. All 4,320 integers were placed correctly in the columns, Item#1-Item#45 in 96
Customers must use the internet to fill out an online form to address their complaints or service needs. These forms are processed by employees in your department. Currently the turnaround time on any given form is between four to eight hours. This creates a number of other customer complaints. Project Call Center is designed to reduce this turnaround time by 75% by creating and staffing a call center in Tampa. Building acquisition, building renovations, building fit out, IT system upgrades, and hiring and training of staff are estimated to cost $8.5 million dollars. This $8.5 million dollars can be paid evenly in any two quarters in the next year. In addition, seven new employees will need to be hired at $40,000 burdened labor costs per year to staff the call center. Management of this project could easily be done with the current in-house staff. Most of the work of this project would be outsourced and will have minimal impact on day-to-operations.
e. Click to select the Table tab in the dialog box. If your settings do not match those shown below, make the necessary changes.
1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:
Microsoft Access provides many functions for end users. While working in IT Support, many different situations may present from customers phoning in and requesting information or assistance. Following are three different situations that may be presented at a support desk. First, we will examine a veterinarian who wants to use Microsoft® Access® for his business, and has some questions regarding the functions of Access. Second, a man created a database to inventory his customers’ past due accounts to ensure that he receives payment. Third, a user has been using a Microsoft® Access® database and queries to track her commemorative