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]