FIT Midterm Review, Microsoft PowerPoint Skills Project, Excel Unit D Terms, Excel: Chapter 3, ComSt 102 Exam 2, Excel 2010 - Comprehensive, Microsoft PowerPoint Fundamentals, PowerPoint Chapter 1, PowerPoint 2: Fundamentals, Powerpoint Lesson 1 and...

Ace your homework & exams now with Quizwiz!

If a table were 3 vertical cells by 6 horizontal cells, how many rows and columns would be in the resulting table?

3 Rows by 6 Columns

Can captions be added to a Photo Album?

Yes

Is it all right if an image flows off the edge of a slide?

Yes

In PowerPoint, if you have a photo album with two pictures on a page can you change it so that 4 pictures can be on a page?

Yes, by editing the Photo Album

What is done during the Drafting phase of the writing process? a) Writing the document b) Researching the document c) Editing the document d) Publishing the document

a) Writing the document

What protection option would you choose if you wanted people to only review your document? a) Require a Password b) Make it read-only c) Restrict editing d) Hide all images

c) Restrict editing

What is a template?

A preset starting file designed and formatted for a specific purpose

What do you do if the spelling and grammar checker finds an error that is not really an error?

Click Ignore

What is a collection of illustrations and photographs that can be searched to find images for your presentation?

Clip Art

Bullets must be small solid circles and cannot be changed to other symbols. True or False?

False

Try to put as much information into each slide, to limit the number of slides. True or False?

False

Italics, Underline, and Bold are _________

Font Styles

What Ribbon tab would you select to change the Shape Style of a text box?

Format

What Ribbon would you select to create WordArt?

Insert

What Ribbon would you select to create a Photo Album?

Insert

What tool on the Ribbon would you choose if you wanted to add an outside border to a table, at one time?

The Border painter in the Design Tab for the table.

Which of the following are valid ways to create a new presentation? a) Based on a template b) Based on another existing presentation c) From scratch with a blank presentation d) All of the Above

d) All of the above

WordArt is a combination of text and __________

graphics

What PowerPoint feature is the best for creating a common look and feel for a presentation?

Themes

Cell Format

Allows someone to change a cell's appearance; alignment, font, border, patterns, etc. as well as its numerical type; number, text, currency, percentage, etc.

One-input data table

Allows to vary the value in one cell to calculate the results of one or > formulas & fill the data table C results.

Two-input data table

Allows to vary values in two cells, but can only be applied to one formula

Goal Seeking

Allows you to define output results and then shows what input values are needed to generate that result.

Expand Arguments

Allows you to expand the function dialogue box in order to adjust the arguments in your function.

Data Table

Allows you to investigate how changes to one or two input variables in a formula changes output results.

Print Titles p. 133

An Excel command that enables you to specify rows and columns to repeat on each printed page.

AutoFit

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

AutoFit p. 75

An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column.

Auto Fill

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

Auto Fill p. 56

An Excel feature that generates and extends values into adjacent cells based on the values of selected cells.

formula autocomplete p. 196

An Excel feature which, after typing an = (equal sign and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).

Formula AutoComplete

An Excel feature which, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).

AVERAGE function

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

AVERAGE function p. 118

An Excel function that adds a group of values, and then divides the result by the number of values in the group.

MAX function p. 120

An Excel function that determines the largest value in a selected range of values.

MIN function p. 120

An Excel function that determines the smallest value in a selected range of values.

MEDIAN function p. 119

An Excel function that finds the middle value that has as man values above it in the group as are below it; it differs from AVERAGE in that the result is not affected as much by a single value that is greatly different from the others.

HLOOKUP

An Excel function that looks up values that are displayed horizontally in a row.

NOW function p. 128

An Excel function that retrieves the date and time from your computer's calendar and clock and inserts the information into the selected cells.

Design mode

An Excel view in which you can work with ActiveX controls.

Expand Formula Bar button p. 53

An Excel window element with which you can increase the height of the Formula Bar to display lengthy cell content.

Expand horizontal scroll bar button

An Excel window element with which you can increase the width of the horizontal scroll bar.

Horizontal window split box p. 53

An Excel window element with which you can split the worksheet into two horizontal view of the same worksheet.

Horizontal window split box (Excel)

An Excel window element with which you can split the worksheet into two horizontal views of the same worksheet.

Expand Formula Bar button

An Excel window wlwmwnt with which you can increase the height of the Formula Bar to display lengthy cell content.

Gallery

An Office feture that displays a list of potential results instead of just the command name.

Handout

An accompanying ____ gives audience members reference notes and review material for your presentation.

Which statement about an account is true?

An account is an individual accounting record of increases and decreases in specific asset, liability, and stockholders' equity items.

Liabilites

An amount owed to a lender or other creditor

Column Labels area

An area in the layout section of the PivotTable Field List in which you can position fields that you want to display as columns in the PivotTable report; field names placed here become column titles and the data is grouped in column by these titles.

What's a pane?

An area of a window displaying related content.

All Programs

An area of the Start menu that displays all the available programs on your computer system.

Criteria range

An area on your worksheet where you define the criteria for the filter, and which indicates how the displayed records are filtered.

Asset

An economic resource that a business owns and can use to operate the business

Formula Bar

An element in the Excel window that displays the value or formula contained in the active cell; here you can also enter or edit values or formulas.

Name Box p. 52

An element of the Excel window that displays the name of the selected cell, table, chart, or object.

Formula

An equation that performs mathematical calculations on values in a worksheet.

Formula p. 54

An equation that performs mathematical calculations on values in a worksheet.

Command

An instruction to a computer program that causes an action to be carried out.

Database

An organized collection of facts related to a specific topic.

Stockholder

An owner o a part of a corporation

Cell content

Anything typed into a cell.

Conditional formatting

Appear only when the value in a cell meets condition I specify. Home tab, Styles group. 8 relational operators: between, not between, equal to, not equal to, >, <, > or<, < or = to.

What's a Mini Toolbar?

Appears automatically. Initially transparent. Has commands R/T changing the appearance of text in a worksheet.

Formula Bar

Appears directly below the toolbar in the worksheet; displays a formula when the cell of a worksheet contains a calculated value.

In her history presentation, Bobbie wants to include her class period in the footer only on the current slide. Which option in the Header and Footer dialog box would she select?

Apply

Font Effects

Artistic elements you can add to your text.

If a company issues common stock for 40,000 and uses 30,000 of the cash to purchase a truck

Assets will be increased by 40,000

Which of the following represents the expanded basic accounting equation?

Assets+Dividends+Expenses=Liabilities+common stock+revenues

Where is the status bar?

At the bottom of worksheet window above the task bar. Usually says Ready.

What are Standard properties?

Author, Title & Subject.

What-if analysis AKA Sensitivity analysis

Automatic recalculation when I change values in cells referenced by a formula. Just change #'s to see new results. (Split worksheet & scroll right bottom screen to total, e.g. Operating Income, to see how my new #'s affect Total.

When you type the wrong character, you can press the ____ key to erase all the characters back to and including the one that in incorrect.

BACKSPACE

What is the name of the view on the File tab that enables a user to manage files and data about files, and find frequently used features for managing PowerPoint presentation files?

Backstage

Banded columns

Banded rows-- alternating colors every other row. Banded columns-- alternating color every other column

Have a clear goal and audience

Before starting your presentation, you should _____.

What's the default name of a workbook?

Book 1

Line and area chart

Both these charts show trends over time

Click___ to move stacked object to the top of the stack

Bring front

Modify Table Quick Style

Bring up Quick Style table gallery-- Right-click on desired style-- Select "Duplicate"-- "Modify Table Quick Style" dialog box comes up-- Type new name in "Name" field-- Use "Format" button in dialog box to launch "Format cells"

Sepia changes picture colors into ___

Brown , gold , and yellow

Creating Criteria Range

Build a small table C same column headings as main table-- Fill in info needed-- Select the new table-- Name it "Criteria Area" using "Name box" next to formula bar.

What type of list has an entry proceeded by a symbol?

Bulleted list

Maria adds text to a bulleted list on slide 5 of her presentation. On the text that she adds, she does not want a bullet. Using commands on the Home tab, how does she remove the bullet that automatically appears?

Bullets

Monitor dimensions and resolution affect how ___ display on the ribbon

Buttons

Workbook-level buttons p. 52

Buttons at the far right of the Ribbon tabs that minimize or restore a displayed workbook.

Back and Forward buttons

Buttons at the top of a folder window that work in conjunction with the address bar to change folders by going backward or forward one folder at a time.

Field buttons

Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart.

On Account

Buying or selling on credit

Landscape

By default, slides in a new presentation are in ____ orientation.

Work sheet tab colors

By default: Active -- white background. Inactive -- blue-gray. If I color a worksheet: Active-- underlined in the color. Inactive -- colored background.

By pressing what key allows you to select multiple slides?

CTRL

=10+B2

Cell C2 contains the formula "=10+D3". If you copied C2 to A1, what would be the formula in A1?

3D X & Y rotation button

Chart Tools -- Layout -- 3D rotation function. X axis rotates Chart around by 10 degrees increments (0 to 359), Y axis tilts it (0 to 90).

Select the formula to multiply the quantity and price

Choose "B"

Save the workbook "July"

Choose "Save As"

Sort the column from A to Z

Choose "Sort A to Z"

Insert a pie chart

Choose "pie"

Use the fill button to copy the formula

Choose the down arrow, the first one

Sort the column from A to Z

Choose the filter sign

Change the size of the words to 22

Choose the number "22" from the list

You can change the chart type even after it has been created.

Choose the statements about creating charts that is TRUE.

Print the highlighted section

Click "Print Area"

Launch "Custom AutoFilter" dialog box

Click AutoFilter arrow in a column heading-- Select "Number filters"-- Select "Custom filter"

How do I open Backstage View?

Click File tab

Minimize, Display, Restore Ribbon

Click Minimize Ribbon (right corner before Help button). Same button to Restore. To display: Select a tab, Ribbon will show up for that tab. It'll disappear after I select a function.

Type 1500 for the paycheck for the second half of the month

Click here and type in "1500"

Bold the words highlighted in blue

Click on "B"

Change the page orientation to landscape

Click on "Orientation" then choose "Landscape"

Change the page orientation to landscape

Click on "Page Layout"

Underline the words highlighted in blue

Click on "U"

Copy the highlighted selection

Click on copy sign

How do you insert a picture in a presentation?

Click the Picture button in the Images group on the Insert tab and select the photo to insert it.

Enter 230 for health insurance

Click the box after "health insurance" and type in 230

What do you click to change the paragraph alignment to centered?

Click the center alignment tool in the Home Tab

Delete Column A

Click the delete button

Click on column D and make it wider

Click the edge of column D

What do you call a collection of photos and illustrations from which you can choose an image to add to a presentation?

Clip Art

What command is used to quit the current presentation on screen but leave the PowerPoint 2010 program open?

Close

The _____ gallery has a wide variety of preset formatting combinations for coloring pictures.

Coloring

Labels

Column and row headings that describe the values and help the reader understand the chart.

What commands are available in Backstage View?

Command that I use to work outside the document, e.g. saving, printing, closing document, exiting Excel, etc.

Why use Surface chart?

Compare data from 3 columns and/or rows in 3-D manner (categories & series are both numeric). Show trends in values in a continuous curve.

Why use a Radar chart?

Compare several sets of data C each set represented by a different color.

Why use a Column or Cylinder chart?

Compare values side by side.

Criteria (Excel)

Conditions that you specify in a logical function.

criteria p. 123

Conditions that you specify in a logical function.

Tool tabs AKA

Contextual tabs. Show up when I use a certain function, e.g. insert a chart.

A photos color intensity can be modified by changing the brightness and ____

Contrast

____ is the difference between the darkest and lighters areas of an image

Contrast

Examples of Universal needs

Conventional commodity such as bulk chemicals, petroleum, steel, sugar, and the like Industrial and consumer products such as handheld calculators, semiconductor chips, personal computers, and liquid crystal display screens

What is a Theme?

Coordinating colors, matching backgrounds, fonts, and effects.

What does Fill Handle do?

Copies a cell content to adjacent cells.

Dave wants to print slides 7, 12 and 19-32 of his presentation at the same time. Which print option would allow Dave to enter the slide numbers that he wants to print?

Custom Range

Goal seeking

Data tab| Data Tools group| What If Analysis function -- Goal seek. Goal seek dialog box: Set cell (e.g. B2 shows Total) To value: (value I want to see, e.g. 3,000) By changing cell: (Cell that shows by how much I need to increase/decrease certain expense to reach my goal of the Set cell, e.g. C4).

Launch Data Table dialog box

Data tab| Data tool group| What-If Analysis button-- Select "Data Table" from drop down menu

Subtotal button

Data tab| Outline group. Covert table to a range first (Right-click-- Table--Convert to Range)

Advanced Filter dialog box

Data tab| Sort& Filter group| Advanced button. Disables AutoFilter (no arrows). Like AutoFilter, but doesn't filter based on comparison criteria selected from main table. Used to set up a criteria range to show records that passed the test set by Criteria range

Table AKA

Database. Organized collection of data (rosters, lists)

Sharon wants to add the date to her science presentation. She wants the date to remain the same each time it is opened. Which of the following in the Header and Footer dialog box would she select?

Date and Time (Fixed)

Investing Activities

Decisions made by manangement to buy and sell long term assests

What is WordArt?

Decorative text that you can add to a document

Division

Define the following operator: /

As the newly elected president of FBLA, Mindy is creating a presentation to be used at the next meeting. She has created a slide that contains duplicate information and decides that it is not needed for an effective presentation. In slide pane view, Mindy can right-click the unnecessary slide and select which option?

Delete Slide

Pam is using the outline view in PowerPoint. She would like to lower selected text from level 1 to level 2. Which command should she use?

Demote

In a multilevel bulleted list slide, creating a lower-level paragraph is called ___the text

Demoting

Trey is creating a PowerPoint for his Chemistry class. He wants to make sure all the slides have a similar visual appeal. Which tab would he choose to ensure that all slides have a single theme?

Design

Primary activities

Design, creation, and delivery of the product; its marketing; and its support and after-sale service

Pictures have different file formats. Explain what a JPEG file is.

Designed for photographic images. Handles gradual color blending and complex graphics well. Produces a smaller than most other formats because of compression.

Document properties

Details about a file that describe or identify it, including the title, author name, subject, or keywords that identify the documents topic or contents; also known as metadata.

Business entity Principle

Dictates that the financial affairs of a business organization must be kept separate from the personal financial affairs of the business owners

Dialog Box Launcher v. Task pane

Displays additional options for the group v. Can stay open & visible while I work in the workbook.

A credit is not the normal balance for which account listed below?

Dividends account

What are the "do's and don'ts" for less is more?

Do use numbered or bulleted lists and keep items short. Don't cram information onto a slide or use paragraphs.

Properties

Document ____ are the details about a file.

PowerPoint automatically records information in your presentation file, such as file size, creation date, and number of slides which are called ________________.

Document properties

A ___ is a specific design with coordination colors, fonts, and special effects.

Document theme

. In her history presentation, Bobbie wants to include her class period on all slides except the first. Which option in the Header and Footer dialog box would she select?

Don't show on title slide

The process of moving a slide object to a new location using the mouse pointer is called_____

Drag and drop

In Slide Sorter view, which method is used to change slide order?

Drag and drop to new location

AutoFilter arrow in a table

Drop down arrow in each column heading. Can be removed or added

"Undo" several steps C one click

Dropdown in "Undo" -- Drag through entries.

Pressing the ___key when entering title text in a placeholder creates a new paragraph.

ENTER

The most obvious example of the push for local responsiveness based on region is the

EU

What's a relative reference?

Each adjusted cell reference. Done automatically by Excel when I use Fill handle to copy a formula (or month, day,etc). Not just a copy, but adjusted to one column to the right of the previous column (or row).

Location Economies

Economies that arise from performing a value creation activity in the optimal location for that activity, wherever in the world that might be (transportation costs and trade barriers permitting)

What can you do with the Dialog box?

Edit the text/paragraph

________________ control the direction of transition movement and options vary based on the transition.

Effect Options

Fred wants to give his FBLA presentation about the upcoming membership drive an intense look. Fred should use which PowerPoint feature that includes pre-programmed settings that specify degrees of intensity for fills, lines, and special effects such as shadows and bevels?

Effects

Difference between Enter key, Enter box, Arrows keys to register data in a cell

Enter key completes entry and makes a cell below active. Enter box completes entry only & keeps the cell active. Arrow on keyboard completes the entry and makes the adjacent cell active.

#REF

Error message. Shows if I delete cells or a row that had a formula.

True

Every presentation should have a clear goal (t/f)

True

Every prsentation should have a beginning, a middle, and an end (t/f)

Scale to Fit p. 133

Excel commands that enable you to stretch or shrink the width, height, or both, of printed output to fit a maximum number of pages.

Entering formula: Using cell ref v. Name

Excel copies format to new cells (e.g. I put =C6 in H3, C6 format is applied to H3) v. Excel only copies formula, but NOT format

statistical functions p. 117

Excel functions, including the AVERAGE, MEDIAN, MIN, and MAX functions, which are useful to analyze a group of measurements.

What command is used to quit the current presentation on screen and quit the PowerPoint 2010 program?

Exit

. Sheila is using the outline view in PowerPoint. She would like to view the detailed content of all of her slides. Which command should she use?

Expand All

Absolute cell reference

$B$4 (enter B4 & press F4). Both column & row ref stay the same when I copy the cell to new destination.

Column width

0 to 255 characters wide.

Content of a folder window

1) Address bar; 2) Previous Locations button (end of address bar); 3) Refresh button (after Previous location button); 4) Search box (right corner of address bar); 5) Command bar (under Address bar); 6) Navigation pane (left of a window)

Changing column width

1) Autofit (Cells group, Format command); 2) Drag a column border. 3) Column width (Cells group, Format command); 4) Select column -- Right-click -- Column width 5) Double-click column border

Changing row heights

1) Autofit (Cells group, Format command); 2) Drag a row border. 3) Select a row -- Right-click -- Row height. 4) Row height (Cells group, Format command).

2 kinds of data tables

1) Changing 1 input value to see resulting effect on 1 or > formulas; 2) Changing 2 input values to see resulting effect on 1 formula

Sequence in choosing border characteristics

1) Color 2) Style (line) 3) Border (type)

Often used financial functions

1) FV (rate, periods, payment). Future value of investment based on periodic, constant payments @ constant interest rate; 2) PMT (rate, periods, loan amount). Calculate payment for a load based on amount, constant payments @ constant interest rate; 3) PV (rate, periods, payment). Present value of investment. Returns PV of annuity. Total amount that a series of future payments now is worth

3 ways to Sort

1) Home tab| Editing group| Sort & Filter button 2) Data tab|Sort & Filter group| A to Z button; 3) Select a cell-- Right-click-- Sort

2 ways to do borders

1) Select range-- Click "Borders" arrow in Home tab--Choose border 2) Right click--Format cells--Border tab OR Font group dialog box launcher arrow--Border tab drop down arrow-- Select "More borders"

How do you improve your nonverbal communication?

1. Be aware and mindful 2. observe others reactions to ur NVs 3. Ask others about your NVs 4. PRACTICE

Conflict defined (4 elements)

1. an expressed struggle 2. between at least 2 interdependent people 3. incompatible goals, scarce resources and interference 4. achieving a goal.

5 steps to assertiveness ***

1. describe how you feel in the situation 2. disclose your feelings to build empathy 3. identify effects of the behavior 4. be silent and wait for a response 5. paraphrase both content and feelings

5 steps to assertiveness

1. describe how you view the situation 2. disclose your feelings 3. identify effects of their behavior 4. be silent, wait for a response 5. paraphrase content and feeling

5 power principles

1. power exists in all relationships 2. power derives from the ability to meet the other persons needs. 3. both people in the relationship have some power. 4. power is circumstantial 5. power is negotiated

Steps of the listening process

1. receiving/ selecting 2. Attending 3. understanding 4. remembering

Conflict as a process (5 stages)

1. source 2. beginning (frustration awareness) 3. middle (active conflict) 4. End (resolution) 5. Aftermath

A point is ____ of an inch in height

1/72

Default row height

15 points (1 point = 1/5 of an inch, 1 inch = 75 points)

Condition

2 values & relational operator. True of False for each cell in the range. If condition is True, formatting is applied. If False, formatting is suppressed, e.g. I set format in a cell "Ads" to show zero, if Total income is < # specified.

