Intro Computer Final Exam
Function
A computational procedure that performs a specific operation
the equals sign (=).
All formulas in Excel begin with
motion path
An animation effect in PowerPoint that is applied when an object moves on a slide.
transition
Visual effects for when a PowerPoint presentation moves from one slide to the next.
display resolution
The number of pixels (dots) displayed on a computer monitor.
Field Size
Use the _____ option box to limit the number of characters that are allowed in a field entry
True
Periods and commas go outside the parentheses, except for when the parenthetical sentence stands alone.
presentation graphics
PowerPoint can best be described as a ____ program.
wavy red
PowerPoint's spelling feature inserts a ____ line below words that are not contained in the Spelling dictionary or are not corrected by the AutoCorrect feature.
slide layout
Pre-built and customizable slide templates that contain placeholder boxes for slide objects, such as titles, graphics, or text.
Database
A ____ is a collection of data that has been organized so that the data can be easily stored, sorted, extracted, and reported
Bibliography
A _____________ is a complete list of the sources used in a document. This list typically contains more publication details than citations, such as the complete name of an article and the name of the journal in which it was published.
network
A _____________ is a group of computer systems that are interconnected in such a manner that they can share information with each other
placeholder
A box with a dotted line that is added to a slide or slide layout to mark where an object or text will go.
Move Chart
A chart can be placed in the same worksheet as the data or it can be inserted into its own sheet with options at this dialog box.
pie
A chart type that displays data values as parts of a whole by dividing a circle into proportional sections
file
A collection of data created on a computer that can be opened, modified, saved, and deleted.
theme
A coordinated group of color styles, effects, and fonts that are applied to a slide or page to give it a consistent and professional look
Cloud Storage
A data storage service provided by a hosting company that makes stored data available on any device via the Internet.
Record
A data structure composed of fields. For example, it could be created for each employee and could contain fields, such as employee first name, employee last name, job, salary, and hire date.in rows and columns. Each column contains attributes of the information being stored.
folder
A directory element that can contain one or more files.
active cell.
Excel's Spell Check feature begins checking at the
transitions
Fades, dissolves, and wipes are examples of
smiley face
Use emoticons sparingly. There is one emoticon typically accepted in business email etiquette, is the standard ____________.
Sparklines
Miniature charts that illustrate changes in a row or column of data and fit in a cell are called
file's extension
On Windows, the _________ determines which application will be used by default to open it.
References
One of the most important parts of writing academic papers is properly citing your sources. Word offers a variety of tools that assist you in managing your sources. The __________ tab includes options to insert footnotes, endnotes, citations, and a bibliography .
F1
One way to access Help resources in Excel is to point to a button on a tab and then press the ____ function key.
range
A _____ is a group of adjacent cells in an Excel worksheet.
row
A horizontal group of cells that is defined by a number.
blind carbon copy
BCC means:
charts.
Column, line, pie, bar, area, and scatter are types of Excel
Formula bar
This part of the Excel screen displays the contents of the active cell
APA
A formatting style defined by the American Psychological Association . This format defines structure and appearance requirements for writing academic papers, articles, books, etc.
MLA
A formatting style defined by the Modern Language Association . This format defines structure and appearance requirements for writing academic papers, articles, books, etc.
smart phone
A mobile device that combines cell phone and computer capabilities, such as the ability to browse the Internet.
animation
A movement effect that can be applied to slide objects in Microsoft PowerPoint.
slide show
A presentation option in PowerPoint that allows a presenter to display a presentation one slide at a time to an audience.
Table
A relational database object that stores information in rows and columns. Each column contains attributes of the information being stored.
Primary key
A relational database table column or set of columns that uniquely identify each row (record) in a table.
Flash Drive
A small, portable storage device that uses flash memory to store information.
Web browser
A software application that processes HTML web pages so that a user can interact with websites.
Report Wizard
A tool in Access that assists computer users with creating reports by guiding them through report design and build steps.
Word Art
A tool in Microsoft Word that adds various text effects, such as outlines, shadows, and colors
margin
A/An ___________is the amount of space between the text and the edge of a document
entrance animation
An animation effect in PowerPoint that is applied when the object first appears on a slide.
scroll bar
An element on the side or bottom of a window that is used to control which part of the window is currently in view.
library
At Coastal Pines you can visit the ____________ if you need additional Help Resetting your Email Password.
False
Before typing your name at the end of the email , sign off with something such as " Whatever"!
updates
Bug fixes and feature upgrades that are offered periodically from developers, which keep your systems and programs current.
Book1.xlsx
By default, Excel 2016 workbooks are saved with the ____ extension.
Navigation Pane
The object at the left side of the Access screen that displays the objects in the database organized into groups is the __________
carbon copy
CC means:
slide master
Customizable slide whose layout, formatting, and organization is automatically applied to each new slide created in a presentation
tables
In Word , _____________________ are used to assist in organizing the document with rows and columns.
workbook
Information created in Excel is saved in a file called a
student name and the course #
It helps the professor when a student always types in the subject line
True
Should your email should start by addressing the person you are talking to? For example : Hi Professor Thomas.
the largest value in the argument.
The MAX functions returns
Run Command
The _____ instructs Access to carry out the instructions and display the results.
File Explorer
The _______ application allows you to navigate the file system and manage files and folders, including those on optical disks and external drives. It also lets you manage files on the network and to access cloud storage such as Microsoft OneDrive.
Subject line
The ________ should be short and informative and always include your class number and name.
Internet of Things
The __________ refers to the network of physical devices that are connected to the Internet and capable of communicating and sharing data through sensors, network connectivity, barcodes, QR codes, and other technologies.
propertie
The ___________ of a document provide metadata—information that describes the document. This information includes document title, author name, subject, and keywords that identify the contents of the file.
status bar
The __________________ at the bottom of a Word document window shows basic information about the document, such as word count, current page number, and total pages
AutoSum
The ________________________________button is often the fastest way to add simple functions to your spreadsheet. The functions it provides are SUM, AVERAGE, COUNT NUMBERS, MAX, and MIN
Data Type
The classification of the type of data that can be stored in a database column.include including the classification of the type of data that can be stored in a database column. Common types including integer, date, and varchar.
Merge and Center
The easiest way to make a good-looking title for your cells is to use the_____________ commands where data can be aligned both vertically and horizontally in your cells.
select the range of cells containing the data to be charted.
The first step in creating an Excel chart is to
operating system
The main software program that controls computer processing, software application execution, and integration and operation of computer peripherals, devices, and hardware.
double spaced
The most commonly used academic style manuals (MLA, APA, and Chicago) require body paragraphs to be _______ with no additional spacing between paragraph.
Internet
The vast collection of networking hardware and physical computing devices . This is the largest network in the world.
Name Box
The____________shows the coordinates of the currently selected cell. You can select any cell in a worksheet by typing its coordinates into this box and pressing Enter. This is useful when you are working with extremely large worksheets.
Landscape
There are two types of page orientation. Documents can also be printed in ______orientation, in which the long edge of the paper is horizontal.
Portrait
There are two types of page orientation. Word's default page orientation setting is where the long edge of paper is vertical.
clear all formatting
This feature clears the formatting within the selected text, such as paragraph spacing, font color, underlining, bold, italics, and superscript
properties
This provides the metadata information that describes the document.
line
This type of Excel chart is used to depict trends and change over time intervals.
Settings
To change margins in your worksheet, click the margins gallery in the ____ category in the Print backstage area.
Images; INSERT
To insert a picture from a file, click the Pictures button in the ____ group on the ____ tab.
Design View
To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu
Text highlighting
What is selecting and Marking text to make it stand out from the text around it
correct spelling and punctuation
When a student is in the academic environment and at work , he\she should be sure to have ___________ and\or _______________.
all caps
When typing ____________ gives the impression the sender is shouting in the email.
watermark
You can use a _____________ in Word to indicate the documents status. This creates a faint background image added to a Word document .
False
You can use text words in your email to your professor and boss.
True
Your Full Email Address and a Password are used to gain access to any student computer on any site of Coastal Pines Technical College
printers
______ allow you to output physical documents and images from digital files on a computer. They can be connected using a USB port, a FireWire port, or a network connection.
Recycle Bin
_______ holds all deleted files, allowing you to restore them if you later decide that you shouldn't have deleted them.
ScreenTips
___________ are small windows that display explanatory text when the cursor hovers over a command
Footnotes
____________ are numbered citations or comments that appear at the bottom of the page. A superscript number will appear in the text whenever a it is added.
Netiquette
_____________ refers to rules of etiquette that should be observed while using computer networks, such as the Internet.
Templates
_______________ are ready-made documents that are designed for particular tasks and use professional-looking themes and styles.
Firewalls
_______________ control the flow of network traffic and protect systems from unauthorized network connections. They are configured with a set of rules that define what kind of traffic is allowed and what kind is not allowed.
Email etiquette
________________ is the principles and behavior of what one should use in academic and professional environments
Spam
____________________ is unwanted, unsolicited email that is sent to your email account.
Tone
__________________________one is the most misunderstood aspect of business emails.
Line spacing
____________is the vertical distance between lines of text in a paragraph. Single- and doublespacing are the most common settings
Trolls
___________are people who deliberately try to create conflict among users.