Answer:
on Freeze Panes so the first row containing column headings (Row 5) on the SupportCalls worksheet wil remain static when scrolling. Ensure that Rows 1-4 are visible. Convert the data to a table, name the table SupportCalls, and apply the Gold, Table Style Medium 12 Remove duplicate records Add a new column to the table named Duration Create a formula using unqualified structured references to calculate the days required to resolve the incident (Date Resolved - Date Created) Add a total row to display the Average days required to resolve an issue. o ñ Sort the table by Agent Name in alphabetical order, add a second level to sort by Description, and create a custom sort order as follows: Won't power on, Virus, Printing issues, Software Update, Forgotten Password. Add a third level to sort by Duration smallest to largest. (Mac users, to create the custom list, from the Excel menu, click Preferences. In the dialog box, click Custom Lists.) Filter the table to only display closed incidents as indicated in the status column. Use Quick Analysis to apply the default Data Bars conditional formatting (Solid Blue Fill) to the Duration column (range 16:185) Mac users on the Home tab, click Conditional Formatting, point to Data Bars, and under Solid Fill, click Blue Data Bar. Create a new conditional format that applies Red fill and bold font to incident (range A6 A85) that required 30 or more days to resolve Change page breaks so page 2 begins with the Computer ID column (column EX Set the print scale to 85% Add a custom footer with your name on the left side, the sheet name code in the center, and the file name code on the right side Save and close the workbook Submit the workbook as directed
Widte Automatic HeightAutomatic- Escale Gridlines Headings View Print Margins Onentation Sure Print reaks Background Print Titles 100% Bring Send Forward - Backward Selection Pane Arrange 747-57548 DE Technical Support Calls 3 Threshold days 1992 2971 1850 9018 6404 Cox COX Incident Number - Date created - Last Name - Agent Name 747-57548 3/24/2021 Murray Broadnax 254-3993: 2/4/2021 Stone Broadnax 831-91089 4/4/2021 Herrera Broadnax 15207-19047 2/4/2021 Cook Broadnax 16 284-56116 2/17/2021 Ramos Broadnax 19 295-57913 5/5/2021 Nguyen Cox 23 619-44822 2/10/2021 Silva 24 605-47583 3/9/2021 Garner 29 424-30728 4/26/2021 Walker Dodson 31 875-36070 5/2/2021 Delgado Dodson 32 727-78890 2/15/2021 Watts Dodson 33 247-70541 3/24/2021 Rodgers Dodson 34 868-40830 5/5/2021 Griffin Dodson 35 878-43585 3/13/2021 Hale Dodson 37 859 12568 3/18/2021 Soto Hays 38 2019-20285 2/20/2021 Coleman Hays 41 179-51542 3/29/2021 Gray 42 657-68422 1/16/2021 Washington Hays 45 751-81316 3/3/2021 Ramirez 49 614-70314 2/20/2021 Gutierrez 52683-70001 3/22/2021 Newman 54 422-24141 2/18/2021 Carpenter Leggett 3/1/2021 SupportCalls 8930 9589 9955 3488 4468 2340 7125 2853 8586 3198 1577 6405 9751 3801 6580 4978 16 Won't power on Won't power on Won't power on Virus Virus Won't power on Software Update Forgotten Password Won't power on Won't power on Printing issues Software Update Forgotten Password Virus Won't power on Won't power on Software Update Software Update Virus Software Update Forgotten Password Forgotten Password Went Weron Status Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed Closed 7 Date Resolved Duration 3/25/2021 2/20/2021 4/30/2021 2/12/2021 2/28/2021 5/13/2021 | 2/12/2021 3/14/2021 5/2/2021 5/28/2021 2/28/2021 4/11/2021 5/7/2021 3/21/2021 4/5/2021 3/20/2021 4/9/2021 2/9/2021 3/24/2021 3/3/2021 3/26/2021 2/26/2021 6/12/2021 -
On Freeze Panes, the SupportCalls worksheet's first row of column headings (Row 5) will stay static even when scrolling. Make sure Rows 1-4 are discernible.
What is Static scrolling?Create a table using the data, rename it Support Calls, and apply the Gold, Style Medium Table 12 Get rid of duplicate records Create a column in the table with the name Duration.
To determine the number of days necessary to settle the event, create a formula utilizing unqualified structured references.
To show the average number of days needed to fix a problem, add a total row. The data in alphabetical order by Agent Name, add a second level of sorting by Description, and generate a unique sort order like in the example below.
Therefore, On Freeze Panes, the Support Calls worksheet's first row of column headings (Row 5) will stay static even when scrolling. Make sure Rows 1-4 are discernible.
To learn more about Column headings, refer to the link:
https://brainly.com/question/13163317
#SPJ2
Not Answered 17.Not Answered 18.Not Answered 19.Not Answered 20.Not Answered Question Workspace Jessica wants to purchase a new hard drive. She wants a drive that has fast access because she will use it to edit videos on her PC. She also needs a lot of storage and wants to have at least 4 TB available to save her videos. Jessica wants to keep the cost down as much as possible possible. What type of hard drive should Jessica purchase?
Answer: HDD 7200RPM
Explanation:
a solid state drive is going to be so much money especially if its 4 TB so just get a HDD 7200RPM or even better if its higher revolutions per minute......
Which of the following was the most significant impact the NEA had on the performing arts industry? W
It created more performance spaces.
O It increased awareness of the performing arts.
It increased production of the performing arts.
O It created more jobs.
Save and Exit
Next
Submit
dan
Answer:
The NEA’s focus on building new performing arts centers led to an increased production of arts.
MSWord is a popular___________ program.
Answer:
graphic word processing program
Answer:
word-processing application
Explanation:
MSWord is a popular___word-processing application____ program
Define a class named Bits that holds a single integer variable. You will use this integer simply as a container of bits. The number of bits you can support depends on the type of integer you use. We will use an unsigned long long, which on most platforms occupies 64 bits.
What is another name for a switch A.Number system B.Variable C.Logic Gate D.Boolean
Answer:
logic gate
Explanation:
took the test lol
These steps describe the procedure to delete files from your computer.
Click on the Recycle Bin.
Click on the Delete icon.
Select the file to be deleted.
Select Delete from the File menu.
Answer:
select the file to be deleted
Explanation:
What is the purpose of a computer network needs assessment? to evaluate how to move from the current status to the desired goal to determine what steps employees can take to increase company revenue to analyze which workers need more training to improve their performance to compare worker productivity
Answer:
to evaluate how to move from the current status to the desired goal
Identify the following verb by number and person by checking on the appropriate boxes.
SHE WANTS!!
second person
singular
plural
same form for both singular and plural
third person
first person PLEASE HELP!!!!!! LAUNGUAGE ARTS
Answer:
Singular and third person
Explanation:
Second person: this answer is not correct as second person refers to pronouns such as “you, yourself” like in a recipe.
Singular: this is correct as a singular verb is when there is only one subject. You can also tell it’s a singular verb as the present tense ends with a “s”.
Plural: this is not plural because there is only one subject. Plus the present tense of the verb ends with an s so it’s not a plural verb. Plural verb’s present tense never ends with an s.
Third person: this is correct because the subject of the sentence is someone else. Third person pronouns include: “her, she, he, him, they, then” basically, third person is when you talk about someone else.
First person: this answer is not correct because first person refers to one’s self. So first person pronouns are: “I, me, myself”
10 sentences about computer parts.
Define cloud, and explain the three key terms in your definition. Compare and contrast cloud-based and in-house hosting using the comparison presented in Q6-1 as a guide. In your opinion, explain the three most important factors that make cloud-based hosting preferable to in-house hosting.
Cloud computing is making hardware, software and data available on demand via a network.
The cloud stands for a network that, with all the computers connected to it, forms a kind of 'cloud of computers', where the end user does not know how many or which computer the software runs on or where those computers stand exactly.
In this way, the user no longer needs to be the owner of the hardware and software used and is therefore not responsible for maintenance. The details of the information technology infrastructure are hidden from view and the user has his own virtual infrastructure, scalable in size and possibilities.
Learn more in https://brainly.com/question/8645052
1.(154)10=(?)2
help me! I will give 25 points.
Please answer the following question in Verilog.
To test our functions we will generate a 3-bit vector that counts up by one every cycle which we will use as the inputs to the decoder. The decoder output will then be fed into the inputs of the encoder to produce an inverted version of the original 3-bit test vector. For every input vector you should toggle the enable signal to both the encoder and decoder function which can be easily done by using the clock waveform used to determine when to increment the input vector as the enable signal as well.
Answer:
345678909 my number
Explanation:
4. Identify which type of algorithmic operation each one of the following steps belongs to: a. Get a value for x from the user. b. Test to determine if x is positive. If not, tell the user that he or she has made a mistake. c. Take the cube root of x. d. Do Steps 1.1, 1.2, and 1.3 x times
Answer:
a. input/output
b. if/else statement
c. while loop
Explanation:
I don't know, sort of...
Write a method named removeDuplicates that accepts as a parameter a List of integers, and modifies it by removing any duplicates. Note that the elements of the list are not in any particular order, so the duplicates might not occur consecutively. You should retain the original relative order of the elements. Use a Set as auxiliary storage to help you solve this problem.
For example, if a list named list stores [4, 0, 2, 9, 4, 7, 2, 0, 0, 9, 6, 6], the call of removeDuplicates(list); should modify it to store [4, 0, 2, 9, 7, 6].
The method is an illustration of loops or iteration.
Loops are used to carry out repetitive operations.
The removeDuplicates method in Python is as follows, where comments are used to explain each line.
#This defines the method
def removeDuplicates(list):
#This initializes the output list
outputList = []
#This iterates through the list
for i in list:
#All elements not in the output list, are appended to the output list
if i not in outputList:
outputList.append(i)
#This returns the output list
return str(outputList)
At the end of the method, the new list contains no duplicates.
Read more about similar program at:
https://brainly.com/question/6692366
full meaning of XP in computer
Answer → eXPerience
Describe psychographic differences among the past five generations of Americans that you learned about in this course. What type of game would you create for each generation based on that generation’s psychographic characteristics? Give reasons for your choices. You may do some online research to find existing games (if any) that may appeal to each generation of players.
Answer:
sorry I don't know about this question
Can I please get an answer, it's for computer science.
Answer:
I believe the answer would be B. C. and D. A, wouldnt make sense, as GitHub doesn't have that as a feature. I hope this helps! :)
Answer:
ok im not 100% sure this is right but i also don't pay attention in any of my classes except music so i would maybe say options D,B, and A
Explanation:
where and when to implement such network.
i think it is a
and it is b , so haha
To what extent do you agree with the assertion that “Collection development begins with community analysis”. (Give reasons to buttress your answer).
The assertion that collection development starts with community analysis is logically correct.
The collection development policy is vital for setting goals for the collection that mirror the missions of the library. It gives information to the stakeholders of the library about how the collection will be chosen, and who will make the decisions regarding the collection.
Collection development starts with community analysis. The collection plan should follow a logical process in order to be effective. The community should be taken into consideration before the plan is carried out. The more one knows about the community, the better it'll be to make the collection plan effective.
Read related link on:
https://brainly.com/question/21529943
You should move around and take a rest for 30 minutes every 5 minutes.
True Or False
Answer:
obviously true.........
What protocol is used to discover the hardware address of a node with a certain IP address?
Answer: ARP hope this helps
Which statement correctly describes one aspect of the team's commitment at the end of PI Planning?
The statement that describes an aspect of the team's commitment at the end of PI Planning is to maintain predictability with uncommitted objectives.
A program increment (PI) simply means a timebox during which an agile release train helps in delivering incremental value in the form of tested and working systems and software.
A program increment (PI) is usually eight to twelve weeks long. An aspect of the team's commitment at the end of PI Planning is to maintain predictability with uncommitted objectives.
Read related link on:
https://brainly.com/question/23060988
Draw a conceptual sketch of your laptop. Identify the keyboard, screen, power source, and storage device and etc. using arrows and labels.
Answer: 12345678910111213141516171819202122
ACTIVITY NI MATCHING TYPE Directions: Match Column A with Column B. Write the letter of the correct answer on the space provided before the number a. Trion your nails b. visits the dentist c. scrub your hands with soap and water d. wear deodorant taking a bath 18111411 hely wear suitable clothes at work g. avoidis open wounds while working with food h. Regularly out your hair. 1. Use a seperate towel or cloth wiping hands. . keep sanitizer. 10.
Answer:
Mark me a brainless plss i need that i am blink plss
Which of the following factors is most likely to result in low shipping and handling costs? A higher than average hourly pay rate for material handlers A rare but high-in-demand packaging material A promotion for free shipping on orders over a predetermined order total All of the above
Answer: A higher than average hourly pay rate for material handlers
Explanation:
Shipping and handling cost describes costs related to the total cost of an ordered item which are included in the fees used to deliver the item to the buyer. Hence, the correct option is C
Shipping and handling cost usually depend on the size of the item, the buyer's location and fragility of the item purchased.
From the options given, handling and shipping fee may be reduced as a result of free promotional shipping on orders.
Handler and drivers who are paid above average will result in increased shipping fee and rare in-demand items won't come cheap either.
Hence, low shipping fee will most likely be as a result of promotion for free shipping on orders over a predetermined order total.
Learn more : https://brainly.com/question/20533392
Your sister has just emailed you an attached file with the invitation list for her upcoming party.
Which of these tells you what type of file it is?
A. Folder name
B. File name
C. Extension
D. Call Number
Answer:
The file Extension so the answer is C
What is a segmentation?
Answer:
Segmentation means to divide the marketplace into parts, or segments, which are definable, accessible, actionable, and profitable
What is the relationship between the speed of an object in the amount of energy it has? explain
If known vulnerabilities in software are entry points for an attacker, why are the software vulnerabilities not corrected before the software is released?
Answer:
we dont knoqw
Explanation:
The developer hasn't had enough time to address them, these flaws are referred to as "zero days." is the software vulnerabilities not corrected before the software is released.
What is software?Software is a set of instructions, information, or computer programs that are used to operate equipment and perform certain tasks. Hardware, which is a term for a computer's external components, is the opposite of it. In this usage, "software" refers to the running scripts, programs, and apps on a device.
The procedures and software that make it possible for a computer or other electrical equipment to operate are referred to as software. Examples of the processes and programs that make up a computer system are Excel, Windows, and iTunes.
System software consists of the programs and processes required to run the computer. System software, utility software, and application software are the three subcategories of software.
Thus, The developer hasn't had enough time to address them.
For more information about software, click here:
https://brainly.com/question/985406
#SPJ2
am i the only one that finds so much bots on peoples pages lol