Description

ICT 122 Final Exam – Question and Answers

1. If 4/6 is entered in a cell without applying any format, what will Excel treat it as?
2. Which of the following is an example of a Microsoft Access extension?
3. Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?
4. How can a user change the order of slides in Microsoft PowerPoint?
5. In a Microsoft Access database, where are the Sort and Filter group commands located?
6. In Ms Excel, to format a range so that all values greater than $500 appear in red, which of the following can you use?
7. In Excel, what do formatting changes made to numbers affect?
8. Which area in an Ms Excel window allows entering values and formulas?
9. Max previewed the animations on a slide in his presentation. He decided it would look better if the Fly In animation applied to one of the objects was a little slower. Which of the following can he change to make that animation slower?
10. Which statement is False?
11. In Access, if a user makes an invalid entry, this will be displayed in the error box.
12. Which of the following functions is used in logical comparisons?
13. Which of the following is the fastest way to open an Access database?
14. What is the name of a Microsoft Excel feature that is built to anticipate errors you might make and reject those errors before accepting the data?
15. Which of the following options represent the correct MS Excel formula to multiply two values located in cells X10 and AA10?
16. Which of the following is correct syntax in Microsoft Excel?
17. Which of the following is NOT a common MS Excel chart type?
18. What is the advantage of using forms over other Microsoft Access objects?
19. Which of the following items are used in Microsoft Excel charts?
20. Which of the following is NOT an example of a chart in Microsoft Excel?
21. In Ms Excel which of the following can make up a formula?
22. Which of the following is has the correct formula syntax?
23. During ICT122 Test 2, one student comes running asking for which lab they are registered in. Which one will you use to answer the student’s question?
24. A student wants to round the number 24.7835 entered in cell D8 so that it displays as 24.784. Which of these formulas can she use to do so?
25. What will happen when you release mouse pointer after dropping the primary key of one table into foreign key of another table?
26. How can one tell that a cell is the active cell?
27. In Access, which of the following design technique identifies and eliminates redundancy by applying a set of rules to your tables to confirm that they are structured properly?
28. In Microsoft PowerPoint, which of the following allows you to add text to a slide without using the standard slides placeholders?
29. Which statement is true regarding adding new records into a table in datasheet view?
30. In Ms Excel which of the following features can be used to create a dropdown list of items in a cell from which users can choose from?
31. In Microsoft Access, which of the following data types should be used to store numbers representing payments for services in a bank?
32. When you insert a chart on a slide using the Charts button in a content placeholder or the Charts button on the Insert tab, which of the following opens so that you can enter the data for the chart?
33. What is the difference between a name box and a formula bar?
34. Which of these is not a valid form layout in Microsoft Access?
35. Which one of the following is not a valid data type in Access?
36. Which field property is used in Microsoft Access to limit values that can be entered in a field?
37. One difference between forms and reports in MS Access is:
38. In the MS Excel formula =SUM (A1:C3), how many cells are in the range?
39. Which of these refers to a collection of related records in a database?
40. Which of the following is NOT a valid formula in Microsoft Excel?
41. In Microsoft Excel, what is a function inside another function called?
42. In Ms Excel, what is the box on the chart that contains the name of each individual record called?
43. To select a single worksheet cell so you can work with it, which of the following would you do?
44. Which statement is true regarding a query?
45. In Ms Excel, which chart shows trends over time?
46. In the formula =SUM(A6:A9), which of the following best describes A6?
47. Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet. Which of the following series of clicks will help her do so?
48. Which character is used in Ms Excel to indicate absolute referencing?
49. Which of the following layouts would you use if you have two items to compare in a slide?
50. In Ms Excel, if cell D6 contains the formula =C2+C$3 and you copy the formula to D9, what will be the formula in D9?
51. In Microsoft Access, which of the following creates a drop down list of values to choose from?
52. A workbook template has which of the following file extensions?
53. In Ms Excel, which of the following is NOT one of the arguments of database functions?
54. What is presentation?
55. To make your presentation more interesting, you should consider converting lists to which of the following?
56. What type of software is Microsoft Excel?
57. Suppose we have names of ICT122 Test rooms in cells D2 to D7, and the rooms’ capacities in cells E2 to E7. Which of these formulas will compute the total capacity of all the 5 rooms?
58. In Microsoft Access, which of the following describes the validation rule “<=120”?
59. What is displayed when a formatted number does not fit within a cell?
60. Which of these is equivalent to the formula: = (B1, B2, B3, B4, B10, B11, B12) / 7 ?