When you install PowerPoint, the default setting allows you to reverse up to the last___ changes by tapping or clicking the undo button on the quick access toolbar

20

120

2pi/3

240

4pi/3

What's in the Command bar?

5-6 buttons: 1) Organize; 2) Open; 3) Share with; 4) Burn; 4a) Email; 5) New folder

300

5pi/3

225

5pi/4

150

5pi/6

315

7pi/4

210

7pi/6

Default column width

8.43 characters.

3D SUM

=SUM('Sheet 1 name:Sheet 2 (or 3 or 4 if I'm summing up a range of sheets)!B5 (or cell name C #'s I'm adding) close )

False

=SUM(A1:A9)/2 is a formula that DOESN'T use cell reference. (T/F)

Document Theme

A ____ is a specific design with coordinating colors, fonts, and special effects.

Offsets

A background feature called ____ allows you to move the background from the slide borders in varying distances by a percentage.

Insertion point

A blinkng vertical line that indicates where text or where graphics will be inserted.

Select All box p. 53

A box that appears in the upper left corner of the worksheet grid that, when clicked, selects all the cells in a worksheet.

Sole Proprietorship

A business entity that has one owner, where, for legal anf tax purposes, the business and the owner are considered the same

Not- For- Profit Business

A business that attemptes to create an exchange or sale where revenue equals costs

For- Profit Business

A business that attemptes to create an exchange, or sale, where revenue exceeds expenses, creating profit

Manufacturing Business

A business that produces the physical goods that it sells to its own customers

Service Business

A business that sells a service to customers

Merchandise Business

A business that sells physical goods or products to its customers

Wholesale Business

A business that sells products the other businesses for resale

Retail Business

A business that sells products to the final consumer of the product

absolute cell reference p. 179

A cell reference that refers to cells by their fixed positions in a worksheet; an absolute cell reference remains teh same when the formula is copied.

Absolute cell reference

A cell reference that refers to cells by their fixed positions in a worksheet; an absolute cell reference remains the same when the formula is copied.

Backstage view

A centralized space for file management tasks; for example, opening, saving, printing, publishing, or sharing a file. A navigation pane displays along the left side with tabs that group file-related tasks together.

legend p. 181

A chart element that identifies the pattern or colors that are assigned to the categories in the chart.

Embedded chart

A chart that is inserted into the same worksheet that contains the data used to create the chart.

pie chart p. 179

A chart that shows the relationship of each part to a whole.

line chart p. 205

A chart type that is useful to display trends over time; time displays along the bottom axis and the data point values are connected with a line.

Data marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series.

data marker p. 181

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points form a data series.

Data marker

A column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point; related data points from a data series.

Keyboard shortcut

A combination of two or more keyboard keys, used to perform a task that would otherwise require a mouse.

Context Sensitive Command

A command associated with activities in which you are engaged.

Context sensitive

A command associated with activities in which you are engaged; often activated by right clilcking a screen item.

Context sensitive

A command associated with activities in which you are engaged; often activated by right-clicking a screen item.

Error Checking command

A command that checks for common errors that occur in formulas.

Copy

A command that duplicates a selection and places it on the clipboard.

Freeze Panes

A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes.

freeze panes p. 129

A command that enables you to select one or more rows or columns and freeze (lock) them into place; the locked rows and columns become separate panes.

Merge & Center p. 64

A command that joins selected cells in an Excel worksheet into one larger cell and centers the contents in the new cell.

Go To

A command that moves to a specific cell or range of cells that you specify.

Go To Special

A command that moves to cells that have special characteristics, for example, to cells that are blank or to cells that contain constants, as opposed to formulas.

Clear Filter

A command that removes a filter.

Cut

A command that removes a selection and places it on the clipboard.

Find and replace (Excel)

A command that searches the cells in a worksheet--or a selected range--for matches and then replaces each match with a replacement value of your choice.

find and replace p. 127

A command that searches the cells in a worksheet--or in a selected range--for matches and then replaces each match with a replacement value of your choice.

Folder

A container in which you store the files.

Record

A data R/T each person in database

AutoComplete

A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

CSV (commas separated values) file

A file type in which the cells in each row are separated by commas; also referred to as a comma delimited file.

Comma delimited file

A file type that saves the contents of the cells by placing commas between them and an end-of-the-paragraph mark at the end of each row; also referred to as a CSV (comma separated values) file.

Advanced Filter

A filter that can specify three or more criteria for a particular column, apply complex criteria to two or more columns, or specify computed criteria.

Compound filter

A filter that uses miore than one condition--and one that uses comparison operators.

Custom Filter

A filter with which you can apply complex criteria to a single column.

Statement of Retained Earnings

A financail statement that reports the amount accumulated net profits a business has retained and not paid in dividends since incpetion. The statement reports the beginning balance of retained earnings, plus net income or minus net loss in the given periods, less the dividneds during the given period, equaling anding retained earnings

Balance Sheet or Statement of Financial Position

A financial statement that reports the assests, liabilities, and stockholders' equity of a business at a specific point in time

Income Statement

A financial statement the reports the revenue and expenses of a business during a given period of time.

DSUM function

A function that sums a column of values in a database that is limited by criteria set for one or more cells.

IF function

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

WordArt p. 189

A gallery of text styles with which you can create decorative effects, such as shadowed or mirrored text.

Product

A good or services purchased or produced by a business to be sold

Get External Data group

A group of commands that enable you to bring data from an Access database, from the Web, from a text file, or from an AXL file into Excel without repeatedly copying the data.

logical functions p. 123

A group of functions that test for specific conditions and that typically use conditional tests to determine whether specified conditions are true or false.

Chart Layout gallery

A group of predesigned chart layouts that you can apply to an Excel chart.

Chart Layouts gallery p. 69

A group of predesigned chart layouts that you can apply to an Excel chart.

Chart Styles gallery p. 69

A group of predesigned chart styles that you can apply to an Excel chart.

Chart styles gallery

A group of predesigned chart styles that you can apply to an Excel chart.

Series p. 56

A group of things that come one after another in succession; for example: January, February, March, and so on.

Extensible Markup Language (XML)

A language that structures data in text files so that it can be read by other systems regardless of the hardware platform or operating system.

value axis p. 207

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.

What do I see in a worksheet window?

A portion of a worksheet on the screen.

pane p. 129

A portion of a worksheet window bounded by and separated from other portions by vertical and horizontal bars.

Function p. 60

A predefined formula--a formula that Excel has already built for you--that performs calculations by using specific values in a particular order or structure.

function p. 117

A predefined formula--a formula that Excel has already built for you--that performs calculations by using specific values in a particular order or structure.

Function

A predefined formula--aformula that Excel has already built for you--that perform calculations by using specific values in a particular order or structure.

Theme

A predefined set of colors, fonts, effects

Template

A predesigned presentation

Template

A preset starting file designed and formatted for a specific purpose.

Enhanced ScreenTip

A screentip that displays more descriptive text than a normal screentip.

Excel table p. 130

A series of rows and columns that contains related data that is managed independently from the data in other row and columns in the worksheet.

Excel Table

A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet.

Font

A set of characters with the same design and shape.

What's a Gallery?

A set of choices arranged in a grid or a list, e.g. Format tool tab in Chart Tools when a drop down window displays colors.

What's a Gallery

A set of choices displayed when a the gallery's scroll arrow is clicked.

Vertical window split box p. 52

A small box on the vertical scroll bar with which you can split the window into two vertical views of the same worksheet.

S- Corporation

A small corporation that has net the legal requirements to act as a corporation but elected to be taxed at individual rates

COUNTIF function

A statistical function that counts the number of cells within a range athat meet the given condition and that has two arguments--the range of cells to check and the criteria.

volatile p. 129

A term used to describe an Excel function that is subject to change each time the workbook is reopened; for example the NOW function.

In PowerPoint, what is a text box?

A text box allows you to create and place text wherever you want.

What does a theme change in a workbook?

A theme is a predefined set of colors, fonts, chart & cell styles, fill effects. Also changes standard colors in the font gallery.

Sparklines p. 66

A tiny chart in the background of a cell that gives a visual trend summary alongside your data; makes a pattern more obvious.

PowerPoint assumes every new slide, except for a blank slide, has ____

A title

Insert Function

A toolbar button that displays functions by category that will assist you in writing the formula.

Check boxes

A type of ActiveX control that the person filling in the form can select to indicate a choice.

data point p. 181

A value that originates in a worksheet cell and that is represented in a chart by a data marker.

Column

A vertical group of cells in a workbook.

Slide Show View

A view in PowerPoint that shows the slides on the full screen with the animations and transitions.

Diagram

A visual representation of data to help readers better understand relationships among data

What are Tool tabs?

AKA Contextual tabs: Tabs that show only when I'm using a certain function,e.g. after I insert a Column, I'll see Chart Tools tab.

What's Quick Access Toolbar?

Above Ribbon (can be dragged to be below it) on the Title bar, at left edge of the Title bar. Give one-click access to frequently used commands.

International Financial Reporting Standards (IFRS)

Accounting standards developed by the International Accounting Standards Board for use throughout the world

Accrual Accounting

Accounting that recognizes a business transaction when it occurs, whether or not cash is received or disbursed

What is an Action Button?

Action buttons are built-in button shapes that can be added to play sound, jump to other slides, or open a web site.

Financing Activities

Actions that generate the receipt or cash from raising capital or the payment of long term liabilities

Services

Activites that exsit but that purchases a product from a business

Operating Activities

Activities that create revenue and or expenses in the entity

False

Adding borders on the cells is just for decoration, not to group the cells. (T/F)

What's the function of SUM command?

Adds all numbers in a range of cells.

Types of conditional formats (5)

1) Highlight; 2) Top and Bottom rules; 3) Data bars; 4) Color scales; 5) Icon sets

Handouts print _____ to ______ slides on a page.

1, 9

steps to managing the problem

1. manage your emotion 2. manage information using strong listening and responding skills 3. manage goals- seek accurate understanding of others goals 4. manage the problem by structuring conflicts as problems to be solved.

Excel type of charts

11 types total: Pie. Area. XY scatter. Line. Stock. Surface. Doughnut. Bubble. Radar. Column. Cylinder.

330

11pi/6

How many database functions are there in Excel?

12 to eval numeric data in a table

360

2pi

Total interest

=12*years*monthly_payment-loan_amount

3D Average

=Average('First sheet name:Last sheet name!cell #)

Total cost

=price+total_interest

Range finder p. 82

A Excel feature that outlines cells in color to indicate which cells are used in a formula; useful for verifying which cells are referenced in a formula.

Presentation

A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.

Cell style

A defined set of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.

=F6/3

A formula that contains a cell reference

Corporation

A legal entity, chartered under state law, empowered to conduct business; the corporation and owners are considered as separate for legal and tak purposes

Business

A legal organization that attempts to create value by exchanging products with customers for money

Accounts Payable

A liability incurred by a business when purchasing goods and services

Border v. Outline

A line placed on 1 side of a cell or range of cells v. a Box (lines on all 4 sides)

Break-even

A point at which an entity covers its costs and starts to make a profit.

SUM function p. 61

A predefined formula that adds all the numbers in a selected range of cells.

SUM functions p. 117

A predefined formula that adds all the numbers in a selected range of cells.

Data table (Excel)

A range of cells that shows how changing certain values n your formulas affect the results of those formulas and that makes it easy to calculate multiple versions in one operation.

Column p. 53

A vertical group of cells in a worksheet.

Workbook p. 51

An Excel file that contains one or more worksheets.

Which of the following is a standard document property?

Author

____ determines the overall lightness or darkness of an entire image

Brightness

Click ___ to move a stacked object toward the top of the stack

Bring forward

You can insert a new slide by pressing the ____keyboard shortcut keys

CTRL + M

What is the shortcut key to select all text?

CTRL-A

What is the shortcut key that saves a document?

CTRL-S

What is the shortcut key that repeats the last task?

CTRL-Y

CHAPTER THREE

Chapter 3

What's in each tab?

Collection of Groups.

What is the vertical row in a table called?

Column

When dealing with a presentation, what is the 6x6 rule?

Each slide should have no more than 6 lines with 6 words per line.

Custom table sorting

Home tab| Editing group| Sort & Filter button-- Custom sort

Launch "New Formatting Rule" dialog box (to set off cells containing certain values)

Home tab| Styles group| Conditional formatting button-- Select "New Rule". Select a type of rule

Double-click the worksheet tab

How can you rename a worksheet?

There is a double line between rows and columns.

How can you tell if the worksheet has hidden rows and columns?

Quick Access Toolbar

If you accidentally replace the wrong text, just click the Undo button on the ____.

Scenario

If you wanted to do an Excel What-If Analysis of a system with eight different inputs which tool would you use?

The ____ dialog box allows you to search for clip art by using descriptive keywords

Insert pictures

What are the four main paragraph alignment choices?

Left, right, center and justify

False

Monthly Payment!A10 is a cell reference that would not result in an error. (T/F)

As shown in the accompanying figure, the ____ arrow dos plays the Facet layout gallery

New slide

The default PowerPoint view is ____view

Normal

You can type and format notes in the _____ pane

Notes

Chart elements

Objects that make up a chart.

The difference between the effects and the styles is that each effect has several ____ providing you with more control over the exact look of the image.

Options

If you accidentally replace the wrong text, just click the undo button on the ____

Quick access toolbar

____effects convert colors in a picture to a wide variety of hues.

Recolor

Select all sheets

Right-click a sheet tab -- Select all sheets.

In the normal view what is the tab that displays at the left column of thumbnails?

Slides

general fund p. 179

The term used to describe money set aside for the normal operating activities of a government entity such as a city.

Subtitle

The text below a main title, usually include your name and class in PowerPoint

Hide & Unhide a workbook

View tab| Window group| Hide button. With any workbook open click Unhide to launch "Unhide" dialog box-- Select desired workbook-- OK

Clear All

What Clear command would you use to make cell A2 look like cell B3?

Define Objectives and Outline Presentation

What are the first two steps in creating a PowerPoint presentation?

Format attributes

What are the pieces of information that describe the appearance of a cell's content?

Tiling

You can use ____ options to repeat a background image many times vertically and horizontally on a slide.

go to

a command in the scroll box that enbles users to browse by field endnote footnote comment section page edits headings graphics or tables

markup

a markup is a version of a document with comments and revision marks displayed for easy viewing

columns

a vertical stack of cells in a table

Avoidance

backing off and trying to side step conflict "lose-lose"

Page Layout view is available for chart sheets.

false

empathy

feeling what another person is feeling

cell

in a table or spreadsheet the text area at the inersection of a row or column

Fill Color

the background of the cell

i-beam

the large i created when users place the cursor near the insertion point

combination chart

two charts in one

bypassing

when confusion is caused by the fact that the same word can mean different things to different people

What are formatting symbols?

$, comma, %, etc.

Ashley has a limited supply of paper. Which print layout option will minimize the amount of paper used and includes up to nine images per page?

. Handouts

When saving a presentation that will be exported to Microsoft Word 2010, which file type should be selected?

.rtf

File name extension for Excel files

.xlsx

0

0

2 ways to insert PMT function (launch Insert Function dialog box)

1) Formulas tab| Function Library group| Insert function button| Select "Financial" in category| Select PMT function-- Enter arguments; 2) Insert Function button in formula bar-- Select Financial category-- Select PMT function-- OK-- Enter arguments-- OK

2 ways to apply currency style

1) Home tab| Number group| $ function; 2) Right-click|Format cells|Number tab

2 ways to Format as Table

1) Home tab| Styles group| Format as table button-- Selects style, dialog box comes up; 2) Insert tab| Tables group-- Table button

2 ways to launch VLOOKUP

1) Insert Function box in formula bar-- click "Or select a category" box arrow-- click Lookup & Reference-- click VLOOKUP; 2) Formulas tab| Function library group|Lookup & Reference button-- Select VLOOKUP

2 ways to launch Format cells dialog box

1) Right-click-- Format cells; 2) Font dialog box launcher arrow-- Choose needed tab

2 steps in Protecting worksheet

1) Select cells I want to leave unprotected-- Change cell protection setting to unlocked status (Format cells-- Protection tab-- Remove check from Locked box). Removing check mark= Selected cells will stay unprotected when entire worksheet will get protected; 2) Protect entire worksheet If I protect entire worksheet, I can't change anything, including locked status of individual cells

3 ways to create names based on titles

1) Select range-- Type name in Name box (Next to formula bar)--Enter; 2) Select range-- Define Name button (New Name dialog box launches)-- Type name-- OK; 3) Select range-- Name Manager button-- New (launches same New Name dialog box as in #2)--Type name-- OK

2 ways to Add/ Remove AutoFilters

1) Sort & Filter button in Home group; 2) Filter button (Data tab)

Pie chart components

1) Title (Layout tab-- Labels group-- Chart title function; 2) Legend: category names (Legend function, same tab, same group); 3) Data labels: Choose label position & content in "Format Data Labels" dialog box.

2 ways to Create % series

1) Type % values into 2 cells-- Select the 2 cells-- Drag using Fill Handle; 2) Type % values into 2 cells-- Select the 2 cells-- Right drag using Fill Handle-- Select "Fill Series"

Major parts of Excel

1) Workbooks & Worksheets (like a notebook); 2) Charts; 3) Tables (organize & store data in worksheets); 4) Web Support (I can save worksheets in HTML for others to view & change it using a browser).

Extract

1. To decompress, or pull out, files from a compressed form. 2. The location to which you copy the records is the Extract area, and is commonly placed below the table of data. Using this technique you can extract--pull out--multiple sets of data for comparison purposes.

Process of using words of support

1. describe own feelings, rather than evaluate the behavior of others 2. solve problems rather than try to control others 3. be genuine rather than manipulative. 4. empathize rather than remain detached from others. 5. be flexible rather than rigid 6. present yourself as equal rather than superior

How many characters fit in sheet name?

31

How many layout views are in Status bar?

3: 1) Normal; 2) Page Layout; 3) Page Break Preview

Types of Sparkline charts

3: Line, Column, Win/Loss.

270

3pi/2

135

3pi/4

True

=$A10/B5 uses absolute cell references. (T/F)

Parts of IF function

