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.