Microsoft Office Applications

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

content control

An interactive object you can add to customize documents; may contains instructions for filling in text and graphics

destination document

The document to which items are being pasted.

.docx

The file extension for Microsoft Word 2016, 2013, 2010, and 2007 files.

logical test

The first part of an IF function; if the logical test is true, then the second part of the function is applied; if it is false, then the third part of the function is applied.

fill

The formatting of the interior of a shape or slide background, such as color, picture, texture, or pattern.

transparency

The opacity of an object, such as a fill pattern that lets you see through the object so that any text behind it is visible.

nameplate/banner

The portion of a newsletter that contains the title of the newsletter and usually an issue information line; also called a banner.

issue information line

The portion of a newsletter that identifies the specific publication

.dot

is a file in Microsoft word template that is used to store the default settings such as font, font size, content of a file, etc.

line break

is a poetic device that is used at the end of a line, and the beginning of the next line.

NOW function

In Excel, a function that returns a number that corresponds to the system date and time, beginning with December 31, 1899.

font set

A format that lets you define one font for headings and another for body text.

filtered Web Page format

A format that saves a file in webpage format and then reduces the file size by removing specific Microsoft Office formats.

web page format

A format that saves certain webpage components in a folder, separate from the webpage.

Adobe Reader

A free Adobe application that lets you view, navigate, and print PDF files.

nested IF function

A function in which the action to be taken for the true or false case includes another IF function.

volatile function

A function that automatically recalculates its values every time Excel does any calculation in the workbook

gradient

A gradual progression of colors and shades, usually from one color to another color or from one shade to another shade of the same color.

subhead

A heading that is subordinate to a higher level heading.

ruling line

A line that separates areas of a newsletter.

snaking columns

A multiple-column report that prints with the "down, then across" layout, with the first label printed in the upper-left corner on the first page, the second label printed to its right, the third label printed below the first label, and so on; also called newspaper-style columns

category names

A range that identifies the major groups for a chart.

building block

A ready-made graphic or text element you can insert in a document, such as a cover page, design accent, or header.

Horizontal rule

A ruler that appears below the ribbon in the document window in Print Layout, Draft, and Web Layout view

HTML

A special language that software developers use to create and format webpage elements; stands for Hypertext Markup Language

handout master

A template element that designates the placement of text, such as page numbers, on a sheet of paper intended for distribution to audience members.

Office Clipboard

A temporary storage area in the computer's memory that lets you collect text and objects from a file created by a Microsoft Office app, and then paste the text or objects into files created by any Microsoft Office app; can hold a maximum of 24 items.

pull-quote

A text box that contains a quote or an excerpt from an article, given graphical emphasis, and placed on the same page; also called a pullout.

justified

A type of alignment in which the first and last characters of each line are aligned and extra space is inserted between words to evenly spread the words across the line.

Vertical rule

A vertical line that separates areas of a newsletter.

What-if analysis

A way to explore the impact that changing input values has on calculated values and output values

sparkline chart

provides a simple way to show trends and variations in a range of data within a single cell.

newsletter

A (usually) double-sided multipage publication with newspaper features, such as columns and a masthead, and the added eye appeal of sidebars, pictures, and other graphics

texture fill

A background fill that uses a specific file or an image that simulates a material, such as cork, granite, marble, or canvas; also called a picture fill.

mixed cell reference

A cell reference that changes when the formula containing that reference is moved to a new location

assumptions

A cell value that you can change to determine a new value for formulas.

hide slide

A command that hides a slide from the audience during the running of a slide show

column break

A command that places the insertion point at the top of the next column.

Mark as Final

A command that saves a presentation as a read-only document.

SmartArt graphics

A diagram that shows information or ideas visually using a combination of shapes and text.

source document

A document from which items are being copied; also, the documents that are used when combining or comparing documents.

resume

A document that contains an applicant's personal information, educational background, and job experience.

Document Inspector

A feature that examines a file for hidden properties, personal information, and comments.

.mht

A file extension associated with the HTML format that allows webpages to be saved in a single file and opened in a browser.

single file web page format

A file format that saves all webpage components in a single MHTML file that has a .mht extension.

template

A file with a theme applied and that may contain formatted placeholder text, headers and footers, and graphics that you replace with your own information for hundreds of purposes, including budgets, flyers, and resumes; template files have slightly different file extensions than standard application files, such as .xltx, .pptx., or .dotx.

gradient fill

A fill that consists of one-color shade gradually progressing to another shade of the same color or one-color progressing to another color.

When using spreadsheet software, explain the importance of using cell references in a formula.

Cell references allow you to change a value in multiple formulas by changing the value in a single cell.

gradient stop

Color tops are stopping points in a gradient that show a specific color at the exact location we set.

Describe Microsoft Word's template feature.

Contains formatted placeholder text in content controls, header and footers, and Graphics which you can replace with your own information.

What elements could be included about an individual within a resume?

Contains personal information, educational background, and job experience.

data series

Data from a column or row in a sheet; the set of values represented in a chart.

WordArt

Formatted, decorative text in a text box or other shape, created using WordArt tools.

IF function

In Excel, a function that assigns a value to a cell based on a logical test.

format symbols

In Excel, a symbol that assigns a format to numbers as they are entered.

Gridlines

In Excel, horizontal and vertical lines in a worksheet or chart that make it easier to read. In PowerPoint, evenly spaced horizontal and vertical lines on the slide that help you align objects. In a table, nonprinting lines that show cell boundaries.

