Blog

In C13, enter the round function to store the number from B13 to the nearest hundred and display 12900. [BLANK-1]

Go to the Text Sheet. Separate the headers and the company names and the location of their headquarters in A1:A10 into B1:C10 leaving them as displayed in column A. Answer the following questions about how you completed this: What cells did you select before starting the command? [BLANK-1] What command can you use to separate the words into 3 columns? [BLANK-2] What is the delimiter? [BLANK-3] Separate the labels now but skip the states since not all locations have a state listed. What did you choose to skip the state field? [BLANK-4] Did you fill in anything else in step 3? [BLANK-5]

On the PMT sheet, Enter the formula for monthly interest expense in cell C11 and fill it down. Paste your formula in the blank. [BLANK-1]

Start the IF in cell G11 to check if the job status is FT.  FT is in the input cell F4.  If it is, the VLOOKUP should find the percent of the raise they will earn in the VLookup Values Table.  If the job status is not FT, the IF should leave the cell looking empty. Multiply the salary by the percent found with the Vlookup function to compute the salary with the raise. Make sure to do the math to compute the new raise in the correct place. Fill in all 4 arguments for the VLOOKUP function. Paste your function in the blank: [BLANK-1]

Enter a function in B7 on the Birthday sheet to compute how much will have accumulated by Tina’s 20th birthday if her mother invested $1,000 for her on her birthday each year starting on her 3rd birthday. The annual interest rate is 6.25%. Use the input cells in B3:B5. Paste the function in the blank. [BLANK-1]

On the Choose sheet, Enter a combination of two functions in E1 that will return values between 0 through 15 when generating random whole numbers. You want a potential 0 and a 15. One of the functions should be the integer function.   You will not get any credit for using the Randbetween function. You can copy the function down and over F1 through M10 to see if you get a 0 and a 15. Paste your function in the blank. [BLANK-1]

Consider the following list and the selection sort.  What number will be further left?  (i.e, 64 will no longer be there. What number will take the place of 64? 64 25 12 22 11

Which Team Topologies team type is responsible for providing shared tools and infrastructure?    

In the classical chief programmer team, who is responsible for architectural design and interface issues?

The members of which group are determined to recreate the look and the spirit of their respective subculture’s golden age, discounting the effect of years of inaccurate media stereotyping in the process?