Download CGS 1060 Study Guide Final Questions with Verified An and more Exams Nursing in PDF only on Docsity!
CGS 1060 Study Guide Final
Questions with Verified Answers
Which term is used to refer to all of the physical parts of a computer system? - ANSWERShardware Software that allows you to do word processing, send e-mails, or play games is commonly referred to as - ANSWERSapplication programs Which of the following is an example of an operating system? - ANSWERSMicrosoft Windows A mainframe computer is - ANSWERSan extremely fast, expensive computer with a large data capacity that is typically used by huge companies. A computer that serves other computers by running important software and storing important data is called a - ANSWERSserver What piece of computer hardware is often referred to as the "brains" of the computer? - ANSWERSCPU Which of the following components would NOT be considered a peripheral device? - ANSWERSmotherboard At the lowest level of processing, computers represent data and instructions using a series of binary digits, 1's and 0's. An individual binary digit is known as a - ANSWERSbit A kilobyte is - ANSWERS1024 bytes A string of 8 binary digits is known as a - ANSWERSbyte A removable USB flash drive with a capacity of 4096 megabytes has an equivalent storage capacity of - ANSWERS4 GB Which type of memory contains the instructions necessary for the computer's basic input/output system (BIOS) which is used to load essential data when the computer is turned on? - ANSWERSROM
Which type of memory stores any programs and data that are currently in use by the CPU that will be lost when the computer is switched off? - ANSWERSRAM Which unit of measurement is equivalent to one billion bytes? - ANSWERSgigabyte (GB) What unit of measure is used when describing the speed of a computer's CPU? - ANSWERShertz To increase the performance of your computer and the number of programs it can effectively run at one time, you may want to increase the size of the computer's - ANSWERSRAM Which of the following would be considered an input device? - ANSWERSmouse A display monitor's screen is composed of tiny square units called - ANSWERSpixels Of the different types of computer storage, which would you expect to have the most capacity? - ANSWERShard disk What is the name for the piece of software that manages the hardware, application programs, and provides a graphical user interface to the user of the computer? - ANSWERSoperating system Which of the following is NOT considered an operating system? - ANSWERSMicrosoft Word How many digits is the binary language comprised of? - ANSWERStwo What type of software is used to scan for malicious programs that may be residing in your computer's hard disk or memory? - ANSWERSantivirus The enclosure that contains most of the components of a computer is commonly called the: - ANSWERSsystem unit Memory that requires electrical power to retain data is referred to as being: - ANSWERSvolatile What is the top-level domain for the Uniform Resource Locator (URL) given as http://angel.irsc.edu? - ANSWERS.edu The Internet is best described as a: - ANSWERSa global network of networks What is the protocol prefix for the Uniform Resource Locator (URL) given as http://angel.irsc.edu? - ANSWERShttp://
Which of the following protocols is NOT associated with the transmission or reception of email? - ANSWERSDHCP Google and Bing are examples of what kind of software system? - ANSWERSweb search engine Which of the following is NOT a good practice in combating being a victim of computer fraud? - ANSWERSSend your username or password via email only when the request comes from your IT department. Adware is - ANSWERSmalicious software that displays advertisements and messages when you use your computer. Malware is - ANSWERSthe general term used to describe malicious software that can cause damage to your computer system or data. Spyware is - ANSWERSmalicious software that follows the actions you take and forwards the information to a third party. Phishing is - ANSWERSthe tactic of using a fake web site to imitate a site a user knows and trusts. (Windows) By default when you go past the Lock screen in Windows 10, you will be presented with the ____ which acts as the main workspace on the computer screen. - ANSWERSDesktop (Windows) Pressing which key on the keyboard will bring up the Windows 10 Start Menu? - ANSWERSWindows key (Windows) If you accidentally delete files from your computer's hard drive, they can be "restored" or retrieved from the - ANSWERSRecycle Bin (Windows) A file is best described as - ANSWERSa named unit of storage typically containing text, images, audio, or video (Windows) Which Windows system utility contains a comprehensive list of the devices connected to your computer and displays warning icons next to devices that are misconfigured or disabled? - ANSWERSDevice Manager (Windows) Which of the following is something that would NOT be found by looking through the Performance tab of the Task Manager? - ANSWERSmost frequently visited website (Windows) What is the name of the anti-virus and anti-spyware program that comes with Windows 10? - ANSWERSWindows Defender
(Windows) By pressing Alt+F4 key combination on the keyboard, you can - ANSWERSclose the current application (Windows) You want to find information on how to configure a network printer in Windows 10. Which area of the Task Bar would help you quickly get started in finding the information you need? - ANSWERSSearch Bar (Windows) Pressing which keyboard key allows you to quickly access Windows Help or a Windows application's Help feature? - ANSWERSF (Windows) Cascading the open Windows applications will - ANSWERSstagger the windows on top of each other so that all of the window title bars are visible but only the top active window's content is visible (Windows) Which Windows application can be best used to manage the files and folders on your computer? - ANSWERSFile Explorer (Windows) Because shortcut menus display different options depending on the type of item selected, we say that they are - ANSWERScontext-sensitive (Windows) Applications (or apps) in Windows 10 that you use frequently can be pinned as ____ on the right-side of the Start Menu. - ANSWERStiles (Windows) In Windows 10, which feature at the top left of the File Explorer app contains icons for a small set of the most commonly used commands? - ANSWERSQuick Access Toolbar (Windows) Which tool in Windows allows you to easily terminate non-responsive applications and to view system utilization statistics? - ANSWERSTask Manager (Windows) If Windows 10 doesn't automatically detect and install an appropriate printer, one can be manually added through - ANSWERSthe Settings gear cog (Windows) A file pathname that describes the exact location of that file on your computer begins with - ANSWERSthe Drive letter (Windows) What part of an application's window typically contains the name of the application and/or file as well as the minimize, maximize, and close buttons? - ANSWERSTitle Bar (Windows) A quick way to toggle between the open applications is to use - ANSWERSAlt + Tab (Windows) When a file is copied or cut, it is temporarily placed in the - ANSWERSWindows Clipboard
(Windows) What is the name of the Task Bar feature that allows the user to organize open application windows on multiple Desktops? - ANSWERSTask View (Windows) What is the name of the latest web browser included with Windows 10? - ANSWERSEdge (Windows) Microsoft Edge is integrated with Microsoft's web search engine called: - ANSWERSBing (Windows) If a website doesn't work well with Edge, you can always try using the second (older) web browser also included with Windows 10 called: - ANSWERSInternet Explorer 11 (Windows) Free Microsoft accounts can be created and you can choose a free Microsoft email account to go with including domains @outlook.com and - ANSWERS@hotmail.com (Windows) Microsoft Windows 10 and Microsoft Edge contain options to allow browsing of the Internet in separate browser windows that will not record any details from the browsing sessions to your device using _____ mode. - ANSWERSInPrivate (Windows) The Microsoft Windows 10 operating system introduces a virtual personal assistant called - ANSWERSCortana (Windows) Which Windows 8 feature can automatically back up files in the Documents, Music, Video, and Pictures libraries, and in the Contacts, Desktop, and Favorites folders as well as providing a new file versioning feature? - ANSWERSFile History (Word) The default Word 2016 file format (or file type) is: - ANSWERSDOCX (Word) When you create a new document in Word, you can either create a new blank document or you can choose to pick one of the pre-formatted documents, known as______, that may already include headings and titles formatted in particular fonts and colors. - ANSWERStemplates (Word) Which Word ribbon tab contains the most commonly used command functions such as copying and pasting, changing fonts, and setting paragraph formatting options?
- ANSWERSHome (Word) What do you call the area at the top of Word's window that contains contextually-distinct tabs with groups of buttons to access the application's features that pertain to the document or item? - ANSWERSribbon (Word) Which Word feature is used when you want to save, print, or open a document?
- ANSWERSFile tab menu
(Word) A Word file is usually referred to as a(n) _____. - ANSWERSdocument (Word) Which keyboard shortcut can be used to copy text in a document? - ANSWERS[Ctrl] + [C] (Word) Which keyboard shortcut can be used to paste text in a document? - ANSWERS[Ctrl] + [V] (Word) The current location on the page where text is placed when typing is known as the insertion point or the: - ANSWERSCursor (Word) In Word, what is the name of a temporary storage area that holds text that has been copied or cut? - ANSWERSClipboard (Word) Which page orientation turns the paper on its side and prints as 11 inches wide by 8.5 inches tall? - ANSWERSLandscape (Word) Word allows you to save files in a PDF format. True or False? - ANSWERSTrue (Word) This Word command will save the active file using the same file name by replacing the contents of the existing file with the document as it appears on the screen.
- ANSWERSSave (Word) Suppose you have a Word 2016 document and want to send it to a friend in the old Word 97-2003 format. Which File menu option will help you accomplish this? - ANSWERSSave As (Word) What keyboard shortcut would allow you to select the entire Word document? - ANSWERS[Ctrl] + [A] (Word) In Word, spelling errors are marked with: - ANSWERSa red wavy underline. (Word) If you wanted to replace all instances of the word "customer" with "valued customer" in a document, which button from the Find and Replace Dialog box would be most helpful? - ANSWERSReplace All (Word) In Microsoft Word 2016, the toolbar that appears to the upper right of text that is selected is known as the _____. - ANSWERSMini toolbar (Word) A typeface variation, such as Times New Roman or Calibri, that defines how text appears is referred to as a _____. - ANSWERSfont (Word) The act of changing a font's color, italicizing it, applying bold, or changing its size is called ______. - ANSWERSformatting
(Word) Which of the following terms refers to a connection to a location in the current document, another document, or to a Web site? - ANSWERShyperlink (Word) How do you produce a context-sensitive drop-down menu when working with an object (such as a table) in Word? - ANSWERSright-click on it (Word) One limitation of the Page Borders feature in Word is that they must be applied to all four sides of the page and to each page of the document identically. True or False? - ANSWERSFalse (Word) What is the default formatting that is applied to hyperlinks in Word? - ANSWERSunderlined with blue text color (Word) When inserting a footnote into a document, where does the footnote number or symbol get added to the document? - ANSWERSThe cursor location (Word) Which of the following is true regarding headers in Word 2016? - ANSWERSThe header content does not have to be the same on all pages of a document. (Word) ____ Settings are those that are predefined and available from the moment you first open the program. - ANSWERSDefault (Word) If you hover your mouse over a hyperlink in a Word document, Word will notify you that a ______ operation can be used to follow that link. - ANSWERSCtrl+Click (Word) Once a table is drawn, you cannot alter its dimensions by inserting/deleting rows or columns. True or False? - ANSWERSFalse (Word) Page numbering is done automatically in Word and there is no way to manually adjust the page number for a given page. True or False? - ANSWERSFalse (Word) Paragraph spacing settings apply globally to the entire document. You are not allowed to have different line spacing settings for different paragraphs in the same document. True or False? - ANSWERSFalse (Word) When inserting a footnote into a document, where does the footnote text get added to the document? - ANSWERSThe bottom of the page (Word) Click the _______ button from the Paragraph group of the Home tab in Word to turn on the display of nonprinting formatting characters such as the Paragraph Mark. - ANSWERSShow/Hide (Word) It is possible to merge the cells in an entire row together into a single merged cell. True or False? - ANSWERSTrue
(Word) Moving part or all of a paragraph in from the left and/or right margin is called: - ANSWERSindenting (Word) When multiple people are collaborating on a document and providing suggestions and ideas for improvement, it is helpful to make use of Word's ____ feature found on the Review ribbon. - ANSWERSComment (Word) Which of the following refers to a source reference or long comment that typically appears at the end of a document? - ANSWERSEndnote (Word) By clicking the ___________ checkbox when inserting the date and/or time into a Word document, the document will display the current date/time each time you open it. - ANSWERSUpdate automatically (Word) The vertical space between lines of text is referred to as: - ANSWERSline spacing (Word) What feature from the Word References tab tell the reader what source(s) you used in coming up with the information you just typed? - ANSWERScitations (Word) Which of the following is NOT TRUE regarding Word's Track Changes feature found on the Review Ribbon? - ANSWERSThe Track Changes feature is limited to a one year time frame for each document's lifespan. (Word) The ____ can be automatically generated from the document's citation sources.
- ANSWERSBibliography (Word) The edge of a table or table cell in which different styles and colors can be applied is called a: - ANSWERSborder (Word) Which Word screen element displays the location of margins and indents for the selected paragraph(s)? - ANSWERSRuler (Word) A formatting convention whereby the first line of a paragraph aligns with the margin and the body is recessed to the right is called a: - ANSWERShanging indent (Word) A powerful tool that lets you create letters, e-mails, or address labels for many different recipients, pulling information from a customer list or a database is called: - ANSWERSMail Merge (Word) Table of contents commonly make use of hyperlinks to allow readers to quickly jump to various sections of a large document. True or False? - ANSWERSTrue (Word) What is the term for a structure in Word that contains two or more cells, arranged horizontally in columns and vertically in rows? - ANSWERStable
(Excel) Hitting Ctrl + Home keys on the keyboard will bring you back to the upper leftmost cell of the worksheet whose cell reference is given by: - ANSWERSA (Excel) Press the ______ key to move the active cell one position to the right on the worksheet. - ANSWERSTab (Excel) This bar displays entries as they are made and edited in the Excel workbook window and also shows the actual formula used to calculate the value shown in the worksheet cell. - ANSWERSFormula (Excel) If you wish to MOVE the contents of one cell to another cell, which command will you use: Copy or Cut? - ANSWERSCut (Excel) If you wish to DUPLICATE the contents of a range of cells to another portion of the worksheet, which command will you use: Copy or Cut? - ANSWERSCopy (Excel) A new Blank Workbook in Excel 2016 contains one worksheet named: - ANSWERSSheet (Excel) Excel 2016 files have names that end with a default file extension of ____. - ANSWERS.xlsx (Excel) To save a workbook in a format compatible with Excel 97-2003 versions, the file extension should be: - ANSWERS.xls (Excel) If you're sharing your data with someone who does not have Excel or any sort of spreadsheet software on their computer, you may want to save your workbook in this format: - ANSWERS.pdf (Excel) In Excel, the program name and name of the open file are displayed in the: - ANSWERSTitle bar. (Excel) By clicking the File tab from the Excel ribbon, you have entered the _________ view. - ANSWERSBackstage (Excel) To save an Excel workbook using a different format, location, or filename click the File tab from the Excel ribbon and choose: - ANSWERSSave As (Excel) From the Backstage view Print options, select ____________ under Settings to print all sheets in a workbook. - ANSWERSEntire workbook (Excel) Which page orientation prints the worksheet on paper that is wider than it is tall?
- ANSWERSLandscape Orientation (Excel) The keyboard shortcut for the Print command is: - ANSWERS[Ctrl] + [P].
(Excel) The date and page number of an Excel workbook are commonly placed in a: - ANSWERSHeader or footer (Excel) ____________ is the process of changing the appearance of cells and the overall layout of the worksheet. - ANSWERSFormatting (Excel) Which Excel ribbon tab contains the Font group which allows you to change the font type, size, and color? - ANSWERSHome (Excel) The background of a cell is called the: - ANSWERSfill color. (Excel) Cell ________ such as Heading and Title allow you to apply multiple formats to a cell at once. - ANSWERSstyles (Excel) The edges or lines around a cell are referred to as the cell's: - ANSWERSborder (Excel) ____________ is used to copy the formatting of one cell to other cells. - ANSWERSFormat Painter (Excel) By default, textual data is ____ aligned within Excel cells. - ANSWERSleft (Excel) Combining two or more cells into a single cell creates a: - ANSWERSmerged cell (Excel) Once a set of cell's in Excel have been combined (or merged), they can never be split apart. True or False? - ANSWERSFalse (Excel) Use the ____________ command to display text on two lines within a cell and to keep the contents of a cell from extending beyond the its column width and running over into the cells next to it. - ANSWERSWrap Text (Excel) Applying Excel's Percent Style number format to the decimal value 0.17 will result in which of the following being displayed in the cell? - ANSWERS17% (Excel) If you have a column of data in Excel that represents the cost of different items, then you will likely format that data using either an Accounting number format or a ______ number format. - ANSWERSCurrency (Excel) Suppose you enter the date 4/12/14 in cell A1 and choose the Long Date number format from the Number group of the Home ribbon tab. What will be displayed in cell A1? - ANSWERSSaturday, April 12, 2014 (Excel) The ____________ feature can complete a series of values into adjacent cells based on the value of other cells and can also be used as a shortcut to copying and pasting. - ANSWERSAuto Fill
(Excel) Which of the following functions could be used in finding the largest value from cells C2 through C25? - ANSWERS=MAX(C2:C25) (Excel) Which Excel ribbon tab contains the Function Library command group? - ANSWERSFormulas (Excel) Which of the following is a logical operator and not a comparison operator? - ANSWERSNot (Excel) What is the result of the Excel formula =AND(4=4, 15<=9)? - ANSWERSFalse (Excel) What is the result of the Excel formula =OR(8=4, 5<=9)? - ANSWERSTrue (Excel) Suppose cell D5 has a value of 17. What will be the value of cell E5 if it contains the formula =IF(D5<=10,"OK","Not Good")? - ANSWERSNot Good (Excel) To automatically add row and column headers and analyze a group of related data independenly from other cells in the worksheet, you can convert a range of cells to a(n): - ANSWERSExcel table (Excel) Once data has been formatted as a table in Excel, the tabular format cannot be deleted or removed. True or False? - ANSWERSFalse (Excel) To automatically apply several formatting options to a table all at once, choose one of Excel's predefined table: - ANSWERSstyles (Excel) What is a visual representation of data used to convey information in an easy-to- understand and attractive manner called? - ANSWERSChart (Excel) Prior to creating a chart, it is important to: - ANSWERSselect/highlight the data you wish to chart (Excel) Items such as a chart title, gridlines, data labels, and so on that can be added to a chart are commonly referred to as chart _____. - ANSWERSelements (Excel) The area within the X- and Y-axis boundaries where the chart appears is referred to as: - ANSWERSPlot area (PowerPoint) A slide design that contains matching complementary colors, major and minor fonts, as well as specific effects, like shadows or reflections is referred to as a: - ANSWERStheme (PowerPoint) PowerPoint allows you to insert tables into your slides. Tables are organized by columns and rows, the intersection of which is called a: - ANSWERScell
(PowerPoint) A simulation of movement added to graphics or text on a slide is called: - ANSWERSanimation (PowerPoint) A special effect that marks how one slide moves off and the next slide moves onto the screen is called a(n): - ANSWERStransition (PowerPoint) The very top left portion of the window contains icons representing commonly used commands such as save, undo, or start with the presentation from beginning is known as the: - ANSWERSQuick Access Toolbar (PowerPoint) Tables in PowerPoint are limited to alphanumeric content and cannot contain media content such as images or video clips. True or False? - ANSWERSFalse (PowerPoint) PowerPoint is used to create: - ANSWERSpresentations (PowerPoint) The animation effects are numbered on the slide so you know the order in which they take effect. True or False? - ANSWERSTrue (PowerPoint) Which view is most commonly used to edit your presentations slide by slide? - ANSWERSNormal (PowerPoint) When you click on an object on your slide such as a table or picture, you will be presented with one or more new tabs on the PowerPoint ribbon. These tabs are called _____ because they are specific to the type of item or object you have selected on the slide. - ANSWERScontextual (PowerPoint) Which PowerPoint ribbon tab gives you access to the Comments and Compare command groups which are helpful when collaborating with a group on a presentation? - ANSWERSReview (PowerPoint) Which view makes it easy to see all the slides at once and to rearrange the order of the slides in your presentation? - ANSWERSSlide Sorter (PowerPoint) The outer edge or line around a table is referred to as its: - ANSWERSborder (PowerPoint) Because of possible copyright infringements, PowerPoint does not allow song clips or music to be added to presentations. True or False? - ANSWERSFalse (PowerPoint) Which view gives you an idea of how your presentation will look when you deliver it? - ANSWERSSlide Show (PowerPoint) Which PowerPoint tool could be used to quickly and easily depict a series of steps or levels using a pyramid shape with the ability to add your own text to the diagram? - ANSWERSSmartArt
(Access) By indexing a field, Access can - ANSWERSspeed up searching and sorting records in the table (Access) In order to restrict the data that is inputted into a field, Access can use - ANSWERSdata validation rules (Access) A ______ can be used to add a custom error message for users when they enter an invalid entry for a data field. - ANSWERSField Validation Text (Access) A(n) ____ is a combination of literal and mask characters that specifies the format that Access allows users to use when inputting data into a field in a table and is useful for inputting such things as telephone numbers and social security numbers. - ANSWERSinput mask (Access) Suppose you want to view only the records in a table that have a value of "FL" in the state field. What can you do to quickly display only those records that meet that criteria? - ANSWERSfilter the table on the state field (Access) The 348 exchange has been moved to the 704 area code. To quickly update the telephone number field of all the records in a table, use this feature in Access. - ANSWERSFind and Replace (Access) To quickly rearrange a table's records, you can do this to the table data. - ANSWERSSort (Access) If you want to sort a table by the price field with the highest prices coming first, you should sort on the: - ANSWERSprice field in descending order (Access) Each row in a table contains a(n): - ANSWERSrecord (Access) The data type for a telephone number field is: - ANSWERSShort Text (Access) Each of the following is an Access data type, EXCEPT: - ANSWERSData (Access) The data type of an item price, such as $10.50 is : - ANSWERSCurrency (Access) A single field in a table can have more than one data type defined. - ANSWERSFalse (Access) Information in a database is typically stored in this, which consists of vertical columns and horizontal rows. - ANSWERSTable (Access) RDBMS is an acronym for: - ANSWERSrelational database management system
(Access) The field that uniquely identifies each record in a table is called a: - ANSWERSprimary key (Access) The main purpose of a form is to: - ANSWERSview and enter data into tables. (Access) The purpose of a query is to: - ANSWERSask questions and display specific data from a table. (Access) A database object that summarizes the fields and records from a table in an attractive, easy-to-read format is a: - ANSWERSreport (Access) Each row in an Access table contains a(n) _____ which consists of multiple fields of information. - ANSWERSrecord (Access) Each individual chunk of data that collectively make up a record in a database is called a: - ANSWERSfield (Access) Which of the following views in Microsoft Access is used for entering actual data into records? - ANSWERSDatasheet view (Access) Which of the following views in Microsoft Access is used for changing the design and structure of tables? - ANSWERSDesign view (Access) If a relationship is established between two tables they will share a common: - ANSWERSfield (Access) When designing a table, each field must have a defined ______ which identifies the kind of data that may be stored in that field. - ANSWERSdata type (Access) This data type is used to store up to 255 alphanumeric characters, spaces, and symbols. - ANSWERSShort Text (Access) Since each Social Security Number is unique per person, in the past many companies and organizations used it as a _____ field to uniquely identify their patients, employees, and so on. - ANSWERSPrimary key
