CGS1060 Final Exam - Module Exams
[EXCEL] In excel, a worksheet is contained in a file called a _____. a - workbook b - workpad c - notebook d - datapad
Workbook.
[EXCEL] In excel, the electronic spreadsheet you work in is called a _____. a - tablet b - databook c - numericsheet d - worksheet
Worksheet.
[COMPUTER CONCEPTS] Which optical drive provides the most storage capacity on a single disc? a - hard drive b - DVD c - CD d - Blu-Ray
Blu-Ray.
[COMPUTER CONCEPTS] A series of eight bits is called a _____. a - bide b - bint c - bita d - byte
Byte.
[COMPUTER CONCEPTS] ______ are simple drawings that are included as collections with many software packages. a - standard art b - windows art c - sample art d - clip art
Clip art.
[WINDOWS 7] You move a file using which commands? a - copy and paste b - cut and paste c - delete d - none of the above
Cut and paste.
[WINDOWS 7] The _____ is the shaded area behind your desktop objects. a - notification area b - task bar c - window d - desktop background
Desktop background.
[WINDOWS 7] After Windows 7 starts up, you see the Windows 7 _____. a - icon b - logo c - folder d - desktop
Desktop.
[ACCESS] This section prints once for every record. a - group header b - group footer c - report header d - detail
Detail.
[WINDOWS 7] Which of the following send to menu commands copies the file to the documents library? a - desktop (create shortcut) b - mail recipient c - documents d - DVD RW Drive (D:)
Documents.
[WORD] Which Word view allows you to see a simplified layout of a document, without margins, headers and footers, or graphics? a - print layout view b - web layout view c - outline view d - draft view
Draft view.
[WINDOWS 7] A(n) _____ is a container that helps you organize your files. a - window b - file c - taskbar d - folder
Folder.
[ACCESS] Use this form creation tool to create a form from scratch in Form Design View. a - form b - blank form c - form design d - form wizard
Form design.
[ACCESS] This access object provides an easy-to-use data entry screen. a - macro b - form c - table d - module
Form.
[WINDOWS 7] _____ are optional programs that present helpful or entertaining information on your desktop. a - icons b - dialog boxes c - gadgets d - taskbars
Gadgets.
[ACCESS] Which two sections can be added to a report if you group records? a - group header and group footer b - group header and detail c - group footer and detail d - group summary and detail
Group header and group footer.
[WINDOWS 7] A ______ is a box that lets you select an option from a list of options. a - text box b - spin box c - check box d - list box
List box.
[WINDOWS 7] If your computer is set up for more than one user, you might need to to ____, or select your user account name when the computer starts. a - restart b - log in c - log out d - shut down
Log in.
[COMPUTER CONCEPTS] Any device connected to a network is called a _____. a - byte b - bone c - bit d - node
Node.
[WINDOWS 7] The _____ at the right side of the task bar contains icons that represent informational programs you might find useful. a - recycle bin b - desktop c - notification area d - desktop background
Notification area.
[COMPUTER CONCEPTS] SDRAM is plenty fast for the average computer and is synchronized with the processor to allow faster access to its contents. a - true b - false
True.
[EXCEL] A cell reference that does not change when it is copied is called a relative cell reference. a - true b - false
True.
[EXCEL] The paste option from the excel home tab allows the user to specify components of a cell's contents to be pasted. a - true b - false
True.
[EXCEL] Using the fill handle to copy formulas prevents the excel user from having to retype formulas in adjacent cells. a - true b - false
True.
[EXCEL] You can a print a chart by itself or as part of the worksheet. a - true b - false
True.
[EXCEL] You can resize a chart to improve its appearance by dragging its SIZING HANDLES. a - true b - false
True.
[EXCEL] You can use buttons on the insert tab of the ribbon to create and modify a chart. a - true b - false
True.
[EXCEL] You use formulas in Excel to perform calculations such as adding, multiplying, and averaging. a - true b - false
True.
[POWERPOINT] If you embed your fonts, you will not have to worry about the availability of those fonts on other computers. a - true b - false
True.
[WINDOWS 7] A file hierarchy is a system that arranges files and folders in different levels, like the branches of a family tree. a - true b - false
True.
[WINDOWS 7] A(n) PASSWORD allows you to enter and use the files in your user account area. a - true b - false
True.
[WINDOWS 7] Command buttons let you issue instructions to modify objects. a - true b - false
True.
[WINDOWS 7] Windows 7 lets you create a(n) HOMEGROUP, a names set of computers that can share information. a - true b - false
True.
[WORD] Before deleting, editing, or formatting text, you must select the text. a - true b - false
True.
[COMPUTER CONCEPTS] _____ is space on the computer's storage devices that stimulates RAM. a - virtual memory b - cyber memory c - CPU cache d - none of the above
Virtual memory.
[WORD] Each time you create a new source in Word's citation tool, the source information is saved on your computer so that it is available for use in any document. a - true b - false
True.
[WORD] Highlighting is transparent color that is applied to text using the Highlight pointer. a - true b - false
True.
[EXCEL] The default accounting number format adds dollar signs and _____ decimal places to the data. a - one b - two c - three d - four
Two.
[WINDOWS 7] A(n) ______ is a small, portable storage device. a - RAM b - USB flash drive c - hard drive d - none of the above
USB flash drive.
[ACCESS] The group header and group footer section can be turned on or off in which pane? a - properties b - field list c - toolbox d - group, sort, and total
...
[ACCESS] Which report view's primary purpose is to quickly review the first page of the report? a - print preview b - layout c - design view d - report view
...
[WORD] Files created in Word 2010 are automatically assigned the ______ file extension to distinguish them from files created in other software programs. a - .doc b - .xls c - .rtf d - .docx
.docx
[WORD] What is the default margin given to the top, right, left, and right sides of a document created in word? a - 1/2" b - 3/4" c - 1" d - 1 1/4"
1"
[WORD] Which of the following is not one of the functions of word processing software such as Microsoft Word? a - tools for entering, editing, and formatting text. b - tools for adding graphics to documents c - ability to enter and edit formulas in cells d - use Mail Merge to create letters and mailings
Ability to enter and edit formulas in cells.
[WINDOWS 7] Which of the following is a storage device? a - hard drive b - CD c - DVD d - all of the above
All of the above.
[WORD] The office clipboard allows you to collect text and graphics from which other office application listed below before inserting them into your Word documents? a - excel b - access c - PowerPoint d - all of the above
All of the above.
[WORD] Which of the following is a type of clip that is stored in Word's clip organizer? a - graphics b - sounds c - animations d - all of the above
All of the above.
[COMPUTER CONCEPTS] _____ are developed for people with physical impairments or disabilities to use computers. a - assistive devices b - creative input devices c - software programs d - none of the above
Assistive devices.
[ACCESS] A FOREIGN key field is always on the "one side" of a one-to-many relationship between two tables. a - true b - false
False.
[ACCESS] The easiest way to filter the records for an exact match it to use the Filter by Form feature. a - true b - false
False.
[ACCESS] To filter for comparative data and to specify more complex criteria, use the filter by selection feature. a - true b - false
False.
[COMPUTER CONCEPTS] A Network Programming Card (NPC) is necessary to be installed in each computer that is part of a network. a - true b - false
False.
[COMPUTER CONCEPTS] Document production software is typically used as a numerical analysis tool. a - true b - false
False.
[COMPUTER CONCEPTS] In data communications, the computer that originates the message is the channel messenger. a - true b - false
False.
[COMPUTER CONCEPTS] Inkjet printers transfer ink to the paper by striking a ribbon with pins. a - true b - false
False.
[COMPUTER CONCEPTS] Programming languages are not considered a part of the system software. a - true b - false
False.
[COMPUTER CONCEPTS] The first standard optical storage device available for personal computers was the CD (compact disc), which can now hold 700 MB of data.
False.
[COMPUTER CONCEPTS] Wireless input devices take input such as your fingerprints and authenticate your use of a system. a - true b - false
False.
[EXCEL] A chart must be located in a specific cell or at a specific address range. a - true b - false
False.
[EXCEL] An excel workbook has the file extension .xml. a - true b - false
False.
[EXCEL] Following the order of precedence, a formula calculations addition first, then multiplication. a - true b - false
False.
[EXCEL] SUB gridlines show the values between the tick marks. a - true b - false
False.
[EXCEL] The COUNT function in excel returns the number of all cells in a range that contain any type of data. a - true b - false
False.
[EXCEL] The font is measured in units called PIXELS. a - true b - false
False.
[EXCEL] The increase decimal button automatically adds dollar signs and two decimal places to you data. a - true b - false
False.
[EXCEL] To add a clip to a worksheet, click clip art in the illustrations group on the HOME tab. a - true b - false
False.
[EXCEL] You must apply borders to all cells in a worksheet; you cannot apply them to only selected cells. a - true b - false
False.
[WINDOWS 7] If a window is already maximized, the maximize button changes to the MINIMIZE button. a - true b - false
False.
[WINDOWS 7] RAM is a permanent storage location. a - true b - false
False.
[WORD] By default, tab stops occur every 1/4" in a document. a - true b - false
False.
[WORD] One way to copy text to another location in a document is by pressing [shift] as you drag the selected text from one location to another. a - true b - false
False.
[WORD] Page numbers placed on a page in a document are permanent, meaning that once they have been added, they cannot be removed. a - true b - false
False.
[WORD] The scroll through option under the editing group in word's home tab can be used to navigate to a particular location in a document. a - true b - false
False.
[WORD] There are two main categories of fonts: scripted and printable. a - true b - false
False.
[WORD] To store a document permanently so you can open it and edit it in the future, you must save it as an XML file. a - true b - false
False.
[WORD] When searching and replacing text within Word, to find, review, and replace each occurrence individually, click _____. a - highlight all b - show all c - find next d - replace all
Find next.
[ACCESS] This button helps search for data in a single field or in all fields. a - find b - sort ascending c - filter by string d - filter by criteria
Find.
[COMPUTER CONCEPTS] Monitor _____ is the diagonal measurement from one corner of the screen to the other. a - screen size b - resolution c - dot pitch d - width
Screen size.
[ACCESS] Which data type stored Web addresses? a - lookup wizard b - hyperlink c - www address d - HTML
Hyperlink.
[WORD] The _____ indent button will move selected text away from the left margin in a word document. a - decrease b - increase c - left d - hanging
Increase.
[ACCESS] A join line is also called a _____ line. a - query b - link c - connection d - objectivity
Link.
[COMPUTER CONCEPTS] _____ are small computers that fit in the palm of your hand. a - PDAs b - laptop computers c - desktop computers d - mainframes
PDAs.
[COMPUTER CONCEPTS] An external peripheral device must have a corresponding _____ that connects it back to the computer. a - input and output b - disk and cable c - port and disk d - port and cable
Port and cable.
[WORD] Document ___________ are user-defined details about a file that describe its contents and origin, including the name of the author, the title of the document, and keywords that you can assign to help organize and search your files. a - inspections b - searches c - properties d - iotas
Properties.
[ACCESS] The wildcard character that stands for any single character is the _____. a - ampersand (&) b - question mark (?) c - exclamation mark (!) d - Caret (^)
Question mark &
[WINDOWS 7] Windows 7 places folders and files you delete from your hard drive in the _____. a - trash can b - recycle bin c - RAM d - none of the above
Recycle bin.
[WORD] You insert and manage footnotes and endnotes using the tools in the footnotes group on the _____ tab. a - file b - references c - view d - insert
References.
[COMPUTER CONCEPTS] _____ describes the technical details about each component of a computer system. a - architecture b - specifications c - configuration d - data
Specifications.
[EXCEL] An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data. a - database b - spreadsheet c - dataform d - project
Spreadsheet.
[COMPUTER CONCEPTS] _____ refers to the practice of sending e-mails to customers or potential customers of a legitimate Web site asking them to click a link in the e-mail that goes to a spoofed site. a - pharming b - firewalling c - phishing d - stealing
Stealing.
[ACCESS] Which type of control would you most likely use to display name information? a - text box b - label c - combo box d - list box
Text box.
[ACCESS] "Focus" refers to which data you would edit if you started typing. a - true b - false
True.
[ACCESS] It would make sense to set the tab stop property of a text box that will not be used for data entry to no. a - true b - false
True.
[ACCESS] On a form, text box controls display data from an underlying record source. a - true b - false
True.
[ACCESS] Tables contain all of the data in the database. a - true b - false
True.
[ACCESS] When using a wizard, you can click the back button to review previous dialog boxes. a - true b - false
True.
[ACCESS] You can resize form sections in form design view. a - true b - false
True.
[COMPUTER CONCEPTS] A strong password is defined as a password of at least eight characters of upper and lowercase letters and numbers. a - true b - false
True.
[WORD] Which key click combination can be pressed to create a manual page break in your document in word? a - [enter] b - [alt][enter] c - [shift][enter] d - [ctrl][enter]
[Ctrl][Enter]
[WINDOWS 7] To select a group of items that are next to each other, click the first item in the group, press and hold _____, then click the last item in the group. a - [shift] b - [ctrl] c - either a or b d - neither a nor b
[Shift]