=IF (G3 (shows # of years) <=$E$3 (total years in life of loan) - logical test, PV($E$2 (shows interest rate)/12,12*($E$3 (total years) -G3(years paid so far)) - Shows value if true, -$E$4 (shows monthly payment)),0) zero = Value if false. So if # of years is > $E$3, then total = 0. I don't owe anything

Statement of Cash Flows

A Financial statement that reports the sources and uses of cash for a given period of time

AutoPlay

A Windows feature that displays when you insert a CD, a DVD, or other removable device, and which lets you choose which program to use to start different kinds of media, such as music CDs or CDs and DVDs containing photos.

Style

A ____ is a named group of formatting characteristics.

Bounding Box

A border that displays around the edges of a selected object.

Hierarchy

A catergory of SmartArt graphics used to create an organization chart or show a decision tree.

Data bar

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to other cells; the length of the bar represents the value in the cell--a longer bar represents a higher value and a shorter bar represents a lower value.

data bar p. 127

A cell format consisting of a shaded bar that provides a visual cue to the reader about the value of a cell relative to other cells; the length of the bar represents the value in the cell--a longer bar represents a higher value and shorter bar represents a lower value.

Select the cell and edit the formula in the Formula Bar.

A cell has a very long formula that you must edit. What would be the best way to edit the formula.

Absolute cell reference

A cell reference that refers to cells by their fixed position in a worksheet; an absolute cell reference remains the same when the formula is copied.

Legend p. 67

A chart element that identifies the patterns or colors that are assigned to the categories in the chart.

Column chart

A chart in which the data is arranged in columns and which is useful for showing data changes over a period of time or for illustrating comparisons among items.

File

A collection of information stored on a computer inder a single name, for example a Word document or a PowerPoint presentation.

Calculated column

A column in a table in which each row uses a common formula referencing other fields in the table

Find

A command that finds and selects specific text or formatting.

Cycle

A continual process diagram.

Variant

A copy of a theme with different color schemes.

Bevel

A curve to soften the appearance of a straight edge. Select a chart -- Right-click -- Format Data Series (to launch dialog box) -- 3-D Format & Choose Bevel in Top &/or Bottom.

Digital certificate

A digital means of proving identity and authenticity.

AutoFilter menu

A drop-down menu from which you can filter a column by a list of values, by a format or by criteria.

Document Inspector

A feature that can find and remove hidden properties and personal information in a workbook.

Compatability Checker

A feature that finds any potential compatability issues and creates a report so that you can resolve the issues.

AutoComplete (Excel)

A feature that speeds your typing and lessens the likelihood of errors; if the first few characters you type in a cell match an existing entry in the column, Excel fills in the remaining characters for you.

Calculated column

A field, or column, that contains formulas or functions

Compressed file

A file that has been reduced in size and thus takes up less storage space and can be transferred to other computers quickly.

conditional format p. 126

A format that changes the appearance of a cell--for example, by adding cell shading or font color--based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.

Conditional format

A format that changes the appearance of a cell--for example, ny adding cell shading or font color--based on a condition; if the condition is true, the cell is formatted based on that condition, and if the condition is false, the cell is not formatted.

DCOUNT function

A function that counts the number of occurances of a specified condition in a database.

DAVERAGE function

A function that determines an average in a database that is limited by criteria set for one or more cells.

DGET function

A function that extracts from your data table a single record that matches the conditions you specify.

IF function p. 117

A function that uses a logical test to check whether a condition is met, and then returns one value if true, and another value if false.

Paste Options gallery p. 143

A gallery of buttons that provides a Live Preview of all the Paste options available in the current context.

Icon sets

A group of three, four, or five small graphic images that make your data visually easier to interpret and are used to add emphasis to the conditional format of a file.

Row p. 54

A horizontal group of cells in a worksheet.

Limitied Liability Corporation

A hybrid business entity having characteristics of both a corporation and a partnership

What is a hyperlink?

A hyperlink is a link from one object on a slide to another location, such as another slide or a web site.

HTML (Hypertext Markup Language)

A language Web browsers can interpret when you save a worksheet as a Web page.

Axis

A line that serves as a fram of reference for measurement and which borders the chart plot area.

axis p. 207

A line that serves as a frame of reference for measurement and which borders the chart plot area.

Debug

A method to locate and correct errors step by step.

text box p. 187

A movable resizeable container for text or graphics.

Loss

A negative profit that occurs when the cost of a sale is greater than the revenue from the sale

Intranet

A network within an organization that uses Internet Technologies.

Value axis p. 67

A numerical scale on the left side of a chart that shows the range of numbers for the data points; also referred to as the y-axis.

Landscape orientation

A page orientation in which the paper is wider than it is tall.

Stakeholder

A person or organization affected by a business

Customers

A person or organization that purchases a product from a business

Contrast

A photo's color intensity can be modified by changing the brightness and ____.

1/72

A point is ____ of an inch in height.

Picture element p. 57

A point of light measured in dots per square inch on a screen; 64 pixels equals 8.43 characters, which is the average number of digits that will fit in a cell in an Excel worksheet using the default font; abbreviated "pixels"

Rounding p. 62

A procedure in which you determine which digit at the right of the number will be the last digit displayed and then increase it by one if the next digit to its right is 5, 6, 7, 8, or 9.

Filtering

A process in which only the rows that meet the criteria display; rows that do not meet the criteria are hidden.

Footer

A reserved area for text or graphics that displays at the bottom of each page.

Header

A reserved area for text or graphics that displays at the top of each page in a document.

Page Layout view p. 71

A screen view in which you can use the rulers to measure the width and height of data, set margins for printing, hide or display the numbered row headings and the lettered column headings, and change the page orientation; this view is useful for preparing your worksheet for printing.

Normal view p. 73

A screen view that maximizes the number of cells visible on your screen and keeps the column letters and row numbers close to the columns and rows.

Annuity

A series of fixed payments (e.g. months) at a fixed interest rate.

Font

A set of characters that have the same design.

Ellipsis

A set of three dots indicating incompleteness; when following a command name, indicates that a dialog box will display.

Financial Accounting Standards Board (FASB)

A seven- person group primarily responsible for the establishment of standards of financial accounting and reporting called GAAP

bevel p. 183

A shape effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Bevel

A shepe effect that uses shading and shadows to make the edges of a shape appear to be curved or angled.

Transition

A slide ____ is a special animation effect used to progress from one slide to the next slide in a slide show.

Where's Dialog Box Launcher?

A small arrow in the lower-right corner in a group on the Ribbon.

Dialog Box Launcher

A small icon that displays to the right of some group names on the Ribbon, and which opens a related dialog box or task pane providing additional options and commands related to that group.

Table sizing handle

A small triangle in a table ("Format as Table") in right lower corner, like Fill Handle. Used to add new rows to the table

Dialog box

A small window that contains options for completing a task.

Field

A specific type of data such as name, employee number, or social security number that is stored in columns.

Number format p. 59

A specific way in which Excel displays numbers in the cell.

COUNTIF function p. 123

A statistical function that counts the number of cells within a range that meet the given condition and that has two arguments--the range of cells to check and the criteria.

Fund

A sum of money set aside for a specific purpose.

fund p. 179

A sum of money set aside for a specific purpose.

What would be the best option to organize a large amount of information? A table or a list?

A table

Data validation (Excel)

A technique by which you can control the type of data or the values that are entered into a cell by limiting the acceptable values that are entered into a cell by liniting the acceptable values to a defined list.

Define Clipboard

A temporary storage for the copied information.

Select all button

A triangle to the left of Column Heading A & above Row 1

Data point

A value that originates in a worksheet cell and that is represented in a chart by a data marker.

goal seek p. 189

A what-if analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

Integer

A whole number used in mathematical computations.

What's a Task pane?

A window to the left of main screen that stays open & visible while I work in the workbook, e.g. Clipboard task pane (shows up when I click Clipboard Dialog Box Launcher).

Defined name

A word or string of characters in Excel that represents a cell, a range of cells, a formula, or a constant value; also referred to as simply a name.

chart sheet p. 181

A workbook sheet that contains only a chart.

Chart sheet

A workbook that contains only a chart.

Summary Sheet p. 150

A worksheet where totals from other worksheets are displayed and summarized.

Prepaid expenses

Accounts that are assests of a business because they represent items that have been purchased but will be used later

Cash Accounting

Accoutning that recognizes business transactions only when cash is received or disbursed

True

Actions are predefinted shapes (t/f)

Actual Cost

Actual cost of assests and services acquired; also referred to as HISTORICAL COST

Shadow

Adding a ____ to text adds depth and helps the letters display prominently.

SUMIF, COUNTIF, AVERAGEIF

All can have multiple criteria, e.g.=SUMIF (C1:C6,D1:D6,"<10",D1:D6">5") Sums values between 5 and 10

Accounting number format v. Currency style format v. Comma style format?

All in # Group. Accounting: Displays #'s C 2 decimal places, Fixed $ sign in the left of a cell & aligns decimal places of cells below vertically v. Currency: Displays floating $ sign in cells. v. Comma: Cells are displayed C 2 decimals & commas as thousands separators.

What happens when you click Align Left when multiple objects are selected?

All of the objects selected will align on the left side of the page or slide.

Collapse Arguments

Allows you to shrink the function dialogue box in order to choose cells for your function.

IF function cell reference

Always absolute, e.g. $E$4

Relative Reference

An adjustable/changeable cell reference

Evaluate Formula

An auditing tool that helps you examine complex formulas.

Digital signature

An electronic, encryption-based, secure stamp of authentication on a document.

Label p. 54

Another name for a text value, and which usually provides information about number values.

Cell address

Another name for cell reference.

Digital ID

Another name for digital signature--an electronic, encryption based, secure stamp of authentification on a document.

X-axis p. 67

Another name for horizontal (category) axis.

AutoSum

Another name for the SUM function.

AutoSum p. 62

Another name for the SUM function.

x-axis p. 207

Another name for the horizontal (category) axis.

y-axis p. 207

Another name for the vertical (value) axis.

Y-axis p. 67

Another name for vertical (value) axis.

Spreadsheet p. 51

Another name for worksheet.

Application

Another term for program.

Value p. 54

Anther name for constant value.

logical test p. 124

Any value or expression that can be evaluated as being true or false.

Sorting a table

Arranging records in a specific sequence (Ascending sequence or Descending sequence) OR Smallest to Largest/ Largest to Smallest (if column has numbers)

Font

As shown in the accompanying figure, tap or click the ____ arrow to display the Font gallery.

Why is it important to ask questions while giving a presentation?

Asking questions will keep your audience engaged.

Which accounts normally have debit balances?

Assets, expenses, and dividends.

How to add standard document properties?

Author name, Title, Subject of my workbook. Go to Backstage View -- Click on "Properties" (under doc preview) -- Choose "Show document panel" (first choice) -- Fill in the boxes.

What feature automatically revises typing errors based upon information contained in Microsoft Office 2010's standard dictionary?

AutoCorrect

True

AutoFill automatically adjusts formulas with relative cell references. (T/F)

What AutoFit option is used to automatically adjust column width based on the data in the cells?

AutoFit Contents

Mixed cell reference

B$4.Column ref changes to C, D, etc. when I copy the cell to another column. Row ref doesn't change. $B4 -- Row ref changes to 5,6, etc., but column stays the same (if copied vertically, but if horizontally, both will stay same

Relative cell reference

B4. When column & row ref are copied to another cell, both are adjusted to reflect the new location.

Change % entry

Backstage| Options| Advanced| "Enable automatic % entry" box

If you use the __template, as opposed to a formatted theme, you must make all design decisions.

Blank Presentation

Sheet tab scrolling buttons p. 52

Buttons to the left of the sheet tabs used to display Excel sheet tabs that are not in view; used when there are more sheet tabs than will display in the space provided.

What's the default font name size for a workbook?

Calibri 11 pt.

Yes

Can Templates and Themes be customized?

Yes

Can captions be added to a photo album?

Yes

Can you open a website from within a PowerPoint presentation using hyperlink?

Yes

Can you reuse slides from other presentations?

What happens when I start entering txt

Cancel & Enter boxes show up in the formula bar.

Color ____ indicates that one color is dominating a picture

Cast

Dependent cells

Cells that contain formulas that refer to other cells.

Constraint cells

Cells that contain values that limit or restrict the outcome.

Format p. 64

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.

Format (Excel)

Changing the appearance of cells and worksheet elements to make a worksheet attractive and easy to read.

CHAPTER TWO

Chapter 2

Formatting marks

Characters that display on the screen, but do not print, indicating where the Enter key, the Spacebar, and the Tab key were pressed; also called nonprinting characters.

What is the range of the cells?

Choose "D"

Select the whole worksheet C one click

Click "Select All" -- small triangle in right upper corner between column A and row 1

Print the highlighted section

Click "Set Print Area"

Range Finder

Click a cell containing a formula -- Cells in the formula will be highlighted = The range is shown

Change the size of the words to 22

Click on the number 11 first,

Paste "Extra Income" into the active cells

Click on the paste button

Use the autosum button to add up the amounts

Click the "E" button

Save the workbook "July"

Click the "file" button

Use the fill button to copy the formula

Click the arrow sign

Collapse & Expand a folder

Click the black arrow to expand. Click it again to collapse.

Pam is using the outline view in PowerPoint. She would like to hide the detailed content of all of her slides. Which command should she use?

Collapse All

What are sources that can be used for images?

Computer hard drive and the Internet.

Number values p. 54

Constant values consisting of only numbers.

Text values p. 54

Constant values consisting of only text, and which usually provides information about number values; also referred to as labels.

Learning effects

Cost savings that come from learning by doing. Ex. Labor

COUNTIF function

Count values in a range only if they meet a criteria. =COUNTIF (B9:B21 (range of cells to compare criteria with),"Full Time" (criteria)

DCOUNT function

Counts # of numeric entries in a table field that pass a test

____ is a font that resembles the letters that typewriters produced

Courier new

Keisha wants to change the font color on the 1st and 3rd bulleted items on slide 6 of her Allied Health Presentation. What is the best way to select both bullets at the same time?

Ctrl + click

Keyboard shortcut for Bold

Ctrl+B

Keyboard shortcut for Italics

Ctrl+I

Keyboard shortcut for Underline

Ctrl+U

You can control how placeholders and other objects are resized by pressing the following keys as you drag. Explain how the placeholder is resized.

Ctrl: The placeholder size changes from a fixed center point. Shift: The height and width proportions are maintained as the size changes Ctrl + Shift: The placeholder resizes from the center and remains in proportion

To change a selected shapes height or width to a specific value, type the value in the height or width text boxes on the____

DRAWING TOOLS FOMRAT tab/ size group

Pie chart: Slices names

Data series. Category names (column titles, e.g. Jan, Feb, etc.)

Enabling/Disabling Autofilter

Data tab -- Sort & Filter Group -- Filter function click to enable (drop boxes show) or disable

Enter custom criteria C AutoFilter

Data tab -- Sort & Filter group -- Filter function (to put drop down arrows on column headings). Click arrow -- Number filters -- Custom filters -- Set your parameters.

Information

Data that has been organized in a useful manner.

Chart Tools tabs

Design. Layout. Format.

Which of the following accounts is increased with a debit?

Dividends

Drilling an entry

Enter a # once and copy it though several worksheets so that it's entered in the same cell on all selected worksheets.

Which of the following keys can you press to run a slide show starting with slide 1?

F5

Data

Facts about people, events, things, or ideas.

Text ___defines the appearance and shape of letters, numbers, punctuation marks , and symbols.

Font

Gregory is making a presentation to encourage fellow students to join the prom committee. Which of the following would include options for accomplishing this?

Font Effects

Gregory is making a presentation to encourage fellow students to join the prom committee. He would like to emphasize the date of the first meeting by making it bold. Which of the following would include options for accomplishing this?

Font Style

Which term refers to the size of alphabetic and numeric characters on a slide?

Font size

Sharon wants to include her name on each slide in her science presentation. Where in the Header and Footer dialog box would she type her name?

Footer

What is the block of text at the bottom of the page called?

Footer

Rotate text

Format cells (right-click or Format function in Cells group) -- Alignment tab -- Orientation box

To save time and avoid formatting errors, you can use the ___ to apply custom formatting to other places in your presentation quickly and easily.

Format painter

What are the two ways to create WordArt?

From new or by convert existing text.

HLOOKUP function v. VLOOKUP

H is used when the table direction is horizontal v. V is used when a table direction is vertical (most often used R/T most tables being vertical)

Select Column

Highlight an entire column

Select Row

Highlight an entire row

4

How many operands are in the following formula? =D4+D13-D15*D13

10

If D3=30 and D4=20, what is the result of the function IF(D4<D3, D3-D4, "Full")

True

If a cell has a DARK fill color, then the text color should be: A LIGHT color to create contrast. (T/F)

Allows you to define input variables in various situations. The output result for each situation is show in a summary table.

In Excel, which statement best describes the What-if Analysis Scenario tool?

Constraints

In Solver, values that limit or restrict the outcome.

An operand

In the formula "=D10+15", what part of the formula is the "15"?

Which ribbon contains the command to insert a text box on a slide?

Insert

The ___ dialogue box allows you to search for and insert files from a range of online sources

Insert media

Yes

Is (=F18+F19/2) a formula that uses cell reference?

Yes

Is it possible for an image flows off the edge of a slide?

Why should you use themes?

It is a way to add instant "pop" to a presentation.

What command on the Home Ribbon enables a user to change the design of a slide after it has been inserted into a presentation?

Layout

Double clicking active cell borders

Left side= 1st cell in row becomes active. Right side= Last cell becomes active. Top side= Top cell becomes active. Bottom side= Bottom cell becomes active

What happens to a formula when I fill handle it horizontally (copy a formula across columns)?

Letters change, numbers stay. Letters increase by one, e.g. A10*N23 will change to B10*M23 (alphabetically), etc.

Why use Bubble chart?

Like Scatter chart, but for 3 sets of data.

False because Headers and Footers both work on Excel

Microsoft Excel can use Headers but not Footers, just like Microsoft Word.

To delete WordArt text outline, click ___ in the text outline gallery

No outline

False

Only text objects and shapes (such as arrows) can be defined as hyperlinks (t/f)

Which of the following is the path to Send Backward button?

PICTURE TOOLS FORMAT tab/ arrange group

_____ adds designs that repeat in rows across a slide

Pattern fill

What do text boxes allow you to do in a PowerPoint presentation?

Place text anywhere on a slide

Formatting text in a shape follows the same techniques as formatting text in a ____

Placeholder

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text _____

Placeholder

Slides

PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.

Display formula version

Press CTRL + ACCENT (`).

Which area in the Print dialog box is used to change the default printer?

Printer Status Dropdown

The operations of a firm can be thought of as a value chain composed of a series of distinct value creation activates

Production, marketing and sales, materials management, R&D, human resources, information systems, and firm infrastructure

Why should you not apply a different transition to every slide of your presentation?

Random movements with transitions don't entertain an audience and can be seen as distracting or annoying

What are some of the ways to use shapes in PowerPoint?

Shapes can add interest to a presentation. You can add text to shapes to give them more meaning. Shapes can be used to make flow charts.

Core Competence

Skills within the firm that competitors cannot easily match or imitate

False

Source Data!B12 is a cell reference that will not result in an error. (T/F)

Worksheet AKA

Spreadsheet

Display monthly payments as (+) #'s

Start formula C - after =

How to get Help S starting Windows program

Start menu -- Help and Support

Which Tab allows you to select themes and variants?

The Design tab.

Comma Style

The Excel number format that inserts thousand comma separators where appropriate and applies two decimal places; Comma Style also leaves space at the right to accommodate a parenthesis when negative numbers are present.

What would you click in PowerPoint to create a new slide?

The New Slide button in the Home Tab

True

The What-if Analysis Scenario tool allows you to define input variables in various situations. The output result for each situation is show in a summary table. (T/F)

Outline

The WordArt ____ is the exterior border surrounding each letter or symbol.

Event

The action that causes a program or macro to run, such as clicking a button or command or pressing a combination of keys.

Edit

The actions of making changes in text or graphics in an Office file.

Strategy

The actions that managers take to attain the goals of the firm

What is the easiest way to have all the text boxes line up with the first text box?

The align tools

Cost

The amount of money or money substitutes a business receive an item used in operating a business

Font Style

The appearance of type (e.g., bold and italics)

category axis p. 207

The area along the bottom of a chart that identified the categories of data; also referred to as the x-axis.

Category axis

The area along the bottom of a chart that identifies the categories of data

Lettered column headings p. 53

The area along the top edge of a worksheet that identifies each column with a unique letter or combination of letters.

Details pane

The area at the bottom of a folder window that displays the most common file properties.

Slide Notes

The area below each slide in PowerPoint where notes can be placed that only the presenter can see.

Margin

The blank space around the edges of the page.

Filtering buttons

The buttons on a slicer which you use to select the item by which to filter.

Active cell

The cell, surrounded by a b lack border, ready to receive data or be affected by the next Excel command.

Cell Reference

The column letter and the row number. Example: B12

Field names

The column titles from source data that form categories of data for a PivotTable report.

Chart layout

The combination of chart elements that can be displayed in a chart such as a title, legend, labels for the columns, and the table of charted cells.

Chart layout

The combination of chart elements that can be displayed in a chart such as title, legend, labels for the columns, and the table of charted cells.

Fill

The inside color of an object.

Extract area

The location to which you copy records when extracting filtered rows.

Fill handle

The small black square in the lower right corner of a selected cell.

Base

The starting point; used in calculating the rate of increase, which is the amount of increase divided by the base.

base p. 196

The starting point; used in calculating the rate of increase, which is the amount of increase divided by the base.

Andy is creating a presentation about seatbelts. He finds himself using the word "save" repeatedly in his presentation. What feature could he use to find a synonym for this word?

Thesaurus

=5+A1*B1

This formula is a complex formula.

When you add a new slide following the title slide, PowerPoint uses the ___ slide layout for the new slide

Title and content

What area in the window contains the Quick Access Toolbar, filename, and Window control buttons?

Title bar

What's the purpose of Cell styles (Home tab -- Styles group)?

To change several cell characteristics of a cell at once.

What are Cylinder & Column charts used for?

To compare data.

No Outline

To delete WordArt text outline, click ____ in the Text Outline gallery.

Why would you use WordArt?

To make text pop or stand out.

Cell protection

To prevent users from accidentally changing values critical to worksheet.

Formula Auditing

Tools and commands accessible from the Formulas tab that help you check your worksheet for errors.

Where is the Ribbon?

Top of the window, below the title bar.

Mini Toolbar

Transparent thing. Disappears if I don't use it.

Every presentation should have a beginning, a middle, and an end. True or False?

True

Every presentation should have a clear goal. True or False?

True

Font Effects are similar to Font Styles, but are used in more specific circumstances. True or False?

True

True

True or False: You can use borders to create a group of cells or make specific cells stand out.

False

Try to put as much information into each slide, to limit the number of slides (t/f)

Format tab

Under which ribbon tab would you find the Alignment Tool?

Cells that are aligned vertically

What is a column?

6 lines and 6 words

When dealing with a presentation what is the 6x6 rule?

Text file

Which of the following files can be used to import data into Excel?

Author

Which of the following is a standard document property?

What is white space?

White space lets the eye take a break and helps the viewer focus on the key information on the slide.

To engage the audience

Why should you ask questions during a presentation?

To keep slide uncluttered

Why should you keep the text boxes on a slide short and to the point?

To group the cells

Why would you add borders to cells?

To make sure all of the information in the column is visible.

Why would you want to change the column width?

What is Word Art?

Word Art is a combination of text and graphics.

Autofill

You want to enter a series of dates down a column. What would be the best tool for the job?

Italicized

____ text has a slanted appearance.

save

a button in the quick access toolbar that saves an existing document

chart style

a collection of formatting that controls the color of the chart area, plot area, and data series.

data series

a collection of related data points

Column Heading

a column letter above the grid that identifies each column

font theme

a combination of two font to be applied to headings and text as part of a theme

copy

a command in word that places a duplicane copy of selected text in the clipoard

Filter

a condition that data must meet to be included in a selection - a way of limiting data in a list

Malapropism

a confusion of one word or phrase for another that sounds similar (instruction and construction)

text box

a container that holds text on a slide

save as

a dialog box that will save a document in a specific format

texture

a graphic that repeats to fill an image creating the appearance that the surface is a certain material sush as mardle wood or paper

section

a grouping of contiguous slides

drop down list

a list that diplays options you can choose sush as a list of fonts by clicking the option you want

bookmark

a location or selection of text that you name and identfy for future reference

point size

a measurement that refers to the height of characters with one point equaling approximately 1/12 of an inch

Pseudo conflict

a misunderstanding. occurs when we miss the meaning of the message

text effects

a new font command group that adds a distinctive appeararance such as outlines shadows glows or reflections to selected text

smart art layout

a particular arrangement of shapes that a graphic can have examples include list process cycle hierarthy etc

theme

a scheme of complementing colors

font

a set of characters that have the same design

chart sheet

a sheet in a workbook that contains only a chart that is linked to the workbook data

dialog box launcher

a small arrow in the lower-right corner of the group

mla style

a standardizaton of guidelines used by colleges and universities for research papers

screen tip

a tip that appears when the mouse pointer rests on a tool a basic screen tip displays the tool;s name and shortcut key if a shortcut exists for that tool

What shortcut key(s) would you press in the PowerPoint Slide Sorter to indent a selected line? a) Tab b) CTRL c) Tab-Shift d) CTRL-Shift

a) Tab

Cell Label

ability to use name box to name a range of cells/cell

Evidence that would not help with determining the effects of a transaction on the accounts would be an

advertising brochure

Adjustments are often prepared

after the balance sheet date, but dated as of the balance sheet date.

all markup

all changes and comments are displayed on the document

Freeze Panes

allows the user to select specific rows or columns that remain visible when scrolling in the worksheet

command

an instruction users give word by clicking a button or entering instruction into a command box

The usual sequence of steps in the transaction process is

analyze, journalize, post to the ledger.

character

any single letter number symbol or punctuation mark

What is the use of touch?

can communicate empathy or power.

Functions of eye contact

cognitive, monitor, regulator, expressive

chart filter

controls which data series and categories are visible in a chart

SmartArt graphics

diagrams such as list,process, cycle, hierarchy, relationship, matrix, and pyramids

Page Break Preview

displays the location of the different page breaks within the worksheet

citation

excerpt from the source of informaton

In its simplest form, an account consists of all of the following except

explanation column

gridlines

extends across the plot area to create a scale of measure for each value

>, >=, and = are examples of conditional operators

false

An Excel worksheet is made up of one or more workbooks.

false

text pane

fly-out pane that allows you to key information for a smart art graphic

tick marks

found on the vertical axis; create a scale of measure for each value

biased language

insensitivity towards others, may include hate speech

A revenue account

is increased by credits

A revenue account

is increased with a credit

the dividends account

is increased with debits and decreased with credits

The right side of an account

is the credit side

antonym

is the opposite meaning of a word i.e good and bad

At the time a company prepays a cost

it debits an asset account to show the service or benefit it will receive in the future.

what are other reasons that non verbal comm is important? (other than stats)

its how we communicate feelings and attitudes, more believable, create meaning, help people respond and adapt, major in interpersonal relationships.

chart title

label that describes the entire chart. it should reflect the purpose of the chart

high-low-close stock chart

marks a stock's trading range on a given day with a vertical line from the lowest to the highest stock prices

illustrators

nonverbal behaviors that accompany verbal messages (pointing at the screen)

exploding

pulling a slice away from the pie chart

Strategic goal is to

pursue a low-cost strategy on a global scale

minor gridlines

represent the values between the tick marks

major gridlines

represent values at the value axis tick marks

exploded pie chart

separating one or more slices from the rest of the chart

In recording accounting transactions, evidence that a transaction has taken place is obtained from

source documents

Competition

stresses wining a conflict at the expense of another "win-lose" ~ugliest~

What symbol would you choose to show the reading view in PowerPoint?

the Open Book

sympathy

the acknowledgment of someone else's feelings

Cell Alignment

the position in which text is placed within a cell

plot area

the region containing the graphical representation of the values in the data series. two axes form a border

aspect ratio

the relationship of width to height in a picture shape or silde

layout master

the slide master for a particular slide layout

backstage view

the view accessed via the file tab that contains tools and commands in office 2016

Worksheet

the workspace made up of columns and rows where you enter data to create an electronic spreadsheet

what do we mean by saying that words are arbitrary?

there is usually no inherent meaning to a word and it must be agreed upon to have meaning

Selection Tool

thick white cross

print

to send a document to a printer

annotate

to write or draw on a slide during a presntation write the mouse or writh a stylus or finger on a screen

fonts

typefaces that are used to display characters numbers and symbols in your power point presntations

collaboration

uses other-oriented strategies to achieve a positive solution for all that are involved "win-win"

ActiveX controls

Graphhic objects, such as check boxes or buttons, that you place on a form to display or enter data, perform an action, or make the form easier to read. When the person filling in the form clicks the ActiveX control, a macro or script runs that automates a task or offers options.

One method of getting the audiences attention and reinforcing the major concepts being presented is to have____ on the title slide

Graphical elements

___help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations

Graphics

_____ changes picture color into black, white, and shades of gray

Grayscale

Sending electronic documents is a way to contribute ___ computing

Green

What is the correct path to the bold button?

HOME tab/ Font group

What are yellow adjustment handles on shapes?

Handles used to adjust certain visual features of a shape.

An accompanying ___gives audience members reference notes and review material for you presentation.

Handout

Travis wants to give his audience a sheet to follow along and make notes during his presentation that includes representations of each slide. Travis should utilize which feature of PowerPoint?

Handouts

Which print setting enables multiple slides to be printed on one page?

Handouts

Mr. Jones is creating handouts for his MSITA class presentations. What feature in the Header and Footer dialog box would allow him to add the class name to the top?

Header

What is the block of text at the top of the page called?

Header

If you want to include identifying information on all slides of a presentation, use the ________________________ command on the insert tab.

Header and Footer

The notes pane is ____ until you tap or click the notes button on the status bar to open the pane.

Hidden

Active Cell

Highlighted worksheet cell that is ready for data entry

Financial Statements

Historical, objective reports, prepared according to GAAP, that communicate financial information about a business

Selecting multiple sheets

Hold CTRL & click on sheets.

Using Fill Handle to copy cell content

Hold CTRL (or not) while dragging by the Fill handle.

Select all sheets in a workbook

Hold down SHIFT key and click the last sheet on the bottom (to deselect hold down SHIFT & click sheet 1 OR click any sheet but Active)

Which ribbon includes the command to create presentation slides from an outline?

Home

Where is Merge & Center function?

Home tab -- Alignment group

Sort in ascending/descending order

Home tab -- Editing group -- Sort&Filter function -- Select A to Z or Z to A

Where do I go to change font, size, color?

Home tab -- Font group

Format as Table

Home tab -- Styles group -- Format as Table function -- Select table style -- Check range to be correct -- Select "My table has headings" -- OK

Add/ Remove AutoFilter arrows (drop down arrows) from column headings

Home tab| Editing group| Sort & Filter button-- Select "Filter" form drop down menu

Pictures can be aligned both ________________ and _______________ on a slide.

Horizontally, Vertically

They are independent and not related.

How are a cell's content and format related?

Right click on the selected cells

How can you access the hide/unhide command for a group of selected cells?

By using parentheses

How can you force a certain order of operations in a formula?

Ask a few questions

How can you increase audience involvement?

Wrap the text

How can you make a large amount of text visible in a cell without changing the width of the cell?

Insert functions, define the name, create the name range, review the formula

How can you use the formulas tab?

Show formulas in a print-out

How could you double-check formulas in a worksheet?

When choosing fonts for a presentation, what should you consider?

How legible the font is with the background color, lighting and room size can affect how readable it is, how big the font size should be, traditional or playful feel?

0

How many arguments are used in the following Excel function which returns the current date and time? NOW()

1

How many errors are in the following formula? =(A3+A5+A6)/A5*B1)

2

How many errors are in the following formula? SUM(A2:B10)+(C3/)(E3-E10))

Two

How many errors are in the following formula? SUM(A2:B10)+(C3/)(E3-E10))

3

How many operators are in the following formula? =B14+AVERAGE(E1:E50)-D3/D6

What is similar about hyperlinks and action buttons? What is different?

Hyperlinks and action buttons can both be used to navigate to another slide or to open a web site. Action buttons are different because they are pre-defined shapes.

Unprotected v. Protected cells

I can change values v. I can't change values (all formula cells should be protected)

Formatting and IF function

IF function doesn't apply the format of original cell to new cell. General style format is applied

False

If A3=10 and B6=14, what is the result of the logical expression A3=B6

AutoCorrect in Spell checker

If I always mis-type a word, I click AutoCorrect. Anytime in the future I type the word wrong, Excel automatically change it to the right word.

IF function: Values assigned

If Logical test is true, IF function assigns PV function to the cell. If Logical test is false, IF function assigns 0 to the cell. if I put double -quote symbols (" "), then IF function will leave the cell blank if Logical test is false (instead of 0)

=F3

If you copied C6 to E3, what would be the resulting cell reference in E3?

True

If you don't want to print out some data on your worksheet, you can hide the rows or columns containing the data. (T/F)

Portrait

If you had a worksheet with 46 rows and 3 columns of data, what would probably be the best page orientation for the worksheet?

Blank Presentation

If you use the ____ template, as opposed to a formatted theme, you must make all design decisions.

=

In Excel, all formulas must begin with what symbol?

Yes

In PowerPoint, if you have a photo album with two pictures on a page can you change it so that 4 pictures can be on a page?

Decision variables

In Solver, cells that will change too achieve a desired result; also called Variable cells.

Desktop

In Window, the opening screen that simulates your workj area.

Folder window

In Windows, a window that displays the contents of the current folder, library, or device, and contains helpful parts so that you can navigate.

File list

In a Folder window, the area on the right that displays the contents of the current folder or library.

Relative cell reference p. 63

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.

relative cell reference p. 179

In a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to.

Interval

In a moving average, the number of cells to include in the average.

False

In an Excel table, if you enter a formula in the top cell of a column, the formula would NOT be automatically copied down the column. (T/F)

The formula is automatically copied down the column

In an Excel table, if you enter a formula in the top cell of a column, what would happen next?

True

In an Excel table, to fill a formula down a column, you need to enter the formula in the first cell. Excel will then automatically copy the formula down the other cells in the column.

Where are the functions?

In the Groups.

An operator

In the formula "=F3+5", what part of the formula is the "+"?

Where's Enter box?

In the formula bar under Ribbon, between Insert function symbol and Name box.

25-13

In this formula, which calculation is performed first? =12*A3*(25-13)

15/3

In this formula, which calculation is performed first? =A2+15/3+100/E4

B4*100

In this formula, which calculation is performed first? =B4*100+15/3

15/3

In this formula, which calculation is performed first? =A2+15/3+100/E4

Fields

Individual data items that make up a record

Change history

Information that is maintained about changes made in past editing sessions.

What Ribbon tab would you click to insert a shape?

Insert

Format Sparkline charts

Insert the chart. Sparkline tools tab Design shows up -- Style tab -- Choose style. Show group -- Choose High Points, Low point, Negative points, First point, Last point, Markers.

Locating a value creation activity in the optimal location for the activity can have one of two effects

It can lower the costs of value creation and help the firm achieve a low-cost position, and/or it can enable a firm to differentiate its product offering from those of competitors

False

It's always better to add more graphic elements to a slide (t/f)

____text has a slanted appearance

Italicized

Which text alignment command aligns text with both the left and right margins of a slide and adds space between words as needed?

Justify

Data labels

Labels that display the value, percentage, and/or category of each particular data point and can contain one or more of the choices listed--Series name, Category name, Value, or Percentage.

Which term refers to a predetermined way of organizing objects on a slide including title text and other content?

Layout

Using the ____ you can choose the arrangement of placeholders on a new slide.

Layout gallery

Creating "a moat of cells"

Leaving several rows empty above the table for Criteria area. Leaving several columns empty to the left of the table starting at column A for other queries if needed

Default selection in create names from values in the: in "Create Names from Selection" dialog box?

Left column

What happens to a formula when I fill handle it downward from Source cell?

Letters stay, Numbers change. #'s increase by one, e.g. A10* N23 will change to A11*N24, etc.

Which of the following describes the classification and normal balance of the Unearned Rent Revenue account?

Liability, credit

Why use Area charts?

Like Line (show changes over time), but to compare > one set of data C area under the line filled in C different color for each set of data. Shows differences between sets of data over time.

Why use a Doughnut chart?

Like Pie chart, but compares > one set of data C each set of subsequent set of data surrounding the previous set.

Why use XY (scatter) chart?

Like a Line chart, but each piece of data isn't connected C a line to compare pairs of values.

Gridlines

Lines in the plot area that aid the eye in determining the plotted values.

Whats in Favorites area?

Link to my favorite locations. By default, links only to Desktop; Downloads; Recent places.

What do Libraries have?

Links to files & folders that I included in a library.

Insert Worksheet button

Located on the row of sheet tabs, a sheet tab that, when clicked inserts and additional worksheet into the workbook.

Insert Worksheet button p. 52

Located on the row of sheet tabs, a sheet tab that, when clicked, inserts an additional worksheet into the workbook.

Why is consistency important?

Maintaining consistency will help your presentation appear seamless and thoughtful

Shapes

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation.

For most firms the preeminent goals is to

Maximize the value of the firm for its owners and its stockholders

Value creation

Measured by the difference between V and C (V-C)

Profit Growth

Measured by the percentage increase in net profits over time higher profitability and a higher rate of profit growth will increase the value of an enterprise and thus returns garnered by its owner, the shareholders

Profitability

Measured in a number of ways, but for consistency, we define it as the rate of return that the firm makes on its invested capital, calculated by dividing the net profits of the firm by total invested capital Rate of return concept

True

Merging cells means to combine 2 or more cells into a single cell. (T/F)

True

Microsoft Excel can use Headers & Footers, just like Microsoft Word.

Print Layout, Full Screen Reading, Web Layout, Outline, and Draft are examples of ____________

Microsoft Word Views

The italic button is located on the____

Mini tool bar

What does the wavy, red line under a word in a presentation mean?

Misspelling

Expense

Money or other value surrendered due o the sale of goods or services of the operating of the business

Stockholders' Equity

Money provided to the business by owners either through an initail investment or the retention of profits also known as OWNERS' EQUITY

Buttons

Monitor dimensions and resolution affect how ____ display on the ribbon.

In the Timing Group, the Advance Slide options control whether slides advance On Mouse Click or a specific number of seconds. Give one example of when you would use each option.

Mouse Click: When you are giving notes and you have to talk more about each subject Specific # of Seconds: When you have pictures set to music (8th grade slideshow)

Pam is using the outline view in PowerPoint. She would like to reposition slide 2 to become slide 6. Which command should she use?

Move Down

Sheila is using the outline view in PowerPoint. She would like to reposition slide 5 to become slide 2. Which command should she use?

Move Up

What does Percent Style button do?

Multiplies the cell entry by 100.

Select a range of cells using assigned names

Name box drop down arrow-- Select desired name

Name reference v. Cell reference

Name references are absolute

8. As the newly elected president of FBLA, Mindy is creating a presentation to be used at the next meeting. She is finished with the slide she is working on and wants to insert another one in the default arrangement. In slide pane view, Mindy can right-click the current slide and click which option?

New Slide

In the PowerPoint 2010 View Ribbon, which presentation view enables a user to view one slide at a time in the Slide Pane?

Normal

What's the default view of a worksheet?

Normal Layout View. Shows continuous arrangement of rows and columns.

By default, slides in a new presentation at in ____ orientation

Portrait

What's the default print orientation?

Portrait C worksheet printed in the top left area of the paper.

Paragraph Alignment

Position of text in a document (left, center, right, justify)

Which of the following software programs is used to create a collection of slides that may contain text, charts, pictures, sound, movies, or multimedia, and is often called a presentation graphics program?

PowerPoint

PowerPoint can save presentations in different formats. Explain the use of each format.

PowerPoint Presentation: File Extension: .pptx Uses: This is the default file format. It is compatible with all PowerPoint versions starting with 2007 PowerPoint Picture Presentation: File Extension: .pptx Uses: It converts each slide into an image. Helps to reduce file size Open Document Presentation: File Extension: .odp Uses: Can be opened in applications that use this kind of format, including Google Docs

A title

PowerPoint assumes every new slide, except for a blank slide, has ____.

Themes

PowerPoint displays many ____ that are varied and appealing and give you an excellent start at designing a presentation.

Predefined

PowerPoint provides a wide variety of ____ shapes that can add visual interest to a slide.

What is the first step in the writing process?

Pre-Writing

Financial functions

Pre-built formulas that perform common business calculations such as calculating a loan payment on a vehicle or calculating how much to save each month to buy something; financial functions commonly involve a period of time such as months or years.

Slide Layout

Prearranged sets of placeholders for various types of slide content.

PowerPoint provides a wide variety of ___ shapes that can add visual interest to a slide

Predefined

Functions

Predefined formulas that oerfirm calculations by using specific values, called arguments, in a particular order or structure.

Which pair of accounts follows the rules of a debit and credit in relation to increases and decreases in the same manner?

Prepaid Insurance and Advertising Expense

A Power point ____ can help deliver a dynamic, porfessional-looking message to an audience.

Presesntation

Enter

Pressing the ____ key when entering title text in a placeholder creates a new paragraph.

CTRL

Pressing which key allows you to select multiple slides?

. Charles has asked his teacher to review his presentation and make suggestions for improvement within the file. Which print option allows him to print these suggestions?

Print Comments and Ink Markup

Dave wants to print only the slide on which he is currently working. Which print option should he use?

Print Current Slide

Document ___ are the details about a file

Properties

In PowerPoint 2010, where is the command located to undo the last action?

Quick Access Toolbar

Keshawn has never used Microsoft PowerPoint 2010 before. He discovered a way to put his most commonly used commands together at the top of his screen for easy access. What is this customizable feature of PowerPoint?

Quick Access Toolbar

The undo button is located on the ____

Quick Access Toolbar

PMT function argument entry

Rate, Payment, Loan amount =PMT(monthly interest rate, (rate/12),# of payments (12*Years), Loan_Amount)

For academic purposes, you may include images in your presentation if you ____________________________?

Reference their sources as you would any other research citation

What are examples of styles?

Regular, Italic, Bold, and Bold Italic.

Data series

Related data points represented by data markers; each data series has a unique color or pattern represented by a chart legend.

Data series p. 68

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

data series p. 181

Related data points represented by data markers; each data series has a unique color or pattern represented in the chart legend.

The firm's profit will be greater the lower C is

Relative to P

Relative v. Absolute v. Mixed cell referencing (addressing)

Relative-- no $ sign before column letter or row #'s v. Absolute-- enter $ before any column letters or row #'s v. Mixed-- only one $ sign before either column or row.

Which of the following accounts has a normal credit balance?

Rent Revenue

How do these prepaid expenses expire?

Rent- With the passage of time Supplies -Through use and consumption

To instruct PowerPoint to confirm each change, click the find next button in the____ dialog box

Replace

What protection option would you choose if you wanted to prevent people from viewing your document? a) Require a Password b) Make it read-only c) Restrict editing d) Hide all images

Require a Password

Reliabilty Principle

Requires information to be verifiable, confirmable by any independent observer; also called OBJECTIVITY PRINCIPLE

Primary activities are divided into four functions

Research and development, production, marketing and sales, and customer service

If you change the size of a picture incorrectly, you can restore the picture's original dimensions by clicking the _______________ button.

Reset Picture

Which command is used to insert slides from one presentation into another presentation?

Reuse Slides

Which accounts normally have credit balances?

Revenues, liabilities, and retained earnings.

Check spelling

Review tab, Proofing group, Spelling button in the right corner.

Protect entire worksheet

Review tab| Changes group-- Protect Sheet button

. Linda is using Microsoft PowerPoint for the very first time. While looking at her default screen, she notices that all of the elements are set in tabs. What are all of the commands on each tab called?

Ribbon

Set color & thickness of borders

Right click| Format cells| Border tab

How is numbers aligned in a cell?

Right-aligned. If there're more numbers than can fit in a cell, the cell will show #######.

Moving a file by right-click & drag

Right-click a file -- Drag it to a new location -- Select Move, Copy or Cancel.

Format a range as a table

Right-click on table -- Select "Table" from short cut menu -- Select "Convert to Range" from submenu -- Click "Yes" on dialog box

Hide & Unhide sheets in a workbook

Right-click the tab-- Select "Hide". Right-click any tab-- Select "Unhide"-- Select desired sheet in Unhide dialog box-- OK

Why is it important to think about the colors you are going to use in your slide show and have high contrast between text and background (dark on light etc.)?

Room lighting can change how clear or vibrant it is when it is projected on a large-screen as compared to the computer

Which of the following accounts is increased with a credit?

Sales Revenue

Color___ changes the intensity of colors

Saturation

In PowerPoint 2010, what command is used to save a new presentation?

Save

Difference between Save & Save As

Save -- Existing file C Same file name v. Saving existing file C a Different file name & different location (if desired).

In PowerPoint 2010, what command is used to save an existing presentation with a new name or in a new location?

Save As

Charles has several slides in his presentation which are either smaller or larger than the paper size in the printer. Which print option should he use to ensure that each slide utilizes the maximum print area?

Scale to Fit Paper

Splitting windows into panes

Select a cell -- View tab -- Windows group -- Split function. Result: window is split in 4 C selected cell in top left corner of lower right screen. Remove Split: Click Split again or Double click on a split bar in worksheet.

Hide & Unhide columns

Select a column (or a cell in a column I want to hide)-- Ctrl+0. Select columns around hidden column (or single cells)-- Ctrl+Shift+)

AutoCalculate function

Select a range of cells I want to check -- Right-click on Status bar (at bottom) -- Min, Average & Sum will be shown.

Inserting rows & columns

Select a row or column -- Insert (right-click -- Insert, or Insert function in Cells group). Selected column becomes new column, data moves to right. Selected row becomes new row, data moves down.

Create range names

Select a section of a worksheet-- Enter the name in the name box (when Name is selected in Name box, the range will be selected)

Delete column A

Select column A

Clearing formatting in the cells

Select formatted cells -- Choose Normal in Styles or Go to Editing group, Clear function, Clear formats.

Create names based on row titles

Select range-- Launch "Create Names from Selection" dialog box (Formulas tab| Defined Names group| Create from Selection button)

How to make a Sparkline chart

Select the cell in which Sparkline will go -- Insert tab, Sparklines group, Choose your chart (Line, Column, Win/Loss)-- Select the range of rows by dragging -- Release the mouse.

Clear cell using Fill Handle

Select the cells containing data I want to delete. Use Fill Handle to drag backward over data so shadow covers the data.

Format a range as a table

Select the range, e.g. Rows C columns headings-- Home tab| Styles| Format as table button-- Select style-- Click on "My table has headers" in "Format As Table" dialog box (if applicable)

Extract range

Selecting "Copy to another location" option in "Advanced Filter" dialog box= Copying records meeting comparison criteria in criteria range to another part of worksheet instead of showing them as a subset of the table.

What's Point mode?

Selecting cells to use in a formula by using the mouse. Just point to a cell & it'll be put in a formula.

Clean slate

Selecting the Blank Presentation option allows you to start a presentation from a _____.

How can a firm increase its profitability and rate of profit growth by expanding internationally

Sell products to the international market Source activities where they are performed most efficiently Realize greater cost economies

What option would you choose to move a selected object to the last layer?

Send to Back

The ___command moves the selected object underneath all objects on the slide

Send to back

Green

Sending electronic documents is a way to contribute to ____ computing.

Using names made of 2 words in formulas

Separate names by underscore (_)

What's a range?

Series of 2 or > adjacent cells in a column or row or a rectangular group of cells.

A debit is not the normal balance for which account listed below?

Service Revenue

Adding a ___ to text adds depth and helps the letters display prominently

Shadow

What are the three options available to customize a shape's format?

Shape Fill, Shape Outline, and Shape Effect

Many of the shapes included in the ___ gallery can direct the viewer to important aspects of the presentation

Shapes

False

Shapes CANNOT be added to a photo album (t/f)

What are shapes?

Shapes are predefined objects such as boxes, circles and arrows.

Why use Pie charts?

Show contribution of each piece of data to the whole of the data. Use it when all pieces can be added together.

Why use Stock chart?

Show stock market data.

Function of Sparkline chart

Show trends & variations in a range of data.

(Final starts here). Amortization schedule

Shows beg and ending balances & amount of payment applied to principal & interest for each year over the life of the loan

What's Live preview?

Shows the effect of a gallery choice on the worksheet when I roll the pointer over, S applying the changes.

Keisha's does not want the text on slide 3 to run out of the textbox and she wants the textbox to remain the same size. How can she prevent this?

Shrink text on overflow

Which PowerPoint 2010 pane shows the current slide as it will appear during the slide show?

Slide

What should you change if you want on particular slide to have a different arrangement of text box placeholders?

Slide Layout

In powerpoint, the ____ store information about slide backgrounds,layouts, and fonts for each theme

Slide Master

It is best to use the _________________ tab to change theme colors or theme fonts when you want to make additional changes to customize slide layouts or background graphics such as to add a company logo to all slides in the presentation.

Slide Master

Which button allows you to preview the presentation as the audience will see it?

Slide Show

Which view displays each slide so that it fills the entire screen with no tool-bars or other Windows elements visible on the screen?

Slide Show

Two more views are important for the delivery of your presentation. Explain when these views would be used.

Slide Show View: When you are showing your presentation in front of an audience to see Presenter View: It displays speaker notes so that just the speaker can see them

What view is shown that is displayed to the audience?

Slide Show view

Travis wants to make sure that his presentation is organized in the best arrangement. He needs to view as many slides as possible in one view. Which feature of PowerPoint should Travis view?

Slide Sorter

Which view shows thumbnails (smaller versions) of a presentation's slides, making it easy to rearrange them?

Slide Sorter

Sharon wants to be able to quickly locate the 12th slide in her science presentation. Which option in the Header and Footer dialog box would she select?

Slide number

PowerPoint ___should reinforce the speakers message and help the audience retain the information

Slides

Which group on the Home Ribbon contains commands to create new slides in a presentation?

Slides

Cindy has created a report in her biology class using Word 2010 and would like to save time by using the content of that report to create a presentation. Which option under New Slide would she choose to import that information?

Slides from Outline

Auto Fill Option Menu

Small box under Auto Fill box in the corner of a cell. 1) Copy cells (doesn't create series); 2) Fill series (set as default, doesn't show in option menu); 3) Fill formatting only; 4) Fill S formatting (contents only); 5) Fill months (same as #2, but only shows if a series has a month in it)

Why might you want to change the slide layout in PowerPoint?

Sometimes you will want to change the slide layout to better fit the content.

Conditions

Statements in a formula that can be evaluated as true or false, and then return an appropriate value if true, and another value if false.

You can enter a cell references in a formula by typing in the reference. You can enter a cell reference in a formula by clicking the cell location on the spreadsheet. Cell references make it easy to use values from other cells in a formula.

Statements that ARE true about cell references.

Cost Principle

States the when a business acquires assests or services, they should be recorded at their actual cost, also called HISTORICAL COST

What is the name of the area that contains the zoom control and PowerPoint view buttons?

Status bar

A ___ is named group of formatting characteristics

Style

McDonald's is increasingly finding that its foreign franchisees are a source of valuable new ideas. Which aspect of creating value is McDonald's taking advantage of in this instance

Subsidiary skills

Remove Automatic Subtotals from Table

Subtotal dialog box-- "Remove All" button

Expectancy violation theory

Suggests that you will interpret the message of others on how you expect them to behave. ex. midwesterners shake hands and smile when they meet someone new, you would not expect them to bow.

Comparison operator

Symbols tat evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.

comparison operator p. 124

Symbols that evaluate each value to determine if it is the same (=)., greater than (>), or less the (<), or in between a range of values as specified by the criteria.

A word with a meaning similar to that of another word is called a ____

Synonym

Experience Curve

Systematic reduction in production costs thatt have been observed to occur over the life of a product

The basic format of a journal would not include a (n)

T-account

Insert "Total" row @ bottom of table

Table tools Design tab| Table style Options group| Ceck "Total Row" box

Contextual tabs

Tabs that are added to the Ribbon automatically when a specific object, such as a picture is selected, and that contain commands relevant to the selected object.

What are the elements of the Ribbon?

Tabs, Groups, Commands.

Merge Cells

Takes two or more cells and combines them into one.

Drilling Technique

Taking the content from one sheet and pasting it to multiple sheets at one time.

Texture

Tap or click the Texture button to display the ____ gallery, as shown in the accompanying figure.

A _______________ contains the characteristics of a theme and usually provides sample content you can edit for your own slides or delete if you want only the background it provides.

Template

This is a slide show with the characteristics of a theme but also with sample content on several slides. You ca edit the content or remove individual slides you do not need to create your presentation. You can design elements with the Slide Master to create custom designs. What is it?

Template

What contains a predefined theme, sample text, and graphics on a slide or slide background to guide you as you develop your content?

Template

Explain the difference between a theme and a template.

Templates contain both themes and content. Themes do not contain any content slides. Templates can only be use when a new presentation is first created. Themes can be added or changed at any time.

What are the three main options available to customize a WordArt's format?

Text Fill, Text Outline and Text Effect.

Font

Text ____ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.

True

Text boxes allow you to place text anywhere on a slide (t/f)

Which command is used to change the orientation of text in a text box to vertical, stacked, or rotated?

Text direction

Entering text in a cell

Text is left-aligned. If text is wider than the width of the cell, it goes to next. If next cell isn't empty, overflow text is hidden.

Hyperlink

Text or graphics that, when clicked, take you to another location or file, or to a Web page on the Internet or on your organization's intranet.

Data p. 54

Text or numbers in a cell.

Data (Excel)

Text or numbers in a cell.

What types of items on a slide can be defined as hyperlinks?

Text, shapes, images

Tap or click the texture button to display the ____ gallery , as shown in the accompanying figure

Texture

Deselect

Tha action of canceling the selection of an object or block of text by clicking outside of the selection.

True

The Autofill automatically fill cells with information based on other selected cells. (T/F)

Format as you type

The Excel feature by which a cell takes on the formatting of the number typed into the cell.

format as you type p. 199

The Excel feature by which a cell takes on the formatting of the number typed into the cell.

Accounting Number Format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthesis for negative numbers.

Accounting Number Format

The Excel number format that applies a thousand comma separator where appropriate, inserts a fixed U.S. Dollar sign aligned at the left edge of the cell, applies two decimal places, and leaves a small amount of space at the right edge of the cell to accommodate a parenthsis for negative numbers.

What would you click to open the Paragraph dialog box?

The Expansion arrow in the Paragraph section on the Home Tab

Mini toolbar

The Italic button is located on the ____.

Where would you click in PowerPoint to see the layer order for all the objects on a slide?

The Layer Pane

True

The Margin controls adjust the amount of white space around the outside of the printed page. (T/F)

The amount of white space around the outside of the printed page

The Margin controls adjust what part of the worksheet?

Hidden

The Notes pane is ____ until you tap or click the Notes button on the status bar to open the pane.

(PICTURE TOOLS FORMAT tab | Picture Styles group)

The Picture Effects button is located on the ____, as shown in the accompanying figure.

(PICTURE TOOLS FORMAT tab | Picture Styles group)

The Picture Styles gallery, shown in the accompanying figure, is displayed by clicking the More button located on the ____.

Associated PivotTable report

The PivotTable report in a workbook that is interactive with its PivotTable chart.

Where is the Notes pane in PowerPoint?

The Review Tab

Insert Media

The ____ dialog box allows you to search for and insert files from a range of online sources.

Insert Pictures

The ____ dialog box allows you to search for clip art by using descriptive keywords.

Find and Replace

The ____ feature automatically locates specific text and then replaces it with desired text.

Title slide

The ____ introduces the presentation to the audience.

Pixels p. 57

The abbreviated name for a picture element.

Document Theme

The accompanying figure illustrates the screen you use to choose a ____.

Double-click

The action of clicking the left mouse button two times in rapid succession.

Drag

The action of holding down the left mouse button while moving your mouse.

Embed

The action of inserting something into the same worksheet that contains the data used to create the chart.

Drag and drop

The action of moving a selection by dragging it to a new location.

drag and drop p. 121

The action of moving a selection by dragging it to a new location.

paste p. 143

The action of placing text or objects that have been copied or moved from one location to another location.

Click

The action of pressing the left button on your mouse pointing device one time.

Explode

The action of pulling out one or more pie slices from a pie chart for emphasis.

explode p. 185

The action of pulling out one or more pie slices from a pie chart for emphasis.

Center alignment

The alignment of text or objects that is centered horizontally between the left and right margin.

Interest

The amount charged for the use of borrowed money.

Revenue

The amount of money a business receives from the sale of a product

Category axis

The area along the bottom of a chart that identifies the categories of data; also referred to as the x-axis.

Numbered row headings p. 53

The area along the left edge of a worksheet that identifies each row with a unique number.

Backstage tabs

The area along the left side of backstage view with tabs to display various pages of commands.

Status bar p. 52

The area along the lower edge of the Excel window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculations such as Sum and Average display.

plot area p. 207

The area bounded by the axes of a chart, including all the data series.

Active area

The area of the worksheet that contains data or has contained data--it does not include any empty cells that have not been used in the worksheet.

Address bar

The bar at the top of a folder window with which you can navigate to a different folder or library, or go back to a previous one.

Chart Elements box

The box in the Chart Tools tabs from which you can select a chart element so that you can format it.

chart elements box p. 209

The box in the Chart Tools tabs from which you can select a chart element so that you can format it.

Placeholder

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text ____.

What would you click to change text to a bulleted list?

The bullet list button in the Home Tab

What's Source area (AKA Copy area)?

The cell being copied. Info goes to Destination area (AKA Paste area).

Left alignment p. 55

The cell format in which characters align at the left edge of the cell; this is the default for text entries and is an example of formatting information stores in a cell.

Active cell

The cell, surrounded by a black border, ready to receive data or be affected by the next Excel command.

Certificate authority

The certificate associated with a digital signature that is issued to the reputable sugnoer. A commercial organization that issues digital certificates, keeps track of who is assigned a certificate, signs ertificates to verify their validity, and tracks which certificates are revoked or expired.

Arrange All

The command that tiles all open program windows on the screen.

And comparison operator

The comparison operator that requires each and every one of the comparison criteria to be true.

B-The headings would be pasted, and overwrite the kitchen data.

The data in the dotted box was copied into the clipboard. What would be the result if you did a PASTE command in the selected cell?

Displayed value

The data that displays in a cell.

Displayed value p. 59

The data that displays in a cell.

Underlying value p. 59

The data that displays in the Formula Bar.

.xls file name extension

The default file format used by Excel 2010 to save an Excel workbook.

General format

The default format that Excel applies to numbers; this format has no specific characteristics--whatever you type in the cell will display, with the exception that trailing zeros to the right of a decimal point will not display.

General format

The default format that Excell applies to numbers; this format has no specific characteristics--whatever you type in a cell will display, with the exception that trailing zeros to the right of a decimal point will not display.

Where would you click to delete a comment in the document?

The delete comment button in the Review Tab

Slide Size

The desired length and width of your presentation.

Options

The difference between the effects and the styles is that each effect has several ____, providing you with more control over the exact look of the image.

chart area p. 186

The entire chart all of its elements.

Chart area

The entire chart and all its elements.

Fundamental Accounting Equation

The equation the total assest equal the sume of total liabilities and total stockholders' equity Assets= Liabilities + Stockholders' Equity

Sale

The exchange between a business anda consumer where the business provides a customer a product and the business receives money or money substitutes

What would you click in the Dialog box to double-space every line in the paragraph?

The expansion arrow in the line spacing section

What would you click to see the list of Microsoft Word Styles?

The expansion arrow on the list of Microsoft Font Styles in the Document Formatting section in the Deign Tab.

What would you click to see the "Duplicate Selected Slide" command?

The expansion arrow on the new slide button in the home tab.

Where would you click in the Dialog box to indent the first line of a paragraph?

The expansion arrow under special in the indentation section of the dialog box

Interest

The expense of using borrowed money for a period of time

Underlying formula p. 61

The formula entered in a cell and visible only on the Formula Bar.

value after increase = base x percent for new value p. 200

The formula for calculating the value after an increase by multiplying the original value--the base--by the percent for new value (see the percent for new value formula).

Chart p. 66

The graphic representation of data in a worksheet; data presented as a char is usually easier to understand than a table of numbers.

Chart (Excel)

The graphic representation of data in a worksheet; data presented as a chart is usually easier to understand than a table of numbers.

Where would you click to manually adjust the height of the table's first row?

The height options in the Format Tab for the Table

Cell reference

The identification of a specific cell by its intersecting column letter and row number.

Cell address

The identification of a specific cell by its intersecting column letter and row number; another name for a cell reference.

Cell reference

The identification of a specific cell by its intersecting column letter and row number; another name for cell address.

Cell p. 51

The intersection of a column and a row.

Cell

The intersection of a column and row.

Cell

The intersection of a row and a column

Sheet tabs p. 52

The labels along the lower border of the Excel window that identify each worksheet.

sheet tab p. 138

The labels along the lower border of the Excel window that identify each worksheet.

Category labels

The labels that display along the bottom of a chart that identifies the categories of data; Excel uses the row titles as the category names.

Category labels

The labels that display along the bottom of a chart to identify the categories of data; Excel uses the row titles as the category names.

Where would you click to select the first row on a table?

The left most cell in the first row of that table

Column heading

The letter that displays at the top of a vertical group of cells in a worksheet; beginning with the first letter of the alphabet, a unique letter or combination of letters identifies each column.

KeyTips

The letter that displays on a command in the Ribbon and that indicates the key you can press to activate the command when the keyboard control of the Ribbon is activated.

Layout section

The lower portion of the PivotTable field list that

rate = amount of increase/base p. 196

The mathematical formula to calculate a rate of increase.

order of operations p. 197

The mathematical rules for performing multiple calculations within a formula.

Where would you click to select a whole table?

The move all button on the table

Where would you click to move a text box?

The move all button on the text box

Row heading p. 54

The numbers along the left side of an Excel worksheet that designate the row numbers.

What happens to the original information when it is copied to the clipboard?

The original information remains unchanged.

Chart styles p. 69

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have a flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light.

Chart style

The overall visual look of a chart in terms of its graphic effects, colors, and backgrounds; for example, you can have flat or beveled columns, colors that are solid or transparent, and backgrounds that are dark or light.

What would you click to activate the Format Painter?

The paint brush button under the cut and copy buttons in the Home Tab

percent rate of increase p. 195

The percent by which one number increases over another number.

Alignment

The placement of paragragh text relative to the left and right margins.

Value

The price someone is willing to pay for an item

Worksheet p. 51

The primary document that you use in Excel to work with and store data, and which is formatted as a pattern of uniformly spaced horizontal and vertical lines.

sort p. 131

The process of arranging data in a specific order based on the value in each field.

what-if analysis p. 189

The process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.

Filter

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.

filter p. 131

The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify.

Auditing

The process of examining a worksheet for errors in formulas.

navigate p. 138

The process of exploring within the organizing structure of Windows.

Drag and Drop

The process of moving a slide object to a new location using the mouse pointer is called ____.

Extracting

The process of pulling out multiple sets of data for comparison purposes.

Accounting

The process of recognizing, measuring, recording, and reporting information about a business

Encryption

The process of restricting access to files by scrambling the contents with a program.

Scaling p. 75

The process of shrinking the width and/or height of printed output to fit a maximum number of pages.

Collaboration

The process of working jointly with others.

Financial Accounting

The processs of recognizing, measuring, recording, and reporting information about a business's transactions to stakeholders outside the business, including stockholders and lenders

True

The quickest way to enter a function in a cell if you already know the name of the function is to directly enter the function in the cell. (T/F)

Economies of Sclae

The reductions in unit cost achieved by producing a large volume of a unit

Aspect Ratio

The relationship between the width and height of a slide. It is written as a ratio of width to height. Width always comes first

Error Value

The result of a formula that Excel cannot evaluate correctly.

Profit

The revenue from a sale less than the cost of the sale

Generally Accepted Accounting Principles (GAAP)

The rules, principals, and concepts established by the accounting profession that govern financial accounting

Where would you click in PowerPoint to create a section in a presentation?

The section button in the Home tab

Command dialog boxes

The set of dialog boxes that includes Open, Save, Save as, which are provided by the Windows programming interface, and which display and operate in all of the Office programs in the same manner.

tick marks p.208

The short lines that display on an axis at regular intervals.

3-D

The shortened term for three-dimensional, which refers to an image that appears to have all three spatial dimensions--length, width, and depth.

3-D p. 183

The shortened term for three-dimensional, which refers to an image that appears to have all three spatial dimensions--length, width, and depth.

Retained Earnings

The stockholders' equity that is the result of the business haing net income, or net earnings, that have been retained in the business

Common Stock

The stockholders' equity that is the result of the owners of the business investing money for other assests into the business

Proxemics

The study of space

Detail data

The subtotaled rows that are totaled and summarized; typically adjacent to and either abiove or to the left of the summary data.

Arithmetic operators

The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Arithmetic operators

The symbols +, -, *, /,%, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Operators p. 80

The symbols with which you can specify the type of calculation you want to perform in an Excel formula.

Info tab

The tab in the Backstage view that displays information about the current file.

paste area p. 143

The target destination for data that has been cut or copied using the Office Clipboard.

Point and click method p. 61

The technique of constructing a formula by pointing to and then clicking cells; this method is convenient when the referenced cells are not adjacent to one another.

Additive

The term that describes the behavior of a filter when each additional filter that you apply is based on the current filter, and which further reduces the number of records displayed.

Ascending

The term that refers to the arrangement of text that is sorted alphabetically from A to Z, numbers, sorted from lowest to highest, or dates and times sorted from earliest to latest.

Descending

The term that refers to the arrangement of text that is sorted alphabetically from Z to A, numbers sorted from highest to lowest, or dates and times sorted from the latest to earliest.

Default

The term that refers to the current selection or setting that is automatically used by a computer program unless you specify otherwise.

General fund

The term used to describe money set aside for the normal operating activities of a gonvernment entity such as a city.

Risk

The uncertainty that could result in an outcome not desired

Field section

The upper portion of the PivotTable Field List that contains the names of all the field names--the column titles in the source data.

Compound criteria

The use of two or more criteria on the same row--all conditions must be met for the records to be included in the results.

Future calue (Fv)

The value at the end of the time periods in an Excel function; the cash balance that you want to attain after the last payment is made--usually zero for loans.

major unit p. 208

The value in a chart's value axis that determines the spacing between tick marks and between the gridlines in the plot area.

Arguments

The values that an Excel function uses to perform calculations or operations.

arguments p. 118

The values that an Excel function uses to perform calculations or operations.

What is a transition?

The visual effect of movement that occurs when one slide changes into another slide

Detail sheets

The worksheets that contain the details of the information summarized on a summary sheet.

detail sheets p. 152

The worksheets that contain the details of the information summarized on a summary sheet.

Fred wants to give his FBLA presentation a designer-quality look — a look that includes one or more slide layouts with coordinating colors, a matching background, fonts, and effects. Fred will want to apply which PowerPoint feature to his presentation?

Theme

What is a predefined combination of colors, fonts, and font effects, that can be applied to your presentation?

Theme

What is a slide show with only background graphics and text treatments but no content? Different layouts control where slides are positioned. You can edit the content or remove individual slides you do not need to create your presentation. You can design elements with the Slide Master to create custom designs

Theme

When you begin creating a new PowerPoint presentation, you need to select a ____

Theme

Janice wants to create a presentation that contains bold fonts, colors and effects. Which group on the design tab will be best suited for this task?

Themes

PowerPoint displays many ___ that are varied and appealing and give you an excellent start designing a presentation.

Themes

PowerPoint has built-in _____________ that provide a unified look for all the slides in a presentation.

Themes

Describe how you would display templates related to creating a greeting card?

There are several methods for doing this task, but the most direct is to start a new presentation and then search for "greeting card templates" in the Search box.

What word processing tool can help you find synonyms to improve your word choice?

Thesaurus

Why should you resize a picture using the corner sizing handles?

They can change both horizontal and vertical dimensions at the same time

How can shapes enhance your presentation?

They can help add flair and/or emphasize some information.

Firms that compete in the global marketplace typically face two types of competitive pressure that affect their ability to realize lo realize location economies and experience effects, and to leverage products and transfer competencies and skills within the enterprise

They face pressure for cost reductions and pressure to be locally respnsive

What is the benefit of adding a theme to a presentation?

They provide a unified look for all the slides in the presentation

What is the main advantage of using templates and other presentations to create a new presentation?

They save you time designing slides and allows you to focus more on the content

Horizontal Category axis (x-axis)

This displays along the bottom of the chart to identify the category of data.

Roman Numerals

This is NOT a number formats in Microsoft Excel?

Templates

This is an advantage to create a new presentation because it saves you time desinging slides and allow you to focus more on the content.

You can use ____ opinions to repeat a background image many times vertically and horizontally on a slide

Tiling

. Steve is ready to begin developing the slides for his presentation. Which is the default slide layout for slide 1 of a new presentation?

Title Slide

PowerPoint has several slide layouts that can be used in presentations. When would you use the following layouts?

Title Slide: Just has a placeholder for a title and subtitle Title and Content: It has a placeholder for a slide title and a body placeholder for bulleted text Section Header: Has a title and subtitle placeholder; usually has a different look than the title slide Comparison: Works best for comparing two lists because it provides a heading area above each content placeholder Picture and Caption: used when you want to insert a picture with a description

The ___ introduces the presentation to the audience

Title slide

When you open a new presentation, a slide with the default ___ layout appears

Title slides

Sort

To arrange data in alphabetical or numerical order.

Correct (DRAWING TOOLS FORMAT tab | Size group)

To change a selected shape's height or width to a specific value, type the value in the Height or Width text boxes on the ____.

Why use PV function?

To determine how much the borrower of the loan still owes at the end of each year. Formula =12*(18-1) where 18 is life of loan in years & 1 is amount owed after first year. Result will be shown in months remaining (204)

INDEX & MATCH functions

To find a name & see how much he made. =INDEX (A9:J21(range where to look. Can be multiple enclosed in () & separated by comas), MATCH (R11 (cell where I wrote person's name),A9:A21 (cells in column C all names),0 (match exactly),8(cells in column C #'s))

Replace

To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box.

Function of Conditional formatting

To make a row or cell stand out when the info in them meet the conditions I specify via Conditional Formatting (Home tab|Styles)

Format Painter

To save time and avoid formatting errors, you can use the ____ to apply custom formatting to other places in your presentation quickly and easily.

Why use Line chart?

To show changes in data (trends) over time.

Hiding portions of a workbook

To show only what a user needs to see

SUMIF function

To sum values in a range =SUMIF(J9:J21 (selected range),"A" (criteria),H9:H21 (range of cell C which to compare criteria)

Display automatic subtotals

To summarize data in table

A slide ___ is a special animation effect used to progress form one slide to the next slide In a slide show

Transition

___help one slide flow gracefully into the next during a slide show

Transitions

____ allows you to see through the background, so that nay text on the slide is visible.

Transparency

You can change the transparency of a picture used as a slides background with the ____

Transparency Slider

Pie chart, doughnut, radar charts

Trend lines cannot be used with these charts

Transnational strategy

Trying to simultaneously achieve low costs through location economies, economies of scale, and learning effts

Range p. 58

Two or more selected cells on a worksheet that are adjacent or nonadjacent; because the range is treated as a single unit, you can make the same changes or combination of changes to more than one cell at a time.

Create Percent series using Fill Handle

Type % value in one cell, type another % value increased by 0.25 (or any increment I want)-- Use Fill Handle to drag to other cells

Rename "C1" into "expenses"

Type expenses under C1

Continue to save the workbook

Type in July, then choose save

Filling multiple cells C same value

Type in the value-- Select desired range for value to appear-- Fill button(Home tab| Editing group-- Select "Down"

Row banding

Type of formatting where adjacent rows have different formatting for each row in a table to be distinguished from other rows (striped look)

When would you use copy and paste?

Use copy and paste to reuse information

When would you use cut and paste?

Use cut and paste to move information between slides

Cloud computing

Use of Web servers of a third-party provider on the Internet to store files and run applications.

When would you use slide notes?

Use slide notes to add information you want to remember to say during your presentation.

=6

Using the correct order of operations, what does this formula equal? =(4-2)*6/2.

=8

Using the correct order of operations, what is the does this formula equal? =16/4*2.

Consumer surplus per unit is equal to

V-P

When you click a theme, a dialog box opens where you can choose from different color combinations called _________________.

Variants

____ are the alternate designs that exist for each theme

Variants

Chart types

Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.

Chart types p. 67

Various chart formats used in a way that is meaningful to the reader; common examples are column charts, pie charts, and line charts.

Hides data that you do not want to see

What does filtering data in a spreadsheet do?

Combine 2 or more cells into a single cell.

What does it mean to merge cells?

=SUM(B3:B6)

What function should be entered to calculate the TOTAL budget?

=MIN(B3:B7)

What function would you use to find the least expensive item?

The column doesn't appear, but the data is still there.

What happens when you hide a column in Microsoft Excel?

Large images

What has more of a visual impact on a slide?

Each rectangle in a spreadsheet.

What is a cell?

Clip art

What is a collection of illustrations and photographs that can be searched to find images for your presentation?

Comma

What is a common delimiter for data?

Theme

What is a predefined combination of colors, fonts, and font effects, that can be applied to your presentation?

F3:F26

What is the argument in this function? =AVERAGE(F3:F26)

F3:F26

What is the argument in this function? =MAX(F3:F26)

B11:H14

What is the argument in this function? =COUNT(B11:H14)

Page Break Preview

What is the best View for planning how your Excel worksheet data fits on a printed page?

=SUM(B2:B5)

What is the best formula for finding the total value for cells B2 through B5?

(HOME tab | Font group)

What is the correct path to the Bold button?

align all objects left

What is the easiest way to have all the text boxes line up with the first text box that is on the left?

Comma

What is the most common type of delimiter?

4

What number would the function "=COUNT(A2:A7)" return?

Format

What ribbon tab would you select to change to shape style of a text box?

Insert

What ribbon would you select to create WordArt?

Insert

What ribbon would you select to create a PowerPoint hyperlink?

Insert

What ribbon would you select to create a photo album?

Insert

What ribbon would you select to create a text box?

Insert

What ribbon would you select to create an action button?

Ctrl+X then Ctrl+V

What sequence of keyboard shortcuts would you use to MOVE information from one cell to another?

Slide layout

What should you change if you want one particular slide to have a different arrangement of text box placeholders?

Find the five top sales people in a company

What statement is NOT an example of a what-if analysis?

$

What symbol is used to designate an absolute cell reference?

Number

What tab group would you use to change the format of cell A2 to match cell A3?

Formulas

What term refers to mathematical equations used in Excel to perform calculations?

Line

What type of chart best shows how data changes over time?

The worksheet will be MOVED

What will happen when you drag and drop a worksheet tab into another workbook WITHOUT holding the Ctrl key down?

It will be copied after "Sheet3" in the Sample workbook

What will happen with the selected worksheet when "OK" is clicked in the "Move or Copy" dialog window?

Global Web

When different stages of the value chain are dispersed to those locations around the globe where value added is maximized or where costs of value creation are minimized

Universal needs

When the tastes and preferences of consumers in different nations are similar if not identical

False

When using conditional formatting on a cell, highlighting negative numbers by using red text does not occur. (T/F)

You want to highlight negative numbers by using red text.

When would you use conditional formatting on a cell?

Title and Content

When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.

Theme

When you begin creating a new PowerPoint presentation, you need to select a ____.

True

When you hide a column in Microsoft Excel, the column doesn't appear, but the data is still there. (T/F)

20

When you install PowerPoint, the default setting allows you to reverse up to the last ____ changes by tapping or clicking the Undo button on the Quick Access Toolbar.

Title Slides

When you open a new presentation, a slide with the default ____ layout appears

BACKSPACE

When you type the wrong character, you can press the ____ key to erase all the characters back to and including the one that is incorrect.

Above the worksheet, the third cell and the longest. (Letter C)

Where is the Formula Bar?

on the bottom

Where is the Notes pane on a document

Font dialogue area, small box showing borders

Where would you click on the Home tab to access controls for adding borders to cells?

Box on lower right border

Where would you click to AutoFill the formula down the rest of the column?

Font dialogue area, paint can

Where would you click to add a fill color to a cell?

Plus sign

Where would you click to create a new worksheet?

paintbrush

Where would you click to activate the Format Painter?

layout

Where would you click to change the slide layout?

enter

Where would you click to create a new slide if the cursor was at the end of the slide name?

new slide

Where would you click to create a new slide?

section

Where would you click to create a section in a presentation?

indent left

Where would you click to decrease the indent of the selected line?

down arrow on new slide

Where would you click to see the "Duplicate Selected Slide" command?

selection pane

Where would you click to see the layer order for all the objects on a slide?

Page Layout

Which Page View shows how a worksheet will appear on a printout?

Page Break Preview

Which Page View shows where the worksheet is split into separate pages for printing?

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to determine how your company can stay profitable by varying the commission rates for your 12 sales people.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to keep a car loan under $400 a month.

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to payback a student loan in 10 years

Goal Seeking

Which What-If Analysis tool would you use to solve the following problem? You want to figure out how to payback a student loan in 10 years.

Data Table

Which What-If Analysis tool would you use to solve the following problem? You want to find out what interest rate you have to get in order to keep your house payment under $1200 a month.

The image that shows ragged both right and left

Which alignment option would you click to center the text in the middle of the selected cell?

Click and drag the column's boundary line to the desired width. Double-click the column's boundary line. Right-click the column header and then click Column Width.

Which are ways to change the column width in Excel?

Slide show

Which button allows you to preview the presentation as the audience will see it?

Insert picture

Which button from the File command would you use to add an imge saved on your computer or a storage device?

Monthly Payment!A10

Which cell reference to another worksheet will RESULT in an error?

Number category, far right tool

Which command would you click to remove the decimal place from the currency in the selected cells?

Insert copied cells

Which command would you use, if you wanted to move row 6 in between row 3 and 4, without overwriting any data.

open book

Which control would you click to show the Reading View?

Text file

Which files can be used to import data into Excel?

=$A$10/100

Which formula uses absolute cell references?

=$A10/B5

Which formula uses absolute cell references?

=B3/$B$7

Which formula would you enter into C3, and then AutoFill into C4-C6, to calculate the percent sales (Pct.) for the regions?

=MAX(A2:B5)

Which function would you enter to return the number 45.1?

The data header information must be bold

Which is NOT necessary for organizing data to make it easier to sort?

Browse in the Function Library group and/or Click Insert Function and enter a search phrase

Which is a way to search for a function?

Ctrl

Which key should you press if you wanted to select cells that are noncontiguous or not beside one another?

Ctrl+U

Which keyboard shortcut underlines text in a cell?

Ctrl+C

Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?

Ctrl-C

Which keys would you press to copy worksheet data into the clipboard?

Ctrl-V

Which keys would you press to paste worksheet data into the clipboard?

Ctrl-A

Which keys would you press to select all the data on a worksheet?

layer 1

Which layer is the layer on the top?

Currency

Which number format would you want to apply to a cell showing the total sales for the month?

Currency

Which number formats would you want to apply to a cell showing the total sales for the month?

Formulas

Which of the following DOES NOT have to be considered when looking at the page layout before printing a worksheet?

Themes

Which of the following PowerPoint features is the best for creating a common look and feel for a presentation?

F5

Which of the following keys can you press to run a slide show starting with slide 1?

In the header

Which of the following would be the best location to place your name on a spreadsheet?

Landscape

Which page orientation displays more worksheet columns?

Portrait

Which page orientation displays more worksheet rows?

shape styles

Which ribbon group is used to change the style of a text box?

adjust

Which ribbon group would you use to make an image match the look and feel of the slide background?

horses, ducks, dogs, cats

Which set of data is in descending order?

tab

Which shortcut key would you press to indent a line?

Tab shift

Which shortcut keys would you press to decrease the indent of a selected line?

You can use borders to create a group of cells or make specific cells stand out.

Which statement is true?

Insert

Which tab would you click to create a Table?

File

Which tab would you use to access the Print controls?

Relative

Which type of cell references are automatically updated when it is copied?

Absolute

Which type of cell references are locked and NOT automatically updated when it is copied?

Outline View

Which view in PowerPoint is useful for creating an outline?

Slide sorter

Which views show thumbnails (smaller versions) of a presentation's slides, making it easy to rearrange them?

Text and graphics

WordArt is a combination of _____.

____ allows you to type new text or convert existing text to WordArt

WordArt styles

What are components of a chart?

X axis, Y axis (vertical axis, numbers), Legend (represents rows), Data series (info set that determines the sizes of pie pieces).

Can Templates and Themes be customized?

Yes

False

You access the hide/unhide command for a group of selected cells by left clicking on the selected cells. (T/F)

Press Ctrl+Z

You accidentally delete a large portion of you spreadsheet. How do you get the information back?

True

You can change the chart type even after it has been created. (T/F)

Transparency slider

You can change the transparency of a picture used as a slide's background with the ____.

What are some options in PowerPoint for editing/customizing a Photo Album?

You can customize the number of pictures on a slide and add slide titles. You can add captions to pictures. You can add shapes and shapes with text to pictures.

CTRL+M

You can insert a new slide by pressing the ____ keyboard shortcut keys.

CTRL+ENTER

You can move the insertion point into the next text placeholder by pressing the ____ keyboard shortcut keys.

True

You can rename a worksheet by double-clicking the worksheet tab. (T/F)

True

You can use borders to create a group of cells or make specific cells stand out. (T/F)

False

You can use the Formulas Tab to change the Excel View, to hide Heading, Gridlines and the Ruler.

True

You double-check formulas in a worksheet by showing formulas in a print-out. (T/F)

Pie

You have been tracking your home expenses in different categories. You want to see what percentage of the total each category represents. Which type of chart would be best for this purpose?

Changed alignment

You have decided to center the text within a cell. What have you done?

Bar

You want to chart the average summer time temperatures of the 20 hottest cities in the United States. Which type of chart would be best for this purpose?

Bar

You want to compare the batting average of every baseball player on the team. Which type of chart would be best for this purpose?

Bar

You want to compare the batting average of every baseball player in the league. Which type of chart would be best for this purpose?

Column

You want to compare the shooting percentage of the five starters on the basketball team. Which type of chart would be best for this purpose?

Line

You want to show the daily stock price of a company over the last 6 months. What type of chart would be best for this purpose?

Line

You want to show the stock price of a company over the last 6 months. What type of chart would be best for this purpose?

____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.

Zooming

Use of square brackets in computational fields in a table

[@column heading]. Brackets are used in tables in formula cells

Pattern fill

____ adds designs that repeat in rows across a slide.

Transparency

____ allows you to see through the background, so that any text on the slide is visible.

WordArt styles

____ allows you to type new text or convert existing text to WordArt.

Variants

____ are the alternate designs that exist for each theme.

Brightness

____ determines the overall lightness or darkness of an entire image.

Graphics

____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.

Courier New

____ is a font that resembles the letters that typewriters produced.

Gradient Fill

____ is one color shade gradually progressing to another shade of the same color or to another color.

hyperlink

a block of text or a graphic that when mouse-clicked takes the user to a new location to an internal or external page

placeholer reading view

a box that can hold either text or a graphic object power point view that is similar to slide show view except it is in a window rathar than filling the entire screen

dialog box

a box that displays additional options box information you can use to execute commands

dialog box

a box that displays additional options or information you can use to execute command

Placeholder

a boxed outline on a slide that can be used to insert text or an object when clicked

ribbon

a broad band that runs across the top of the power point window that organizes commands and tools into an easy to use interface the ribbon was introduced in office 2007

Partnership

a business that has more than one owner, where for legal and tax purposes, the business and the owners are considered the same

action

a button or text block programmed to perform a specific action such as jumping to a slide or staring a program

A journal provides

a chronological record of transactions

footnote

a citation in a document placed at the bottom of the page in the document on which the citation is located a footnote is foratted as single spaced with hanging indent and double spaced between each footnote according to the mla guidelines

endnote

a citation in a document placed at the end of the document in which the citation is located an endnote is formatted as double spaced with no hanging indent according to the mla guidelines

Selecting the Blank Presentation option allows you to start a presentation from ___________

a clean slate

cut

a command in word that removes selected txet from the original location and place the deleted text in the clipboard collection

undo

a command that allows users to cancel or undo their last command or action

replace

a command that enables users to replace one word or phrase with another

paste

a command that pastes txet from the clipboard to a new location in the original document or now document

repeat

a command that repeats a user,s last action

chart element

a component that completes or helps clarify the chart

live preview

a feature that enables you to see a preview of an option when you hover the mouse pointer over it

wordart

a feature used to turn text a formatted graphic

workbook

a file containing one or more worksheet in excel

monospaced

a font in which all of its characters take up the same amount of horizontal space

proportional space

a font that does not have the horizontal spacing varies

sans serif

a font that does not have the small line extensions on its characters

serif

a font that has small lines at the beginning and end of characters and that is usually used with large amounts of text

block style

a format style that aligns text along the left margin

odject zoom

a function that allows a user to zoom in on odject such as tables charts or images while in read mode

AutoSum

a function that automatically adds selected cells

Chart

a graphic representation of values used to identify trends and contrasts in data

action button

a graphic that serves as a hyperlink to jump to a location or perform a specific action such as jumping to a slide or starting a program

organization chart

a graphic that shows the relationships between personnel or departments in an organization

data table

a grid that contains the data source values and labels

data series

a group of related data points that display in row(s) or column(s) in the worksheet. must use the same scale. do not include total or averages.

custom show

a group of sildes in a presentation that can be shown separately from the presentation

numbered ilst

a group of steps procedures or actions that are listed in numerical order

x-axis

a horizontal border that provides a frame of reference for measuring data horizontally.

rows

a horizontal line of cells in a table

legend

a key that identifies the color, gradient, picture, texture, or patter assigned to each data series in a chart

Note Payable

a liability repersented by a written promise that requires future payment

caption

a line of text that describes an object

trendline

a line that depicts trends or helps forecast future data

Border

a line that indicates a boundary of a cell or range

menu

a list of options

bibliography

a list of sources referred to in the document and is placed at the end of the document also referred to as a works cited page

works cited

a list of sources referred to in the document and is placed at the end of the document also referred to as a works cited page

Row Heading

a number at the far-left side of a row that can be clicked to select the entire row of cells

portrait orientation

a page orientation that is taller than it is wide

landscpe orientaton

a page orientaton that is wider than it is tall

slide sorter view

a power point view that displays all the slides in a presentaion on a single screen

notes page view

a power point view that shows one slide at a time along with any notes that are associated with the slide

slide show

a power point view that view lets you preview your presentation on the so you see it the way your audience will see it

layout

a predefined arrangement of placeholers for text or objects such as charts or pictures

Series

a predictable list of sequential numbers, dates, times, or text

Recording the adjusting entry for depreciation has the same effect as recording the adjusting entry for

a prepaid expense

slide master

a slide that stores information about the formats applied in a presentation such as theme fonts layouts and colors

sparkline

a small line, column, or win/loss chart contained in a single cell. present a condensed, simple, succinct visual illustration of data. does not include a chart title or axis labels. helps your audience understand data quickly without having to look at a full-scale chart

white space

a space batween pages in a document

static evaluation

a statement that fails to recognize change. common in parents who are in prison

clipboard

a storage area that temporarily stores the items for a user to paste in another location of the document or office file

paragraph styles

a style in which the formats are applied instantly to all text in the paragraph where the insertion point is located whether or not text is selected

character styles

a style that is applied to individual characters or words that users have selected

mixed punctuation

a style that requires a colon after the sautation and a comma after the salution and a comma closing

open punctuation

a style that requires no punctuaiton after the salutation or the closing

An account consists of

a title, a debit side, and a credit side

command

a tool such as an icon a button or a list that tells power point to pertform a specifc task

scroll bars

a tool that allows the user to move up or down within the document

scroll buttons

a tool that allows user to move up or down one ilen at a time or more quickly if users click and hold the button

scroll box

a tool that allows users to move horizontally and vertically through a document more quickly than the scroll buttons or to see a screen tip displaying a user,s positiob in the document

navigation pane

a tool that appears in the left side of the window when you select its command in the show command group

word wrap

a tool that automatically wraps text to the next line as it reaches the right margin of the document

preview

a tool that enadles users to visually check your document for errors before printing

ribbon

a tool that is divided into eight that contain groups

backstage view

a tool that offes quick access to commands for performing many file management tasks all displaed in a single navigation pane that can be customized to meet users needs

gridlines

a tool that provides a grid of vertical and horizontal lines that help you alogn graphics and other objects in a document

format painter

a tool to copy character and paragraph formatting

quick access toolder

a toolder that contains commands that users use more often such as save undo and rede

y-axis

a vertical border that provides a frame of reference for measuring data vertically.

grayscale group

a viewing mode in which there are on colors only shades of gray task specific group divded among the command tads appropriate to the work a user currently performs

smart art graphic

a visual representation of information

chart

a visual representation of numerical data that compares data and helps reveal trends or patterns to help people make informed decisions. depicts data in a clear, easy-to-interpret manner and contains enough data to be useful without overwhelming your audience

A T- account

a way of depicting the basic form of an account

indexing

a way to avoid allness. using statements to separate one situation, person or example from another.

multi-selecton

a word feature that enables users to select multiple itms of the text that are not adjacent

Which of the following statements is TRUE? a) Action Buttons are predefined shapes b) Hyperlinks and Action Buttons perform different types of actions c) Only text objects and shapes (such as arrows) can be defined as Hyperlinks

a) Action Buttons are predefined shapes

Which Ribbon group would you use to make an image match the look and feel of the slide background? a) Adjust b) Picture Styles c) Arrange

a) Adjust

What steps are used to MOVE text or an image in a Word document? a) Cut and Paste b) Cut and Copy c) Copy and Paste d) Copy and Cut

a) Cut and Paste

If the cursor is at the end of a text in the Slide Sorter of a PowerPoint, what key(s) would you press to create a new slide? a) Enter b) Tab c) CTRL-Enter d) CTRL-N

a) Enter

Researching information is mainly done in what step of the writing process? a) Pre-Writing b) Drafting c) Revising d) Editing

a) Pre-Writing

An account is a part of the financial information system and is described by each one of the following except

an account is a source document

hyperlink

an adderss that refers to another location such as a website a different slide or an external file

table

an arrangement of columns and rows used to organize

dialog box launcher

an arrow in the lower right corner of some command groups on the ribbon that opens a dialog box related to the command group

Accounts Receivable

an assest the represents amounts owed to the business by customers

worksheet

an excel document used to organize numerical data that can then be analyzed or otherwise manipulated

Workbook

an excel file with one or more worksheets

object

an independent element on a worksheet; not located in a specific cell or range

settings

an option that enables users to set document proerties

table of contents

an ordered list of the topics in a document along with the page numbers on which they are found usually located at the beginnig of a iong document

The usual sequence of steps in the recording process is to

analyze each transaction, enter the transaction in the journal, and transfer the information to the ledger accounts

The first step in the recording process is to

analyze the transaction in terms of its effect on the accounts

The usual sequence of steps in the transaction recording process is

analyze, journalize, post to the ledger

inline

another way of displaying comments instead of using balloos on the right is to display them within the paragraphs of text itself

Row

appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window

Column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

plot area

area inside the horizontal and vertical axes

Why is nonverbal communication important in communication?

as little as 7% of communication is verbal. 93% is non verbal

text box

as the name implies a box that holds that you type into it

compromise

attempts to find a middle ground in a conflict. "lose/win, win/lose"

What is the most important piece of information to include in a page header or footer? a) Author name b) Page number c) Date d) Grade

b) Page Number

What Ribbon group is used to change the style of a text box? a) Insert Shapes b) Shape Styles c) WordArt Styles d) Arrange

b) Shape Styles

What button would you click to have the image selected go behind another image?

backward

If a company buys a 700 machine on credit, this transaction will affect the

balance sheet only

Accrued Expenses have

been incurred, not paid, and not recorded

Accrued expenses have

been incurred, not paid, and not recorded

Conversation Narcissism

being a self absorbed listener and focusing just on what you are going to say next.

2 classical dialectical tensions

being autonomous vs being connected (to be close to someone and to be independent) being open vs being closed (desire to disclose things to your partner and desire to have privacy)

listening barriers (7)

being self absorbed unchecked emotions criticizing the speaker differing speech and thought rate information overload external noise

quick style

built-in formatting for text graphics smart diagrams charts wordart pictures tables and shapes

Rachel would like to add a list to one of the slides in her presentation. Which of the following should she use?

bullet text

What would be the best way to make an image more visible while minimally affecting the text box? (While an image is behind the text box) a) Change the layer of the image to the Front b) Decrease the size of the text box c) Change the text box transparency

c) Change the text box transparency

Refining and organizing your writing is done in what step of the writing process? a) Pre-Writing b) Drafting c) Revising d) Editing

c) Revising

What phase of the writing process is it best to have other people review your document? a) Pre-Writing b) Drafting c) Revising d) Editing

c) Revising

What shortcut key(s) would you click in the PowerPoint Slide Sorter to decrease the indent of the selected line? a) CTRL-Shift b) ALT-Shift c) Tab-Shift d) Back Arrow

c) Tab-Shift

In the first month of operations, the total of the debit entries to the Cash account amounted to $1,400 and the total of the credit entries to the Cash account amounted to $800. The Cash account has a

c. $600 debit balance. X Solution: $1,400 dr. - $800 cr. = $600 dr. d. $600 credit balance.

axes

category axis labels and the value axis quantities in increments in column, bar, and the line charts

data point

cell containing a value

Absolute Reference

cell refernence that points to a specific cell and does not change when copied ($B$4)

Resize

change the size of

read mode

changes the page layout of the document and hides the rippons some editing tools are availadle

wildcard

characters to find words or phrases that contain specifc letters or combinatin or letters

embedded chart

chart that is inserted directly in the current worksheet and doesn't exist in a separate file

group

collections of related word commands

Text Color

color that the text appears in in a cell

auto correct

command that automatically completes the text of the current data day of the week and month

Pressures for cost reduction can be particularly intense in industries producing

commodity-type products where meaningful differentiation on non-price factors is difficult and price is the main competitive weapon

column chart

compares data using columns; default chart type

bar chart

compares data using horizontal bars

clustered column sheet

compares groups -- or clusters -- of columns set side by side for easy comparison. facilitates quick comparisons across data series, and it is effective for comparing several data points among categories

pie chart

compares sizes of pieces as part of a whole; used for single series of numbers

line chart

compares trends over even time intervals

scatter chart

compares trends over uneven time or measurement intervals

bar chart

compares values across categories using horizontal bars. horizontal axis displays values and the vertical axis displays categories. preferable when category names are long.

Listening

complex process of selecting, attending to, constructing meaning from, remembering, and responding appropriately to verbal and non verbal messages

inferences

conclusions based on partial information

chart sheet

contains a single chart only; you cannot enter data and formulas

chart area

contains the entire chart and all of its elements, including the plot area, titles, legend, and labels

footer

content that appears on the bottom of the page

header

content that appears on the top of the page

100% stacked column chart

converts individual data points into percentages of the total value. each data series is a different color of the stack, representing a percentage. depicts contributions to the whole

Firms face competitive pressure when they venture into the global marketplace. Companies face pressure from ____ reductions and to be ______ responsive

cost, locally

An account will have a credit balance if the

credits exceed the debits.

What are some conflict triggers? ( 7 elements)

criticism, feeling entitled, perceived lack of fairness, more perceived costs than rewards, different perspectives, stress and lack of rest, dialectical tensions.

Before starting your presentation, you should ________________ a) know the audience b) have a clear goal c) create all of the graphics d) A & B e) All of the above

d) A & B

Under what Ribbon tag would you find the Alignment tool? a) Design Tab b) Transitions Tab c) Animations Tab d) Format Tab

d) Format Tab

If you are looking at a document with read-only protection, which of the following commands would be enabled? a) Font Style b) Review Comments c) Cut and Paste d) None of the Above

d) None of the ABove

embedded

data that has been placed in a desinaton application so that it can be edited with the tools of its original source application

liked

data that has been placed in a desinaton so that it maintains a link with its source file changes to the source file are also made in the liked object

Assets normally show

debit balances

wordart

decorative text that enhances text

A paid dividend

decreases assets and stockholders equity

Ways people use image repair

denial evade responsibility reduce offensiveness corrective action mortification

Orientation

describes the direction of the page or the paper you will print on (landscape or portrait)

polarization

description and evaluation of what you observe in terms of extremes such as good and bad. there is no in between

data labels

descriptive labels that show exact value or name of a data point

denotative meaning

dictionary meaning

Simple conflict

difference stances on the issue, stems from difference in ideas, definitions, perceptions or goals

simple markup

displays a red line near the left margin

category axis

displays descriptive group names or labels to identify data. usually defined by column or row labels in the worksheet

value axis

displays incremental numbers to identify the worksheet values used to create the chart

Status Bar

displays information about the current document

line chart

displays lines connecting data points to show trends over equal time periods. the x-axis displays time, whereas the value axis represents the value. enables you to detect trends because the line continues to the next data point

Name Box

displays the active cell address

original

displays the document in the original version

column chart

displays values in vertical columns where the height represents the value. create to compare values across different categories. most effective when limited to 7 or fewer categories

data point

each value in a cell you select for your chart

tads

eight areae of activity on the ribbon that comtain groups or collections of related word command

Emotional Contagion Theory

emotional expression is contagious and people can "catch" emotions through observation

A negative number that is displayed using the Accounting Number Format is shown with a negative sign, such as -5 or -6.

false

A relative cell reference refers to a cell by its fixed position within the worksheet and is not adjusted when the formula is copied.

false

A summary sheet is used to provide a visual cue about the value of a cell in relationship to other cells.

false

A toggle value is one that is used by a program unless the user changes it.

false

According to Excel's order of operations, addition and subtraction are done before exponentiation.

false

AutoComplete generates and extends a series of values based on the values of other cells.

false

By default, text values entered into a cell are right justified.

false

By default, the plot area and the chart area are filled with different colors.

false

Data that is displayed in a cell is called the underlying value

false

Deleting the contents of a cell also removes the format that has been applied to the cell.

false

Detail sheets display and summarize totals from other worksheets.

false

Each data point is represented in a chart by a legend.

false

Entering the year portion of a date as 40 will be interpreted as the year 2040.

false

Excel does not provide a spelling checker.

false

Excel's Number format leaves a space at the right of the number for a closing parenthesis in case the value is negative.

false

Excel's Paste Options gallery does not include Live Preview.

false

Graphics cannot be placed in a text box.

false

IF is an example of a statistical function

false

In Excel, column headings are made up of a letter and a digit, such as A2.

false

In Excel, numbers are used as column headings

false

Number values are often called labels.

false

Once a pie chart is created, it cannot be rotated.

false

The COUNTIF function takes three arguments.

false

The Excel user can move from one worksheet to another by clicking the data bar

false

The MEDIAN function adds a group of values and then divides the sum by the number of items in the group.

false

The data in an Excel table can only be sorted into ascending order.

false

The only kinds of values that can be entered into a cell are text values and number values.

false

Workbook-level buttons are found along the lower border of the Excel window and identify each worksheet.

false

ou must delete the current value in a cell before you can begin entering a new value.

false

Listener apprehension

fear of misunderstanding or misinterpreting the messages spoken by others

Task oriented listeners

focus on achieving a specific outcome or accomplishing a task. listen for verbs

Localization strategy

focuses on increasing profitability by customizing the firm's goods and services so that they provide a good match to tastes and preferences in different national markets

emblems

generally understood meaning and substitutes a word or a phrase (raising hand in class)

The firm makes a profit so long as P is

greater than C

bulleted list

group of items or phrases that presnt related ideas

What is another term for touch?

haptics

synonym

has the same meaning as another word

percent of new value = base percent + percent of increase p. 200

he formula for calculation a percentage by which a value increases by adding the base percentage--usually 100%--to the percent increase.

regulators

help control interaction or flow of communication (eye contact)

document properties

hidden information such as personal data is added to the document company name and keywords

x-axis

horizontal axis or category axis; contains the names of data groups such as locations, months or years

gridlines

horizontal or vertical lines that span across the chart to help people identify the values plotted by the visual elements

category axis

horizontal or x-axis; contains the names of data groups such as locations, months or years

hyper text transfer protocol http

how data is transferred through the servers

legend

identifies each data marker using a different color

person card

identifies the person who reviewed the document

plagiarism

illegal use of someone.s work

assistant

in an organization chart a person who peports directly to a superionr

suordinates

in an organization chart persons or department who are supordinate to another person or deppartment

top-level shape

in an organization chart the porson or department at the head of the organization

The double-entry system requires that each transaction must be recorded

in at least two different accounts

file tab

in office 2016 the tab that takes you to backstage view to access save print options and other commands

Debits

increase assets and decrease liabilities

A debit to an asset account indicates

increase in the asset

The receipt of cash in advance for a customer

increases assets and liabilities

A revenue generally

increases assets and stockholders equity

header

inforation such as a date slide number or text phrase that appears at the bottom of each slide in a presntation

iooter

inforation such as a date slide number or text phrase that appears at the bottom of each slide in a presntation

The support activities of the value chain provide

inputs that allow the primary activities to occur

The difference between V and P is in part determined by the

intensity of competitive pressure in the marketplace: the lower the intensity of competitive pressure, the higher the price charge relative to V

accommodation

involves giving in to the demands of another "lose-win"

axis titles

labels that describe the category and value axes

text annotation

labels that further describe your data; created using textboxes

After a business transaction has been analyzed and entered in the book of original entry, the next step in the recording process is to transfer the information to

ledger accounts

Critical listeners

listen for errors, inconsistencies, and discrepancies.

analytical listeners

listen to all sides of the issue, wait until they hear all facts before reaching a conclusions

live preview

live preview shows you how your document will look with the selected feature

A company can create more value by

lowering production costs or by making the product more attractive

template

master document that has predefined page layout fonts margins and styles and is used to create new document that will share the same basic formatting

rulers

measuring tools to align text graphics and other elements used within a document

sparkline

miniature chart contained in one cell

affect displays

nonverbal movements and posture that communicate emotions (slouching in chair)

The primary difference between deferred and accrued expenses is that deferred expenses have

not been incurred and accrued expenses have been incurred

Deferred revenue is revenue that is

not earned but the cash has been recieved

Deferred expenses have

not yet been recorded as expenses

Constant value

number, text, dates, or times of day that you type into a cell.

A product's production costs decline by some quantity about each time cumulative

output doubles

allness

over generalizing meaning. making overqualified, untrue generalizations

Rachel wants to add a long quotation to her presentation. What type of text is this?

paragraph text

Theory of image repair

people engage in communicative behavior designed to reduce, redress, or avoid damaging their reputation

Dialectical tensions

peoples desire for 2 things at once

connotative meaning

personal and subjective meaning

180

pi

90

pi/2

60

pi/3

45

pi/4

30

pi/6

reward power

power is based on a persons ability to fulfill and satisfy your needs ex. parents giving you allowance.

expert power

power is based on a persons knowledge and experience. ex. doctors

referent power

power is based on our attraction and admiration to another person, or the charisma a person possesses. ex. looking up to another sibling.

Legitimate Power

power is based on respect for a persons position ex. "because im the boss" or pulling over because a cops lights are on

Coercive power

power is based on the use of sanctions or punishments to influence others. ex. your boss can fire you

A lot of conflict steps from different perspectives on issues such as

power, social issues, personal flaws, distrust, intimacy and personal distance

Which of the following is not part of the recording process?

preparing a trial balance

The appropriateness of each strategy varies given the extent of

pressures for cost reductions and local responsiveness

lock tracking

prevents changes being made to a document the document is protected with a password

Core competencies are typically expressed in what that other firms are unable to duplicate

product offereing

Attaining economies of scale lowers a firm's unit costs and increases its

profitability

The best interpretation of the word "credit" is the

right side of an account

category labels

row and column labels

adaptors

satisfy a personal need to help adapt and respond to an immediate situation (moving chair for group work)

Sapir- Whorf hypothesis

says that language shapes our reality

restricted code

set of words that have particular meaning to a person, group or culture. (screamer=someone who sends an email in all capital letter)

balloons

shaded blocks of text used for command appearing on the right side of the docment

scatter chart

shows a relationship btwn two numerical variables using their x and y coordinates. used to represent data in educational, scientific, and medical experiments

pie chart

shows each data point as a proportion to the whole data series. displays as a circle where the entire pie represents the total value of the data series. each slice represents a single data point Not suitable for multiple data series

stock chart

shows fluctuations in stock changes. high-low-close, open-high-low-close, volume-high-low-close, and volume-open-high-low-close.

area chart

shows how individual volume changes over time in relation to total volume

stacked column chart

shows the relationship of individual data points to the whole category. displays only one column for each category. each category is color-coded for one data series. used for when you want to compare total values across categories, as well as to display the individual category values. disadvantage is the segments within each column do not start at the same point, making it more difficult to compare individual segment values across categories

The normal balance of any account is the

side which increases that account

drop down arrows

small downward pointing arrows next to tools on the ribbon that provide drop down lists with additonal options

sizing handles

small series of dots at the corners and sides of a chart's border, indicate that the chart is selected

confirming response

statement that causes another person to value him or herself more

disconfirming response

statement that causes another person to value him/herself less

The classification and normal balance of the Dividends account is

stockholders equity with a debit balance

Which of the following describes the classification and normal balance of the Retained Earnings account?

stockholders equity, credit

Six primary emotional categories

surprise, fear, disgust, anger, happiness and sadness

nonprinting characters

symols for certain formatting commands that can help users create and edit documents

Social decenteration

taking into account another persons thoughts, values, background and perspective

In recording an accounting transaction in a double-entry system

the amount of the debits must equal the amount of the credits

An accountant has debited an asset account for 1,000 and credited a liability account for 500. What can be done to complete the recording of the transaction?

the amount of the debits must equal the amount of the credits.

live spacing

the amount of vertical space between paragraphs

timings

the amounts of time asigned to each slide before it automatically advances to the nex

ink

the annotations crieatd with the pen and highlighter tools during a slide show

formatting

the appearance of text or objects on a slide

insertion point

the blinking point at the upper-left side of the document where you will begin creating your text

The left side of an account is

the debit side

normal view

the default power point view that lets you focus on an individual slide

slide size

the dimensions of a slide expressed in a ratio such as 4..3 or 16..9

orientation

the direction that material appears on a page when printed

no markup

the document is displayed as a final copy

handout master

the master that controls the layout and elements of handouts

Dividned

the payment of past and current profits, less losses, previously retained in the business

what is kinesics?

the study of human movement and gesture

tab leader

the symbols that appear in a table of contents between a topic and the corresponding page number

presentation tools

the tools and commands that are active during slide view

Fill Handle

this is the name of the small black square that displays in the bottom right corner of the active cell

thumbnails

tiny images of the document pages

Select

to choose or highlight a row, column, cell or range

Why should you ask questions during a presentation?

to engage the audience

demote

to make an item subordinate to another iteem

promote

to make an item superior to another item

Which one of the following is not a part of an account

trial balance

A chart layout may include a number of chart elements such as title, legend, and labels for the columns.

true

A function is a predefined formula.

true

A group of cells that Excel treats as a single unit is called a range.

true

A pie chart can only be based on one data series.

true

A range can be made up two or more nonadjacent areas on a worksheet.

true

A value or expression that can be evaluated as true or false is called a logical test.

true

Absolute cell references are indicated by the $ symbol.

true

All Excel formulas begin with the equal sign (=).

true

Cell contents are either values or formulas.

true

Clicking a command that is followed by an ellipsis will cause a dialog box to display

true

Data within a cell can be displayed rotated to draw attention to the data.

true

Excel allows the user to delete the formatting of a cell without deleting the contents of the cell

true

Excel's Formula Bar displays the underlying value of the active cell

true

Excel's NOW function returns the date and time, which it retrieves from the computer's clock and calendar.

true

Formatting marks represent certain keystrokes in a document, but do not display when the document is printed.

true

Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the =.

true

If a value is changed in a cell, Excel recalculates all formulas that reference that cell.

true

Logical functions are used to test for specific conditions.

true

MIN and MAX are examples of statistical functions.

true

One way a user can enter a formula is to use the point and click method.

true

Scaling allows the user to indicate the maximum number of pages to be used when printing a worksheet.

true

Text values usually are used to provide information about the numbers displayed in worksheet cells.

true

The AutoFill feature will continue a series based on the values placed in two or more consecutive cells.

true

The IF function returns one value if a logical test is false and a different value if the logical test is true.

true

The data in an Excel table is managed independently from the other data in the worksheet.

true

The first step in entering data by range is to select the desired range.

true

The result of a function is displayed in a cell, and the underlying formula is displayed in the Formula Bar.

true

The sizes of pie slices are automatically adjusted when the underlying data values are changed.

true

The target destination for data that has been cut or copied using the Office Clipboard is called the paste area.

true

The terms worksheet and spreadsheet are interchangeable

true

The user can add and delete commands on the Quick Access Toolbar.

true

The word pixel is short for picture element.

true

Using Comma Style causes a negative number to be displayed inside parentheses.

true

Using conditional formatting allows the user to have a cell formatted in different ways depending on the value stored in that cell.

true

When printing a worksheet, the orientation can be changed either on the Page Layout tab or in Print Preview.

true

When you add or delete rows or columns in a worksheet, Excel automatically adjusts all of the formulas.

true

z-axis

used in 3-charts for comparing data across both categories and values

Move Tool

used to place a selection in a new location

y-axis

vertical axis or value axis; contains the numerical values that help you interpret the size of chart elements

value axis

vertical or y-axis; contains the numerical values that help you interpret the size of chart elements

data marker

visually represent each data point; a column on a column chart is an example of this

error bars

visuals that indicate the standard error amount, percentage, or a standard deviation for a data point or marker

Cell Value

what is typed into a cell-contained with in

Using accrual accounting, revenue is recorded and reported only

when the services are rendered without regard to when cash is received

Gunny sacking

where old problems are dredged up and used against each other

ego conflict

where the original issue is ignored as partners attack each others self esteem and each person becomes more defensive

source

where you acquire the information a source can come from a book web interview etc

sizing handles

white filled squares that makes the chart bigger or smaller

onomantopia

word that is pronounced like the sound or event that it is signifying (buzz, roar, giggle)

True

you would want to change the column width to make sure all of the information in the column is visible. (T/F)

Depending on the font style used, title text for individual slides is usually _____________ points.

• 36-44

When using the Title Slide layout, the title text is usually ______________ points.

• 54-72

PowerPoint allows you to export files. List two examples of files that you can export.

• A video: saves the presentation as a video • Package presentation for CD: Saves your presentation and all are linked or embedded files

PowerPoint's _____________________ feature fixes many simple errors as you are typing.

• AutoCorrect

How do you start a presentation from the beginning? How do you start a presentation from the current slide you are on?

• Beginning: Press F5 • Current: Click the Slide Show button on the Status bar

What shortcut keys can you use to create a duplicate slide?

• Ctrl+D

What is the shortcut key to open the Save As dialog box?

• Ctrl+S

When reusing slides from another presentation, what happens to the slides you import when you keep the source formatting?

• It will look the same as it did in the other presentation

What key do you use to select multiple slides that are adjacent to one another? What about nonadjacent slides?

• Next to each other: Select the first slide, press Shift while you click the last slide • Spread out: Select the first slide, press Ctrl while you press each one you want to select

Explain the difference between a quiet transition and an energetic transition?

• Quiet Transition: Like turning pages • Energetic Transition: To grab attention or indicate a new topic

Compare Save and Save As. When would you use each?

• Save: • Save As: Use this to give your presentation a name and to put it in a specific folder (1st time you save)

How do you change a bullet symbol in a presentation?

• Select the text, Click the bullets button list arrow, select bullets and numbering, select a bullet

Give three examples of text case that can be used.

• Sentence case • tOGGLE cASE • Capitalize Each Word

______________________ refers to how text is capitalized.

• Text case

What are placeholders in a slide?

• They have no fill color or border, but you can change that. You can also resize them as needed to fit your content. Usually body placeholders contain bulleted text

What is the purpose of adding bullets to a presentation?

• They help mark the beginning point so people can see the items are separate.

Why would you adjust the pane size when working in Normal View?

• To help you better focus on one aspect of your presentation

What is the Zoom feature used for?

• To increase the size of the slide you are working on when you need to see in detail

When would you use the thesaurus in a presentation?

• To replace a word that is either awkward or is repeated a lot throughout

How can you align text within placeholders?

• Using the buttons on the home tab: Left, Center, Right, Justified OR Top, Middle, or Bottom

What are sizing handles?

• When you click on the area or border around the placeholder, small white squares will appear. These are used to change the shape/size of the placeholder.

When could you use the format painter?

• When you want certain things throughout your document to have the same format, but you don't want to do it all manually

What do you insert when you want the next line of text to start on a new page?

Page Break

Print gridlines. Row & column headings

Page Layout tab -- Page Set up dialog box -- Sheet tab in the box -- Check Gridlines, Check Row & Column headings.

Janice would like to number the slides in her presentation. Which command on the design tab would be best suited for this task?

Page Setup

Freeze columns & Row titles

Freeze panes (View tab -- Window group -- Freeze panes function). All data above & to the left of active cell is frozen on screen. Or I can freeze 1st column, or 1st row.

Row height

From 0 to 409 points.

Ashley wants to make a printed copy of her presentation exactly as shown to her audience. Which print option should she use?

Full Page Slides

Title Slide

Generally the first slide in a presentation; introduces the audience to the presentation.

Create a new document S starting a program

Get to the folder you want to create a new doc in -- Right-click-- New -- Select the program -- Name the file. It'll be blank, but the file will be there. You can work on it later.

Roman numerals

Give one example of something that is NOT a number format in Excel.

___ is one color shade gradually progressing to another shade of the same color or to another color

Gradient fill

Which tabs shows a text-only display of each slide in the presentation?

Outline

David wants to quickly change the font color of the bulleted items on slides 2, 3, and 7 of his biology presentation. In which pane would he most easily accomplish this task?

Outline Pane

Mr. Jones has a very lengthy MSITA class presentation; he has decided to share handouts with the class. What feature in the Header and Footer dialog box will help keep the pages in order?

Page number

Format painter: Single click v. Double

Painting format into one cell v. Into many cells till I press Esc or Click Format painter again.

Arguments

Parameters added to a function that help in evaluating data, or performing calculations

Employee

People hired by a business for a period of time to operate in the business

Relational listeners

People oriented. comfortable and skilled at listening to peoples feelings and emotions. most likely to empathize

Goods

Physical items that can be touched ad felt

Icons

Pictures that represent a program, a file, a folder, or some other object.

Mason has set up 5 slides in his new presentation and is ready to enter some text. He decides to put his text in a box with a dotted outline, designed for the placement of content on the slide. What is this referred to?

Placeholder

The firm's profit per unit sold (p) is equal to

P (The average price that the firm can charge a consumer for the product given competitive pressure and its ability to segment the market) - C (compromises all relevant costs, including the firm's cost of capital)

Which term refers to the boxes that hold text or objects on a slide?

Placeholder

Insert Row/Column

Placing a new, blank row or column in the spreadsheet.

Order of Operation in Excel

P.E.M.D.A.S. (Parentheses/Percentage, Exponentiation, Multiply, Divide, Add, Subtract).

The picture effects button is located on the ___, as shown in the accompanying figure.

PICTURE TOOLS FORMAT/ Picture styles group

The picture styles gallery , shown in the accompanying figure, is displayed by clicking the more button located on the ___

PICTURE TOOLS FORMAT/ Picture styles group

Expanding globally allows firms to increase their profitability and rate of profit growth in ways not available to purely domestic enterprises. Firms that operate internationally are able to

Expand the market for their domestic product offering by selling those products in international markets Realize location economies by dispersing individual value creation activities to those locations around the globe where they can be performed most efficiently and effectively Realize greater cost economies from experience effects by serving an expanded global market from a central location, thereby reducing costs of value creation Earn a greater return by leveraging any valuable skills developed in foreign operations and transferring them to other entities within the firm's global network of operations

Fixed expenses

Expenses that remain the same each month.

A company would typically experience a decrease in profit growth if it should decide to disperse vault creation activities to different locations as a way to perform those activities more efficiently T/F

False

True or False Each slide can have more than one transition.

False

True or False: Notes and handouts cannot include header information.

False

Grouping worksheets

Fancy name for select all sheets. Select by holding CTRL & clicking each one or by clicking first sheet, holding SHIFT, clicking last sheet

What's in Excel file name?

File name & four-character extension (.xlsx)

What are automatically updated properties?

File system properties: Date of file creation or Changes & File size.

Customizing Ribbon

File tab (Backstage view) -- Options -- click Customize Ribbon in left pane of Options dialog box.

Solid___ is one color used throughout the entire slide

Fill

WordArt ___ in the interior of a letter can sons its of a solid color, texture, picture, or gradient.

Fill

The ____ feature automatically locates specific text and then replaces it with desired text.

Find and replace

False

Find the five top sales people in a company is an example of what a what-if analysis is. (T/F)

DAVERAGE function

Finds the average of #'s in a table field that pass a test

Floating v. Fixed $ sign

Floating is close to the number. Fixed is always aligned to the left of the cell.

Global standardization strategy

Focus on increasing profitability and profit growth by reaping the cost reductions that come from economies of scale, learning effects, and locaation economies

As shown in the accompanying figure, tap or click the ___ arrow to display the font gallery

Font

Mr. Jones is creating handouts for his MSITA class presentations. What feature in the Header and Footer dialog box would allow him to add the class name to the bottom?

Footer

What is the text that appears on every slide but, depending on the theme applied, may not always appear at the bottom of a slide?

Footer

_______________ are displayed on every slide with placeholders for the date and time, slide number, and footer text.

Footers

Font styles

Formatting emphasis such as bold, italics, and underline.

IF function

Formula function -- IF -- Function argument dialog box: Logical test -- enter my argument, e.g. B13>=B7. Value if true -- enter cell ref, e.g. $B$2. Value if false -- enter zero.

System date AKA Date stamp

Formulas tab -- Function library group -- Insert function or Click "Insert function" in formula bar to bring up "Insert function" dialog box -- "or select a category" drop down box -- "Date & Time" -- Select NOW -- Enter.

Name manager button

Formulas tab| Defined names group| Name manager function

Formula checking

Formulas tab| Formula Auditing group-- Error checking button

PowerPoint provides different views to help create slides, organize them, and display them in a slide show. Explain each view below: Normal View Outline View Slide Sorter Notes Page Reading View

Normal View: The default view where you enter the content of the slides and move between slides as you develop them. Outline View: This view expands the pane at the left of your slide area to show slide titles and bulleted text. Slide thumbnails are not displayed. Slide Sorter: This view displays slides as thumbnails so it is easy to reorganize slides and apply transition effects to control how the slides advance Notes Page: This view displays each slide on a page with space below the slide where you can type speaker notes. You can also use the Notes pane below each slide to type speaker notes as well. Reading View: This view displays the slideshow at full screen or another window size controlled by the viewer. Navigation controls are in the Status bar at the bottom of the window.

. Which pane in PowerPoint 2010 provides an area for placing reminders to help a presenter during a presentation?

Notes

Which print setting creates printouts of an entire slide on the top of the page and an area for speaker notes below the slide?

Notes Pages

Mason has set up 5 slides in his new presentation and is ready to enter some text that he does not want his audience to see. This text will be a reference for him and is hidden during the presentation. The place Mason will insert important key points that he wishes to cover during the presentation is located where?

Notes Pane

Tammy is preparing to give a presentation. She would like to view information that will remind her what to say to her audience but that they will not see. Which view should she print?

Notes page

You can type comments to yourself in the ____ for a specific slide whole working in normal view

Notes pane

Which type of list is best suited for items that DO go in a specific order?

Numbered

Constant value

Numbers, text, dates, or times of day that you type into a cell.

A background feature called____ allows you to move the background from the slide borders in varying distances by a percentage

Offsets

Groups

On the Office Ribbon, the sets of related commands that you might need for a specific type of task.

Row level symbols

On the left of a table in gray area 1-- Hides all rows but Grand Total row; 2-- Hides detail records but shows subtotal & Grand Total rows; 3-- Shows all rows

Where's the Name box?

On the left, right under the Ribbon. Gives active cell reference.

To increase the font size of selected text,chose the increase font size button , located ____

On the mini toolbar

What's Enhanced Screen Tip?

On-screen note that gives the name of the command, keyboard shortcuts, description of the command.

Graphical Element

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide.

Goal Seek

One of Excel's What-If Analysis tools that provides a method to find a specific value for a cell by adjusting the value of one other cell--find the right input when you know the result you want.

Exploded Pie chart

One or > slices are offset.

PowerPoint increased the weight of a line in ___ increments

One-fourth

Studies show people remember at least ___ more information when the document they are seeing or reading contains visual elements

One-third

Net Income

Operating profit less interest expense computed a revenue, less operating expenses, less interest expenses

Add-ins

Optional commands and features that are not immediately available and must be installed or activated to use.

Create custom series C fill handle

Options button in Backstage view -- Advanced tab -- Edit Custom Lists button.

Purpose of data tables

Organize answers to what-if questions

. In preparation for an upcoming meeting, Liam is creating a PowerPoint presentation. If Liam would like to focus only on the content, which pane would be best suited for this purpose?

Outline

. Mason has set up 5 slides in his new presentation and is ready to enter some text. He wants to enter text without having to think about other PowerPoint elements such as graphics, pictures, sound and animation. He just wants to focus on entering text. The best method for Mason to enter text is to use what feature of PowerPoint 2010?

Outline

After reviewing the PowerPoint presentation rubric for History class, Ava realizes that she should have used the same font in each slide. Which pane will allow her to quickly make this revision?

Outline

In preparation for an upcoming meeting, Liam is creating a PowerPoint presentation. If Liam would like to focus only on the content, which feature should he use?

Outline

In preparation for an upcoming presentation, Shanna is importing a document that includes the text into PowerPoint. Which of the following features should she use?

Outline

The WordArt ____ is the exterior border surrounding each letter or symbol

Outline

What type of list is best suited for items that DO NOT go in any specific order?

Bulleted

During the editing phase you should not worry about grammar and word usage. True or False?

False

It's always better to add more graphic elements to a slide. True or False?

False

Shapes can NOT be added to a Photo Album. True or False?

False

The Title style is a poor choice if you want to make the document title stand out. True or False?

False

What Ribbon would you select to create an Action Button?

Insert

Where would you click on the image to increase the border thickness for a table?

The Border Button in the Design Tab for the Table

What would you click in PowerPoint to change the slide layout?

The Layout button in the Home Tab

Why would you use the Insert Picture from FIle command?

To add an image saved on your computer or a storage device

Can you open a website from within a PowerPoint presentation?

Yes; your best option would to use a Hyperlink

What Ribbon tab would you select to insert a table of contents? a) Home b) Insert c) References d) Page Layout

c) References


Related study sets

Mandatory Reporting of Child Abuse

View Set

Chapter 26 Fluid, Electrolyte, and acid-base balance

View Set

Chapter 30: The Child with a Skin Condition

View Set

Chapter 7 Management and Leadership

View Set

NUR 1018 - Gas exchange - adaptive Q's

View Set

Principles of Management: Chapter 11; Managing Human Resource Systems

View Set