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......
Give short introduction of profession and make a list of its types.
Which telemetry is used for monitoring astronauts in space
Answer:
I believe it is medical telemetry
Language is Python
9.9 LAB: Count input length without spaces, periods, exclamation points, or commas
Given a line of text as input, output the number of characters excluding spaces, periods, exclamation points, or commas.
Ex: If the input is:
Listen, Mr. Jones, calm down.
the output is:
21
Answer:
text = input('Please enter a line of text')
text = text.replace(" ", "")
text = text.replace(".", "")
text = text.replace("!", "")
text = text.replace(",", "")
print(len(text))
Explanation:
i answered this same exact question the other day.
line by line, the first line asks for input with a prompt.
the second line replaces spaces, the next one replaces periods, the next exclamation marks, the next commas. then the last line prints the total number of characters
In this exercise we have to use the computer language knowledge in python to write the code as:
the code is in the attached image.
In a more easy way we have that the code will be:
text = input('Please enter a line of text')
text = text.replace(" ", "")
text = text.replace(".", "")
text = text.replace("!", "")
text = text.replace(",", "")
print(len(text))
See more about python at brainly.com/question/26104476
CPU is also called RAM.
True or false.
Answer:
False
Explanation:
RAM works in conjunction with the central processing unit (CPU). If RAM is the temporary memory, you can think of the CPU as the brain of the computer. The CPU chip retrieves data from the RAM
FALSE ...
BECAUSE RAM IS A MEMORY AND CPU IS A UNIT OF COMPUTER THAT'S WHY IT IS FALSE
What was the most surprising thing you learned this term? Why did it surprise you?
Answer:
is this just a small question you are asking the world?
Explanation:
because i am not fully understanding this, could you please give further detail?
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
am i the only one that finds so much bots on peoples pages lol
Which type of game is least likely to need a structured narrative?
a first-person shooter, ,
an adventure game ,
a role-playing game ,
a sports game
Question 4
Answer:
an adventure game
Explanation:
It is this because people explore more than rather have certain dialouge or storylines like perspective games. so in that case i hope this answer helps!!!
Write a program that can add, Subtract, multiply and divide entered numbers.
In Python:
def add(x, y):
return x + y
def subtract(x, y):
return x - y
def multiply(x, y):
return x * y
def divide(x, y):
return x / y
Show a parse tree and a leftmost derivation for : B = C * (A + B)
by using the grammar below:
-> =
-> A | B | C
-> +
| *
| ( )
|
Answer:
mhyfocnu,sobgu,kvngwugwe8hri
Explanation:
sovijbjxyzkuvcg
Prokaryotes are __________________ and include ________________________.
Question 2 options:
unicellular, bacteria and archaea
multicellular, bacteria and archaea
unicellular or multicellular, plants and animals only
unicellular or multicellular, eukarya
Prokaryotes are unicellular and include bacteria and archaea. The correct option is A.
What are prokaryotes?
Prokaryotes are that organism who are single-celled and the cell of a primitive type. The cell does not contain any cell organelles. It contains a false nucleus and ribosomes. Other organs are absent in the prokaryotic cells.
The prokaryotic cells are present in bacteria, and archaea. These organisms are tiny microorganisms. They are present everywhere on the earth. They are free-living or parasitic.
Bacteria are unicellular prokaryotic, and they are present as both free-living and a parasite. They are both good and bad bacteria. Archaea are also similar to bacteria.
Thus, the correct option is A. unicellular, bacteria, and archaea.
To learn more about prokaryotes, refer to the link:
https://brainly.com/question/15329345
#SPJ2
What kind of loop repeats until something else (determined by the program) happens?
iterative number loop
condition-controlled loop
count-controlled loop
forever loop
Answer:
The Condition-controlled loop
Explanation: Because its called a Condition and it does not stop untill something happens thats why its called "condition".
Answer: It's Condition-controlled loop
Explanation: The meaning of condition-controlled loop is Blocks will keep repeating until a condition is satisfed, Also beacuse I already did the quiz.
- Discuss the input-process-output model as it relates to program development.
- Explain the purpose of each step and how that information is used in each step.
- What would be the impact on overall program performance if one of these steps was not included?
Lets see example.
Look at the program created in python below.
[tex]\tt num=int(input("Enter\:a\: number:"))[/tex]
[tex]\tt for\:i\:in\:range(3):[/tex]
[tex]\qquad\tt print(i*x)[/tex]
Suppose you missed the input or don't give that then you won't get an output.
The Input-Output Model is a multifunctional graph that shows the inputs, outputs, and processing activities needed to convert inputs into outputs.
The Input-Output Model:The modeling is sometimes set up to incorporate any storage that occurs during the process. The inputs reflect the external flow of data and commodities into the operation.
All actions necessary to transform the inputs are included in the processing stage. The data and materials that flow out of the process of transformation are the outputs.
A small engineering business, for example, feels there are issues with its hiring procedure.
Several of the newly hired junior engineers stayed at the business for less than a year.
This is a significant expense for the company, since hiring and training new professionals is expensive and time consuming. The human resources department chooses to assemble a team of people with a lot of expertise in hiring new engineers. One from their first jobs is to create a hiring process input-output model. They come up with the following.
Find out more information about 'Input-output model'.
https://brainly.com/question/25519126?referrer=searchResults
List the steps you would take to create folders/directories in different operating system environments.
In Linux we use the terminal to create files and folders.
To create a folder:
1. Open a terminal
2. Go to a directory where you want to create the folder
3. Use the change directory command to go to the directory.
4. Use the mkdir command to make a folder
To create a file:
1. Open a terminal
2. Go to a directory where you want to create a file.
3. use the touch command followed by the filename.
Example to create a directory:
mkdir foldername
Example to create a file:
touch file.txt
Answer:
Various operating systems have different ways of creating folders or directories. Here are steps to create folders or directories in some of the most common operating systems.
Windows
You can create a new folder in Windows by following the two different ways stated below.
These are the steps for creating a new folder through using the File menu.
Open the location where you want to create the new folder.
Then, select the File menu and click New.
Finally, select the Folder option.
These are the steps to create a folder using the right-click method.
Open any location where you want to save your new folder.
Right-click on any blank area of the screen.
This opens a menu. Select New from the menu.
Lastly, from the menu that opens after you select New, and click Folder.
MS-DOS
These are the steps to create directories in MS-DOS.
Click the Start menu.
Click All Programs and then select on Accessories.
Then, select Command Prompt.
Navigate to the location you want to save your new folder. For example, if you want to open the C drive, the command will be: C:
To create a new directory, type mkdir followed by the folder name of your choice. For example, if I want a folder named projects, I will enter the command, “mkdir projects”.
To create multiple new directories in the newly created directed directory, you can use the md MS-DOS command. For example, if you want to make sub-directories named project1, project2, and project three, your command will be md project1 project2 project3.
Mac OS X
There are three ways to create a new folder in the MAC OS X
These are the steps for creating a new folder through using the File menu.
Open any location where you want to save your new folder.
Afterwards, select the File menu and click New Folder
These are the steps to create a folder using the right-click method.
Open any location where you want to save your new folder.
Right-click on any blank area of the screen.
This option opens the folder menu. Select New Folder from the menu.
These are the steps to create directories in Terminal.
Open the Utilities folder. Start the Terminal program.
Navigate to the location where you want to save your new folder.
To create a new directory, type mkdir followed by the folder name of your choice. For example, if I want a folder named projects, I will enter the command, “mkdir projects”.
To create multiple new directories in the newly created directed directory, you can use the -p Terminal command. For example, if you want to make sub-directories named project1, project2, and project three, your command will be -p project1/project2/project3.
Linux
There two ways of creating a new folder in Linux.
These are the steps for creating a new folder using the right-click method.
First, open the file manager.
Then, proceed to the location where you want to save your new folder.
Next, right-click on a blank spot.
Finally, select Create New Folder from the drop down menu.
These are the steps for creating a new folder using Terminal.
Open Terminal by using the Ctrl+Alt+T combination of keys.
To create a new directory, type mkdir followed by the folder name of your choice. For example, if I want a folder named projects, I will enter the command, “mkdir projects”.
To create multiple new directories in the newly created directed directory, you can use the -p Terminal command. For example, if you want to make sub-directories named project1, project2, and project three, your command will be -p project1/project2/project3.
Explanation:
for plato
2.Is having the right tool imperative to successful completion of task at hand?
[tex]\huge\underline\mathtt\colorbox{cyan}{Yes}[/tex]
Having the right tool is imperative to successful completion of task at hand.
explain how communication in fuses management efficiency
Explanation:
Effective communication is pivotal in increasing productivity because it directly influences the behavior of the staff and the way they perform. ... That is why it is essential that you practice communicating with your staff. It will improve understanding and, in the result, will elevate productivity and efficiency.
9. Organs are made up of vast numbers of cells that perform various tasks. When cells die within an organ,
homeostasis is interrupted. What will most likely happen so that homeostasis can be maintained?
Answer: A new cell grows
Explanation:
explain how communication smooth and efficient working of an organisation.
Answer:
Effective communication is pivotal in increasing productivity because it directly influences the behavior of the staff and the way they perform. ... That is why it is essential that you practice communicating with your staff. It will improve understanding and, in the result, will elevate productivity and efficiency.
The pinky finger on the right hand types _____.
S W 2 X
M J U 7
A Q Z 1 ~
; P 0 ' / [ ]
Answer and Explanation:
The answer is the fourth option: ; P 0 ' / [ ]
These keys line up to where the pinky finger on the right hand would be able to reach (comfortably) and press.
The hand should line up with the pinky placed on the ; key.
The right hand index finger should be on J (with the little bump on it), middle finger on K, ring finger on L, and pinky finger on ;.
The left hand index finger should be on F (with the little bump on it), middle finger on D, Left Side Ring Finger on S, and pinky finger on A.
#teamtrees #PAW (Plant And Water)
I hope this helps!
The pinky finger on the right-hand types ; P 0 ' / [ ]. These keys are placed so that the right hand's pinky finger could comfortably reach and press them. Thus, option D is correct.
The pinky on the; key should be in alignment with the hand. The pinky finger should be on; the middle finger on K, the ring finger on L, and the index finger on J on the right hand.
The pinky finger should be on A, the middle finger on D, the left side ring finger on S, and the index finger on F (the one with the small bump). The majority of the keyboard's keys, including the following ones, are controlled by the right pinky (little) finger, which is positioned over the ";" key.
Therefore, option D is the ideal selection.
Learn more about keyboard keys here:
https://brainly.com/question/33836881
#SPJ3
Which of the following expressions in Java is equal to 4?
3% 7
7 % 3
17 % 7
11 % 7
28 % 7
Answer:
3% 7
Explanation:
because 7 because seven ate nine and three was lonely so seven decided to also eat three and became a lesser number somehow because three apparently was not as big as the number 9 so maybe eating three caused him to go down to 4
The expression "11 % 7" in Java is equal to 4.
The "%" operator calculates the remainder of a division operation.
In Java, the "%" operator is used to calculate the remainder of a division operation.
So, let's evaluate each expression and see which ones equal 4:
3 % 7 = 3 (remainder of dividing 3 by 7)
7 % 3 = 1 (remainder of dividing 7 by 3)
17 % 7 = 3 (remainder of dividing 17 by 7)
11 % 7 = 4 (remainder of dividing 11 by 7)
28 % 7 = 0 (remainder of dividing 28 by 7)
Based on these evaluations, the expression "11 % 7" is equal to 4.
To learn more about programming visit:
https://brainly.com/question/14368396
#SPJ3
A reference is _____.
Answer:
a written or spoken comment that mentions somebody/something
Discussion Topic
Music exists across the world. It acts as a universal language. Can you see yourself
working in some sort of musical career? How might music influence your career path?
Consider other people you know, as well, from family members to friends. Can you see
any of them entering the music business? How might this business benefit each of
these people? If any of them came to you with an interest in the music business, how
would you guide them, given what you now know about music and the music business?
What personality types would do the best in the music business?
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
What protocol is used to discover the hardware address of a node with a certain IP address?
Answer: ARP hope this helps
How can you begin networking online? What’s step one?
Answer:
Step 1: Establish your digital presence by building out your profile. ...
Step 2: Find people to connect with by joining LinkedIn groups. ...
Step 3: Engage by posting content and talking to industry influencers. ...
Step 4: Repeat until you amass a strong following.
Explanation:
Define a method calcPyramidVolume with double data type parameters baseLength, baseWidth, and pyramidHeight, that returns as a double the volume of a pyramid with a rectangular base. calcPyramidVolume() calls the given calcBaseArea() method in the calculation. Relevant geometry equations: Volume
Answer:
import java.io.*;
public class Main {
public static void main(String[] args) throws IOException {
double baseLength = 0, baseWidth = 0, pyramidHeight = 0;
Object[] volume;
volume = calcPyramidVolume(baseLength, baseWidth, pyramidHeight);
}
public static Object[] calcPyramidVolume(double baseLength, double baseWidth, double pyramidHeight) {
double area = calcBaseArea(baseLength, baseWidth);
double volume = baseLength * baseWidth * pyramidHeight;
return new Object[]{volume, area};
}
public static double calcBaseArea(double length, double width) {
return length * width;
}
}
Explanation:
The problem is flawed because it is completely inefficient for one to create two separate methods to calculate the volume and the area when they can be done at once.
The second problem is that it was never specified whether to return something from the calcBaseArea method.
I assumed it required it, so it is not advisable to initiate the method as a double, but rather create it as an Object so that it can return two values: the volume and the area.
Complete the following sentence by choosing from the options below. (select all that apply)
The main benefits of computers are their ability to:
save files
retrieve files
modify files
play DVDs
DONE
Answer:
Save files
Explanation:
The main benefit of a computer is to save files if there is no good storage the computer is bot complete
Thiết kế biểu đồ thực thể liên kết và tập lược đồ cơ sở dữ liệu quan hệ cho các bài toán quản lý sau:
Bài toán 1. Bạn cần một cơ sở dữ liệu để quản lý thông tin về các tạp chí. Với mỗi tạp chí bạn cần quản lí tên tạp chí, số ISSN (mã số công bố của tạp chí), số phát hành và năm phát hành. Dữ liệu về các bài báo trong tạp chí bao gồm: tiêu đề bài báo, trang bắt đầu và trang kết thúc của bài báo trong tạp chí (nghĩa là bài báo bắt đầu từ trang nào, và kết thúc ở trang nào trong tạp chí). Giả thiết rằng không có hai bài báo nào có cùng tiêu đề. Mỗi bài báo được viết bởi một vài tác giả. Mỗi tác giả bạn sẽ lưu các thông tin về tên, địa chỉ email và địa chỉ cơ quan.
Answer:
sorry please write in English than i help.you i don't understand your language
HELP ASAPPPP PLSSSSS!!!!!! The purpose of capillary tubes is to:
permit oxygen and nutrients to be absorbed by cells
allow blood to complete a path between arteries and veins
reverse the flow of blood
provide a means for cell wastes to enter the blood stream
Answer:
Permit oxygen and nutrients to be absorbed by cells
Explanation:
Because ,the capillaries arw the smallest of the blood vessels they act as a bridge between the two main..vessels
