Identify the Statement About Windows Tasks That is False

1 UNIT 2 — MILESTONE 2 Identify the statement about Windows tasks that is FALSE. Clicking on the Internet Explorer icon is a shortcut way to display all Microsoft Office programs. You can view all files on a computer by using File Explorer (formerly known as Windows Explorer). Pressing the power button begins the boot process. The most common way to open an application is by using the Start menu. RATIONALE Pressing the power button begins the boot process. You can view all of the files on a computer by using File Explorer (formerly called Windows Explorer). The most common way to begin an application is by accessing the Start menu. However, clicking on the Internet Explorer icon is not a shortcut way to display all Microsoft Office programs. Clicking on that icon will open the Internet Explorer web browser. 2 Select the data type that can only be classified as a number. 83.152 $1,253.12 13:30 11/10/11 RATIONALE The appropriate type for "83.152" is number. The appropriate type for "$1,253.13" is currency. The appropriate type for both "13:30" and "11/10/11" is date/time. 3 Luis has an organized system of icons, files, and folders on his computer's home screen. Which element of the Microsoft Windows operating system is Luis using? Desktop Start Menu Device Manager Control Panel RATIONALE The description refers to the Desktop of the Microsoft Windows operating system on Luis' computer. 4 __________, developed by Apple, can be used to calculate and organize financial information. Numbers Excel Calc Keynote RATIONALE Numbers, developed by Apple, can be used to calculate and organize financial information. Numbers is a spreadsheet application that is part of the iWork productivity suite, along with Keynote and Pages. Numbers is available for iOS and Mac OS. 5 Which of the following is the FIELD in a database table? 6/5/1985 beextraordinary@email.com Name Emily Walker RATIONALE 6/5/1985, beextraordinary@email.com, and Emily Walker should appear in rows in a database table because they are parts of specific records. Name should appear as a column heading in a table, because it represents a field and indicates the type of information collected in the column. 6 Jeremiah searches his computer for movie files that he recently shot during his vacation in Belize. Select the set of file types that Jeremiah should look for. .wma and .mpg .mpg and .key .mov and .ods .avi and .wmv RATIONALE The set of file types that Jeremiah should look for is .avi and .wmv. Video file formats are used to store digital video data on a computer system. 7 Select the scenario that describes a top-down approach to data warehouse design. Connor’s Meat Market, which just opened, creates data marts to track the sale of each of the following meats: beef, pork, lamb, and fish. Crawford's Fabrics, which wants to expand its operations, combines data from the purchasing and sales departments into a central database, to be divided into new data marts as needed. Cynthia’s Florals, which is dealing with debt, creates new data marts for the service, delivery, and sales departments to develop a strategy to stay in business. Cathy’s Cards and Gifts, which has three stores, creates data marts for its sales, marketing, and delivery departments to study the possibility of establishing a new store. RATIONALE Crawford’s Fabrics uses a top-down data warehouse design. It began collecting data, then divided what it collected into data marts, as needed. The other answer involve a bottom-up data warehouse design. Bottom-up design builds data marts from different departments, then merges the data marts into a single data warehouse. 8 Brian has a corrupted file that tries to load when his computer is booting up. To solve this problem, he restarts the computer, then presses F8 to display the Advanced Boot Options menu. Which solution is Brian using? Help System Control Panel Windows Backup Safe Mode RATIONALE Brian restarts his computer and then presses F8 to access the Advanced Boot Options menu. This activates the Safe Mode. Safe Mode is a diagnostic state of a computer operating system (OS). It is used to repair problems with an OS. 9 Which of the following is NOT a challenge of data warehouse design? Determining analytics and reporting Data quality Performance requirements Internet speed RATIONALE Data quality, determining analytics and reporting, and performance requirements are challenges of data warehousing. Internet speed is not a challenge, because it does not affect the quality of data warehouse design. However, Internet speed does affect data access. 10 Carrie's computer does not recognize her zip drive when she plugs it into a USB port. Carrie's computer is experiencing a(n) __________. application crash system performance problem file compatibility issue external error RATIONALE Carrie's computer is experiencing a system performance problem. It does not recognize a peripheral input device (in this example, the zip drive). 11 Which productivity software is used to create tables from statistical data? Open Office Impress Google Docs Microsoft Excel Microsoft SQL Server RATIONALE Excel is a spreadsheet program provided by Microsoft that is used to create charts from statistical data. 12 An enrollment counselor queries the following database table to identify undergraduate accounting majors. How many records are displayed in the query? Student_ID 44352 98425 67512 97156 36401 97315 54074 64782 1 2 3 Student_Name State Birth_Year Degree Major Anderson, Tiffany IL 1994 Graduate Economics Avendano, Marco MN 1994 Graduate Accounting Barrett, Eliza IL 1992 Graduate Mathematics Brown, Amy MN 1994 Undergraduate Pre-Medicine Elissa, Jose WI 1997 Undergraduate Accounting Grey, Nicole VT 1999 Undergraduate Theatre Harris, Blake IL 1992 Undergraduate Accounting Jensen, Allan MN 1990 Graduate Economics 4 RATIONALE The query will display only the records that fit the criteria of undergraduate degree and an accounting major. Only two records fit both criteria (Jose Elissa and Blake Harris). 13 Which of the following correctly describes a record? A record contains all the data about one instance of an item in a database. A record is an organized collection of data associated with other data in a database. A record contains all the qualitative data in a database. A record represents a single type of information found in a database. RATIONALE A record contains all the data about one instance of an item in a database. Each record in the database is a row from a table that has information corresponding to each field or column in the table. 14 Because a computer typically runs a variety of programs simultaneously, the role of the operating system is to ensure that all programs have access to the __________. power supply monitor CPU keyboard RATIONALE The CPU manages the commands it receives from the computer software. When a computer is multitasking, the software must access the CPU so that it gets the resources it needs to execute tasks and instructions. 15 Pille runs a small business. She wants to create and send invoices to her customers. Which productivity software should Pille use? Google Slides MySQL Microsoft Access OpenOffice Calc RATIONALE OpenOffice Calc is a spreadsheet application provided by Apache. Because it is open source software, it is easy for users to open, and is compatible with many other spreadsheet programs.