18 Pages
Unlock Document

Concordia University
Business Technology Management
BTM 481
Raul Valverde

EISEL PRACTICE QUESTIONS Module 7: Securing Your System - Protecting Your Digital Data and Devices  Network address translation (NAT) is used to assign internal IP addresses on a network—TRUE  ________ is an unwanted piggyback program that usually downloads with other software you are installing from the Internet.----Spyware  Creating and spreading online viruses is a cybercrime.---TRUE  Instant messaging programs are susceptible to virus attacks.---TRUE  ________ encourages Internet users to reveal sensitive information that could lead to identity theft by sending e-mails that look like they are from legitimate companies but are, in fact, fake.---Phishing  The Windows operating system has built-in password protection of files as well as the entire desktop----TRUE  Bluesnarfing involves the process of taking control of a Bluetooth device and performing actions such as sending text messages or establishing an Internet connection.---FALSE  is the act of tricking people into revealing sensitive information and is often associated with credit card fraud.---PHISING  Theft of a computer is considered cybercrime---FALSE  A denial of service attack can be used to deny hackers access to a computer system.--- FALSE Spreadsheet Analysis - Microsoft Excel  A chart--is a visual representation of numerical data.  A data series--is a group of related data points.  Each row in an Excel table--represents a record.  A cell address (as it applies to Excel 2010)-- identifies a cell by a column letter and a row number.  An X Y (scatter) chart--shows a relationship between two variables.  A chart is composed of only the chart area and labels. You cannot change it, only re-do it after it is created.—FALSE  If the column is too narrow, part of the data you enter in the cell will get deleted.— FALSE  A formula in Excel must begin with a Plus (+) sign.—FALSE  Changing the Format of a cell changes the value of the number stored in the cell.— FALSE  An absolute cell reference indicates a cell¡¯s specific location and the reference changes when you copy the formula.—FALSE  You should use cell references in formulas instead of constant values so--you can change the input values without changing the formulas.  Filtering--is the process of displaying only records that meet specific conditions.  The VLOOKUP function--is a reference to a cell containing a value to look up.  The MIN function--displays the lowest value in a range.  Sorting Values smallest to largest----arranges numbers in sequential order.  If the automatic page breaks occur in undesirable locations, you can adjust the page breaks.-- True  You can sort data by one or more columns.--True  In Excel 2010, there is really no way to tell what a print-out will look like until you print it.--False  Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document.--False  Filtering is the process of deleting records that meet specific conditions.—False  Semi-selection or pointing is the process of using the mouse to select cells while building a formula.—TRUE  The Excel Window contains elements that are similar to other Office applications and some that are unique to Excel.—TRUE  Ribbon Commands with arrows indicate-- there are two or more sub-commands related to the command.  A bar chart--compares values across categories using horizontal bars.  A page break---indicates where data starts on a new printed page.  By default new workbooks contain four worksheets.—FALSE  In Excel, when you hide a column or row, the data is not deleted, just hidden.—TRUE  Conditional formatting-- highlights or emphasizes cells that meet certain conditions.  To adjust the column width and/or row height of many cells at once---click and drag across the cells to select them and use any sizing method you choose.  A spreadsheet--is an electronic file that contains a grid of columns and rows for related data.  A Range name can contain up to 1000 characters but it must begin with a number.— FALSE  You should plan the structure of the worksheets in a workbook before you begin entering data.—TRUE  A page break indicates where the end of all the columns (fields) occurs.—FALSE  The NOW function---displays the current date and time.  You can apply text, value, and date filters to fields based on the data in a particular field.---TRUE  Excel creates charts on the same worksheet as the original data set, but you can move the chart to its own chart sheet in the workbook.---TRUE  Excel uses the / symbol to perform multiplication on operands.---FALSE  A chart layout determines which chart elements appear in the chart area and how they are positioned within the chart area.—TRUE  Merge and Center is not a good tool for creating titles of headings in Excel.—FALSE  The IF function only evaluates a condition if the condition is true.—FALSE  A resizing handle, indicated by faint dots on the outside border of a selected chart, enables you to adjust the size of the chart.—TRUE  The PMT function---calculates the periodic payment for a loan with a fixed interest rate and fixed term.  The Formula Bar (as it applies to Excel 2010)-- displays the content of the active cell.  Labels on charts are not necessary because you can always tell what the chart means by the colors.—FALSE  Using Formatting on data makes it difficult to read and tends to obscure meaningful details.—FALSE  It is possible to rotate the text of a cell to read vertically (up and down) rather than across.—TRUE  Text can be any letters, numbers, and symbols and Excel can use them in calculations.--- FALSE  To simplify entering ranges in formulas you can use---RANGE NAMES Module 5: Understanding and Assessing Hardware - Evaluating Your System  The primary circuit board of a computer system is the ________.—Motherboard  The ________ can be considered the highway on which data travels between the CPU and RAM.—front side bus  The memory your operating system uses is referred to as ________ memory.— kernel  ________ predicts that the capacity of a CPU will double every 18 months.— Moore’s laws  If you want to be able to use a form of optical media (such as a CD or DVD) that you can write to as many times as you like, your media should be in ________ format.—read/writeable  The percentage of time that your CPU is working is referred to as processing time.—FALSE  Every computer is designed with a maximum limit on the amount of RAM it can support.—TRUE  The video subsystem is made up of the video card and speakers.—FALSE  The use of multiple cores on one CPU chip allows the execution of two or more sets of instructions at the exact same time.—TRUE  Temporary data and instructions are not stored on the hard drive because it is faster to retrieve data from RAM.—TRUE  When you evaluate your video card and monitor, you are evaluating your ________ subsystem—video  Because displaying graphics demands a lot of the CPU, a video card also comes with its own ________.---graphics processing unit  ________ determines how quickly the CPU works.—clock speed  Temporary data and instructions are not stored on the hard drive because it is faster to retrieve data from RAM.—TRUE  The use of multiple cores on one CPU chip allows the execution of two or more sets of instructions at the exact same time.—TRUE  The control unit coordinates the activities of all computer components except for the CPU itself.---TRUE  RAM is nonvolatile storage.---FALSE  A stoppage of the hard drive that often results in data loss is called a(n) ________.---HEAD CRASH  RAM is stored directly on the CPU.---FALSE  ________ is the type of RAM memory used most often in today's computers— DDR2  ________ provides quick processing of information by enabling a new set of instructions to start before the previous set has been finished.— HYPERTHREADING  ________ discs have the greatest storage capacity of all types of optical discs.— BLUE-RAY  Upgrading your operating system to the newest version might help increase system reliability.—TRUE  Upgrading your CPU can increase how quickly data can move to or from the CPU.---FALSE  Video cards often include their own RAM.—TRUE  Solid state drives have no platters or motors.—TRUE  ________ memory is a form of random access memory that is more accessible to the CPU than regular RAM.---CACHE  To determine whether your system has the right hardware components to do what you want it to do, you should perform a(n) ________.---SYSTEM EVALUATION  A computer's memory subsystem is made up only of RAM.---TRUE  Hard drive access time is measured in milliseconds.—TRUE  Hard drives have been growing in storage capacity by about 50 percent each year.—TRUE  RAM is your computer's permanent storage space for data that is entered from the keyboard.—FALSE  Front side bus (FSB) speed is measured in ________.—megahertz  When your computer's performance suddenly seems to drop off, the Windows program called ________ gives you easy access to performance information.— task manager  A Blu-ray burner will most likely record both CDs and DVDs.—TRUE  Level 2 cache is slightly farther away from the CPU than Level 1 cache or on a separate chip.----TRUE  The video subsystem is made up of the video card and speakers.---FALSE  The control unit coordinates the activities of all computer components except for the CPU itself.—TRUE  Moore's Law predicts that the number of transistors inside a CPU will triple every 18 months.---FALSE  3D sound is the same as surround sound.---FALSE  Computer systems with insufficient amounts of temporary memory, or ________, often crash.----RAM  The number of bits the video card uses to represent each pixel on the monitor is called ________.—BIT DEPTH  The video subsystem consists of the video card and the ________.----MONITOR  Every computer is designed with a maximum limit on the amount of RAM it can support.---TRUE  Notebook and desktop processors are basically the same and therefore interchangeable.—FALSE  RAM is stored directly on the CPU.----FALSE  The audio subsystem consists of the speakers and a(n) ________.---SOUND CARD  ________ hard drives use much thinner cables and can transfer data more quickly than IDE drives.---SERIAL ATA  Blue-ray players are ________ compatible and can play both DVDs and CDs.--- BACKWARD  RAM is an example of ________ storage because when the power is turned off, RAM is cleared out.----VOLATILE  Modern processors are defined by the combination of processor speed, front side bus speed, and the amount of ________.---CACHE MEMORY  Cache memory is a form of ROM.---FALSE  Hard drive access time is measured in milliseconds.—TRUE  Temporary data and instructions are not stored on the hard drive because it is faster to retrieve data from RAM.---TRUE  External hard drives are an ideal solution when you need more storage than a flash drive can provide.---TRUE  The CPU is located on the motherboard.---TRUE  ________ are the small circuit boards that hold a series of RAM chips.--- MEMORY MODULES  A(n) ________ handles the same type of processes as a CPU but is specialized for 3D and image and graphic processing.---GPU  Hard drives have the largest capacity of any storage device.---TRUE  Level 1 cache memory always contains more storage area than Level 2 cache.— FALSE  Accessing data from the hard drive to send to the CPU is faster than accessing data from RAM.----FALSE Module 4: Using System Software - The Operating System, Utility Programs, and File Management  The type of processor in the computer dictates which operating system a desktop uses.---TRUE  Boot Camp is a utility that allows you to run Windows and Mac OS X at the same time.---TRUE  With the Plug and Play standard, adding hardware to your computer becomes easier.---TRUE  Linux is an open source operating system that can be used both on personal computers and as a networking operating system.---TRUE  Tiles view is the most interactive view of a Windows folder.---FALSE  Once a computer is turned on and the system files are loaded into RAM, the ________ (or supervisor program) is loaded.---KERNAL  The process of swapping data or instructions out of the swap file back into RAM is known as ________.---PAGING  A feature of newer Windows applications is that they use ________ that are organized into tabs displayed on the ribbon.---TOOLBARS  ________ is the ability of the operating system to perform more than one task at a time.---MULTITASKING  Scattered pieces of files on the hard drive can be regrouped into sequential order using the ________ utility.---DISK DEFRAGMENTER  Devices that perform regimented tasks or record precise results require a(n) ________ operating system.---REAL TIME  When using Windows, you should create a restore point before installing new software.--TRUE  Boot Camp is a utility that allows you to run Windows and Mac OS X at the same time.---TRUE  All computers have operating systems.---TRUE  A computer's hardware devices and the operating system are able to communicate using special programs called ________.----DEVICE DRIVERS  ________ is a function of the operating system that entails providing organizational structure to the computer's contents.----FILE MANAGEMENT  The interface used by the Windows operating system is commonly referred to as a(n) ________.----GRAPHICAL USER INTERFACE  CMOS is a special kind of memory that uses a great deal of power.--- FALSE  If you install a device that is not PnP, you will be prompted to install a driver.---TRUE  The High Contrast accessibility feature allows you to select a color scheme setting in which you control the contrast between text and background.---TRUE  When virtual memory is in use, the condition of excessive paging is called swapping.---FALSE  A multiuser operating system is also described as a network operating system.—TRUE  Installing a device driver can sometimes cause system instability.---TRUE  During the boot process, the ________ is responsible for loading the OS from the hard drive into RAM.---BIOS  You can use System Restore to restore your system's settings back to a specific date when everything was working properly---TRUE  You can download a version of Linux from the Internet for free.---TRUE  When virtual memory is in use, the condition of excessive paging is referred to as thrashing.---TRUE  Before upgrading to a new OS, you should ________ your data files.--- BACK UP  While your computer is turned on, the operating system is stored in ________.---RAM  Tiled windows cannot be resized.---FALSE  PnP stands for Plug and Play.---TRUE  Linux does not have a default user interface.---TRUE  Windows 7 will run with 1 GB of RAM, but the system might be challenged by limited resources, especially with graphic-intensive programs.---TRUE  Linux is ________ software, which means that developers can use or modify the underlying source code as they wish.---OPEN SOURCE  The lines of instructional code that make a program work are called ________.---SOURCE CODE  The Windows Backup and Restore Utility allows you to make a duplicate copy of all the data on your hard drive.---TRUE  Large corporations often use powerful computers called ________ to store, manage, and process data from thousands of users.--- MAINFRAMES  The combination of a computer's operating system and application software is referred to as the computer's platform.---FALSE  The process of optimizing RAM by using the hard drive's swap file is called ________.---VIRTUAL MEMORY  OS stands for ________.---OPERATING SYSTEM  A(n) ________ utility (such as WinZip) removes redundancies in a file to reduce the file size.---FILE COMPRESSION  Files are stored in a hierarchical structure of ________ that includes files, folders, and drives.---DIRECTORIES  When your computer runs out of RAM, the operating system borrows space from the CPU.---FALSE  Safe Boot is a special diagnostic mode designed for troubleshooting errors that occur during the boot process.---FALSE  Live Icons allow you to preview the actual contents of a specific file or folder from within a window without actually having to open the file.--- TRUE  The user interface is part of a computer's operating system.---TRUE  API stands for ________.---application programming interface  In Safe mode, only the essential devices of the system function.---TRUE  ________ occurs when the OS processes a higher priority task before a lower priority task.---PREEMPTIVE MULTITASKING  Your first interaction with an operating system is through the ________.-- -USER INTERFACE  System software includes the operating system and ________ programs.—UTILITY Module 3: Application Software - Programs That Let You Work and Play  ________ include specific designs, special formatting, and styles relevant to a particular document.---TEMPLATES  Your computer has two basic types of software: system software and ________ software.---APPLICATION  ________ programs are a form of 3D modeling that engineers use to create automated designs, technical drawings, and model visualizations.---COMPUTER AIDED DESIGN  ________ control how and when text and other objects enter and exit each slide of a slide show.---ANIMATION EFFECTS  The primary benefit of spreadsheet software is its ability to ________ all formulas and functions in the spreadsheet when values are changed.---RECALCULATE  Microsoft Excel and OpenOffice.org Calc are examples of spreadsheet software.---TRUE  Integrated software applications and software suites are essentially the same thing.--- FALSE  When uninstalling software, it is best simply to open the Explorer window and delete the folder containing the software.---FALSE  If you use shareware software after the initial trial period is over without paying for it, you will not be breaking the software license agreement.---FALSE  Adobe Premiere Pro is an example of software that allows you to edit video.---TRUE  Use ________ software to create dynamic slide shows.----PRESENTATION  ________ software includes image, video, and audio editing software.---MULTIMEDIA  The Windows 7 operating system allows you to create a(n) ________, which allows you to go back to your computer's previous settings if anyt
More Less

Related notes for BTM 481

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.