CIS105 - Ch 5-7

Card Set Information

Author:
mportales7
ID:
84675
Filename:
CIS105 - Ch 5-7
Updated:
2011-05-10 23:02:28
Tags:
CIS105 Chapters
Folders:

Description:
CIS105 - Chapters 5-7
Show Answers:

Home > Flashcards > Print Preview

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


  1. __, especially important in business and facilitated by software applications such as microsoft's groove and lotus notes, is a method of mutal learning between two or more people working together towards a common goal.

    A. Collaboration
    B. Participation
    C. Archiving
    D. Concatenation
    A. Collaboration
    (this multiple choice question has been scrambled)
  2. A(n) __ uses application software to perform task.

    A. computer
    B. operating system
    C. hard drive
    D. end-user
    D. End-User
    (this multiple choice question has been scrambled)
  3. Microsoft sells a word processor called Microsoft __.

    A. WordStar
    B. Word
    C. Vista
    D. WordPerfect
    B. Word
    (this multiple choice question has been scrambled)
  4. Microsoft Office replaced menus with __, which displays as a strip across the top of the window.

    A. submenus
    B. ribbons
    C. commands
    D. columns
    B. Ribbons
    (this multiple choice question has been scrambled)
  5. Microsoft Excel, a(n) __ software, presents an interface in a grid of rows and columns and is often used for financial information.

    A. presentation
    B. word processor
    C. spreadsheet
    D. database
    C. Spreadsheet
    (this multiple choice question has been scrambled)
  6. A database __ provides a subset of information and is often used to make business decisions.

    A. table
    B. query
    C. column
    D. form
    B. Query
    (this multiple choice question has been scrambled)
  7. To effectively present a PowerPoint presentation, the presenter needs to __.

    A. enhance each point based on the content of the slide
    B. read the slides for the audience
    C. allow the audience to read the slides with no interference
    D. create slides with lots of content, especially text
    A. Enhance each point based on the content of the slide
    (this multiple choice question has been scrambled)
  8. Object embedding is static, which means it only takes a snapshot, while object __ is dynamic, meaning that both the source and destination files stay current.

    A. interfacing
    B. emphasis
    C. linking
    D. sharing
    C. Linking
    (this multiple choice question has been scrambled)
  9. A raster graphic is also called a(n)__.

    A. image graphic
    B. pixel
    C. bitmap
    D. vector graphic
    C. Bitmap
    (this multiple choice question has been scrambled)
  10. A web authoring program, such as Microsoft Expression Web or Adobe Macromedia, allows a user to create websites without having to know __.

    A. heirarchical marking language
    B. hypertext markup language
    C. hypertext macro language
    D. hypertext macro layouts
    B. Hypertext Markup Language
    (this multiple choice question has been scrambled)
  11. A __ displays a subset of data.

    A. table
    B. filter
    C. worksheet
    D. sort
    B. Filter
    (this multiple choice question has been scrambled)
  12. Why can working with a large worksheet that is too big to display on one screen be confusing for a user?

    A. A user is able to see all information easily and at once.
    B. A user cannot view all of the information in the worksheet at one time.
    C. A user may not change the data in the worksheet.
    D. There are no horizontal scroll bars in spreadsheet application programs.
    B. A user cannot view all of the information in the worksheet at one time.
    (this multiple choice question has been scrambled)
  13. To go to the bottom right cell of a worksheet, press the __ keys.

    A. Ctrl-Alt-Delete
    B. Ctrl-Home
    C. Ctrl-End
    D. Shift-Tab
    C. Ctrl-End
    (this multiple choice question has been scrambled)
  14. __ lets you specify rows and/or columns to keep visible as you scroll and is particularly useful for displaying headings no matter where you scroll.

    A. Layering
    B. Freezing
    C. Protecting
    D. Hiding
    B. Freezing
    (this multiple choice question has been scrambled)
  15. You can hide __.

    A. rows, columns, and worksheets
    B. cells, rows, and columns
    C. worksheets and workbooks
    D. rows, columns, and workbooks
    A. Rows, Columns, and Worksheets
    (this multiple choice question has been scrambled)
  16. Click orientation in the Page Setup group on the Page Layout tab to change the page orientation from portrait to __.

    A. landscape
    B. layer
    C. normal
    D. wide
    A. Lanscape
    (this multiple choice question has been scrambled)
  17. A __ contains rows and columns of related data formatted to facilitate data management and analysis.

    A. query
    B. sort
    C. form
    D. table
    D. Table
    (this multiple choice question has been scrambled)
  18. An inserted record in a table will go __ the selected cell.

    A. to the right of
    B. to the left of
    C. below
    D. above
    D. Above
    (this multiple choice question has been scrambled)
  19. If you use a first sort level of last name and a second sort level of first name, what will be the order of the following records?

    A. 1,2,3,4
    B. 2,3,4,1
    C. 4,1,2,3
    D. 4,2,1,3
    D. 4,2,1,3
    (this multiple choice question has been scrambled)
  20. Sorting in ascending order sorts data in __ order.

    A. most recent to least recent
    B. low to high
    C. descending
    D. high to low
    B. Low to High
    (this multiple choice question has been scrambled)
  21. The system update utiltiy allows companies like Microsoft to send operating system __ to a user's computer using the internet.

    A. utilities
    B. viruses
    C. fixes
    D. patches
    D. Patches
    (this multiple choice question has been scrambled)
  22. Every computer has a(n) __, which administers the hardware and software of the computer.

    A. word processor
    B. GUI
    C. utility driver
    D. operating system
    D. Operating System
    (this multiple choice question has been scrambled)
  23. Restarting a computer while it's already running is called a __ boot.

    A. hard
    B. warm
    C. cold
    D. restart
    B. Warm
    (this multiple choice question has been scrambled)
  24. What is the most valuable asset of an organization?

    A. networks
    B. data
    C. employees
    D. computers
    C. Employees
    (this multiple choice question has been scrambled)
  25. All input and output devices require a __.

    A. device driver
    B. GUI
    C. system utility
    D. swap file
    A. Device Driver
    (this multiple choice question has been scrambled)
  26. A __ presents visual indicators or special graphical elements to communicate with the user.

    A. GUI
    B. device driver
    C. swap file
    D. system utility
    A. GUI
    (this multiple choice question has been scrambled)
  27. The .jpg filename extension designates a file as a __.

    A. Word document
    B. picture or image
    C. text file
    D. web page
    B. Picture or Image
    (this multiple choice question has been scrambled)
  28. The __ utility reorganizes data on a hard disk so that files are stored more efficently resulting in better and faster disk performance.

    A. defragmentation
    B. restore
    C. backup
    D. file manager
    A. Defragmentation
    (this multiple choice question has been scrambled)
  29. The backup utility __.

    A. manages the files and folders on a secondary storage device
    B. copies data from a computer's hard drive to a backup device
    C. reorganizes data on a hard disk to run more efficiently
    D. restores the original data to a hard drive
    B. Copies data from a computer's hard drive to a backup device
    (this multiple choice question has been scrambled)
  30. Virus software checks incoming files for known patterns, or __, of viruses.

    A. viral leaks
    B. watermarks
    C. autographs
    D. signatures
    D. Signatures
    (this multiple choice question has been scrambled)
  31. If the original data table data changes, __.

    A. you must reformat any associated PivotTables and PivotCharts
    B. any associated PivotTables and PivotCharts are deleted automatically
    C. you must refresh any associated PivotTables and PivotCharts
    D. any associated PivotTable and PivotCharts will update automatically
    C. You must refresh any associated PivotTables and PivotCharts
    (this multiple choice question has been scrambled)
  32. One of the guidelines for making a table more efficient is that the top row should contain the __.

    A. title
    B. table name
    C. field names
    D. record numbers
    C. Field Names
    (this multiple choice question has been scrambled)
  33. You can __ data created in another format of another application into Excel.

    A. export
    B. check
    C. import
    D. download
    C. Import
    (this multiple choice question has been scrambled)
  34. If the following represents one row from a comma-delimited text file, how many fields are in the row?

    A. 6
    B. 5
    C. 8
    D. 7
    A. 6
    (this multiple choice question has been scrambled)
  35. Conditional formatting can be used to highlight interesting cells or ranges of cells, emphasize unusual or duplicate values, or visualize data using data bars, color scales, or __.

    A. number filters
    B. color styles
    C. fill colors
    D. icon sets
    D. Icon Sets
    (this multiple choice question has been scrambled)
  36. To specify an OR condition in the criteria range for an advanced filter of a data table, you must __.

    A. enter the values in one row
    B. enter the values in separate rows
    C. click the filter drop-down arrow of each field used for criteria
    D. create a criteria range for each condition
    B. Enter the values in separate rows
    (this multiple choice question has been scrambled)
  37. A(n) __ is a word or string of characters denoting a cell, range of cells, or a constant value.

    A. range name
    B. criteria range
    C. attribute
    D. name box
    A. Range Name
    (this multiple choice question has been scrambled)
  38. Database functions are similar to __ functions, except that they are exclusively for database tables.

    A. logical
    B. information
    C. financial
    D. statistical
    D. Statistical
    (this multiple choice question has been scrambled)
  39. The PivotChart command displays the __ dialog box.

    A. Create PivotChart
    B. Create PivotTable
    C. Create Table
    D. Create PivotTable with PivotChart
    D. Create PivotTable with PivotChart
    (this multiple choice question has been scrambled)
  40. The PivotTable field list allows you to manipulate fields for the Report Filter area, Column Labels area, Row Labels area, and __ area for a PivotTable.

    A. Constants
    B. Values
    C. Content
    D. Data
    B. Values
    (this multiple choice question has been scrambled)
  41. Telecommuting typically reduces and employee's __.

    A. carbon footprint
    B. economic value
    C. productivity
    D. dioxide track
    A. Carbon footprint
    (this multiple choice question has been scrambled)
  42. Burning fossil fuels creates carbon dioxide (CO2), which helps to create the __ effect.

    a. ice age
    b cap emissions
    c. green house
    d. carbon
    C. Green House
  43. __ has gained acceptance as an acknowledged problem and will drive strategic and tactical decisions for many businesses for many decades.

    A. technology
    B. global warming
    C. social justice
    D. global cooling
    B. Global Warming
    (this multiple choice question has been scrambled)
  44. Green computing is a necessity because, among other things, it is the practice of maximizing energy efficiency which reduces __ and that translates into dollars saved.

    A. energy use
    B. reliability
    C. energy efficiency
    D. recyclability
    A. Energy Use
    (this multiple choice question has been scrambled)
  45. The EPEAT, or __, is an easy-to-use online tool that helps large institutions purchase, select, and compare computers based on their environment attributes.

    A. Environmental Protection Electronics Assessment Tool
    B. Economical Product Environmental Assessment Tool
    C. Electronic Product Environmental Assessment Tool
    D. Electronic Product Economical Assessment Tool
    C. Electronic Product Environmental Assessment Tool
    (this multiple choice question has been scrambled)
  46. What government body started EPEAT?

    A. DOE
    B. EPE
    C. DEA
    D. EPA
    D. EPA
    (this multiple choice question has been scrambled)
  47. __ is a voluntary labeling program that attempts to help consumers save money and protect the environment by identifying energy efficient products and practices.

    A. energy freedom
    B. efficiency star
    C. energy star
    D. maximum energy
    C. Energy Star
    (this multiple choice question has been scrambled)
  48. Intel claims it can dramatically increase the performance and efficiency of its micro-architecture by __ and using different transistor materials.

    A. using 3D transistor architecture
    B. increasing the number of transistors
    C. increasing transistor package size
    D. shrinking transistor size
    D. Shrinking transistor size
    (this multiple choice question has been scrambled)
  49. On what three PC modes does the Energy Star program ask computer makers to focus?

    A. Inactive Use, Off, Standby
    B. Active Use, Sleep, Standby
    C. High Use, Medium Use, Low Use
    D. Active Level, Mode Level, Standby
    B. Active Use, Sleep, Standby
    (this multiple choice question has been scrambled)
  50. You can reduce paper consumption by widening margins on documents, reducing font size, and __.

    A. changing ink cartridges regularly
    B. following corporate policy regarding when you should turn off your computer
    C. choosing a printer manufacturer that offers a recycling service
    D. printing on both sides of the paper
    D. Printing on both sides of the paper
    (this multiple choice question has been scrambled)
  51. Cell G12 contains the date 12/19/2008. Which of the following will return the date 1/19/2009?

    A. =G12+MONTH(1)
    B. =DATE (YEAR(G12)+1, MONTH(G12)+1, DAY(G12))
    C. =DATE(YEAR(G12), MONTH(G12)+1, DAY(G12))
    D. =MONTH(G12)+1
    C. =DATE(YEAR(G12), MONTH(G12)+1, DAY(G12))
    (this multiple choice question has been scrambled)
  52. The text to columns command is useful to __.

    A. substitute new text for old in a column
    B. combine text from 2 or more columns into one column
    C. separate text from one text string into 2 or more text strings
    D. convert column text to uppercase letters
    C. Separate text from one text string into 2 or more text strings
    (this multiple choice question has been scrambled)
  53. The concatenate function__.

    A. converts text strings to uppercase letters
    B. separate text from one text string into 2 or more text strings
    C. combines text from 2 or more text strings into one text string
    D. substitutes new text for old text in a text string
    C. Combines text from 2 or more text strings into one text string
    (this multiple choice question has been scrambled)
  54. If cell B12 contain "Duck", what value does =UPPER(B12) return?

    A. "Duck"
    B. "dUCK"
    C. "DUCK"
    D. "duck"
    C. "DUCK"
    (this multiple choice question has been scrambled)
  55. The substitue function __.

    A. separate text from one text string into 2 or more text strings
    B. substitutes new text for old text in a text string
    C. combines text from 2 or more text strings into one text string
    D. converts text strings to uppercase letters
    B. Substitutes new text for old text in a text string
    (this multiple choice question has been scrambled)
  56. What value does =AVERAGEIF(LastName, "Duck", Salary) return if there are 3 cells in the LastName column that contain "Duck" with accompanying salaries of 10000, 20000, and 60000.

    A. 90,000
    B. 3
    C. 30,000
    D. 20,000
    C. 30,000
    (this multiple choice question has been scrambled)
  57. If A20=20,000 then what value does =IF(A20<5000,A20*3%, IF(A20>10000,A20*7%,A20*5%)) return?

    A. 1,400
    B. 20,000
    C. 1,000
    D. 600
    A. 1,400
    (this multiple choice question has been scrambled)
  58. Which function returns a true value if all conditions are true and returns false if any of the conditions are false?

    A. OR
    B. AND
    C. NOT
    D. IFERROR
    B. AND
    (this multiple choice question has been scrambled)
  59. A(n) __ table determines payments for a loan.

    A. database
    B. pay
    C. logical
    D. amortization
    D. Amortization
    (this multiple choice question has been scrambled)
  60. As each month's beginning balance of a loan decreases, less of the payment goes toward the __ and more goes toward the principal.

    A. monthly payment
    B. interest
    C. principal
    D. ending balance
    B. Interest
    (this multiple choice question has been scrambled)

What would you like to do?

Home > Flashcards > Print Preview