COSC 100 Final Exam: True/False
A PIN is a six-digit code that is used for signing in to a Windows 10 computer or device.
False
A bibliography is the best way to plan and organize a larger document.
False
A column heading is represented by numbers.
False
A computer performs three basic functions.
False
A microphone is an example of an output device.
False
A semicolon is used between two cell references to indicate a range of cells.
False
A thin, black border indicates that a cell is selected.
False
Advertising cookies track your online behavior and then are used to provide ads based on your browsing history.
False
An Access table is optimized for printing or onscreen viewing.
False
An active cell is outlined with a thick, blue border.
False
An alias must be enclosed inside number signs.
False
An organization's letterhead is formatted the same as the text in the body of the document.
False
AutoCorrect automatically corrects any grammar errors in your document.
False
Before paragraph formatting is applied to a single paragraph, the ENTIRE paragraph must be selected.
False
CPU speed is measured in calculations per nanosecond.
False
Cells can contain text values and number values, but NOT labels.
False
Citation options, which include Edit Citation and Edit Source, are accessed from the Citations and Bibliography group of the References tab.
False
Cloud-based protection checks your system for malware all of the time.
False
Criteria that contain text must be surrounded by number signs.
False
Each page of a Word document is called a slide.
False
Examples of URLs include .com, .gov, and .edu.
False
Files with the .docx extension appear in the Publish as PDF or XPS dialog box.
False
Flash Fill is the small green square in the lower right corner of an active cell.
False
Footnotes are compiled and placed on a separate page at the end of the document.
False
Footnotes in a document are NOT numbered.
False
For security purposes, password text characters entered into a password box are compressed.
False
Formulas are prewritten or preprogrammed into Excel.
False
Function AutoSum suggests values as you type a function.
False
Gestures are used to interact with a computer via a touchpad.
False
HomeNetwork is what Windows uses to help you connect to other devices on your network.
False
If an item is quarantined, then it has a virus and it must be deleted as soon as possible.
False
If totals are calculated for each month, the Count operator has been selected in the Totals row of the query design grid.
False
If you want to calculate summary statistics, you need to add the Statistics row to the query design grid.
False
In Microsoft Edge, the Favorites button has a sunshine on it.
False
In a document, flagged errors are identified by red and green exclamation points.
False
In an Access database, a report is used to find, update, and add table records.
False
In an Access database, data is stored in queries.
False
In query Design view, the query design workspace shows the fields that will be displayed when the query runs.
False
In reports, lists are typically indented 0.25 inch.
False
InPrivate browsing is a feature used to open multiple web pages in one browser window.
False
Internet Explorer allows you to create web notes.
False
Internet Explorer is the default web browser in Windows 10.
False
Normal view shows how a worksheet will look when it is printed.
False
Null is synonymous with a value of zero.
False
On a computer with a touch screen, touching the device screen once with your finger is known as tagging.
False
On the desktop, the taskbar is located at the top of the screen.
False
Once you turn on your computer, control is given to the application software.
False
Only consecutive numbers can be used for the items in a numbered list.
False
PowerPoint slides are divided into cells.
False
Preferred sites are stored web addresses that you can click on and navigate to quickly.
False
Preview Mode requires you to click the Enable Editing button before you can begin working.
False
Print view is a website view that only includes text.
False
Publisher is an example of a database management system.
False
Queries can only be exported as Excel worksheets.
False
Query Design view has three panes.
False
RAM is used for storing data permanently.
False
Running disk cleanup on your computer allows for better storage and file retrieval.
False
Software included with Microsoft Windows that is used to protect your system from viruses and malicious software is called Microsoft Guardian.
False
Styling refers to specifying the appearance of cells or the layout of a worksheet.
False
Text can be deselected by pressing Esc.
False
The Add Tables dialog box is how tables are added to the query design workspace.
False
The Backspace key is an example of a keyboard shortcut.
False
The Delete key deletes one letter at a time moving from right to left.
False
The Excel function, =SUM(B3:B7), will total the values in cells B4, B5, and B6.
False
The Format Painter button behaves NO differently on being single-clicked versus double-clicked.
False
The Garbage Can is an area on your hard drive that stores files you no longer need.
False
The Search box is located on the Start menu.
False
The command bar in Microsoft Edge contains the hyperlinks to the main pages of a site.
False
The default printer is indicated by a green square.
False
The document header can be made active by single-clicking in the header area.
False
The first line indent of 0.5 inch CANNOT be changed by the user.
False
The image that displays on the desktop is the custom screen image.
False
The insertion point is indicated by a solid, horizontal line.
False
The main benefit of cloud computing is that it is free.
False
The option for centering text is in the Font group of the Home tab.
False
The option for selecting source type appears in the Source Manager dialog box.
False
The page is wider than it is tall in Portrait Orientation.
False
The result of typing a name, pressing the Enter key twice, and typing the date is the name on one line, the date on one line, and two blank lines in between.
False
The sign-in screen is the screen that displays shortly after a computer that is running Windows 10 is turned on.
False
The style guide for a report does NOT address line spacing and paragraph spacing.
False
The words or phrases that automatically appear in a search box are smart screen Filters.
False
There are five family account features.
False
This PC is used to access other computers on your network.
False
To update data in a linked table, open it in the Access database where it is linked.
False
USB flash drives use optical laser technology to read and write data to it.
False
Using c*t in the Criteria row would match coat, coated, and coating.
False
Using c?t in the Criteria row would match cat, cot, cut, and coat.
False
Web archives are also called AHTML.
False
When a new workbook is created from a template, any changes made to the workbook will overwrite any formatting in the template.
False
When purchasing a computer, you may want to select one that has multiple RAM and GPU ports for attaching additional storage devices.
False
When select queries are run, they change the data in the underlying table.
False
When the first page of a document is displayed and a header is inserted, the header appears ONLY on the first page.
False
When you save a document, it is saved permanently in the computer's RAM.
False
When you select text, contextual tabs appear.
False
When you set a print area, the range of selected cells is named Selected_Area.
False
Worksheet is synonymous with workbook.
False
You are NOT able to add new words to the Office dictionary.
False
You can use Print Preview to see what the results of a formatting change will be if you select it.
False
Your personal preferences for Cortana are stored in a OneNote notebook.
False
A cell address is the same as a cell reference.
True
A collection of networks that are connected throughout the world is called the Internet.
True
A computer is a system that has four basic functions: input, processing, output, and storage.
True
A crosstab query can be used if you want to calculate statistics and group the results by two sets of data.
True
A field that obtains its values from other fields is a calculated field.
True
A file or group of files reduced into a single file is called a compressed folder.
True
A file system is how files can be saved and retrieved in an organized manner.
True
A forward slash and an asterisk are examples of arithmetic operators.
True
A hyperlink can be attached to text or graphics.
True
A menu of commands that match the characters you type is called AutoComplete.
True
A miniature window of an open app, file, or folder is called a thumbnail.
True
A numbered list would be appropriate for presenting the steps for opening a document in Word.
True
A page break on a worksheet is indicated by a dotted line.
True
A peer-to-peer network is used for businesses or homes with no more than five computers.
True
A prebuilt set of cohesive formatting choices including colors and fonts is called a theme.
True
A program downloaded or purchased through the computer's or device's store is generally referred to as an app.
True
A query is synonymous with question.
True
A select query selects and displays records that answer a specific question.
True
A single paragraph can be selected by triple-clicking in the paragraph.
True
A site map is synonymous with site index.
True
A solid-state drive used electricity to retain data even when the computer is turned off.
True
A web browser is the program needed to browse the Internet.
True
An advantage of publishing a Word document as a PDF document is that users who do not have Word can open and read the PDF document.
True
An example of a domain name is www.microsoft.com.
True
An expression is a combination of fields, mathematical operators, and prebuilt functions used to calculates values.
True
Any condition in a query that is used to select the desired records is the criteria.
True
Any content entered in the fields in the Create Source dialog box is automatically altered and punctuated on the basis of the source type and style selected.
True
Because cell styles are prebuilt sets of formatting, Excel makes it easy to format cells.
True
Before the Format Painter button is clicked, the insertion point needs to be on the text formatted with the settings that are to be applied to other text in the document.
True
Before you install new software, you should make sure that you can trust the manufacturer.
True
Bluetooth devices use wireless technology and radio waves to connect devices.
True
Calculated fields need to have an alias.
True
Characters that have the same shape and design are called a font.
True
Chicago Sixteenth Edition is a citation style you can choose.
True
Clicking the File tab will take you to Backstage view.
True
Comparison operators are used to compare two values.
True
Consistency is one advantage of using a style provided by Word, as opposed to applying individual formatting to multiple sections of text.
True
Data such as name or address that you have typed into text boxes while browsing the web is called form data.
True
Data that is shown in a cell is the displayed value.
True
Dialog boxes often contain content not on the Ribbon.
True
Different theme options are stored as thumbnails in a gallery.
True
Document properties are saved as part of the Excel file.
True
Files that are shared without the read privilege will prevent anyone from viewing the document at all.
True
Flash Fill can be used to help format and clean data imported from a database.
True
Folder windows are displayed in the File Explorer.
True
For consistency, the same themes are available in Word, Excel, PowerPoint, and Access.
True
Google is an example of a search provider.
True
Icons are synonymous with buttons.
True
If you are performing a File Explorer search and do not know the file name, you can use a keyword to help identify the file.
True
If you select a word, the Mini toolbar will appear.
True
Images can be inserted from files or online resources.
True
In Excel, cells can contain text, formulas, and functions.
True
In expressions, field names must be enclosed in square brackets.
True
In query Design view, the query design grid shows the tables that will be used in the query.
True
In some cases, the message indicating completion of the Spelling and Grammar check does not appear, and typing errors might still exist in the document.
True
In the cell reference A1, the number 1 indicates the row heading.
True
IntelliSense displays guidelines for the feature you are typing.
True
It is a good idea to run the Spelling and Grammar checker after all text in a document is typed.
True
Maps is an example of a Windows 10 Store app.
True
Most routers that are used in a home environment combine a router and a switch.
True
Most style manuals call for footnote text to be the same size as document text.
True
Office gives you the ability to share documents, spreadsheets, and presentations.
True
One inch is the usual setting for top, bottom, and side margins in a short, informal report.
True
OneDrive is free storage space in the cloud.
True
Paste options are displayed by clicking the Paste arrow.
True
Phishing websites are dishonest websites that look like legitimate websites.
True
Placeholders do not print unless they contain text or objects.
True
Plugins that add extra features or custom commands to Office programs are called Office Add-ins.
True
Queries in Access can be exported as a web page.
True
Query is synonymous with question.
True
Regarding flagged errors, use of the passive voice is identified as a grammar error.
True
Scripts and active content are programs downloaded with a web page that provide additional functionality.
True
Shortcuts are links to specific files, folders, or applications.
True
Signing in to your Microsoft account allows you to access resources such as the Microsoft Cloud.
True
SmartScreen filter can help protect you from online threats.
True
Speech recognition software converts text spoken into a microphone to typed text or computer commands.
True
Text formatting helps organize a document visually without detracting from the meaning.
True
The Avg operator is used to find the average of the values in a group.
True
The Between...And operator can be used to find all numbers or dates between and including two values.
True
The Cloud is an Internet technology.
True
The Format Painter uses the Clipboard to temporarily hold the group of formatting settings being applying to sections of the document.
True
The Name Box is located to the left of the formula bar.
True
The Office Clipboard is a temporary storage area.
True
The Quick Info message explains the purpose of the selected AutoComplete command.
True
The Snipping Tool is the application that creates screen shots called snips.
True
The Source Manager provides the references in the Citation and Bibliography galleries.
True
The Sum operator is used to find the total of the values in a group.
True
The World Wide Web is a collection linked pages that can be viewed from any Internet-enabled device.
True
The formatting marks in a document NEVER print.
True
The formula that displays in the formula bar is the underlying formula.
True
The information that your browser stores as you browse the web is called browsing history.
True
The operating system on a computer serves as a gateway between its hardware and the application software.
True
The position of a first-line indent is indicated by a marker on the ruler.
True
The purpose of the Widow/Orphan control and "Keep with next" paragraph setting is to prevent a heading and the paragraph that follows from becoming separated across two pages.
True
The removal of a program will also remove all related files regardless of where they are stored.
True
The results of a search executed in the Search document box of the Navigation pane can be accessed by clicking the Results command in the Navigation pane.
True
The sign-in screen is the screen that is used when logging into a computer.
True
The size of the text in a footnote can be changed by the user.
True
The spacing between letter elements in a document is specified by style rules.
True
The style guidelines for a report should be consulted before a bullet character or number format is selected for a list.
True
To change the font color to green is an example of changing the format.
True
To fit the size of printed worksheets on a specific number of pages, change the scaling.
True
To reduce a window's size to what it was previously, click the Restore button.
True
To scan the areas on your computer that are most likely to be affected by viruses and malicious software, select a quick scan.
True
To use Office 365, you must pay a monthly licensing fee.
True
To use Windows 10 you need to sign in with a Microsoft account.
True
To view notifications, updates, and system information, visit the Action Center.
True
Using R#D# in the Criteria row would match R2D2, but not RaDg.
True
When a formula is copied to another cell, Excel creates relative cell references in the copied formulas.
True
When a word is selected by double-clicking it and clicking Delete, both the word and the space after it are deleted.
True
When information from another source is quoted or referred to, that source needs to be credited.
True
When printing a worksheet, by default, the gridlines do NOT print.
True
When the Modify Style dialog box is used to modify a style, the formatting changes are made to all of the text that has the style applied.
True
When using the And logical operator, all of the values need to be true to return an outcome of true.
True
When using the Or logical operator, only one of the values needs to be true to return an outcome of true.
True
When zipped files are extracted, the files are kept in the zipped folder and also display in a new, unzipped folder.
True
WhiteHouse.gov is an example of a top-level domain.
True
Windows Update displays information about recent system updates, check for new updates, and view what was recently downloaded or installed.
True
Word provides built-in headers and footers, but also allows them to be customized.
True
Word wrap occurs automatically if a word does not fit on a line.
True
You can interact with a computer that has a touch screen through a series of gestures.
True
You can select a printer to use from the printer list.
True
You can turn off the Word AutoCorrect option to create lists automatically.
True
You can use the Format Painter to copy formatting from text or an object to another.
True
You can use the thesaurus to search for and replace a word with a different word.
True
You need to set a permission level when you share a document.
True
You should always check spelling after you have completed editing and formatting your worksheet.
True
You should always delete your browsing history when working on a public computer.
True
Your computer must be connected to the Internet in order to access files located in the cloud.
True
