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...
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
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