CIS105 - Ch 1 - 4

Card Set Information

Author:
mportales7
ID:
84605
Filename:
CIS105 - Ch 1 - 4
Updated:
2011-05-08 19:53:19
Tags:
CIS105 Chapter
Folders:

Description:
CIS105 - Chapter 1 - 4 PCC
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user mportales7 on FreezingBlue Flashcards. What would you like to do?


  1. Two or more computers connected together for resource sharing and communication is referred to as a __.

    A. network
    B. grid
    C. model
    D. hookup
    A. Network
    (this multiple choice question has been scrambled)
  2. __ is the study, design, development, implementation, support and management of computer-based information systems, particulary software and hardware.

    A. Computer finance
    B. Information Technology
    C. Business technology
    D. Database design
    B. Information technology
    (this multiple choice question has been scrambled)
  3. Often referred to simply as a computer, a __ is the least powerful computer in terms of processing and comes in three typical configurations: the desktop, laptop and handheld.

    A. microcomputer
    B. midrange computer
    C. midrange computer
    D. system processor
    A. Microcomputer
    (this multiple choice question has been scrambled)
  4. The __, or operating system, is the groundwork for all system software and performs jobs like allocating memory, administrating input and output, and file management.

    A. base
    B. forum
    C. platform
    D. staging system
    C. Platform
    (this multiple choice question has been scrambled)
  5. Email, word processors, spreadsheets and databases are all examples of __, used to perform particular task such as creating a budget or creating a resume.

    A. applicative hardware
    B. application software
    C. form software
    D. function software
    B. Application Software
    (this multiple choice question has been scrambled)
  6. Devices that plug into computer systems can be categorized as either an input device or an output device and are often called __ devices.

    A. foreign
    B. peripheral
    C. exterior
    D. outside
    B. Peripheral
    (this multiple choice question has been scrambled)
  7. A computer's primary circuit board, which is a complex array of electronics that connects and helps different components communicate with one another, is most commonly reffered to as the __ board.

    A. mother
    B. circuit
    C. data
    D. process
    A. Mother
    (this multiple choice question has been scrambled)
  8. The __ interprets program instructions and processes data by performing arithmetic and logical operations.

    A. computer programming unit
    B. data processing unit
    C. central processing unit
    D. computer processing unit
    C. Central Processing Unit
    (this multiple choice question has been scrambled)
  9. The ones and zeroes that comprise the binary system are reffered to as __ and combining eight of these creates a byte.

    A. data
    B. numbers
    C. digits
    D. bits
    D. Bits
    (this multiple choice question has been scrambled)
  10. While extremely fast, __ is volatile memory and does not retain data or information after the computer is turned off.

    A. CPU
    B. CMOS
    C. RAM
    D. USB
    B. CMOS
    (this multiple choice question has been scrambled)
  11. When you change a style, __.

    A. the new style will be applied to the paragraph in which the insertion bar currently sits
    B. all text defined by that style will automatically change
    C. you can select a paragraph and it will automatically change
    D. you must reapply the new style to all applicable text
    B. All text defined by that style will automatically change
    (this multiple choice question has been scrambled)
  12. A typeface, or __ is a complete set of characters, including upper and lower case letters, punctuation marks, and special symbols.

    A. font
    B. serif
    C. paragraph
    D. attribute
    A. Font
    (this multiple choice question has been scrambled)
  13. Use the __ to copy exsiting text formats to other text.

    A. format painter
    B. paste
    C. copy
    D. find
    A. Format Painter
    (this multiple choice question has been scrambled)
  14. By clicking the button displaying a paragraph mark in the paragraph group on the home tab, you can __.

    A. insert a tab
    B. insert non-breaking spaces
    C. copy text onto the clipboard
    D. display nonprinting formatting marks
    D. Display nonprinting formatting marks
    (this multiple choice question has been scrambled)
  15. __ text, in which the first letters of each line align but the right margin is ragged, is perhaps the easiest to read.

    A. Justified
    B. Right-aligned
    C. Centered
    D. Left-aligned
    D. Left-aligned
    (this multiple choice question has been scrambled)
  16. __ allows you to copy the content of a cell or range of cells by dragging the fill handle over an adjacent cell or range of cells. This is especially useful for copying formulas and completing sequences.

    A. AutoFill
    B. Select
    C. Fill
    D. Copy
    A. AutoFill
    (this multiple choice question has been scrambled)
  17. The cell at the intersection of the first column and the eighth row would have a cell reference of __.

    A. 18
    B. 81
    C. 8A
    D. A8
    D. A8
    (this multiple choice question has been scrambled)
  18. Which of the following is entered first when creating a formula?

    A. A function
    B. A value
    C. A mathmatical operator
    D. The equal sign
    D. The equal sign
    (this multiple choice question has been scrambled)
  19. What is the answer to =6+4*3-(3*2)?

    A. 24
    B. 6
    C. 432
    D. 12
    D. 12
    (this multiple choice question has been scrambled)
  20. To make formulas visible in your worksheet, either click Show Formulas in the Formula Auditing group of the Formulas tab or press the Ctrl + __ key.

    A. tab
    B. F
    C. question mark (?)
    D. grave accent (')
    D. Grave Accent (')
    (this multiple choice question has been scrambled)
  21. Computers not connected to any other computer are described as __.

    A. networked
    B. connectionless
    C. stand-alone
    D. nonproprietary
    C. Stand-Alone
    (this multiple choice question has been scrambled)
  22. A(n) __ is a collection of computer programs that administer the hardware and software of a computer so they work properly.

    A. suite
    B. compilation
    C. operating system
    D. application
    C. Operating System
    (this multiple choice question has been scrambled)
  23. Modern operating systems feature __, which allows an operating system to run more than one process at a time.

    A. multitasking
    B. file management
    C. applicators
    D. processing
    A. Multitasking
    (this multiple choice question has been scrambled)
  24. The most widely used operating systems include Microsoft __, UNIX, Linux and Mac OS.

    A. Jaguar
    B. Windows
    C. Word
    D. OD
    B. Windows
    (this multiple choice question has been scrambled)
  25. RAM, or primary storage, is considered volatile memory because __.

    A. its contents are lost if not saved to non-volatile device such as a hard drive
    B. it allows access to commonly used calculated values
    C. it stores copies of data from the most regularly used parts of main memory.
    D. it does not communicate using standard protocol resources
    A. Its contents are lost if not saved to non-volatile device such as a hard drive
    (this multiple choice question has been scrambled)
  26. A hard drive, which is a non-volatile __ storage device, records information using a read/write apparatus to record a positive or negative charge on a platter.

    A. cache
    B. secondary
    C. third
    D. primary
    B. Secondary
    (this multiple choice question has been scrambled)
  27. The microsoft platform uses a table of contents referred to as a __, or FAT.

    A. fragmented access table
    B. file access table
    C. file allocation table
    D. fragment allocation table
    C. File Allocation Table
    (this multiple choice question has been scrambled)
  28. Operating systems provide a GUI, or __, to allow a user to interact with a computer.

    A. graphical usable interface
    B. graphical underlying interface
    C. graphical user interface
    D. geographical user interface
    C. Graphical User Interface
    (this multiple choice question has been scrambled)
  29. Every peripheral device requires a(n) __, which allows the operating system to communicate with that device.

    A. icon
    B. USB
    C. embedded OS
    D. device driver
    D. Device Driver
    (this multiple choice question has been scrambled)
  30. Currently, the most widely used microcomputer operating system is __.

    A. Microsoft Windows
    B. UNIX
    C. Linux
    D. Mac OS
    A. Microsoft Windows
    (this multiple choice question has been scrambled)
  31. How should the TODAY function look when entered in the formula bar?

    A. TODAY()
    B. =TODAY()
    C. =TODAY
    D. TODAY
    B. =TODAY()
    (this multiple choice question has been scrambled)
  32. Which of the following is an absolute cell reference?

    A. A$1
    B. $A$1
    C. $A1
    D. A1
    B. $A$1
    (this multiple choice question has been scrambled)
  33. Use the __ to toggle through relative, absolute, and mixed references.

    A. Alt Key
    B. Spacebar
    C. Ctrl Key
    D. F4 Key
    D. F4 Key
    (this multiple choice question has been scrambled)
  34. A relative cell reference within a formula changes relative to the direction in which the formula is being copied, while a(n) __ in a formula is one that stays the same no matter where you copy a formula.

    A. consistent cell reference
    B. mixed cell reference
    C. permanent cell reference
    D. absolute cell reference
    D. Absolute Cell Reference
    (this multiple choice question has been scrambled)
  35. A function is actually a(n) __ that has already been created by Excel and makes difficult computations less complicated.

    A. worksheet
    B. formula
    C. procedure
    D. argument
    B. Formula
    (this multiple choice question has been scrambled)
  36. The SUM function __.

    A. adds numeric entries within a range of cells
    B. counts the number of cells in a range that contains numbers
    C. returns the future value of an investment
    D. calculates the arithmetic mean for the values in a range of cells
    A. Adds numeric entries within a range of cells
    (this multiple choice question has been scrambled)
  37. Assume that A1=10, A2=20, B1=5, B2=15
    What is the result of the following function?
    =IF (A1=A2, MIN(B1:B2), MAX(B1:B2))

    A. 15
    B. 10
    C. 20
    D. 5
    A. 15
    (this multiple choice question has been scrambled)
  38. The VLOOKUP function may use __, which are listed in ascending order in the first column of the lookup table.

    A. absolute references
    B. breakpoints
    C. categories
    D. operators
    B. Breakpoints
    (this multiple choice question has been scrambled)
  39. The __ function calculates the payment for a loan that is paid off at a fixed amount at a periodic rate.

    A. FV
    B. SUM
    C. PAYMENT
    D. PMT
    D. PMT
    (this multiple choice question has been scrambled)
  40. In Excel, dates are stored as __ which allows you to calculate differences between dates, add or subtract days from a date, etc...

    A. text
    B. tabs
    C. numbers
    D. images
    C. Numbers
    (this multiple choice question has been scrambled)
  41. Data security ensures that data is kept safe from corruption and also ensures __, meaning that only intended users can access it.

    A. recovery
    B. storage
    C. privacy
    D. archiving
    C. Privacy
    (this multiple choice question has been scrambled)
  42. Tangible property differs from __ property in that tangible property includes things and this kind of property includes name, ideas, and inventions.

    A. ideological
    B. intellectual
    C. intelligent
    D. intangible
    B. Intellectual
    (this multiple choice question has been scrambled)
  43. In physical storage media, a negative charge represents a "0" __ and a positive charge represents a "1".

    A. bit
    B. decimal
    C. system
    D. byte
    A. Bit
    (this multiple choice question has been scrambled)
  44. When we finish our work, we save the results in __ storage, which is non-volatile.

    A. third
    B. secondary
    C. cache
    D. primary
    B. Secondary
    (this multiple choice question has been scrambled)
  45. When purchasing storage media, consider __ (how much data can it hold), and __ (how quickly can it read and write data).

    A. price, capacity
    B. price, access time
    C. capacity, price
    D. capacity, access time
    D. Capacity, Access Time
    (this multiple choice question has been scrambled)
  46. Memory cards used in digital cameras and thumb drives use flash memory, a form of non-volatile __ storage.

    A. temporary
    B. liquid crystal
    C. solid state
    D. optical
    C. Solid State
    (this multiple choice question has been scrambled)
  47. Large organizations often use RAID's, a series of hard drives treated as a single hard drive, because they __.

    A. are fast and relatively inexpensive
    B. are solid state
    C. provide less capacity but faster access time
    D. have unlimited capacity
    A. Are fast and relatively inexpensive
    (this multiple choice question has been scrambled)
  48. A file which contains sensitive information should not be stored on a(n) __.

    A. hard disk drive
    B. USB Flash Drive
    C. internet drive
    D. DVD
    C. Internet Drive
    (this multiple choice question has been scrambled)
  49. All businesses need to __ information so that it may be accessed at a later date, especially in the case of data loss.

    A. restore
    B. create
    C. backup
    D. delete
    C. Backup
    (this multiple choice question has been scrambled)
  50. __ storage could lead to incredibly small circuits, but will probably not be available for many years.

    A. Holographic
    B. Miniscule
    C. Tiny
    D. Molecular
    D. Molecular
    (this multiple choice question has been scrambled)
  51. When printing a chart, you can choose to print an entire __ or the active sheet.

    A. workbook
    B. chart
    C. section
    D. worksheet
    A. Workbook
    (this multiple choice question has been scrambled)
  52. A chart is based on numeric values in cells called __.

    A. data series
    B. data categories
    C. data points
    D. data cells
    C. Data Points
    (this multiple choice question has been scrambled)
  53. Different types of charts are best suited to different presentations of data. Which type of chart would best display proportional relationships, such as percentages?

    A. Line
    B. Pie
    C. Column
    D. Bar
    B. Pie
    (this multiple choice question has been scrambled)
  54. Which type of chart shows trends over a period of time?

    A. Line
    B. bar
    C. pie
    D. column
    A. Line
    (this multiple choice question has been scrambled)
  55. A(n) __ pie chart displays one or more slices separately to add emphasis to that data represented by the separate slice(s).

    A. doughnut
    B. expanded
    C. 3-D
    D. exploded
    D. Exploded
    (this multiple choice question has been scrambled)
  56. Which type of chart displays data vertically in a column formation and is used to compare values across different categories?

    A. Pie
    B. Line
    C. Bar
    D. Column
    D. Column
    (this multiple choice question has been scrambled)
  57. To avoid presenting a misleading picture, do NOT include __ and individual data points on the same chart.

    A. totals
    B. legends
    C. ranges
    D. data series
    A. Totals
    (this multiple choice question has been scrambled)
  58. To select non-adjacent cells or non-adjacent cell ranges, select the first cell or cell range and then hold down the __ key while selecting the other cells and/or ranges.

    A. Alt
    B. Shift
    C. Delete
    D. Ctrl
    D. Ctrl
    (this multiple choice question has been scrambled)
  59. __, which are the values or names of data points, often do much to enhance a chart.

    A. Data Series
    B. Data Labels
    C. Data Points
    D. Data
    B. Data labels
    (this multiple choice question has been scrambled)
  60. When you embed a chart in Word without linking it back to Excel, __.

    A. you double-click the chart in Excel to automatically send changes to the chart in Word
    B. you right-click the chart in word and select "Update Link" to update the Word chart
    C. you must copy and paste the chart from Excel again to update the chart in Word
    D. the chart in Word will update automatically when you change the original excel chart
    C. You must copy and paste the chart from Excel again to update the chart in Word
    (this multiple choice question has been scrambled)

What would you like to do?

Home > Flashcards > Print Preview