rehearsal feature

In PowerPoint, a feature that lets you advance through slides at your own pace, and the amount of time you view each slide is recorded.

offset

In PowerPoint, a feature that lets you move the background away from the slide borders in varying distances by percentage.

tiling option

In PowerPoint, a feature that repeats the background image many times vertically and horizontally on the slide; the smaller the tiling percentage, the greater the number of times the image is repeated.

notes master

In PowerPoint, a layout template that defines the formatting for speaker's notes.

variant

In PowerPoint, a slight modification of a theme, usually with different colors for the slide background, objects, and text.

rehearsal toolbar

In PowerPoint, a toolbar that contains buttons allowing you to start, pause, and repeat viewing the slides in the slide show and to view the times for each slide as well as the elapsed time.

drop cap

In Publisher and Word, a decorative, large initial capital letter that extends down below the other letters in the line.

text box

In Publisher, a publication object designed to hold text in a specific shape, size, and style. In Access, the most common type of control used to display field values, also, a form element in which you enter text.

placeholder text

In Publisher, prewritten template text that you select and replace to customize a publication. In Word, default text that indicates where text can be typed in documents.

navigating

In Windows, to find a location on a storage device, such as from one file or folder to another.

sections

In Word, a part of a document that can have its own page orientation, margins, headers, footers, and so on. In other words, each section is like a document within a document.

relative cell reference

In a formula, a cell address that automatically changes to reflect the new location when the formula is copied or moved; the default type of referencing used in Excel worksheets; also called a relative reference.

absolute cell reference

In a formula, a cell address that refers to a specific cell and does not change when you copy the formula.

.odt

Is a OpenDocument Text Document file. The files are most often created by the free OpenOffice writer word processor program. Is similar to DOCX file.

What is a newsletter?

Is a mini newspaper, information about any upcoming dates and events.

What is the purpose behind creating a resume?

Is to present you in a good why on why you are the best candidate for the job. To also sent out to employers too.

In what ways, can a large worksheet be manipulated better?

One of the commands is that you can freeze rows and columns so that they remain visible even when you scroll. You can split the worksheet into separate panes so you can view different parts of the worksheet on the screen once. To see the magnification to allow you to see more content, at a smaller size.

Watermark

Semitransparent text or a graphic that appears behind or in front of existing text on the printed pages of a document, spreadsheet, or publication.

PDF

Short for Portable Document Format, a file format developed by Adobe Systems that is the standard format for exchanging documents; lets users view a file using the free Adobe Reader software, without needing to have the program or computer platform that created it.

.rtf

Stands for Rich Text Format. It's a file format standardized by Microsoft for creating formatted text files. Include information such as text style, size, and color.

What groups of individuals might newsletters generally be created for?

Subscribers, employees, customers, patrons, students, etc.

What are the advantages of using templates to create new presentations?

Templates can speed up and simplify the process of creating a presentation. That a template contains text formats, themes, placeholder text, headers, footers, and graphics.

accessibility

The practice of removing barriers that may prevent individuals with disabilities from interacting with data or an app. In relation to digital content, term used to refer to content that is adaptable or available to users who require assistance.

What purpose do slide masters serve within Microsoft PowerPoint?

The slide master is a template that create all five slides in a presentation.

slide master

The template for the slides in a presentation that contains theme elements and styles, text formatting, the slide background, and other objects that appear on all the slides in the presentation.

Explain the advantages paired with using desktop publishing software.

There are more design features in desktop publishing software.

Why are cell references also called assumptions?

To answer what if questions, during a problem or statement.

crop

To trim away part of a picture

Content control

an interactive object you can add to customize documents; may contains instructions for filling in text and graphics.

XPS

a file format created by Microsoft that shows all elements of a printed document as a electronic image and enables file sharing, short for XML Paper Specification.

Multilevel list

a list that contains several levels of list items, with each lower level displaying a different numeric, alphabetic, or bullet character.

Planning proposal

a proposal that offers solutions to a problem or improvement to a situation

Sales proposal

a proposal that sells an idea, a product, or a service

Research proposal

a proposal that usually requests funding for a research project

Cover page

a separate title page in a multipage document that contains, at a minimum, the title of a document, and often the writer's name and sometimes the date.

Column

a single field in a data table; in text layout, a text placeholder used for lists.

Row

a single record in a data table.

autocomplete

a software function that gives users the option of completing words or forms by a shorthand method based on what has been typed before.

Small caps

a typographic convention in which no lowercase letters are used.

.dotx

are template files created by Microsoft word to have pre-formatted settings for generation of further DOCX files.

.txt

is a standard text document that contains unformatted text. They are useful for storing information in plain text with no special formatting beyond basic fonts and font styles.

goal seek

is the ability to calculate backward to obtain an input that would result in a given output.

.htm

means Hyper Text Markup, it's a file extension. The markup tells web browsers how to display a web page's words and images.

.doc

stands for document file. It contain formatted text, images, tables, graphs, charts, page formatting, and print settings.


Ensembles d'études connexes

Unit 1 - Aquinas, Aristotle, and Engels

View Set

Chapter 3 - The Cellular level of Organization

View Set

Life-Span Ch. 1 - Life Span Perspective

View Set

Chp. 4 Finance: The Time Value of Money

View Set

Ignite Seminar A 11th grade Semester 1 Unit 1

View Set

Islamic Art - Exam Pieces: Sultanate-Late Mughals

View Set

Chapter 1,2,3,5 test Marketing 3007

View Set