Question 1 Which of the following statements is not true, based upon your class lessons? Not yet answered Select one: Marked out of 1.00 O a. Access can import data from a worksheet in excel file Flag question b. Access can not import data from a named range in an excel file O c. Access can import data from a named range in an excel file O d. Access can import data from a named range or a worksheet in excel fileQuestion 10 A project has three critical paths. How does this affect the project? Not yet answered Select one: Marked out of 1.00 O a. It makes it easier to manage. P Flag question O b. It makes it more expensive. O c. It requires more people. d. It increases the project risk.Question 1 1 In an excel sheet you write 'Jan' in Cell C4. If you hold it from the right-hand bottom corner Not yet answered drag down you get the following values in Cells C5 to C8 Marked out of Select one: 1.00 a. Jan, Jan, Jan, Jan P Flag question b. February, March, April. May O C. Blank, Blank, Blank, Blank O d. Feb, Mar, Apr. MayQuestion 12 Which of the following is not correct about a Database Table? Not yet answered Select one: Marked out of 1.00 O a. A database table may be empty or full of data Flag question b. It is an object which acts like a container to store data in a row and column format C. Tables may contain master data or transaction data. O d. In case of Master data, it is called 'Principle Data Table: in case of transaction data, it is called 's Data Table'Question 13 You are a project manager working on a project that requires 100 chairs to be built in five v Not yet answered with an overall budget of $10,000 distributed equally each week. You have just begun week To date, you have spent $2,000 with 40 chairs successfully built. What does the cost variand Marked out of you in this circumstance? 1.00 P Flag question Select one: O a. The project is proceeding at 110% of the expected rate. O b. The project is $2000 below budget. O c. The project is getting $4 of work for every dollar spent. d. The project is on budget.Question 14 In an excel sheet you write '1' in Cell C3 and 'A' in Cell 4. If you select both the cells together Not yet answered these from the right-hand bottom corner, and drag down, you get the following values in C to C8 Marked out of 1.00 Select one: P Flag question O a. 2.B,3.C b. 1.A,1.A O C. 2.A.3.A O d. B,C.D.EQuestion 15 Meta Data is: Not yet answered Select one: Marked out of 1.00 a. Data about File Structure Flag question O b. Data about Data Structure c. Data about APIs Structure d. Materials on project databaseQuestion 2 Activity A is worth $300, is 100% complete, and cost $350. Activity B is worth $100, is 95% Not yet answered and costs $85 so far. Activity C is worth $200, is 75% complete, and has cost $175 so far. budget is $1500. What is the cost variance? Marked out of 1.00 Select one: Flag question O a. $-45.00 O b. $500.00 O c. $55.00 d. $-65.00Question 3 While importing Data from a flat file into an Access Database file, you find that there is row Not yet answered contains information about the data in the column such as 'Name', Work Package Number Date' etc.. In order to ensure data quality, you would: Marked out of 1.00 Select one: P Flag question O a. Delete the first row containing non-data information b. Check the box "first row contains field names' c. Transfer text file data into Excess file format and then import into Access O d. Do nothing. Access is smart enough to take care of thisQuestion 4 Activity A is worth $300, is 100% complete, and cost $350. Activity B is worth $100, is 95% co Not yet answered and cost $85 so far. Activity C is worth $200, is 75% complete, and has cost $175 so far. The budget is $1500. What is the schedule variance for the project? Marked out of 1.00 Select one: Flag question O a. $-55.00 O b. $20.00 O c. $-65.00 O d. $-45.00Question 5 According to your project schedule network diagram, the critical path for the project is six Not yet answered One week into the project, the project sponsor informs you that the executive steering com has moved the project's finish date to two weeks sooner than your published finish date. Marked out of Assuming you are on schedule, what is the project slack? 1.00 Flag question Select one: O a. Minus two weeks b. Four weeks O C. Two weeks O d. Minus four weeksQuestion 6 A technique through which any input data is read, broken into fields based upon some deli Not yet answered or algorithms, and fed into another system as input is called: Marked out of Select one: 1.00 O a. Data transfer Flag question b. Data Parsing O c. Data Merger O d. Data combinationQuestion 7 Which of the Master Data File and the Transaction Data file normally changes more freque Not yet answered Select one: Marked out of 1.00 O a. Both change with equal frequency in any system P Flag question b. There is no pattern. It can be either C. Transaction Data File O d. Master Data FileQuestion 8 The critical path provides the project manager with information about: Not yet answered Select one: Marked out of 1.00 a. The longest time the project will take. Flag question b. What activities the project manager needs to focus on while managing the project. O c. Where extra resources should not be placed. O d. Where stakeholders need to be assigned to the project.Question 9 Which of the following formulas show the remaining amount to be spent on the project ba Not yet answered current spending efficiency? Marked out of Select one: 1.00 O a. EV-AC Flag question b. EV- PC C. ETC= EAC-AC O d. EAC=BAC / CPI