Microsoft Excel, Microsoft Excel and Access Test Review, Excel, Excel, Microsoft Excel Fundamentals and Skills Project (BIM), Excel Essentials, Excel Fundamentals, EXCEL SKILLS, Microsoft Excel Fundamentals and Skills Project (BIM), True or False Exc...

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

XY scatter chart

shows a relationship between two variables

range name

word or string of characters that represents one or more cells

semi selection (pointing)

the process of using the mouse pointer to select cells while building a formula

A chart layout may include a number of chart elements such as title, legend, and labels for the columns.

true

Logical functions are used to test for specific conditions.

true

Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use? HLOOKUP VLOOKUP LOOKUP SEARCH

VLOOKUP

Font style

Various ways that fonts can be displayed, such as regular, italic, bold, or bold italic; a special attribute applied to the characters of a font.

Comma

What is the most common type of delimiter?

Number

What tab group would you use to change the format of cell A2 to match cell A3?

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.

The terms worksheet and spreadsheet are interchangeable

true

=MAX(A2:B5)

Which function would you enter to return the number 45.1?

Ctrl+U

Which keyboard shortcut underlines text in a cell?

Ctrl-C

Which keys would you press to copy worksheet data into the clipboard?

File

Which tab would you use to access the Print controls?

Relative

Which type of cell references are automatically updated when it is copied?

Freeze Panes

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

Accounts Receivable

an assest the represents amounts owed to the business by customers

spreadsheet

an electronic file that containsa grid of columns and rows containing related data

Workbook

an excel file with one or more worksheets

argument

an input, such as a cell reference or value, that i neededto complete a function

The usual sequence of steps in the transaction process is

analyze, journalize, post to the ledger.

total row

appears as the last row of a table to display summary statistics, such as a sum

Row

appears horizontally in a worksheet and is identified by numbers on the left side of the worksheet window

stilted

artificially formal; contrived

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

subordinate

belonging to a lower or inferior class or rank; secondary

SUM function

calculates the total of values contained in two or more cells

Move Tool

used to place a selection in a new location

formula bar

displays the content in the active cell

According to Excel's order of operations, addition and subtraction are done before exponentiation.

false

Delete Column A

Click the delete button

Click on column D and make it wider

Click the edge of column D

Unhide Row Tool

-ll-

HTML (Hypertext Markup Language)

A language used to write Web pages.

Dishonored note (p. 411

A note that is not paid in full at maturity.

Static budget (p. 1081

A projection of budget data at one level of activity.

LIFO reserve (p. 299

For a company using LIFO, the difference between inventory reported using LIFO and inventory using FIFO.

Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into worksheet? Shapes Picture Cropping Screen Clipping Screenshot

Screen Clipping

Which command creates decorative text in a worksheet? SmartArt WordArt Draw Shape

WordArt

What character can be placed in front of data to force excel to treat it as text?

'

Cells a1:c5 in sheet 1 are created and named sales; how would a cell on sheet 2 reference the range?

(sales)

Chart Sheet

A separate sheet in a workbook that stores a chart.

chart

Conveys a visual representation of data

Capital expenditures (p. 449

Expenditures that increase the company's investment in plant assets.

=

In Excel, all formulas must begin with what symbol?

Solvency ratios (p. 60

Measures of the ability of the company to survive over a long period of time.

Expense

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

Sales revenue (p. 228

Primary source of revenue in a merchandising company.

Which group on the Form Tools Arrange Ribbon allows the user to align to grid? Merge/split Move Position Sizing & Ordering

Sizing & Ordering

Primary sort field

The first sort field

Plus sign

Where would you click to create a new worksheet?

Changed alignment

You have decided to center the text within a cell. What have you done?

data series

a group of related data points

wrap text

enables a label to appear on multiple lines within the current cell

A summary sheet is used to provide a visual cue about the value of a cell in relationship to other cells.

false

name box

identifies the address of the current cell

category axis

provides descriptive group names for subdividing the data series

exploded pie chart

separates one or more pie slices from the rest of the pie chart

True

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

Worksheet

A blank page in a spreadsheet file

Link

A connection between the files that allows data to be transferred from one file to the other.

Purchase Return

A decrease in the cost of purchases because the buyer returned the goods to the seller

Conditional format

A setting that applies formatting only when a cell's value meets a specified condition.

View short-cuts toolbar

A toolbar located at the right end of the status bar that contains tools for switching between views of document content and changes the display magnification

Maggie wants to use a function that will return True when all its arguments are true, and False when one or more arguments are false. What function would she use? AND IF NOT OR

AND

Face value (p. 513

Amount of principal due at the maturity date of the bond.

When you create a formula, you'll always start by typing the ________ sign.

B. = (equals)

Financing activities (p. 625

Cash flow activities that include (a obtaining cash from issuing debt and repaying the amounts borrowed and (b obtaining cash from stockholders, repurchasing shares, and paying dividends.

Operating activities (p. 625

Cash flow activities that include the cash effects of transactions that create revenues and expenses and thus enter into the determination of net income.

The graphic representation of data in a worksheet.

Chart

Leigh Ann designed a bar chart and would like to add an element above the hart to make the data more meaningful. Which cart feature would she need to include? Axis Chart title Dara Label Legend

Chart Title

surface chart

Chart used to compare data from three columns in a three-dimensional manner

Print the highlighted section

Click "Print Area"

Print the highlighted section

Click "Set Print Area"

Use the fill button to copy the formula

Click the arrow sign

Enter 230 for health insurance

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

Surface Chart

Compares three sets of values in a 3-D chart.

Area Chart

Compares values from different categories. Similar to a line chart except the areas under the line contain a fill color.

Which type of operator enables a user to compare two values in a query criterion? Assessment Evaluation Comparison Appraisal

Comparison

Controllable margin (p. 1098

Contribution margin less controllable fixed costs.

AutoCorrect feature

Corrects common mistakes when you complete a text entry in a cell

Unit production costs (p. 852

Costs expressed in terms of equivalent units of production.

Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use? Count Max Min Average

Count

Liabilities and Stockholders' Equity

Current liabilities, Long-term liabilities, Stockholders' equity

Text or numbers in a cell.

Data

When the data in a workbook is larger than can be printed on a single page, excel prints:

Depends on the user preference

Deposits in transit (p. 354

Deposits recorded by the depositor that have not been recorded by the bank.

Nick wants to make notes for future users of his database so they will properly use the field names and types. Where would he make these notes? Data Type Description Field Nae Properties

Descritption

John wantss to change the chart style on his PivotTable. Which PivotTable chart tools tab would he create? Design Layout Format Analyze

Design

Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart? Style Design Layout Format

Design

Formula AutoComplete

Displays an alphabetical list of functions from which you can choose

Mary has three worksheets that she would like to label as summary, detail and look up. She should

Double-click each tab and type over the highlighted text, or Right-click each one and choose rename, then enter the appropriate name

relative reference

Each adjusted cell reference

Worksheet

Each workbook is made up of individual worksheets, or sheets, containing formulas, functions, values, text, and graphics.

John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create? PivotChart Line Chart Embedded chart Linked Chart

Embedded Chart

Treasurer (p. 360

Employee responsible for the management of a company's cash.

Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?

Entry

Formula prefix

Equal sign preceding a formula

Formula

Equations with symbols for math operations. Example =B6+B7+B8+B9

Extraordinary items (p. 688

Events and transactions that meet two conditions: (1 unusual in nature and (2 infrequent in occurrence.

Accounting transactions (p. 102

Events that require recording in the financial statements because they affect assets, liabilities, or stockholders' equity.

Insert mode

Excel inserts the character and moves all characters to the right

Formula view

Excel view in which cell formulas are displayed rather than the values returned by the formulas.

Which command do you use to close an open file and completely exit the Microsoft Excel program?

Exit

Revenue expenditures (p. 449

Expenditures that are immediately charged against revenues as an expense.

The keyboard shortcut to define a cell as absolute is

F4

False

Find the five top sales people in a company is an example of what a what-if analysis is. (T/F)

Michelle needs each National Technical Honor Society member to complete an information sheet. Which tool would be best? Form Filter Controls Theme

Form

Which command on the home ribbon do you use to format row height and columns width organize sheets and protect or hide cells in a worksheet? Insert Form Sort and filter Format

Format

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select? Cell Style Conditional formatting Fill color Format as table

Format as table

underline

Format that underlines only the characters in a cell, not the entire cell

Double-click the worksheet tab

How can you rename a worksheet?

=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?

Cell

Intersection of a column and a row

Weighted-Average-Cost Method

Inventory costing method based on the average cost of inventory for the period. Weighted-average-cost is determined by dividing the cost of goods available by the number of units available. Also called the average cost method

Dialog box launcher

Item of the Ribbon that opens a dialog box or task pane

False because Headers and Footers both work on Excel

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

Which type of relationship means that a record in the first table is related or matches ore than one record in the second table? One to one Many to many One to many One to any

One to many

Landscape and portrait are

Orientations

Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?

Page Layout

What layout is similar to the print review

Page layout

Employee

People hired by a business for a period of time to operate in the business

Goods

Physical items that can be touched ad felt

Standard costs (p. 1138

Predetermined unit costs which companies use as measures of performance.

Ali has worked for years cataloging his comic book collection into a database. Recently his computer crashed, but fortunately he has a backup on his Skydrive. Which method should he use to restore his database on his new computer? Backup Recover from Backup Save to External Locations Previous Version

Recover from Backup

Which function would you use to add the values of several cells?

SUM

Taylor wants to query the airline database to find out how many seats are open on Flight 33. What type of query would she use? Crosstab Query Multiple Query Simple Query Find

Simple Query

Which command on the Home Ribbon do you use to organize data in ascending or descending order? Find & Select Format Cell Sort & Filter Organize

Sort & Filter

Normal standards (p. 1140

Standards based on an efficient level of performance that are attainable under expected operating conditions.

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.

Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles? Style Design Layout Format

Style

Data label

Text associated with a data value.

Data

Text or numbers in a cell

Footer

Text that appears at the bottom of every page in a document or at the bottom of every slide in a presentation.

Header

Text that appears at the top of every page in a document or every slide in a presentation.

bold

Text that has a darker appearance than normal text

Activity index (p. 940

The activity that causes changes in the behavior of costs.

Series values

The actual data displayed in a chart.

Major tick mark

The indication of the major units of increment on the x- or y-axis.

Freeze

The process of keeping rows and/or columns you select visible in the workbook window as you scroll the worksheet.

Scale (n)

The range of values that spans along an axis.

=5+A1*B1

This formula is a complex formula.

Sort

To arrange data in alphabetical or numerical order.

On startup, Excel displays a new blank:

Workbook

What is the correct hierarchy?

Workbook, worksheet, cell

fill color

a background color appearing behind the data in a cell

chart title

a label that describes a chart

axis title

a label that describes either the category axis or the value axis

range

a rectangular group of cells

chart

a visual representation of numerical data

A T- account

a way of depicting the basic form of an account

Cell Label

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

Assets normally show

debit balances

A paid dividend

decreases assets and stockholders equity

print area

defines the range of data to print

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.

Which one of the following is not a part of an account

trial balance

point

1/72 of an inch

Statement of cash flows (p. 624

A basic financial statement that provides information about the cash receipts and cash payments of an entity during a period, classified as operating, investing, and financing activities, in a format that reconciles the beginning and ending cash balances.

Selection box

A box surrounding an object that lets you move or resize the object.

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

Format painter

A button on the Ribbon that, when selected, copies a format from one cell range to another.

AutoSum

A button that quickly inserts Excel functions that summarize all the values in a column or row using a single statistic - SUM, AVERAGE, COUNT, MIN or MAX

Purchase discount (p. 234

A cash discount claimed by a buyer for prompt payment of a balance due.

Petty cash fund (p. 351

A cash fund used to pay relatively small amounts.

Financial function

A category of Excel functions that calculate values from loans and investments.

Pie chart

A chart in the shape of a circle (like a pie) that shows data values as percentage of the whole.

Operating lease (p. 452

A contractual agreement allowing one party (the lessee) to use the asset of another party (the lessor) ; accounted for as a rental by the lessee.

Managerial accounting (p. 748

A field of accounting that provides economic and financial information for managers and other internal users.

Category field

A field used to group the values in a PivotTable.

Workbook

A file containing multiple spreadsheets

Workbook

A file that contains one or more spreadsheets

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

Factor (p. 418

A finance company or bank that buys receivables from businesses for a fee and then collects the payments directly from the customers.

Statement of stockholders' equity (p. 57

A financial statement that presents the factors that caused stockholders' equity to change during the period, including those that caused retained earnings to change.

Formula

A mathematical expression that calculates a value; all Excel formulas always begin with an equal sign (=) followed by an expression that describes the calculation to be done.

Formula

A mathematical function that contains cell addresses and mathematical operators

Direct write-off method (p. 401

A method of accounting for bad debts that involves charging receivable balances to Bed Debts Expense at the time receivables from a particular company are determined to be uncollectible.

Allowance method (p. 402

A method of accounting for bad debts that involves estimating uncollectible accounts at the end of each period.

Stakeholder

A person or organization affected by a business

Flexible budget (p. 1083

A projection of budget data for various levels of activity.

Overapplied overhead (p. 815

A situation in which overhead assigned to work in process is greater than the overhead incurred.

Underapplied overhead (p. 815

A situation in which overhead assigned to work in process is less than the overhead incurred.

Bank statement (p. 352

A statement received monthly from the bank that shows the depositor's bank transactions and balances.

Validation rule

A statement that defines criteria for the data that can be stored in a cell or range.

Arithmetic operator

A symbol, such as +, - , *, or /, used in a formula to perform arithmetic calculations.

Double-entry system (p. 112

A system that records the two-sided effect of each transaction in appropriate accounts.

Horizontal analysis (p. 694

A technique for evaluating a series of financial statement data over a period of time to determine the increase (decrease that has taken place, expressed as either an amount or a percentage.

Macro virus

A type of virus that uses a program's own macro programming language to distribute the virus.

Date data

A value in a recognized date format.

The correct way to display the range from A1 through C5 and formulas is

A1:C5

Cash-basis accounting (p. 166

Accounting basis in which a company records revenue only when it receives cash, and an expense only when it pays cash.

Accrual-basis accounting (p. 166

Accounting basis in which companies record, in the periods in which the events occur, transactions that change a company's financial statements, even if cash was not exchanged.

Cash Accounting

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

Financing Activities

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

Product-level activities (p. 903

Activities performed in support of an entire product line, but not always performed every time a new unit or batch of products is produced.

Facility-level activities (p. 903

Activities required to support or sustain an entire production process.

Operating Activities

Activities that create revenue and or expenses in the entity

Actual Cost

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

Physical units (p. 850

Actual units to be accounted for during a period, irrespective of any work performed.

Ann needs to duplicate a field that is used in his customer table in the business database for a new form he is creating for entering customer orders. Which item from the tools group would enable him to perform this operation? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

Cathy needs to duplicate a column that is used in her spring sports table in the athletic database for a new form she is creating for fall sports. Which item from the tools group would enable her to perform this operation? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

Keton created a customer information form from his customer table. He realizes he left email address off the form. What tool would he use to add email address to the existing form? Tab Order Add Existing Fields View Code Property Sheet

Add Existing Fields

The correct syntax to make the contents of cell f23 always match the contents of cell d5 is to

Add the function "=d5" in cell f23

False

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

SUM function

Adds all the numbers in a range of cells

Accounting Number Format button

Adds dollar signs and two decimal places to selected data

Insert Tab

Allows you to add various items into a document; such as pages, tables, charts, illustrations, links to Internet sites or other documents, headers, footers,text and symbols

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.

Collapse Arguments

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

Receivables (p. 398

Amounts due from individuals and companies that are expected to be collected in cash.

Table style

An Excel setting that applies styles to four table elements (header row, first column, last column, and totals row).

AutoFill

An Excel tool that enables you to copy the contents of the selected cells by dragging the fill handle over another adjacent cell or range of cells rather than using the copy and past commands.

Live preview

An Office feature that shows the results you would achieve in your file, such as the effects of formatting options on a document's appearance, if you click the option to which you are pointing.

Value-added activity (p. 901

An activity that increases the worth of a product or service.

Relative Reference

An adjustable/changeable cell reference

Cash equivalent price (p. 449

An amount equal to the fair value of the asset given up or the fair value of the asset received, whichever is more clearly determinable.

Compound interest

An amount for which the interest paid is calculated on the principal and any previous interest payments that have been added to that principal.

Liabilites

An amount owed to a lender or other creditor

Balanced scorecard (p. 1153

An approach that incorporates financial and nonfinancial measures in an integrated system that links performance measurement and a company's strategic goals.

What-if analysis

An approach using an electronic spreadsheet in which you change one or more of the values in the worksheet and then examine the recalculated values to determine the effect of the change.

Ribbon

An area at the top of the Excel 2010 window where almost all the capabilities of Word are available to help you use the program efficiently.

Voucher (p. 350

An authorization form prepared for each expenditure in a voucher system.

Copyright (p. 470

An exclusive right granted by the federal government allowing the owner to reproduce and sell an artistic or published work.

Patent (p. 469

An exclusive right issued by the U.S. Patent Office that enables the recipient to manufacture, sell, or otherwise control an invention for a period of 20 years from the date of the grant.

Bad Debts Expense (p. 401

An expense account to record losses from extending credit.

Ratio (p. 54

An expression of the mathematical relationship between one quantity and another.

Column Chart

An image used to compare different groups of data to each other through the use of vertical columns of different lengths

Account (p. 111

An individual accounting record of increases and decreases in specific asset, liability, stockholders' equity, revenue or expense items.

Perpetual Inventory System

An inventory system in which the business keeps a continuous record for each inventory items to show the inventory on hand at all times

Activity-based costing (ABC

An overhead cost-allocation system that allocates overhead to multiple activity cost pools and assigns the activity cost pools to products or services by means of cost drivers that represent the activities used.

Standard predetermined overhead rate (p. 1142

An overhead rate determined by dividing budgeted overhead costs by an expected standard activity index.

Activity (p. 891

Any event, action, transaction, or work sequence that incurs cost when producing a product or providing a service.

text

Any set of characters containing letters, hyphens, or spaces

Formula Bar

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

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose? Ascending Descending Primary Sort Customer Filter

Ascending

Fair value principle (p. 67

Assets and liabilities should be reported at fair value (the price received to sell an asset or settle a liability

The Excel feature that generates and extends values into adjacent cells based on the values of selected cells is

Auto Fill

Copy Cells

Auto Fill option that fills destination area but does not create a series

Fill Formatting Only

Auto Fill option that fills destination area using format of source area

Fill Without Formatting

Auto Fill option that fills destination area with contents without formatting

Fill Months

Auto Fill option that fills destination area with series of months

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What data type should he use? Auto Number Currency Yes/No Hyperlink

Auto Number

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

AutoFit

Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know the mean number of active members in the region. Which aggregate function should she use? Count Max Min Average

Average

Frank needs an estimated number of services his company performs each month. Using a calculated field ,which total function would he use to answer his question? Average Count Max Sum

Average

Weighted-average unit cost (p. 290

Average cost that is weighted by the number of units purchased at each unit cost.

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to remove the Y-axis value. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Axes

Permanent accounts (p. 186

Balance sheet accounts whose balances are carried forward to the next accounting period.

Amy would like to quickly create a form in layout view so that she can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the form's appearance while displaying the data? Blank Form Form Design Form Wizard Form Tool

Blank Form

Barney would like to create a report in layout view so that he can easily modify contents and formatting. Which option uses layout view and gives the user greater control over the report's appearance while displaying the data? Report Report Design Blank Report Report Wizard

Blank Report

insertion point

Blinking vertical line that indicates where next character typed will display

Unsecured bonds (p. 512

Bonds issued against the general credit of the borrower.

Convertible bonds (p. 512

Bonds that can be converted into common stock at the bondholder's option.

Which command on the page layout ribbon enables a user to mark where a new page will begin on the printed copy? Print area Breaks Background Effects

Breaks

Auto Fill Options

Button that allows you to copy values with/without formatting or the format only

Paste button

Button used to paste a copy of the Office Clipboard contents

On Account

Buying or selling on credit

Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use? AVERAGEIF SUMIF COUNTIF TOTALIF

COUNTIF

Preston's form needs to display the tax on an order. Which type of control would allow Preston to display information that would change every day? Bound Unbound Button Calculated

Calculated

Cancel box

Cancels an entry by tapping or clicking

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

Category Axis

The intersection of a column and a row.

Cell

Another name for a cell reference.

Cell Address

=10+B2

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

Anything typed into a cell.

Cell Content

source area

Cell being copied

Nonadjacent range

Cell range that is comprised of two or more separate adjacent ranges.

Mixed reference

Cell reference that contains both relative and absolute references, for example B$4.

Michelle used the property sheet to customize her form in Access. Which task can she complete? Change the background and add captions Enter a new record Move data Switch from Design View to Print Preview

Change the background and add captions

Conditional formatting

Changes formatting of a cell that meets a certain rule

line chart

Chart used to illustrate changes in data over time

pie chart

Chart used to show the contribution of each piece of data to the whole

Spelling button

Checks for apparent misspellings in a worksheet

Outstanding checks (p. 354

Checks issued and recorded by a company that have not been paid by the bank.

Select the formula to multiply the quantity and price

Choose "B"

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.

Retained earnings restrictions (p. 590

Circumstances that make a portion of retained earnings currently unavailable for dividends.

Use the autosum button to add up the amounts

Click the "E" button

Curt needs to exit his database in order to work on another database. What action should he take after saving his work? Close Create New Open from Existing Save As

Clse

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this? Group Collapse Subtotal Outline

Collapse

What is the purpose of the -/+ buttons that appear across the categories on a PivotTable? Drecrease/Increase Collapse/Expand Reduce/Add Subtract/Add

Collapse/Expand

A vertical group of cells in a worksheet

Column

Edward would like to create a chart that uses vertical retangles to compare iPod and iPad sales. Which chart type should he create? Bar Column Line Pie

Column

What term describes the process of repairing and removing wasted space from a database? Recovery Backing up Installation Compacting

Compacting

Internal auditors (p. 343

Company employees who continuously evaluate the effectiveness of the company's internal control systems.

Radar Chart

Compares a collection of values through several data sets.

Criteria filter

Conditions you specify for a filter.

Discounted cash flow technique (p. 1202

Considers both the estimated total net cash flows from the investment and the time value of money.

Numbers, text, dates, or times of day that you type into a cell.

Constant Value

Cost constraint (p. 67

Constraint of determining whether the cost that companies will incur to provide the information will outweigh the benefit that financial statement users will gain from having the information available.

Decentralization (p. 1093

Control of operations is delegated to many managers throughout the organization.

In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two different columns. Which tool would he use? Convert Text to Column Wizard Split View Comma Delimited View Side by Sid

Convert Text to Column Wizard

When using fill down, which is NOT an option

Copy without formatting

Chief financial officer (CFO

Corporate officer who is responsible for all of the accounting and finance issues of the company.

merging cells

Creating a single cell by combining two or more cells

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that? Ascending Descending Filter Custom Filter

Custom Filter

What answer would Excel give if you typed =3+6*2 into a cell?

D. 15

According to the order of operations, which operation is performed first in the following equation: =D1/5+1*D3/(D3-D2)?

D3-D2

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years which he has in a database. He wants to show individual data values. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Data Labels

Nick wants to design a database and wants Access to automatically assign an ID number to each record. What is auto numbering an example of? Data Type Description Field Name Properties

Data Type

An address book containing all Fbla members would be an example of a: Cell Database Fields Record

Database

Investing Activities

Decisions made by manangement to buy and sell long term assests

Fill Series

Default Auto Fill option that Excel uses to fill an area

General number format

Default number format that automatically displays number, for the most part, the same way you enter them.

Normal View

Default view in Excel

Division

Define the following operator: /

font

Defines appearance and shape of letters and numbers

font color

Defines the color of characters

Which command on the home ribbon do you use to remove cells rows or columns from a worksheet or table? Delete Remove Format Format as table

Delete

Donna's Bakery lost a customer named Doggie Donuts. What action should be taken to remove all records from her database for Doggie Donuts? Delete Query Update Query Append Query Make table Query

Delete Query

document properties

Details about a file such as the project author, title, and subject

Font size

Determined by point size, which is a unit of measurement equal approximately to 1/72 of an inch.

Annual rate of return technique (p. 1199

Determines the profitability of a capital expenditure by dividing expected annual net income by the average investment.

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

Orientation

Direction in which contents of page will print

Net present value method (p. 1202

Discounts net cash flows to their present value and then compares that present value to the capital outlay required by the investment.

Fill color list arrow

Displays background color options for a cell

Formula Bar

Displays the contents stored in the active cell

Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose? Edit Comment Show Ink New Delete

Edit Comment

Maria needs to share a form from her database to other members of her work team, but she is not sure everyone has Microsoft Access. She should save the form in which file format to ensure everyone can read the information? PDF XPS Either PDF or XPS DOC

Either PDF or XPS

Closing entries (p. 186

Entries at the end of an accounting period to transfer the balances of temporary accounts to a permanent stockholders' equity account, Retained Earnings.

Adjusting entries (p. 167

Entries made at the end of an accounting period to ensure that the revenue recognition and expense recognition principles are followed.

When creating a PivotTable which are drawn in columns in the worksheet data? Records Fields Cells Ranges

Fields

You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of: Cells Databases Fields Records

Fields

Workbook

File consisting of one or more worksheets

When saving a microsoft access database as another file type which ribbon contains an area of centralized tasks that are related to file management known as the backstage? Home ribbon File tab External Data ribbon Database Tools ribbon

File tab

Hank wants to add color to the header section if his form. Which formatting option would he use? Fill Color Font Size Font Color Format Painter

Fill Color

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

Fill Handle

David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task? AutoFill Filter Find and Replace Sort

Filter

Eddie needs to know which employees work in the Southeast District. Which command would he use? Filter Find Sort Ascending Sort Descending

Filter

Kori wants to know how many students in FBLA are seniors, but does not want to save the information. Which operation would she perform? Filter Find Query Sort

Filter

Michelle needs a list of senior National Technical Honor Society members so she can order their tassels for graduation. Which tool would be best to identify only the seniors? Form Filter Controls Theme

Filter

What is the process of viewing a PivotTable report for a subset that meets the criterion only? Filtering Sorting Positioning Arranging

Filtering

Report filter

Filters the PivotTable to display summarized data for one or more field items or all field items in the Report Filter area.

Controller (p. 752

Financial officer responsible for a company's accounting records, system of internal control, and preparation of financial statements, tax returns, and internal reports.

Treasurer (p. 752

Financial officer responsible for custody of a company's funds and for maintaining its cash position.

Mr.Smith needs to know Jennys address. Which command would he use? Find Select Sort Ascending Sort Descending

Find

Curt needs to format the numbers in his database to two decimal places. Which number format would he use? Currency Fixed General Number Text

Fixed

Dennis needs to format the numbers in his database to three decimal places. Which number format would he use? Currency Fixed General Number Text

Fixed

Kevin created a form to input FBLA membership data. He needs to change the background color of the form so that it displays correctly on mobile devices. Which option provides the tools Kevin will need to modify the form? Blank Form Form Design For Wizard Form Tool

For Design

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to quickly create a new blank database object, one which includes one record at a time and a more detailed view of the structure. Which would you use? Table Design Report Design Query Design Form Design

For Design

Mr. Johnson, the FBLA adviser, is updating the membership database table for the new school year. He wants to define the fields to display and simplify the interface by adding labels and instructions. He would use a? For Table Report Query

Form

Tyler is using Access for a class assignment. Which database object would she use to enter one record at a time? Table Form Macro Report

Form

Jeremy needs to create a quick form based on a single table in his baseball card database. Which option will automatically include all the fields from a single table? Blank Form Form Design Form Wizard Form Tool

Form Tool

Juan wants to view one record at a time in his database. Which view should he be in? Design View Form View Layout View Navigation Pane

Form View

number sign

Formula error messages always begin with this

Johns spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do? Freeze panes Split Hide Unhindered

Freeze panes

FOB shipping point (p. 284

Freight terms indicating that ownership of goods passes to the buyer when the public carrier accepts the goods from the seller.

FOB destination (p. 284

Freight terms indicating that ownership of goods remains with the seller until the goods reach the buyer.

Johnny has planned his baseball card database and determined a logical arrangement. What is his next step? Determine what information to include Discuess the database with users Gather the information Input data

Gather the Information

The default format that Excel applies to numbers is the:

General Formet

Long-term investments (p. 50

Generally, investments in stocks and bonds of other corporations that companies hold for more than one year, and long-term assets, such as land and buildings, not currently being used in the company's operations.

Roman numerals

Give one example of something that is NOT a number format in Excel.

Consigned goods (p. 284

Goods held for sale by one party although ownership of the goods is retained by another party.

Chart

Graph that provides a visual representation of the workbook data.

Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include? Axis Title Chart Title Gridlines Plot Area

Gridlines

Gross Profit Percentage

Gross profit divided by net sales revenue. Also called gross margin percentage

Gross profit rate (p. 245

Gross profit expressed as a percentage by dividing the amount of gross profit by net sales.

Gross profit rate (p. 717

Gross profit expressed as a percentage of sales; computed as gross profit divided by net sales.

Mrs. Wilson needs to create a report that lists students by their homeroom teacher. Each teacher needs a separate list for attendance. Which option would allow Mrs. Wilson to put students together by homeroom on separate sections of the report? Sort Filter Conditional Formatting Grouping

Grouping

Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use? HLOOKUPS SEARCH LOOKUP VLOOKUP

HLOOKUPS

Tom would like to show only some rows in his worksheet and would like to choose the row using the data in a column

He should filter the data using the criteria

Which options are not available in the page layout tools

Header and Footer

Select Column

Highlight an entire column

Select Row

Highlight an entire row

Frank would like to fill a list with the days of the week but wants to leave a blank column between each day. He should

Highlight the first day and a blank cell to the right, use the fill handle to the right

They are independent and not related.

How are a cell's content and format related?

There is a double line between rows and columns.

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

Show formulas in a print-out

How could you double-check formulas in a worksheet?

1

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

Nick wants to immidiately open an employees email from his database.What data type should be used for the email address? Auto Number Currency Yes/No Hyperlink

Hyperlink

nested IF

IF function within an IF function

False

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

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)

When copying cells that have formulas with relative references, the formula will work

If the data for the new location is in the same relative location

Scenario

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

An operand

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

An operator

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

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

requirements document

Includes a needs statement, source of data, and summary of calculations

Asset turnover ratio (p. 466

Indicates how efficiently a company uses its assets to generate sales; calculated as net sales divided by average total assets.

font style

Indicates how the characters are emphasized

Quality of earnings (p. 191

Indicates the level of full and transparent information that a company provides to users of its financial statements.

Quality of earnings (p. 701

Indicates the level of full and transparent information that is provided to users of the financial statements.

What ribbon contains the commands for creating charts in Microsoft Excel? Home Page Layout Insert Data

Insert

What ribbon contains the commands used to create a chart in Excel? Home Ribbon Insert Ribbon Formulas Ribbon Data Ribbon

Insert Ribbon

Ashawn has created a table from his database to see his company's income and expenses for the year and now would like to see the totals for each category. Which table feature should he use? Insert a Totals Row Sort by Selection Insert a Chart Create a Relationship

Insert a Totals Row

relative cell reference

Instructs Excel to adjust cell references as it copies to destination area

Specific Identification Cost Method

Inventory costing method based on the specific cost of particular units of inventory

Line positions (p. 752

Jobs that are directly involved in a company's primary revenue-generating operating activities.

John wants to identify the exact value that each column in his chart represents. Which option should he choose? Gridlines Arrows Pictures Labels

Labels

Legend

Labels that identify the different data series in a chart.

Sarbanes-Oxley Act of 2002 (SOX

Law passed by Congress in 2002 intended to reduce unethical corporate behavior.

Entire Period

Length of time during which beginning inventory and purchases are taken into account when calculating unit cost

Fill handle

Lets you copy cell contents or continue a series of data into a range of selected cells

Drag-and-Drop method

Lets you move or copy data from one cell to another without using the Clipboard

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

Liability, credit

Amanda wants to ensure there are only two charcters for state abbreviation. What should she do? Unique Identifier Limit Field Size Provide a Descritpion Provide Database Security

Limit Field Size

Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create? Bar Column Line Pie

Line

John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create? PivotChart Line Chart Embedded Chart Linked Chart

Line Chart

Page break

Location in a worksheet that determines where a new page begins.

Active cell

Location in the worksheet that will displays typed data that will be affected by a command

IF, AND, OR and NOT are all part of which category of functions? Math & Trig Lookup & Reference Logical Text

Logical

Which term describes the blank portions of a page that fall outside the main body of the printed document? Borders Edges Frames Margins

Margins

SUMIF and SUMIFS are in which category of functions? Lookup & Reference Math & Trig Logical Text

Math & Trig

Solvency ratios (p. 700

Measures of the ability of a company to survive over a long period of time, particularly to pay interest as it comes due and to repay the balance of debt at its maturity.

Profitability ratios (p. 55

Measures of the operating success of a company for a given period of time.

Liquidity ratios (p. 700

Measures of the short-term ability of the company to pay its maturing obligations and to meet unexpected needs for cash.

Profit margin ratio (p. 247

Measures the percentage of each dollar of sales that results in net income, computed by dividing net income by net sales.

Debt to total assets ratio (p. 60

Measures the percentage of total financing provided by creditors; computed as total debt divided by total assets.

Sales Returns and Allowances

Merchandise returned for credit or refunds for service provided

True

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

Weighted-average method (p. 847

Method of computing equivalent units of production which considers the degree of completion (weighting of the units completed and transferred out and the ending work in process.

Marci has a database of all the planets. She needs to know what planets have moons or rings. Which comparison operator would she use to perform the query? Moons and Rings Moons equal Rings Moons not Rings Moons or Rings

Moons or Rings

[Ctrl][Home]

Moves cell pointer to cell A1

* (Shift 8)

Multiplication symbol used in an Excel formula

formula bar

Next to the name box, a cell's data or formula is displayed here when you select the cell

Trade receivables (p. 399

Notes and accounts receivable that result from sales transactions.

What group of tools on the home tab allow a user to switch the format of numbers

Number

Constant values consisting of only numbers.

Number Values

ScreenTip

Onscreen text that appears when you position the mouse pointer over certain objects, such as the objects on the taskbar or a toolbar button. ScreenTips tell you the purpose or function of the object to which you are pointing.

Clicking on the zoom indicator will

Open the zoom dialog box

Net Income

Operating profit less interest expense computed a revenue, less operating expenses, less interest expenses

Licenses (p. 470

Operating rights to use public property, granted by a governmental agency to a business.

The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:

Operators

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select? Center Merge and center Orientation Wrap text

Orientation

When copying and pasting data, which paste option should be used to insert the data but not the original style

Paste special, paste

Sales Discount

Percentage reduction of sales price by the seller as an incentive for early payment before the due date. A typical way to express a sales discount is "2/10, n/30" This means the seller will grant a 2% discount id the invoice is paid within 10 days, or the full amount is due within 30 days

Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this? Picture Styles Artistic Effects Corrections WordArt Styles

Picture Styles

Which is the name of an interactive graphical representation of data tat allows a user to change the groupings? PivotChart PivotTable PivotDate Rotate Table

PivotChart

In order to directly report the data, what must a PivotChart always be associated with? Table Range PivotTable Worksheet

PivotTable

Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data? PivotChart PivotTable PivotDate Rotate table

PivotTable

Insert Row/Column

Placing a new, blank row or column in the spreadsheet.

Dorothy designed a column chart and would like to change the background color to yellow. What chart feature should she modify? Axis Title Chart Title Gridlines Plot Area

Plot Area

Dividends in arrears (p. 582

Preferred dividends that were supposed to be declared but were not declared during a given period.

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

In a table which is a way of exclusively identifying each record in the database? Unique marker Primary key Primary marker Primary category

Primary Key

Wendy needs to print to the color printer instead of the default printer on her computer. Which option would give her the choice to change the printer? Print Preview Quick Print Print Selected Records

Print

Wendy wants to be able to see what her database report will look like without producing a hard copy. Which option would she choose? Print Preview Quick Print Print Selected Records

Print Preview

William has created a report. Which view could he use to see exactly how the report will look on paper? Report View Print Preview Design View Layout View

Print Preview

You can use the

Print Selection option to print a specific range in a worksheet.

If you are printing a worksheet and want the headings to appear on every page, click the

Print Titles command.

automatically updated properties

Properties that include system file properties

Amanda wants to make it easier for other users to input data. What should she do to help other users understand the fields? Unique Identifier Limit field size Povide a Caption Provide database security

Provide a Caption

Quick Access Toolbar

Provides access to commonly used tasks like saving or printing a document, undo,redo, and new

Beth needs to determine the seniors with a GPA of 4.0 or higher. Which object would allow her to create a saved search to find this information in the database? Form Table Query Report

Query

A feature that outlines cells in color to indicate which cells are used in a formula is called:

Range Finder

destination area

Range of cells receiving the copy

Effective-interest rate (p. 534

Rate established when bonds are issued that remains constant in each interest period.

Indirect materials (p. 755

Raw materials that do not physically become part of the finished product or cannot be traced because their physical association with the finished product is too small.

Kirtan has worked for years cataloging his music collection into a database. During a recent storm, Kirtan's computer was damaged, but fortunately he has a backup on his flash drive. Which method should he use to restore his database on his new computer? Backup Recover from Backup Save to Exernal Locations Previous Version

Recover from Backup

How do these prepaid expenses expire?

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

Avery is the president of her FBLA chapter. FBLA keeps all member information in a database. She is often asked by members to pull a detailed summary of all competition participation for scholarship applications. Which report creation tool will automatically pull all the fields from the competition table? Report Report Design Blank Report Report Wizard

Report

Keisha wants to print her completed music databases. Which tool would she use? Filter Form Query Report

Report

Margaret wants to send an address change to all the customers in her current database. She wants to create address labels to accomplish this. Which would she use? Form Report Table Query

Report

Tyler is using Access for a class assignment. Which database object would she use to organize and display data pulled from tables and queries? Table Form Macro Report

Report

Which accounts normally have credit balances?

Revenues, liabilities, and retained earnings.

Which ribbon contains commands to add a comment about a selected cell in a worksheet? Home Insert Review Data

Review

Where is the spellchecker located? View Ribbon Home Ribbon Review Ribbon Page Layout Ribbon

Review Ribbon

Which toolbar contains most of the commands that you'll need in Excel 2013?

Ribbon

To insert a comment into a cell

Right-click in the cell select insert comment

How do you quickly modify a table style to meet user preferences? Right-click on a style and choose Modify Right-click on a style and choose Duplicate Double-click a style from the Table Quick Styles Gallery Choose Modify from the Styles Group on the Home Ribbon

Right-click on a style and choose Duplicate

What tab/group combination is used to change the type of chart used

Right-click on the chart and select change chart type, OR Chart tool tab

To change the color of a worksheet tab

Right-click on the tab and choose tab color, or Click on the worksheet tab, click Home, click Format, choose Tab Color

Intangible assets (p. 467

Rights, privileges, and competitive advantages that result from the ownership of long-lived assets that do not possess physical substance.

Which command on the Page Layout Ribbon enables user to flip objects on a worksheet? Align Arrange Group Rotate

Rotate

A horizontal group of cells in a worksheet

Row

Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use? FIND SUBSTITUTE VLOOKUP SEARCH

SUBSTITUTE

Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use? COUNTIF SUMIF AVERAGEIF TOTALIF

SUMIF

Which of the following accounts is increased with a credit?

Sales Revenue

Net sales (p. 241

Sales less sales returns and allowances and sales discounts.

The fill data handle looks like

Small black plus sign

fill handle

Small black square located in the lower-right corner of the active cell

Enterprise resource planning (ERP system 765

Software that provides a comprehensive, centralized, integrated source of information used to manage all major business processes.

David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task? AutoFill Filter Find and Replace Sort

Sort

Mr. Brown's report needs to be arranged by last name and first name. What tool can he use to ensure that students appear in alphabetical order on his report? Sort Filer Conditional Formatting Grouping

Sort

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? Find & Select Format Cell Sort & Filter Organize

Sort & Filter

Eddie works for ABC Finance. He needs to view which employees has the lowest sales for the month. Which command should he use? Filter Find Sort Ascending Sort Descending

Sort Ascending

Eddie works for ABC Finance. He needs to view which employees has the highest sales for the month. Which command should he use? Filter Find Sort Ascending Sort Descending

Sort Descending

What ensures that a query result appears in a specific order? Filtering Sorting Ordering Placing

Sorting

Ascending order

Sorts text alphabetically from A to Z, numbers from smallest to largest, and dates from oldest to newest.

Descending order

Sorts text in reverse alphabetically from Z to A, numbers from largest to smallest, and dates from newest to oldest.

False

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

Which is a tiny chart that provides a visual representation of data in a worksheet cell? Trendline Sparkline Dataline Flashpoint

Sparkline

Argument

Specifies the numbers, text, or cell references used by a function to calculate a value.

Another name for a worksheet.

Spreadsheet

Ideal standards (p. 1140

Standards based on the optimum level of performance under perfect operating conditions.

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.

Cost Principle

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

Helen is creating a form to gather important information about graduation requirements from her senior homeroom students. What tool would she use to ensure that the sequence in navigating the form fields so data is entered in the order she wants? Tab Order Add Existing Fields View Code Property Sheet

Tab Order

Sheets Tab

Tabs that appear at the bottom of the workbook window,which displays the name of each worksheet

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.

Jenny is setting the addresses for each patient. Which data type should she use? AutoNumber Currency Number Text

Text

workbook

The Excel document that holds all the worksheets

Revenue

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

Principal

The amount of money being loaned.

Cell Reference

The column letter and the row number. Example: B12

Workbook

The file in which Excel stores an electronic spreadsheet.

Useful life (p. 171

The length of service of a productive asset.

Break-even point (p. 951

The level of activity at which total revenues equal total costs.

Median

The middle value in data.

General journal (p. 117

The most basic form of journal.

Mode

The most common value in data.

Sustainable income (p. 686

The most likely level of income to be obtained in the future; calculated as net income adjusted for irregular items.

Cell Address

The name of a cell; contains both the column and row reference

Series name

The name of the data series.

Capital budgeting (p. 1198

The process of making capital expenditure decisions in business.

Sort

The process of rearranging data in a certain order, such as ascending or descending.

Accounting

The process of recognizing, measuring, recording, and reporting information about a business

Filter

The process of temporarily hiding records that do not meet the specific criteria.

Relevance (p. 65

The quality of information that indicates the information makes a difference in a decision.

Secondary sort field

The second sort field.

Active cell

The selected cell in the worksheet; indicated with a dark border.

Custom list

The sequence you specify to sort data.

arithmetic operations

The simple mathematical functions: plus, minus, multiplied by, and divided by

Fill handle

The small black square in the bottom right corner of as cell that allows you to fill adjacent cells with a repeated formula

Margin

The space between the page content and the edges of the page.

Common Stock

The stockholders' equity that is the result of the owners of the business investing money for other assests into the business

Cost behavior analysis (p. 940

The study of how specific costs respond to changes in the level of business activity.

Cost-volume-profit (CVP analysis (p. 947

The study of the effects of changes in costs and volume on a company's profits.

Total manufacturing costs (p. 758

The sum of direct materials, direct labor, and manufacturing overhead incurred in the current period.

Conversion costs (p. 848

The sum of labor costs and overhead costs.

Risk

The uncertainty that could result in an outcome not desired

Point

The unit used to measure the size of the characters in a font.

Points

The unit used to measure the size of the characters in a font.

Budgetary control (p. 1080

The use of budgets to control operations.

Goodwill (p. 471

The value of all favorable attributes that relate to a company that are not attributable to any other specific asset.

Present value (p. 514

The value today of an amount to be received at some date in the future after taking into account current interest rates.

Column

The vertical reference in a spreadsheet

Normal view

The view that renders the workbook and worksheets for the computer screen.

Direct labor (p. 755

The work of factory employees that can be physically and directly associated with converting raw materials into finished goods.

Source file

The workbook that contains the data when two files are linked.

Destination file

The workbook that receives the data when two files are linked; sometimes referred to as the dependent file.

Active workbook

The workbook you are currently using.

Active sheet

The worksheet currently displayed in the workbook window.

Vertical (value) axis

The y-axis where, for example, data values, such as sales values, are plotted.

Michelle wants to change the color of her form to make it more attractive. Which should she use? Form Filter Controls Theme

Theme

Which set of formatting choices includes a set of colors fonts and effects that you can apply to a worksheet to enhance its appearance? Layout Template Theme Design

Theme

When the mouse pointer turns into 2 parallel lines with arrows in opposite directions it means:

There is a hidden row/column

Susie wants to locate the file name of her current document.Where should she look? Rename Navigation Pane Title Bar Status Bar

Title Bar

Sort

To arrange a list of words or numbers in ascending or descending order

Formatting

To change the appearance, not the data, of your workbook.

Scale (v)

To change the size of a graphic to make it fit into a document.

Merge

To combine the main document with a data source.

Truncate

To cut off, or hide, the part of an entry that does not fit in a cell.

goal seeking

To determine the value of a cell on which the formula depends

Autofit

To eliminate empty space by matching the column width to the longest cell entry or the row height to the tallest cell entry.

zoom in

To magnify the appearance of a worksheet or chart

Autofit

To make a column or row as it needs to be to fit the data contained in the cell, Determines the best width for a column or the best height for a row, based on its contents.

Merge and Center

To make one cell out of several highlighted cells and then center the content of that cell

What graphically represents trends in plotted data and predicts future values? Sparkline Trendline Chartline Error Bar

Trendline

True

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

Text string

Two or more text characters.

Rename "C1" into "expenses"

Type expenses under C1

Continue to save the workbook

Type in July, then choose save

Dean needs to add the FBLA logo to the top of his membership form. Which type of control should he use? Bound Unbound Button Calculated

Unbound

Keton wants to add a graphic by one of the fields on his form. Which type of control will he add to the form? Bound Unbound Button Calculated

Unbound

Tammy wants to add instructions by one of the fields on her form to ensure that the data is entered correctly. Which type of control will she add to the form? Bound Unbound Button Calculated

Unbound

splitting

Unmerging a cell

What type of query enables a user to make the same change to all records satisfying a certain creterion? Update Append Action Make table

Update

Elizabeth needs to convert all text in Column A to uppercase. Which function should she use? Proper Upper Lower Trim

Upper

Change in accounting principle (p. 690

Use of an accounting principle in the current year different from the one used in the preceding year.

Consistency (p. 65)

Use of the same accounting principles and methods from year to year within a company.

Custom margins

Used to center the spreadsheet both horizontally and vertically on a printed page.

Letters

Used to identify columns in a spreadsheet

Numbers

Used to identify rows in a spreadsheet

Legend

Used to identify the format of the data marker used for each series in a chart. Used if the chart contains more than one data series.

Equal Sign

Used to indicate the start a formula

format painter

Used to quickly copy a cell's format to another cell

Insert Function dialog box

Used to search for a particular function.

Asiah has created a senior information form from her student table. She wants the parent's home phone text box to have the exact same width as the cell phone text box. What tool would she use to ensure they are exactly the same? Tab Order Add Existing Fields View Code Property Sheet

View Code

Clear All

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

Format attributes

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

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?

Above the worksheet, the third cell and the longest. (Letter C)

Where is the Formula Bar?

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?

Absolute

Which type of cell references are locked and NOT automatically updated when it is copied?

Autofill

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

3-D chart

adds a third dimension to each data series, creating a distorted perspective of the data

If you wanted to filter data to exclude a certain word or phrase, you could use a(n)

advanced text filter

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

logical test

an expression that evaluates true or false

Column

appears vertically in a worksheet and is identified by letters at the top of the worksheet window

Slicers

are basically just filters

sorting

arranges records in a table by the value in fields within a table

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.

SUBTOTAL function

calculates an aggregate for values in a range or a database

AVERAGE function

calculates the arithmetic mean or average of the values contained in two or more cells

PMT function

calculates the periodic payment for a loan with a fixed interest rate and fixed term

Absolute Reference

cell reference that points to a specific cell and does not change when copied ($B$4)

Resize

change the size of

surreptitious

clandestine; furtive, secretive

Text Color

color that the text appears in in a cell

If you want to put your data into alphabetical order by last name, you could use the

command.

radar chart

compares aggregate values of three or more variables represented on axes starting from the same point

plot area

contains a graphical representation of values in a data series

table style

controls the fill color of the header row, columns, and records in a table

order of precedence

controls the sequence in which Excel performs arithmetic operations

An account will have a credit balance if the

credits exceed the debits.

MAX function

displays the highest value in a range

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 toggle value is one that is used by a program unless the user changes it.

false

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

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

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

stringent

imposing rigorous standards of performance; severe

text

includes letters, numbers, symbols, and spaces

Debits

increase assets and decrease liabilities

symbiosis

interdependent relationship

lookup value

is a reference to a cell containing a value to look up

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

freezing

keeps rows and/or columns visible as your scroll through a sheet

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

When reading a chart, you should refer to the

legend to see which color is used to represent each data series.

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

=AVERAGE(range)

returns the average (mean) of a range

=SUM(range)

returns the sum total of (adds up) a range

The best interpretation of the word "credit" is the

right side of an account

In order to share a workbook online, you must first

save it to your OneDrive

pie chart

shows each data point in proportion to the whole data series as a slice in a circular pie

bubble chart

shows relationships among three values by using bubbles

stock chart

shows the high, low, and close prices for individual stocks over time

doughnut chart

shows values as percentages of the whole but may contain more than one data series

The normal balance of any account is the

side which increases that account

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

source documents

Function

special formulas that do not use operators to calculate results. A shortcut formula Ex: sum(B6:B9)

100% stacked column chart

stacks data in one column per category, with each column having the same height (100%)

Fill Color

the background of the cell

print order

the sequence in which pages print

nper

the total number of payment periods

Formatting marks represent certain keystrokes in a document, but do not display when the document is printed.

true

Using accrual accounting, revenue is recorded and reported only

when the services are rendered without regard to when cash is received

One advantage of sparklines is that

you can keep them very close to their source data

True

you would want to change the column width to make sure all of the information in the column is visible. (T/F)

When making an absolute cell reference, you'll need to include at least one

$ (dollar sign)

How does a user define a cell name (A1) as an absolute reference

$A$1

Average-cost method (p. 290

An inventory costing method that uses the weighted-average unit cost to allocate the cost of goods available for sale to ending inventory and cost of goods sold.

Notes payable (p. 506

An obligation in the form of a written note.

Gross Margin

Another name for gross profit

Cost driver (p. 891

Any factor or activity that has a direct cause-effect relationship with the resources consumed. In ABC, cost drivers are used to assign activity cost pools to products or services.

Data source

Any file that contains the data you want to retrieve.

What type of query enables a user to add the results of a query to and existing table in a database? Update Append Action Make table

Append

Intangible assets (p. 51

Assets that do not have physical substance.

Trey would like to outline the cell range A1:F20. Which formatting style should he select? Borders Cell style Conditional formatting Former as table

Borders

Insert a pie chart

Choose "pie"

[Delete]:

Clears the contents of selected cells

To create a new worksheet

Click the Insert Worksheet tab, or Right-click on a worksheet tab and select Insert

Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet? Clip Art Picture SmartArt Instant Art

Clip Art

Where is the command for creating a new table from Table Design view? File tab Home Ribbon Create Ribbon Database Tools Ribbon

Create Ribbon

Sales invoice (p. 236

A document that provides support for each sale.

Accounts Payable

A liability incurred by a business when purchasing goods and services

Times interest earned ratio (p. 525

A measure of a company's solvency, calculated by dividing income before interest expense and taxes by interest expense.

Return on common stockholders' equity ratio (p. 594

A measure of profitability from the stockholders' point of view; computed by dividing net income minus preferred stock dividends by average common stockholders' equity.

Inventory turnover ratio (p. 711

A measure of the liquidity of inventory. Measures the number of times average inventory was sold during the period; computed as cost of goods sold divided by average inventory.

Receivables turnover ratio (p. 415

A measure of the liquidity of receivables, computed by dividing net credit sales by average net accounts receivables.

Receivables turnover ratio (p. 711

A measure of the liquidity of receivables; computed as net credit sales divided by average net receivables.

Purchase return (p. 234

A return of goods from the buyer to the seller for cash or credit.

Generally accepted accounting principles (GAAP

A set of rules and practices, having substantial authoritative support, that the accounting profession recognizes as a general guide for financial reporting purposes.

Data validation

A set of rules that determine what users can enter in a specific cell or range.

Locked property

A setting that determines whether changes can be made to a cell.

Workbook protection

A setting that limits users' ability to make changes to the

Worksheet protection

A setting that limits users' ability to modify the worksheet's contents, structure, or formatting.

Adjacent range

A single rectangular block that includes a group of contiguous cells.

Riley is using Access to collect data for a science project. He is creating a form and wants to apply predefined color and font scheme formats. Which Form Layout Tools contextual tabs should he select for the theme group? Design tab Format tab Arrange tab Page Setup tab

Design tab

Jenny is entering data to the medication field in the patient database and needs to constantly view patient ID numbers to input medication information. What should she do? Format Freeze Fields Hide Fields Sort

Freeze Fields

Page layout view

In Excel, a view that shows how the worksheet will be laid out on the pages sent to the printer.

Print title

In Excel, information that prints on each page.

Row heading

In Excel, the part of a worksheet that identifies each row by a different number.

Column heading

In Excel, the part of the worksheet that identifies each column by a different letter.

Module

In VBA, a collection of sub procedures.

Curt wants to search his CD collection database for the names of the albums from his favorite artist that were released after 2010. What object should Curt create and save to obtain this information most efficiently? Filter Table Query Report

Query

Keisha created a database of her music. She wants to locate only the songs by Beyoncé. What tool should she use in order to view this information and save it for later use? Filter Form Query Report

Query

Which is a way to qualify data by specifying a matching condition or asking a question of the data? Insert Sort Query Probe

Query

Joe wants to modify the query he created to incorporate various colors, fonts and styles to create a custom look. Which query would he use? Design View Simple Query Wizard Query Design View Query Wizard

Query Design View

Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?

Quick Access Toolbar

Which ribbon in layout view contains the commands to insert or delete new rows and columns in a report? Report Layout Tools Design Report Layout Tools Arrange Report Layout Tools Format Report Layout Tools Page Setup

Report Layout Tools Arrange

Reliabilty Principle

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

To resize a column to fit the data automatically

Select the column and choose home/cells/ format autofit, OR Go between the column to be sized and the next column and double click

Julia would like to rearrange her data so that it is in order by the first column

Select the data, choose sort, select first column

In Datasheet view, how does a user delete a record? Double-click the record Select the record and choose Delete from the Create Ribbon Double-click the record and choose Delete from the Database Tools Ribbon Select the record and choose Delete from the Home Ribbon

Select the record and choose Delete from the Home Ribbon

Print area

Selected portion of a worksheet to be printed.

range

Series of two or more adjacent cells in a column or row

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

Service Revenue

Which of the following is the default method for summarizing data in a PivotTable? Count Average Max Sum

Sum

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)

Solvency (p. 60

The ability of a company to pay interest as it comes due and to repay the balance of debt at its maturity.

Cell reference

The address of a cell indicating its column and row location.

What occurs when the cursor is moved over a cell and a user clicks?

The cell is selected

Active Cell

The cell ready for data entry

Materials quantity variance (p. 1145

The difference between the actual quantity times the standard price and the standard quantity times the standard price for materials.

Working capital (p. 59

The difference between the amounts of current assets and current liabilities.

Book value (p. 172

The difference between the cost of a depreciable asset and its related accumulated depreciation.

Discount (on a bond (p. 517

The difference between the face value of a bond and its selling price, when a bond is sold for less than its face value.

Premium (on a bond

The difference between the selling price and the face value of a bond when a bond is sold for more than its face value.

Variance (p. 1144

The difference between total actual costs and total standard costs.

Board of directors (p. 751

The group of officials elected by the stockholders of a corporation to formulate operating policies, select officers, and otherwise manage the company.

Category values

The group or category to which a series value belongs.

x-axis

The horizontal line on a graph

Row

The horizontal reference in a spreadsheet

Standard hours allowed (p. 1150

The hours that should have been worked for the units produced.

Perspective

The illusion that some parts of the 3-D chart are farther away from you than others.

Target net income (p. 954

The income objective set by management.

Residual income (p. 1108

The income that remains after subtracting from the controllable margin the minimum rate of return on a company's average operating assets.

Portrait

The orientation of a document where the page is taller than it is wide.

Landscape

The orientation of a document where the width is greater than the height.

Activity cost pool (p. 891

The overhead cost attributed to a distinct type of activity or related activities.

Maker (p. 407

The party in a promissory note who is making the promise to pay.

Payee (p. 407

The party to whom payment of a promissory note is to be made.

cell

The place data is entered; the intersection between a row and a column

Expense recognition principle (matching principle

The principle that dictates that companies match efforts (expenses); with results (revenues

Journalizing (p. 117

The procedure of entering transaction data in the journal. Ledger (p. 119) The group of accounts maintained by a company.

Posting (p. 120

The procedure of transferring journal entry amounts to the ledger accounts.

Depreciation (p. 171

The process of allocating the cost of an asset to expense over its useful life.

Depreciation (p. 453

The process of allocating to expense the cost of a plant asset over its useful life in a rational and systematic manner.

Amortization (p. 468

The process of allocating to expense the cost of an intangible asset.

Bank reconciliation (p. 352

The process of comparing the bank's account balance with the company's balance, and explaining the differences to make them agree.

Incremental analysis (p. 1189

The process of identifying the financial data that change under alternative courses of action.

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

Direct materials quantity standard (p. 1141

The quantity of direct materials that should be used per unit of finished goods.

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)

Relevant range (p. 943

The range of the activity index over which the company expects to operate during the year.

Total units (costs to be accounted for (pp. 850, 853

The sum of the units (costs started (or transferred) into production during the period plus the units (costs) in process at the beginning of the period.

Total units (costs accounted for (pp. 851, 853

The sum of the units (costs transferred out during the period plus the units (costs in process at the end of the period.

Accounting information system (p. 102

The system of collecting and processing transaction data and communicating financial information to decision makers.

Concentration of credit risk (p. 414

The threat of nonpayment from a single large customer or class of customers that could adversely affect the financial health of the company.

Fraud triangle (p. 336

The three factors that contribute to fraudulent activity by employees: opportunity, financial pressure, and rationalization.

Clear

To remove

What is the purpose of a primary key in a database? Unique Identifier Limits field size Provides a description Provides database security

Unique Identifier

IF function

Used when you want to assign a value to a cell based on a logical test

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

drag and drop

Using touch or the mouse to move or copy cells

What are the rules that a user should follow when entering data into a table? Text Validation Criterion Properties

Validation

Each rectangle in a spreadsheet.

What is a cell?

Cells that are aligned vertically

What is a column?

Comma

What is a common delimiter for data?

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?

4

What number would the function "=COUNT(A2:A7)" return?

Ctrl+X then Ctrl+V

What sequence of keyboard shortcuts would you use to MOVE information from one cell to another?

Line

What type of chart best shows how data changes over time?

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

Text file

Which files can be used to import data into Excel?

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?

horses, ducks, dogs, cats

Which set of data is in descending order?

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?

Workbook window

Window in which a workbook is displayed; also called worksheet window.

An Excel file that contains one or more worksheets

Workbook

Press Ctrl+Z

You accidentally delete a large portion of you spreadsheet. How do you get the information back?

A journal provides

a chronological record of transactions

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

Profit

The revenue from a sale less than the cost of the sale

Management by exception (p. 1090

The review of budget reports by top management focused entirely or primarily on differences between actual results and planned objectives.

Credit (p. 111

The right side of an account.

Header row

The row of field names.

Generally Accepted Accounting Principles (GAAP)

The rules, principals, and concepts established by the accounting profession that govern financial accounting

Conditional formatting

allows you to automatically apply formatting to cells based on their values

Goal Seek

allows you to work backward to find the desired input value

table

an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis

field

an individual piece of data, such as a last name

trendline

an object used to depict trends and forecast future data

Absolute Reference

cell refernence that points to a specific cell and does not change when copied ($B$4)

multiple data series

compares two or more sets of data in one chart

bar chart

compares values across categories using horiztontal bars

single data series

compares values for one set of data

superficial

concerned with or comprehending only what is apparent or obvious shallow

Deleting the contents of a cell also removes the format that has been applied to the cell.

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

Once a pie chart is created, it cannot be rotated.

false

Page Layout view is available for chart sheets.

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

Xlsx

file extension used for Microsoft Excel 2013 documents-identifying the type of program used to create it

To continue a series of dates, you can click and drag the

fill handle

Whenever you format data as a table, it will automatically include

filters

A debit to an asset account indicates

increase in the asset

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

column index number

the argument in a VLOOKUP function that identifies which lookup table column from which to return a value

active cell

the current cell, indicated by a dark border

The left side of an account is

the debit side

Dividned

the payment of past and current profits, less losses, previously retained in the business

rate

the periodic interest rate (ex. monthly)

Cell Alignment

the position in which text is placed within a cell

filtering

the process of displaying only records that meet specific conditions

data label

the value or name of a data point

row height

the vertical measurement of a row

Worksheet

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

Selection Tool

thick white cross

Fill Handle

this is the name of the small black square that displays in the bottom right corner of the active cell

stymie

to hinder or obstruct

Ascending order

to sort data in A>Z order

succumb

to submit to an overpowering force or yield to an overwhelming desire; give up or give in

substantiate

to support with proof or evidence; verify

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

Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the =.

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

Column

vertical group of cells named with a letter

strenuous

very remanding; requiring great exertion

Cell Value

what is typed into a cell-contained with in

Mary needs to export the table of FBLA members from the Southeast Region database to a document that does not allow editing. Which format should she use? .doc .pdf .rtf .txt

.pdf

Earnings per share (EPS

A measure of the net income earned on each share of common stock; computed as net income minus preferred stock dividends divided by the average number of common shares outstanding during the year.

Profit margin ratio (p. 716

A measure of the net income generated by each dollar of sales; computed as net income divided by net sales.

Payout ratio (p. 593

A measure of the percentage of earnings a company distributes in the form of cash dividends to common stockholders.

Payout ratio (p. 719

A measure of the percentage of earnings distributed in the form of cash dividends; calculated as cash dividends declared on common stock divided by net income.

Debt to total assets ratio (p. 713

A measure of the percentage of total financing provided by creditors; computed as total debt divided by total assets.

Current ratio (p. 710

A measure used to evaluate a company's liquidity and short-term debt-paying ability; calculated as current assets divided by current liabilities.

Current ratio (p. 59

A measure used to evaluate a company's liquidity and short-term debt-paying ability; computed as current assets divided by current liabilities.

Quality of earnings ratio (p. 248

A measure used to indicate the extent to which a company's earnings provide a full and transparent depiction of its performance; computed as net cash provided by operating activities divided by net income.

Input message

A message that appears when the cell becomes active; can be used to specify the type of data the user should enter in that cell.

Straight-line method (p. 455

A method in which companies expense an equal amount of depreciation for each year of the asset's useful life.

Activity-based costing (ABC

A method of allocating overhead based on each product's use of activities in making the product.

Straight-line method of amortization (p. 531

A method of amortizing bond discount or bond premium that allocates the same amount to interest expense in each interest period.

Effective-interest method of amortization (p. 534

A method of amortizing bond discount or bond premium that results in periodic interest expense equal to a constant percentage of the carrying value of the bonds.

Direct method (p. 630

A method of determining net cash provided by operating activities by adjusting each item in the income statement from the accrual basis to the cash basis. The direct method shows operating cash receipts and payments.

Percentage of receivables basis (p. 404

A method of estimating the amount of bad debts expense whereby management establishes a percentage relationship between the amount of receivables and the expected losses from uncollectible accounts.

Indirect method (p. 630

A method of preparing a statement of cash flows in which net income is adjusted for items that do not affect cash, to determine net cash provided by operating activities.

Editing mode

A mode in which you can edit part of an entry rather than the entire contents of a cell.

Worksheet (p. 195

A multiple-column form that companies may use in the adjustment process and in preparing financial statements.

Loss

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

Voucher system (p. 349

A network of approvals by authorized individuals, acting independently, to ensure that all disbursements by check are proper.

Chart sheet

A new sheet that is automatically inserted into the workbook, occupies the entire document window, and provides more space and details for the chart.

Screen Tip

A note that appears on the screen to provide information about a button, tracked change, or comment, or to display footnote or endnote. Also displays the text that will appear if you choose to insert a date or AutoText entry.

Value

A number entered into a spreadsheet cell that will be used for calculations

Number data

A numerical value that can be used in a mathematical calculation.

Manual page break

A page break that you insert anywhere on a page.

Responsibility accounting (p. 1091

A part of management accounting that involves accumulating and reporting revenues and costs on the basis of the manager who has the authority to make the day-to-day decisions about the items.

Lessor (p. 452

A party that has agreed contractually to let another party use its asset for a period at an agreed price.

Lessee (p. 452

A party that has made contractual arrangements to use another party's asset for a period at an agreed price.

Balanced scorecard (p. 767

A performance-measurement approach that uses both financial and nonfinancial measures, tied to company objectives, to evaluate a company's operations in an integrated fashion.

Impairment (p. 461

A permanent decline in the fair value of an asset.

Customers

A person or organization that purchases a product from a business

Exploded pie chart

A pie chart with one slice moved away from the pie as if someone were taking the piece out of the pie.

Function

A predefined formula that performs calculations using specific values called arguments.

Cash dividend (p. 584

A pro rata (proportional to ownership distribution of cash to stockholders.

Stock dividend (p. 585

A pro rata (proportional to ownership distribution of the corporation's own stock to stockholders.

Predetermined overhead rate (p. 807

A rate based on the relationship between estimated annual overhead costs and expected annual operating activity, expressed in terms of a common activity base.

Inventory turnover ratio (p. 296

A ratio that measures the liquidity of inventory by measuring the number of times average inventory sold during the period; computed by dividing cost of goods sold by the average inventory during the period.

Plot area

A rectangular area containing a graphical representation of the values in the data series.

Cell Range

A rectangular group of adjacent cells

Sales discount (p. 238

A reduction given by a seller for prompt payment of a credit sale.

External reference

A reference to a cell or range in a worksheet in another workbook.

Auditor's report (p. 19)

A report prepared by an independent outside auditor stating the auditor's opinion as to the fairness of the presentation of the financial position and results of operations and their conformance with generally accepted accounting standards.

Annual report (p. 19)

A report prepared by corporate management that presents financial information including financial statements, notes, a management discussion and analysis section, and an independent auditor's report.

Cursor

A representation on the screen of the mouse pointer location

Profit center (p. 1096

A responsibility center that incurs costs and also generates revenues.

Cost center (p. 1096

A responsibility center that incurs costs but does not directly generate revenues.

Investment center (p. 1096

A responsibility center that incurs costs, generates revenues, and has control over decisions regarding the assets available for use.

Total row

A row at the end of an Excel table that is used to calculate summary statistics for the columns in the table.

Status Bar

A row of information related to the current program. It is usually located at the bottom of a window. Not all windows will have one.

Style

A saved collection of formatting options - number formats, text alignment, font size and colors, borders, and background fills - that can be applied to cells in a worksheet.

Aging the accounts receivable (p. 404

A schedule of customer balances classified by the length of time they have been unpaid.

Cost reconciliation schedule (p. 853

A schedule that shows that the total costs accounted for equal the total costs to be accounted for.

Management discussion and analysis (MD&A) (p. 19)

A section of the annual report that presents management's views on the company's ability to pay near-term obligations, its ability to fund operations and expansion, and its results of operations.

Product life cycle (p. 628

A series of phases in a product's sales and cash flows over time; these phases, in order of occurrence, are introductory, growth, maturity, and decline.

Macro

A series of stored commands that can be run whenever you need to perform that task.

Font

A set of characters that uses the same typeface, style, and size.

Order of precedence

A set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second and so forth.

Financial Accounting Standards Board (FASB)

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

Thumbnail

A small representation of an item, such as an image, a page of content, or a set of formatting, obtained by scaling a snapshot of it. They are typically used to provide visual identifiers for related items.

Theory of constraints (p. 766

A specific approach used to identify and manage constraints in order to achieve the company's goals.

Template

A spreadsheet already set up for a specific purpose

Microsoft Excel 2007

A spreadsheet program you use to display, organize, and analyze numerical data.

Excel application

A spreadsheet written or tailored to meet the user's specific needs; typically includes reports and charts, a data entry area, a custom interface, as well as instructions and documentation.

Resizing handle

A square or dot on a selection box that lets you change and object's width and height.

Cost-volume-profit (CVP analysis (p. 947

A statement for internal use that classifies costs as fixed or variable and reports contribution margin in the body of the statement.

Vertical analysis (p. 696

A technique for evaluating financial statement data that expresses each item in a financial statement as a percentage of a base amount.

Ratio analysis (p. 54

A technique for evaluating financial statements that expresses the relationship among selected items of financial statement data.

Default template

A template that creates the blank Book1 workbook that opens when you start Excel, The default template contains no text or formulas, but it includes all the formatting available in every new workbook

Income Summary (p. 187

A temporary account used in closing revenue and expense accounts.

Comment

A text box that is attached to a specific cell in a worksheet in which you can enter notes.

Mini toolbar

A tool bar that appears next to the pointer whenever you select text and contains buttons for the most commonly used formatting commands, such as font, font size, styles, color, alignment, and indents that may appear in different groups or tabs on the Ribbon.

fill

A tool in Excel that allows you to copy down or across from an existing cell to enter formulas or data into other cells

Spreadsheet

A tool used in business for budgeting, inventory management, and decision making fir analyzing and reporting information.

Insert Function

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

Quick Access Toolbar

A toolbar located in the upper-left corner of the program window, which displays the Save, Undo, and Repeat buttons by default but can be customized to include any command.

Column chart

A type of chart that displays values in different categories as columns; the height of each column is based on its value.

Portrait orientation

A type of page orientation in which the page is taller than it is wide (like a typical business letter.)

Landscape orientation

A type of page orientation in which the page is wider than it is tall, so that text spans the widest part of the page.

Field name

A unique label that describes the contents of the data in a column, also called a column header.

Column header

A unique label that describes the contents of the data in a column.

Ribbon

A user interface design that organizes commands into logical groups, which appear on separate tabs. The Ribbon includes tabs that have access to various groups and commands according to the task being performed.

Time data

A value in a recognized time format.

Accent

A variation on an Excel theme color.

column

A vertical arrangement of cells, organised by letter

Financial perspective (p. 1153

A viewpoint employed in the balanced scorecard to evaluate a company's performance using financial measures.

Learning and growth perspective (p. 1154

A viewpoint employed in the balanced scorecard to evaluate how well a company develops and retains its employees.

Customer perspective (p. 1153

A viewpoint employed in the balanced scorecard to evaluate the company from the perspective of those people who buy and use its products or services.

Internal process perspective (p. 1154

A viewpoint employed in the balanced scorecard to evaluate the effectiveness and efficiency of a company's value chain, including product development, production, delivery, and after-sale service.

Diagram

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

Defined name

A word or string of characters associated with a single cell or a range; also called a range name.

Trademark (trade name

A word, phrase, jingle, or symbol that distinguishes or identifies a particular enterprise or product.

Custom template

A workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting.

Template

A workbook that you can open with labels, formats, and formulas already built into it from which you create new workbooks.

Planning analysis sheet

A worksheet that includes questions to help you define the purpose and objective of a workbook.

Promissory note (p. 407

A written promise to pay a specified amount of money on demand or at a definite time.

Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in that range that are greater than 100 but less than 500. What function should he use? TOTALIFS SUMIFS COUNTIFS AVERAGEIFS

AVERAGEIFS

Comparability (p. 65)

Ability to compare the accounting information of different companies because they use the same accounting principles.

The type of cell reference that refers to cells by their fixed position in a worksheet is:

Absolute

A cell surrounded by a black border and ready to receive data is the:

Active Cell

Services

Activites that exsit but that purchases a product from a business

Batch-level activities (p. 903

Activities performed for each batch of products rather than for each unit.

Unit-level activities (p. 903

Activities performed for each unit of production.

Which type of operation performs mathematical functions, such as MAX, MIN, or COUNT, on a group of records? Statistical Geometric Aggregate Algbraic

Aggregate

Accounts receivable (p. 398

Amounts customers owe on account.

Workspace

An Excel file that saves information about all of the currently opened workbooks, such as their locations, window sizes, zoom magnifications, and other settings.

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.

Contra revenue account (p. 238

An account that is offset against a revenue account on the income statement.

Contra asset account (p. 171

An account that is offset against an asset account on the balance sheet.

Fiscal year (p. 164, in margin

An accounting period that is one year long.

Cost principle

An accounting principle that states that companies should record assets at their cost.

Journal (p. 117

An accounting record in which transactions are initially recorded in chronological order.

International Accounting Standards Board (IASB

An accounting standard-setting body that issues standards adopted by many countries outside of the United States.

Process cost system (p. 840

An accounting system used to apply costs to similar products that are mass-produced in a continuous fashion.

Non-value-added activity (p. 901

An activity that adds cost to or increases the time spent on a product or service without increasing its market value.

Specific identification method (p. 286

An actual physical flow costing method in which items sold and items still in inventory are specifically costed to arrive at cost of goods sold and ending inventory.

Cost accounting (p. 798

An area of accounting that involves measuring, recording, and reporting product costs.

Segment (p. 1092

An area of responsibility in decentralized operations.

Optional argument

An argument that is not necessary for the function to calculate a value (if an optional argument is not included, Excel assumes a default value for it.)

Economic entity assumption (p. 66

An assumption that every economic entity can be separately identified and accounted for.

Monetary unit assumption (p. 66

An assumption that requires that only those things that can be expressed in money are included in the accounting records.

Periodicity assumption (p. 164

An assumption that the economic life of a business can be divided into artificial time periods.

Periodicity assumption (p. 66

An assumption that the life of a business can be divided into artificial time periods and that useful reports covering those periods can be prepared for the business.

Field

An attribute or characteristic of a person, place, or thing (such as a last name, address, city, or state); in Excel, each column represents a field.

Asset

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

Spreadsheet

An electronic file used to organize data and perform calculations

Digital signature

An electronic version of a signature that provides a way to authenticate a workbook; also called a digital certificate.

Reversing entry (p. 190, in margin

An entry made at the beginning of the next accounting period; the exact opposite of the adjusting entry made in the previous period.

Callable bonds (p. 512

Bonds that are the issuing company can retire at a stated dollar amount prior to maturity.

Secured bonds (p. 512

Bonds that have specific assets of the issuer pledged as collateral.

Leveraging (p. 716

Borrowing money at a lower rate of interest than can be earned by using the borrowed money; also referred to as trading on the equity.

splitting

Breaking the Excel window into four panes

On a PivotTable, what is a filed with values not entered as data but determined by a computation involving data in other fields called? Total field AutoSum Calculated Field Analyzed field

Calculated field

Par value stock (p. 577

Capital stock that has been assigned a value per share in the corporate charter.

Outstanding stock (p. 581

Capital stock that has been issued and is being held by stockholders.

Preferred stock (p. 582

Capital stock that has contractual preferences over common stock in certain areas.

No-par value stock (p. 577

Capital stock that has not been assigned a value in the corporate charter.

Current assets (p. 49

Cash and other resources that companies reasonably expect to convert to cash or use up within one year or the operating cycle, whichever is longer.

Investing activities (p. 625

Cash flow activities that include (a. cash transactions that involve the purchase or disposal of investments and property, plant, and equipment using cash and (b. lending money and collecting the loans.

Unearned revenues (p. 172

Cash received before a company earns revenues and recorded as a liability until earned.

Free cash flow (p. 61

Cash remaining from operating activities after adjusting for capital expenditures and dividends paid.

Free cash flow (p. 639

Cash remaining from operating activities after adjusting for capital expenditures and dividends paid.

Restricted cash (p. 359

Cash that is not available for general use but instead is restricted for a particular purpose.

Absolute reference

Cell reference that points to a specific cell and does not change when copied; appears with a dollar sign ($) before each column and row designation.

Individual entries in the FBLA address book would be entered into a: Cells Database Field Record

Cells

Merge & Center button

Centers cell contents over multiple cells

All of the FBLA officers have access to the spreadsheet of member contact information. Which feature in Excel allows others to view which officer made changes to the spreadsheet, when the change was made and what changes were made? Track Changes Change History History Names Manager

Change History

What is the range of the cells?

Choose "D"

Save the workbook "July"

Choose "Save As"

Sort the column from A to Z

Choose "Sort A to Z"

Use the fill button to copy the formula

Choose the down arrow, the first one

Notes receivable (p. 399

Claims for which formal instruments of credit are issued as evidence of the debt.

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"

How do you change the order of the worksheets in a workbook?

Click on a worksheet and drag-and-drop it to the position that you want it in

Copy the highlighted selection

Click on copy sign

To open a new Excel workbook

Click on file (Backstage) tab, select new, choose blank workbook

The steps to build a function in a cell are

Click on formula tab, chose insert function, enter required elements

To select the contents of columns A through C

Click on the column header for A and drag to the column header for C

To select the contents of the entire worksheet

Click on the heading box above row 1 and left of column A, OR Ctrl + A

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

The manager of Doggie Donuts needs to group inventory by types of dog food in stock. He needs a subtotal for each group. Which query type will display this information? Select Query Delete Query Crosstab Query Append Query

Crosstab Query

What are three valid methods for saving a database in Microsoft Access? Alt+S, File tab Save command,Quick Access Toolbar Save command Alt+S, Home Ribbon Save command, Quick Access Save command Alt+S, File tab Save command, Shortcut Save command Ctrl+S, File tab Save command, Quick Access Save command

Ctrl+S, File tab Save command, Quick Access Save command

Dennis needs to format his sales amount column to show dollar signs. Which format would he use? Currency Fixed General Number Text

Currency

Assets

Current assets; Long-term investments; Property, plant, and equipment; Intangible assets

Chad needs to remove a student from the FBLA databas. Which option should he choose? Add new Record Delete Record Move Field Edit Record

Delete Record

Which file type places each record on a separate line and uses a special character to separate fields? Bound Defined Delimited Isolated

Delimited

Which Chart Tools Ribbon tab allows a user to insert various labels on the chart? Style Design Layout Format

Layout

Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart? Design Layout Format Analyze

Layout

Juan is creating a chart graphing attendance at FBLA State Leadership conferences from the past five years from his database. He wants to display a list of colors, shapes, or patterns used as categories in a chart on the right side. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Legend

Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include? Axis Chart Title Data Label Legend

Legend

John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this? Report Filter Legend Fields Axis Fields Values

Legend Fields

Susie has a relational database for her catering business. She wants to create a form which shows the data in a customer table one record at a time. This type of form is a: Main Form Subform Hierarchical Form Datasheet

Main Form

Finished goods inventory (p. 282

Manufactured items that are completed and ready for sale.

Manufacturing overhead (p. 755

Manufacturing costs that are indirectly associated with the manufacture of the finished product.

Cost accounting system (p. 798

Manufacturing-cost accounts that are fully integrated into the general ledger of a company.

Carol has created a table from her database to see all information about FBLA chapters in her region. She needs to know which chapter has the most active members in the region. Which aggregate function should she use? Count Max Min Average

Max

Which software program is used to create a database on a computer, add, change, and delete data in the database and create queries, forms, and reports using the data in the database? Microsoft Access Microsoft Excel Microsoft OneNote Microsoft Outlook

Microsoft Access

True

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

Jim would like the data in row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change? Orientation Page break Print area Print titles

Print titles

Jessica needs to capitalize the first letter in each word. Which function would she use? Upper Trim Lower Proper

Proper

Nick needs to specify two characters for the student ID field. What area of design view would he access to specify this? Data Type Description Field Name Properties

Properties

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? Protect Workbook Protection Protect Sheet Share

Protect Workbook

When a database is created what is defined when names and data types are assigned to all data fields in a table? Structure Definition Design Theme

Struture

Susie has a relational database for her catering business. She wants to create a form which shows the the customer information at the top and any orders for that customer at the bottom. The orders section of the form is a: Main Form Subform Hierarchiacal form Datasheet

Subform

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this? Group Collapse Subtotal Outline

Subtotal

Total quality management (TQM

Systems implemented to reduce defects in finished products with the goal of achieving zero defects.

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

T-account

Plant assets (p. 448

Tangible resources that have physical substance, are used in the operations of the business, and are not intended for sale to customers.

Isabel wants to design a database for her FBLA club to include all the members information. What data type should she use for Last Name? Text Memo Number Date/Time

Text

Label

Text, symbols, dates, or numbers not used in calculations

Work in process (p. 282

That portion of manufactured inventory that has begun the production process but is not yet complete.

Theme color

The 12 colors that belong to a workbook's theme.

True

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

Data series

The Chart Wizard organizes data sources into a collection, where each data series is a range of data values that is plotted as a unit on the chart.

File Tab

The File Tab explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

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?

Fundamental Accounting Equation

The equation the total assest equal the sume of total liabilities and total stockholders' equity Assets= Liabilities + Stockholders' Equity

Gross profit (p. 241

The excess of net sales over the cost of goods sold.

Sale

The exchange between a business anda consumer where the business provides a customer a product and the business receives money or money substitutes

Interest

The expense of using borrowed money for a period of time

AutoComplete

The feature that helps make entering repetitive text easier. As you enter text in a worksheet, text that begins with the same letters as a previous entry in the same column is displayed.

PMT function

The financial function to calculate the amount paid into an investment or loan during each payment period.

When a cell that contains a function is selected the formula bar will display

The formula

Data marker

The graphical representation of the values in the data series of a chart, including items such as each column in a column chart, the pie slices in the pie charts, and the points used in XY (scatter) charts.

Public Company Accounting Oversight Board (PCAOB

The group charged with determining auditing standards and reviewing the performance of auditing firms.

Minor tick mark

The indication of the minor units of increment on the x- or y-axis.

Accounting (p. 5)

The information system that identifies, records, and communicates the economic events of an organization to interested users.

Off-balance-sheet financing (p. 526

The intentional effort by a company to structure its financing arrangements so as to avoid showing liabilities on its balance sheet.

Cell

The intersection of a column or row in a worksheet.

Cell

The intersection of a row and a column

Cell address

The intersection of a row and column

Stock split (p. 587

The issuance of additional shares of stock to stockholders accompanied by a reduction in the par or stated value per share.

Ctrl

The key presses to select non adjacent cells of data to create a chart

Debit (p. 111

The left side of an account.

Contribution margin ratio (p. 950

The percentage of each dollar of sales that is available to apply to fixed costs and contribute to net income; calculated as contribution margin per unit divided by unit selling price.

Earnings management (p. 190

The planned timing of revenues, expenses, gains, and losses to smooth out bumps in net income.

Opportunity cost (p. 1192

The potential benefit that may be obtained from following an alternative course of action.

Responsibility reporting system (p. 1093

The preparation of reports for each level of responsibility in the company's organization chart.

Value

The price someone is willing to pay for an item

Financial Accounting Standards Board (FASB

The primary accounting standard-setting body in the United States.

Revenue recognition principle (p. 164

The principle that companies recognize revenue in the accounting period in which it is earned.

Market interest rate (p. 514

The rate investors demand for loaning funds to the corporation.

Cost of capital (p. 1199

The rate of return that management expects to pay on all borrowed and equity funds.

Direct labor price standard (p. 1141

The rate per hour that should be incurred for direct labor.

Internal rate of return (IRR

The rate that will cause the present value of the proposed capital expenditure to equal the present value of the expected net annual cash flows.

Time value of money (p. 513

The relationship between time and money. A dollar received today is worth more than a dollar promised at some time in the future.

Sam completed a query on the UNC School system and wants to narrow his search to find which schools have a maximum tuition of $15,000 for in-state students. Which operator would he use? < <= > >=

<=

Delores is doing a search of the bed and breakfasts in Southport, NC. She wants to know which bed and breakfast is less than one mile from the waterfront and allows pets. Which comparison operator would she use? >=,and >,and <=,and <,and

<=,and

What text qualifier tells Excel that the cell contains a formula

=

False

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

The athletic director is looking for swim team purchase orders that are more than $200. What criteria would give her this information? >=200 AND swimming >200 OR swimming >=200 OR swimming >200 AND swimming

>200 AND swimming

worksheet

A 'page' of an Excel workbook, accessible by the tabs at the bottom

Statement of Cash Flows

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

Classified balance sheet (p. 48)

A balance sheet that contains a number of standard classifications and sections.

Zoom Slider

A bar in the lower-right corner of an Office program window that you can use to increase or decrease the size of the document on screen.

Lower-of-cost-or-market (LCM) (p. 295

A basis whereby inventory is stated at the lower of either its cost or its market value as determined by current replacement cost.

Sole Proprietorship

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

Consistency Principle

A business must use the same accounting methods and procedures from period to period

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

Worksheet group

A collection of two or more selected worksheets in which everything you do to the active worksheet also affects the other worksheets in the group.

Automatic color

A color option that uses the Windows default text and background color values.

Sort field

A field you use to order data.

Range

A group of worksheet cells, which can be adjacent or nonadjacent. (AKA a cell range)

Cell range

A group of worksheet cells, which can be adjacent or nonadjacent. (Example - A2:G19)

Personal Macro Workbook

A hidden workbook named Personal. xlsb that opens

row

A horizontal arrangement of cells, organised by number

Data bar

A horizontal bar added to the background of a cell whose length reflects the cell's value.

General ledger (p. 119

A ledger that contains all asset, liability, stockholders' equity, revenue, and expense accounts.

Business

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

Free cash flow (p. 714

A measure of solvency. Cash remaining from operating activities after adjusting for capital expenditures and dividends paid.

Days in inventory (p. 712

A measure of the average number of days inventory is held; computed as inventory turnover divided into 365 days.

Return on common stockholders' equity ratio (p. 715

A measure of the dollars of net income earned for each dollar invested by the owners; computed as income available to common stockholders divided by average common stockholders' equity.

Equivalent units of production (p. 847

A measure of the work done during the period, expressed in fully completed units.

Error alert

A message that appears if a user tries to enter a value in the cell that does

Just-in-time (JIT) processing (p. 910

A processing system dedicated to having the right amount of materials, parts, or products arrive as they are needed, thereby reducing the amount of inventory.

Return on assets ratio (p. 715

A profitability measure that indicates the amount of net income generated by each dollar of assets; calculated as net income divided by average total assets.

Return on assets ratio (p. 464

A profitability measure that indicates the amount of net income generated by each dollar of assets; computed as net income divided by average assets.

Spreadsheet

A program that allows you to use rows and columns of data to manage, predict, and present information.

Cash budget (p. 362

A projection of anticipated cash flows, usually over a one- to two-year period.

Excel table

A range of data you can treat as a distinct object in a worksheet.

Fill handle

A small black square in the lower-right corner of a selected cell or cell range that you drag to copy the contents of the selected cells to adjacent cells.

S- Corporation

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

Full disclosure principle (p. 67

Accounting principle that dictates that companies disclose circumstances and events that make a difference to financial statement users.

International Financial Reporting Standards (IFRS)

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

International Financial Reporting Standards (IFRS

Accounting standards, issued by the IASB, that have been adopted by many countries outside of the United States.

Accrual Accounting

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

Prepaid expenses

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

Value chain (p. 764

All activities associated with providing a product or service.

Internal control (p. 337

All the related methods and measures adopted within an organization to safeguard its assets and enhance the reliability of its accounting records, increase efficiency of operations, and ensure compliance with laws and regulations.

worksheet

Allows data easily to be summarized and charted

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.

Stockholder

An owner o a part of a corporation

active cell

Area in which you can enter data, surrounded by a heavy border

horizontal split bar

Bar going across the middle of a split screen

vertical split bar

Bar going up and down the middle of a split screen

Raw materials (p. 282

Basic goods that will be used in production but have not yet been placed in production.

formula

Beginning with an 'equals sign', a calculation or function that can be entered into a cell

Copy button

Button used to copy contents and format of a source area to the Office Clipboard

Decrease Indent

Button used to move the contents of a cell to the left two spaces

Increase Indent

Button used to move the contents of a cell to the right two spaces

Save the workbook "July"

Click the "file" button

Chief executive officer (CEO

Corporate officer who has overall responsibility for managing the business and delegates responsibilities to other corporate officers.

Ken has inserted a picture into his spreadsheet that was taken with a low-quality camera. Which tool would allow him to sharpen the image? Picture Styles Artistic Effects Corrections WordArt Styles

Corrections

Total cost of work in process (p. 758

Cost of the beginning work in process plus total manufacturing costs for the current period.

Cost of Goods Sold

Cost of the inventory the business has sold to customers. Also called cost of sales

Additions and improvements (p. 460

Costs incurred to increase the operating efficiency, productive capacity, or expected useful life of a plant asset.

Product costs (p. 756

Costs that are a necessary and integral part of producing the finished product.

Indirect fixed costs (p. 1097

Costs that are incurred for the benefit of more than one profit center.

Period costs (p. 756

Costs that are matched with the revenue of a specific time period and charged to expense as incurred.

Variable costs (p. 940

Costs that vary in total directly and proportionately with changes in the activity level.

Which of the following accounts is increased with a debit?

Dividends

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

Dividends account

Data definition table

Documentation that lists the fields to be maintained for each record and a description of the information each field will include.

Chad needs to change a members telephone number in the FBLA database. What step should he take? Add New Record Delete Record Move Field Edit Record

Edit Record

Contingencies (p. 526

Events with uncertain outcomes that may represent potential liabilities.

Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculation, and graph data?

Excel

Overtype mode

Excel replaces the character to the right of the insertion point

Research and development costs (p. 469

Expenditures that may lead to patents, copyrights, new processes, and new products; must be expensed as incurred.

Ordinary repairs (p. 460

Expenditures to maintain the operating efficiency and expected productive life of the asset.

Accrued expenses (p. 177

Expenses incurred but not yet paid in cash or recorded.

What term refers to an Excel Chart with offset pieces? Exploded Shattered Seperated Detached

Exploded

What is the process of transferring data from an Access database for use in another application called? Exporting Importing Pasting Distributing

Exporting

Activity-based management (ABM

Extends ABC from product costing to a comprehensive management tool that focuses on reducing costs and improving processes and decision making.

James wants to use an advanced function to search his spreadsheet for a specific string in a text string? REPLACE VLOOKUP SUBSTITUTE FIND

FIND

After reviewing tracked changes, they will no longer appear in your workbook.

False

The report Jamie created has a dark background and the page number is not displaying correctly. Which formatting option would he apply to the page number to add contrast between the background and the page number? Fill Color Font Size Font Color Format Painter

Font Color

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

Formula

NOW function

Function that will display the current system date and time

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?

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?

0

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

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

4

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

3

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

format

How you make a worksheet easier to read and understand

Range reference

Identification of a cell range using the upper-left and lower-right corners of the rectangular selection of cells.

Rows

Identified by numbers on the left side of the spreadsheet. (Horizontal)

Cash payback technique (p. 1200

Identifies the time period required to recover the cost of a capital investment from the net annual cash flow produced by the investment.

Cell

Individual locations on a spreadsheet

Understandability (p. 65

Information presented in a clear and concise fashion so that users can interpret it and comprehend its meaning.

hard copy

Information that exists on a physical medium such as paper

Timely (p. 65

Information that is available to decision makers before it loses its capacity to influence decisions.

Just-in-time (JIT inventory (p. 283

Inventory system in which companies manufacture or purchase goods just in time for use.

Staff positions (p. 752

Jobs that support the efforts of line employees.

absolute cell reference

Keeps the same cell reference as it copies a formula from one cell to another

enter

Key that can be used in place of the Paste button

HOME

Key that selects the cell at the beginning of a row with the active cell

PAGE DOWN

Key that selects the cell down one worksheet window from the active cell

PAGE UP

Key that selects the cell up one worksheet window from the active cell

Ctrl+c

Keyboard shortcut for copy

Ctrl+v

Keyboard shortcut for paste

Sarbanes-Oxley Act of 2002 (SOX

Law that requires companies to maintain adequate systems of internal control.

Which type of field enables a user to select from a list of values when updating the contents of a field? Calculated Attachment Lookup Hyperlink

Lookup

Tom wants to convert all text to lowercase. Which function she he use? Trim Upper Lower Proper

Lower

What action would Donna perform to create a new table named Customer Appreciation from the existing Customer Information table and Order History table? Delete Query Update Query Append Query Make Table Query

Make table Query

Days in inventory (p. 297

Measure of the average number of days inventory is held; calculated as 365 divided by inventory turnover ratio.

Profitability ratios (p. 701

Measures of the income or operating success of a company for a given period of time.

Which is NOT a file type that may be imported into Microsoft Access? Text files HTML files Microsoft Publisher files Microsoft Excel files

Microsoft Publisher files

Ashawn has created a table from his database to know which product has the lowest quantity in inventory from his spring catalog. Which aggregate function should he use? Count Max Min Average

Min

Frank needs to know which employee has used the least amount of sick leave. Using a calculated field, which total function would he use to answer his question? Average Count Max Min

Min

Stockholders' Equity

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

False

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

James wants his spreadsheet to return true when the logical value is false. What function should he use? IF OR NOT AND

NOT

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

Name Box

Ranges can be defined by

Naming the upper left cell : lower right cell

Jackson is starting a new company database to manage his new fall line of products. What form tool could he use to quickly create a set of tabs a user could click to access forms and reports in the database? Form View Layout View Design View Navigation Form

Navigation Form

Sally is the National Technical Honor Society president. She is creating a database to manage her membership information. What form tool could she use to quickly create a set of tabs a user could click to access forms and reports in the database? Form View Layout View Design View Navigation Form

Navigation Form

Juan needs to view and access all parts of his database. Where can these objects be located most efficiently? Design View Form View Layout View Navigation Pane

Navigation Pane

Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database? Objects pane Database pane Navigation pane List pane

Navigation pane

Retained earnings (p. 589

Net income that a company retains in the business.

Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use? Show Ink Delete Edit Comment New

New

name box

Next to the formula bar, the place a cell's name or cell reference is specified

volatile function

Number that the function returns is not constant

Long-term liabilities (Long-term debt

Obligations that a company expects to pay after one year.

Long-term liabilities (p. 512

Obligations that a company expects to pay more than one year in the future.

Current liabilities (p. 52

Obligations that a company reasonably expects to pay within the next year or operating cycle, whichever is longer.

Bonding (p. 344

Obtaining insurance protection against theft by employees.

Horizontal (category) axis

On the horizontal axis, or x-axis, are the data series' category values, or x values.

Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database? Close Create New Open From Existing Save As

Open from Existing

When printing pages, to keep the top 2 rows of data on every page

Page layout tab, print titles, and select rows to repeat

Arguments

Parameters added to a function that help in evaluating data, or performing calculations

Name box

Part of the Excel program window that displays the active cell address

Graph

Provides a visual representation of the workbook data.

Wendy wants to send the database report directly to the printer without editing. Which option should she choose? Print Preview Quick Print Print Selected Records

Quick Print

Contractual (stated interest rate (p. 513

Rate used to determine the amount of interest the borrower pays and the investor receives.

F4 key

Rather than retyping a formula, you can switch reference in editing mode by selecting the cell reference and pressing the F4 key.

Inventory Turnover

Ratio of cost of goods sold to average inventory. Indicates how rapidly inventory is sold

Direct materials (p. 755

Raw materials that can be physically and directly associated with manufacturing the finished product.

Which term refers to storing the same field in more than one location in a database? Redundancy Repetition Replication Recurrence

Redundancy

3-D Reference

Refers to the same cell or range in multiple worksheets in the same workbook. The reference specifies not only the range of rows and columns, but also the range of worksheet names in which the cells appear. (Example: WorksheetRange!CellRange )

Which type of database consists of a collection of tables, each of which contains information on a specific subject? Relational Interactive Collaborative Independent

Relaitonal

What type of database contains multiple collections of data that are related to one another? Joined Relational Flat Managed

Relatina;

Which of the following accounts has a normal credit balance?

Rent Revenue

Which ribbon displays report printing options? Report Design Tools Design Ribbon Report Design Tools Arrange Ribbon Report Design Tools Format Ribbon Report Design Tools Page Setup Ribbon

Report Design Tools Page Setup Ribbon

You are the owner of Ima Graphic Animator, Inc., a graphic design company. You want to place your logo at the top of the first page on a report. Where would you place the logo in the Report Design View? Report header section Page header section Report footer section Page footer section

Report Header Section

Assets (p. 9)

Resources owned by a business.

Temporary accounts (p. 186

Revenue, expense, and dividend accounts whose balances a company transfers to Retained Earnings at the end of an accounting period.

Accrued revenues (p. 175

Revenues earned but not yet received in cash or recorded.

Trading on the equity (p. 716

Same as leveraging.

Curt needs to create a backup to his existing database on an external hard drive. What action should he take? Close Create New Open from Existing Save As

Save As

Marty has spent a lot of time creating a database to track her sales contacts which she has been asked to share with her colleagues. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms? Save As Save as Database Template Create a Backup Save as PDF

Save as Database Template

Rachel has spent a lot of time creating a database for her FBLA chapter which she has been asked to share with other chapters in her Region. What would be the best method of sharing the structure of a database, including relevant tables, queries, and forms? Save As Save as Database Template Create a Backup Save as PDF

Save as Database Template

Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet? Shapes Picture SmartArt Screenshot

Screenshot

sensitivity analysis

Scrutinizing the impact of changing values referenced by a formula in a cell

Trading securities (p. 691

Securities bought and held primarily for sale in the near term to generate income on short-term price differences.

Available-for-sale securities (p. 691

Securities that are held with the intent of selling them sometime in the future.

A box in the upper left corner of the worksheet grid that selects all the cells in a worksheet is the:

Select All Box

To move the contents of cell B4 to F10

Select B4, roll over the edge of the cell and drag the cell to F10, OR Select B4, right-click and select Cut, click on F10, right-click Paste

Margo would like to have the contents of cell F12 turn red if the value falls below 12, what steps should she take?

Select Cell F12, choose home tab/cells/conditional formatting

What is the sequence to use to change the format of data in a cell

Select cell, choose home tab, cells grouping, format

Delete column A

Select column A

Frank would like to move the contents of column F in between the A and B columns he should

Select column F, choose cut, click on the column header for B and choose insert cut cells

Creating a chart follows these basic steps

Select data, choose chart, adjust format

Juan is creating a worksheet that has each week in the month of January in cells B2-B5. How can he put the Label "January" above the cells and center it

Select the cells above the weeks choose merge and center

John would like to add a banner at the top of his spreadsheet. Which object should he insert? Shapes Picture SmartArt Screenshot

Shapes

Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this? Tracking Changes Share Workbook Protect Workbook Export

Share Workbook

The labels along the lower border of the Excel window that identify each worksheet.

Sheet Tabs

To reference the data from cell b5 on sheet 1, a different sheet in the same workbook the syntax is

Sheet1!(b5)

Cash equivalents (p. 358

Short-term, highly liquid investments that can be readily converted to a specific amount of cash.

Bubble Chart

Shows patterns between two or more sets of data. The size of the data marker is determined by the 3rd value.

Tiny charts embedded in a cell that give a visual trend summary alongside your data are:

Sparklines

font size

Specifies the size of characters

Comparison operator

Symbol that indicates the relationship between two values.

format symbol

Symbols that assign a format to numbers as they are entered

Chart title

Term that appears above the plot area and describes the contents of the plot area and the data series.

Average collection period (p. 415

The average amount of time that a receivable is outstanding, calculated by dividing 365 days by the receivables turnover ratio.

Operating cycle (p. 50

The average time required to go from cash to cash in producing revenue.

Earnings per share (p. 718

The net income earned by each share of common stock; computed as net income less dividends on preferred stock divided by the average common shares outstanding.

Typeface

The specific design of a set of printed characters, including letters, numbers, punctuation marks, and symbols.

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

y-axis

The vertical line on a graph

Roman Numerals

This is NOT a number formats in Microsoft Excel?

Juan is creating a chart graphing his inventory database. He needs to name the chart August Inventory Report. Which tab in Chart Options would he select? Titles Axes Data Labels Legend

Titles

select

To make a cell active

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+C

Which keyboard shortcut would you press to copy cells that are selected in a spreadsheet?

workbook

a file containing related worksheets

Row Heading

a number at the far-left side of a row that can be clicked to select the entire row of cells

value

a number that represents a quantity or amount

data point

a numerical value that describes a single value on a chart

function

a predefined formular that performs a calculation

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

table array

a range containing a lookup table

output area

a range of cells containing results based on manipulating the variables

input area

a range of cells containing values for variables used in formulas

lookup table

a range that contains data for the basis of the lookup and data to be retreived

syntax

a set of rules that governs the structure and components for entering a function properly

fill handle

a small black square at the bottom-right corner of a cell

function screen tip

a small popup description that displays the arguments for a function as you enter it

worksheet

a spread sheet that contains formulas, functions, values, text, and visual aids

structured reference

a tag or use of a table element as a reference in a formula

category label

a text that describes a collection of data points in a chart

An account consists of

a title, a debit side, and a credit side

y axis

a vertical line that borders the plot area to provide a frame of reference for measurement

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.

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

Marci is searching a Planet Database. She wants to find out how many moons Saturn has and the names. Which comparison operator would she use? and equal not or

and

subjective

based on or influenced by personal feelings, tastes, or opinions.

MEDIAN function

calculates the midpoint value in a set of values

mixed cell reference

contains a relative and an absolute cell reference; the absolute part does not change but the relative part does change

nonadjacent range

contains multiple ranges of cells

chart area

contains the entire chart and all of its elements

Footer

content appearing at the bottom of each printed page

Header

content appearing at the top of each printed page

Orientation

describes the direction of the page or the paper you will print on (landscape or portrait)

formula autocomplete

displays a list of functions and defined names as you enter a function

column chart

displays data comparisons vertically in a chart

value axis

displays incremental values to identify the values of the data series

Status Bar

displays information about the current document

Name Box

displays the active cell address

TODAY function

displays the current date

NOW function

displays the current date and time

Page Break

displays the location of the different page breaks within the worksheet

Page Break Preview

displays the location of the different page breaks within the worksheet

MIN function

displays the lowest value in a range

sheet tab

displays the name of a worksheet within a workbook

surface chart

displays trends using two dimensions on a continuous curve

area chart

emphasizes magnitude of changes over time by filling in the space between the lines with a color

autofill

enables you to copy the contents of a cell or cell range or to continue a sequence by dragging the fill handle over an adjacent cell or range of cells

IIF function

evaluates a condition and returns one value if the condition is true and another value if the condition is false

File Tab

explains the access to the Excel Options dialog box and provides control to create new documents, save and print documents, as well as several other features.

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

explanation column

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

false

The Subtotal command will automatically

group, outline, and summarize your data.

clustered column chart

groups or clusters similar data in columns to compare data across categories

conditional formatting

highlights or emphasizes cells that meet certain conditions

cell address

identifies a cell by column letter and row number

The double-entry system requires that each transaction must be recorded

in at least two different accounts

The receipt of cash in advance for a customer

increases assets and liabilities

A revenue generally

increases assets and stockholders equity

sizing handle

indicated by faint dots on the outside border of the selected chart, enables you to adjust the size of the chart

relative cell reference

indicates a cell's relative location from the cell containing the formula; changes when the formula is copied

absolute cell reference

indicates a cell's specific location; does not change when the formula is copied

page break

indicates where data starts on a new printed page

synergy

interaction of two or more agents or forces so that their combined effect is greater than any individual part

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.

Freezing panes allows you to

lock row(s) or column(s) in place

HLOOKUP function

looks up a value in a horiztonal lookup table where the first row contains the values to compare with the lookup table

VLOOKUP function

looks up a value in a vertical lookup table and returns a related result from the lookup table

strident

loud, harsh, grating, or shrill; discordant

supine

lying on the back or having the face upward

Grouping worksheets allows you to

make changes to multiple worksheets at once

To combine several adjacent cells into one large cell, you will need to

merge cells

First-in, first-out (FIFO

method (p. 288) An inventory costing method that assumes that the earliest goods purchased are the first to be sold.

subtle

not immediately obvious; abstruse

If you want to display a date in a certain way (such as Friday, March 1, 2013), you can adjust the

number format

range

numbers and/or cell references, separated by commas (discrete) or by a colon (continuous)

circular reference

occurs when a formula directly or indirectly refers to itself

stacked column chart

places stacks of data in segments on top of each other in one coloumn, with each category in the data series represented by a different color

horizontal alignment

positions data between the right and left cell margins

vertical alignment

positions data between the top and bottom cell margins

Which of the following is not part of the recording process?

preparing a trial balance

pv

present value of the loan

supplement

something added to complete a thing, make up for a deficiency, or extend or strengthen the whole

stimulation

something that arouses or causes something to happen

COUNTBLANK function

tallies the number of blank cells in a range

COUNTA function

tallies the number of cells in a range that are not empty

COUNT function

tallies the numbers of cells in a range that contain values

A predesigned workbook you can use to create a new project quickly is called a(n)

template

suspension of disbelief

temporarily and willingly setting aside our beliefs about reality in order to enjoy a story

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.

column width

the horiztonal measurement of a column

cell

the intersection of column and row

breakpoint

the lowest value for a series or specific category of the lookup table

surpass

to be or go beyond, as in degree or quality; exceed

stigmatized

to characterize or brand as disgraceful or ignominious

Select

to choose or highlight a row, column, cell or range

synthesize

to join, to integrate

You can use Document Inspector

to remove personal information from a workbook.

If a value is changed in a cell, Excel recalculates all formulas that reference that cell.

true

Trial balance (p. 129

A list of accounts and their balances at a given time.

Post-closing trial balance (p. 188

A list of permanent accounts and their balances after a company has journalized and posted closing entries.

IF function

A logical function that returns one value if the statement is true and returns a different value if the statement is false.

Mortgage note payable (p. 537

A long-term note secured by a mortgage that pledges title to specific assets as security for the loan.

High-low method (p. 945

A mathematical method that uses the total costs incurred at the high and low levels of activity to classify mixed costs into fixed and variable components.

Replace

The command to overwrite letters and numbers in a workbook with another entry.

Materiality constraint (p. 67

The constraint of determining whether an item is large enough to likely influence the decision of an investor or creditor.

Depreciable cost (p. 455

The cost of a plant asset less its salvage value.

Current replacement cost (p. 295

The cost of purchasing the same goods at the present time from the usual suppliers in the usual quantities.

Direct materials price standard (p. 1141

The cost per unit of direct materials that should be incurred.

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?

Payment date (p. 585

The date cash dividend payments are made to stockholders.

Maturity date (p. 513

The date on which the final payment on a bond is due from the bond issuer to the investor.

Declaration date (p. 585

The date the board of directors formally authorizes the dividend and announces it to stockholders.

Record date (p. 585

The date when the company determines ownership of outstanding shares for dividend purposes.

Total labor variance (p. 1148

The difference between actual hours times the actual rate and standard hours times the standard rate for labor.

Labor quantity variance (p. 1148

The difference between actual hours times the standard rate and standard hours times the standard rate for labor.

Margin of safety (p. 956

The difference between actual or expected sales and sales at the break-even point.

Total overhead variance (p. 1150

The difference between actual overhead costs and overhead costs applied to work done, based on standard hours allowed.

Overhead controllable variance (p. 1162

The difference between actual overhead incurred and overhead budgeted for the standard hours allowed.

Overhead volume variance (p. 1163

The difference between normal capacity hours and standard hours allowed times the fixed overhead rate.

Labor price variance (p. 1148

The difference between the actual hours times the actual rate and the actual hours times the standard rate for labor.

Materials price variance (p. 1145

The difference between the actual quantity times the actual price and the actual quantity times the standard price for materials.

Total materials variance (p. 1145

The difference between the actual quantity times the actual price and the standard quantity times the standard price of materials.

Net present value (NPV

The difference that results when the original capital outlay is subtracted from the discounted net cash flows.

Discontinued operations (p. 687

The disposal of a significant component of a business.

In Excel, numbers are used as column headings

false

Number values are often called labels.

false

Operator

A mathematical symbol that you use to combine values and then return a single value.

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

Which ribbon includes the commands to apply a quick table style to a range of cells? Home Insert Page Layout Data

Home

Which tab/group combination contains the tool to have text appear at an angle within the cell?

Home/alignment

Paste Options button

Immediately displays when you click the Paste button

What is the process of bringing data containing text fields separated by commas into Excel called? Importing data Data collection Data integration Data migration

Importing data

Non-theme font

In Excel, a font that can be used no matter what theme the workbook has.

Page break preview

In Excel, a view that displays the worksheet as it is divided up into pages. Anything outside of the print area is grayed out.

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?

Sub procedure

In VBA, all of the actions performed in a macro.

Value field

In a PivotTable, a field that contains summary data.

Relative reference

In a formula, the address of a cell range based on the relative position of the cell that contains the formula and the cell the formula refers to. If you copy the formula, the relative reference is adjusted to reflect the new location of the cell containing the formula.

Leader line

In a pie chart, a line that connects a data label outside of a pie slice to its corresponding label when space limitations force Excel to place a data label far from its slice.

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?

Banded rows

In an Excel table, rows of alternating colors that make data easier to read.

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.

Chart area

The entire chart and all the elements contained in the chart or graph, such as the title and legend.

mixed cell reference

Cell with only one dollar sign before the column or row

Row

Horizontal groups of cells named with a number

Times interest earned ratio (p. 713

A measure of a company's solvency and ability to meet interest payments as they come due; calculated as income before interest expense and income taxes divided by interest expense.

Asset turnover ratio (p. 717

A measure of how efficiently a company uses its assets to generate sales; computed as net sales divided by average total assets.

Comprehensive income (p. 690

A measure of income that includes all changes in stockholders' equity during a period except those resulting from investments by stockholders and distributions to stockholders.

Pro forma income (p. 702

A measure of income that usually excludes items that a company thinks are unusual or non-recurring.

Return on investment (ROI

A measure of management's effectiveness in utilizing assets at its disposal in an investment center.

Capital lease (p. 527

A contractual agreement allowing one party (the lessee) to use the assets of another party (the lessor) ; accounted for like a debt-financed purchase by the lessee.

Franchise (p. 470

A contractual arrangement under which the franchisor grants the franchisee the right to sell certain products, to provide specific services, or to use certain trademarks or trade names, usually within a designated geographic area.

Privately held corporation (p. 570

A corporation that has only a few stockholders and whose stock is not available for sale to the general public.

Publicly held corporation (p. 570

A corporation that may have thousands of stockholders and whose stock is traded on a national securities market.

Treasury stock (p. 579

A corporation's own stock that has been reacquired by the corporation and is being held for future use.

Job order cost system (p. 798

A cost accounting system in which costs are assigned to each job or batch.

Process cost system (p. 799

A cost accounting system used when a company manufactures a large volume of similar products.

Controllable cost (p. 1093

A cost over which a manager has control.

Sunk cost (p. 1195

A cost that cannot be changed by any present or future decision.

Deficit (p. 589

A debit balance in retained earnings.

Sam enters a numeric criterion in a query to find out which UNC schools have an enrollement that equals 5,000 or greater. What would he enter? ="5000" 5000 "<5000" =->"5000"

=>"5000"

Current liability (p. 506

A debt that a company reasonably expects to pay (1 from existing current assets or through the creation of other current liabilities, and (2 within one year or the operating cycle, whichever is longer.

Current cash debt coverage ratio (p. 642

A cash-based ratio used to evaluate liquidity, calculated as cash provided by operating activities divided by average current liabilities.

Cash debt coverage ratio (p. 643

A cash-based ratio used to evaluate solvency, calculated as cash provided by operating activities divided by average total liabilities.

Cash debt coverage ratio (p. 714

A cash-basis measure used to evaluate solvency, computed as cash from operations divided by average total liabilities.

Current cash debt coverage ratio (p. 710

A cashbasis measure of liquidity; computed as cash provided by operations divided by average current liabilities.

Date function

A category of Excel functions that store and calculate dates as numeric values, representing the number of days since January 1, 1900.

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.

Combination chart

A chart that combines two or more chart types in a single graph.

Line chart

A chart that compares values from several categories with a sequential order, such as dates and times that occur at evenly spaced intervals. The values are indicated by the height of the line.

Embedded chart

A chart that is displayed within a worksheet and one that you can place alongside the data source, giving context to the chart.

XY scatter chart

A chart that shows the patterns or relationship between two or more sets of values.

Pie Chart

A chart used to visually display the parts of a whole as percentages, a circular chart divided into triangular areas proportional to the percentages of the whole

NSF check (p. 353

A check that is not paid by a bank because of insufficient funds in a bank account.

relative cell reference

A code that points to a particular cell, which changes depending where that code is entered; for example, it may point to a cell that is one column to the left and one row above the cell where the formula is entered

absolute cell reference

A code that points to a unique cell, independently of where that code is entered; dollar signs are used to 'lock' the column and row

Group

A collection of buttons for related commands on the Ribbon.

A range of cells is

A collection of individual cells

Record

A collection of related fields that are grouped together, in Excel, each row represents a record.

Standard color

A color that is always available regardless of the workbook's theme.

Custom color

A color you specify as a mixture of red, blue, and green color values, which makes available 16.7 million custom colors - more colors than the human eye can distinguish.

Pixel

A colored dot that, when combined with other pixels, forms a picture or graphics display; stands for picture element.

Bar chart

A column chart turned on its side, so each length is based on its value.

Operations costing (p. 855

A combination of a process cost and a job order cost system, in which products are manufactured primarily by standardized methods, with some customization.

Text data

A combination of letter, numbers and some symbols.

A small red triangle in a cell indicates

A comment associated to the cell

Corporation (p. 570

A company organized as a separate legal entity, with most of the rights and privileges of a person.

Price-earnings (P-E ratio (pp. 703, 718)

A comparison of the market price of each share of common stock to the earnings per share; computed as the market price of the stock divided by earnings per share.

Operating lease (p. 527

A contractual agreement allowing one party (the lessee) ; accounted for as a rental.

Capital lease (p. 452

A contractual agreement allowing one party (the lessee) to use another party's asset (the lessor); accounted for like a debt-financed purchase by the lessee.

Purchase Allowance

A decrease in the cost of purchases because the seller has granted the buyer a discount (an allowance) from the amount owed

Purchase Discount

A decrease in the cost of purchases earned by making an early payment to the vendor

Purchase allowance (p. 234

A deduction made to the selling price of merchandise, granted by the seller so that the buyer will keep the merchandise.

Units-of-activity method (pp. 456, 477

A depreciation method in which useful life is expressed in terms of the total units of production or use expected from the asset.

Declining-balance method (pp. 456, 476

A depreciation method that applies a constant rate to the declining book value of the asset and produces a decreasing annual depreciation expense over the asset's useful life.

Accelerated-depreciation method (p. 456

A depreciation method that produces higher depreciation expense in the early years than the straight-line approach.

Theme

A designed collection of formatting options that include color, graphics, and background images.

Perpetual inventory system (p. 230

A detailed inventory system in which a company maintains the cost of each inventory item and the records continuously show the inventory that should be on hand.

Electronic funds transfer (EFT

A disbursement system that uses wire, telephone, or computer to transfer cash from one location to another

Fraud (p. 336

A dishonest act by an employee that results in personal benefit to the employee at a cost to the employer.

Dividend (p. 584

A distribution by a corporation to its stockholders on a pro rata (proportional to ownership basis

Materials requisition slip (p. 804

A document authorizing the issuance of raw materials from the storeroom to production.

Charter (p. 574

A document that describes a corporation's name and purpose, types of stock and number of shares authorized, names of individuals involved in the formation, and number of shares each individual has agreed to purchase.

Time ticket (p. 805

A document that indicates the employee, the hours worked, the account and job to be charged, and the total labor cost.

Purchase invoice (p. 231

A document that supports each purchase.

Standard cost accounting system (p. 1159

A double-entry system of accounting in which standard costs are used in making entries and variances are recognized in the accounts.

Cumulative dividend (p. 582

A feature of preferred stock entitling the stockholder to receive current and unpaid prior-year dividends before common stockholders receive any dividends.

Click and Type

A feature that allows you to double-click a blank area of a document to position the cursor in that location, with the appropriate paragraph alignment already in place.

Scrollbar

A feature that allows you to scroll up and down or left and right in order to view portions of your work area

Spelling checker

A feature that check the words in a document against the program's built-in dictionary and helps you avoid typographical errors.

Summary entry (p. 802

A journal entry that summarizes the totals from multiple transactions.

Depreciation cost per unit Bond certificate (p. 513

A legal document that indicates the name of the issuer, the face value of the bonds, and such other data as the contractual interest rate and the maturity date of the bonds.

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

Border

A line or box that frames a cell.

Gridlines

A line that extends across the plot area indicating the location of tick marks on the chart's horizontal or vertical axis.

Border

A line that prints along the side of a table cell or around the outside of selected text.

Hyperlink

A link in a file, such as a workbook, to information within that file or another file that, when clicked, switches to the file referenced by the hyperlink.

Chart of accounts (p. 120

A list of a company's accounts.

Adjusted trial balance (p. 183

A list of accounts and their balances after all adjustments have been made.

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.

Theme font

A font associated with a particular design theme and used for headings and body text.

Sans serif font

A font that does not have the small horizontal lines (called serifs) at the tops and bottoms of letters.

Serif font

A font that includes small horizontal lines (called serifs) at the tops and bottoms of letters.

Bonds (p. 512

A form of interest-bearing notes payable issued by corporations, universities, and governmental entities.

Job cost sheet (p. 803

A form used to record the costs chargeable to a specific job and to determine the total and unit costs of the completed job.

=F6/3

A formula that contains a cell reference

Average

A function that identifies the numeric average of a set of values in a column or a row

Autosum

A function to add a set of values in a column or a row

Product

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

Cost-volume-profit (CVP analysis (p. 947

A graph showing the relationship between costs, volume, and profits.

PivotChart

A graphical representation of the data in a PivotTable in which you can interactively add, remove, filter, and refresh data fields.

Limitied Liability Corporation

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

PivotTable

An interactive table that enables you to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.

Production cost report (p. 850

An internal report for management that shows both production quantity and cost data for a production department.

Last-in, first-out (LIFO method (p. 289

An inventory costing method that assumes that the latest units purchased are the first to be sold.

Periodic inventory system (p. 230

An inventory system in which a company does not maintain detailed records of goods on hand and determines the cost of goods sold only at the end of an accounting period.

Periodic Inventory System

An inventory system in which the business does not keep a continuous record of the inventory on hand. Instead, at the end of the period, the business makes a physical count of the inventory on hand and applies the appropriate unit cost to determine the cost f the ending inventory

Matt needs to add his contacts to the Driver Education database. To do this quickly what predefined object can he create? Application Parts Quick Start Sharepoint List Database Object

Application Parts

Prepaid expenses (prepayments

Assets that result from the payment of expenses that benefit more than one accounting period.

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

Property, plant, and equipment (p. 51

Assets with relatively long useful lives that companies use in operating the business.

Which of the following represents the expanded basic accounting equation?

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

Which accounts normally have debit balances?

Assets, expenses, and dividends.

standard properties

Associated with all Microsoft Office files and include author, title, subject

True

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

Terry's form needs to display the FBLA member's exact age based on today's date and their birth date. Which type of control would allow Terry to display information that would change every day? Bound Unbound Button Calculated

Calculated

Noncontrollable costs (p. 1093

Costs incurred indirectly and allocated to a responsibility center that are not controllable at that level.

Mixed costs (p. 944

Costs that contain both a variable and a fixed cost element and change in total but not proportionately with changes in the activity level.

Direct fixed costs (p. 1097

Costs that relate specifically to a responsibility center and are incurred for the sole benefit of the center.

Fixed costs (p. 941

Costs that remain the same in total regardless of changes in the activity level.

Frank needs to know the number of service calls he has received from 123 Walnut Street in one week. Using a calculated field, which total function would he use to answer this question? Average Count Max Sum

Count

Tabs

Demonstrate the access to the various groups of commands on the ribbons, Excel includes 8 tabs on the Ribbon.

Which Ribbon is visible when a PivotTable is selected and allows a user to apply various styles to the PivotTable? Layout Options Design Format

Design

Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart? Design Layout Format Analyze

Design

Which view displays the area used to create a table or to modify the structure of a table? Design Datasheet File Backstage

Design

Riley is using Access to collect data for a science project. He is creating a report and wants to apply predefined color and font scheme formats. Which Report Layout Tools contextual tabs should he select for the theme group? Design tab Format tab Arrange tab Page Setup tab

Design Tab

Ashton needs to add a footer to the data entry form in his gaming database. Which view will allow Aston to add a footer? For View Layout View Design View Navigation Form

Design View

Erin needs to prepare a custom table for her recipe collection. She has to include the ingredient portions. Which is the correct tool to use? Design View Template Sharepoint List Application Parts

Design View

Juan is creating a new database. He wants to assign field names. Which view is BEST to create the new database? Design View Form View Layout View Navigation Pane

Design View

Tanya created a report to show people signed up for a 5K race. She needs to increase the size of the report header so she can add the race logo control. Which view will allow her to resize the header? Report View Print View Design View Layout View

Design View

Comparability

Investors like to compare a company's financial statements from one year to the next. Therefore, a company must consistently use the same accounting method each year

The steps to create a new file based on a template are

Double-click a template file, and Open Excel, click File, click New, select template to use

John wants to create a query that will display the total number of hamburger patties in stock at two different locations. The results should display the sum of the values from each location. Which solution should John use for his query? Crosstab Query Expression Builder Simple Query Totals

Expression Builder

Eddie needs to search for the specific employee that lives on 225 Mayberry Lane. What command would he use? Filter Find Sort Ascending Sort Descending

Find

Internal rate of return method (p. 1205

Finds the interest yield of the potential investment.

You are employed as an assistant at Doggie Daycare. Your boss asked you to update the new pet patient information. If you opened the form in Design view, which view should you switch to in order to enter patient information? Layout View For View Design View Report View

Form View

John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use? Design Layout Format Analyze

Format

Linda wants to ensure birthdates are entered as MM/DD/YYYY. Which field property will be used? Look up Format Default Value Field Size

Format

Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt? Data Design Style Format

Format

When a chart is selected, what tabs will appear in the chart tools contextual menu

Format, layout, design

In Microsoft excel what do you use to emphasize certain entries and make the worksheet easier to read and understand? Formatting Printing Arranging Configuring

Formatting

An element in the Excel window that displays the value or formula contained in the active cell is the:

Formula Bar

Faithful representation (p. 65

Information that is complete, neutral, and free from error.

Verifiable (p. 65

Information that is proven to be free from error.

Dillano wants to ensure social security numbers are entered in a proper format. Which field property will be used? Input Mask Format Default Field Size

Input Mask

First-In, First-Out (FIFO) Cost Method

Inventory costing method by which the first costs into inventory are the first costs out to costs of goods sold. Ending inventory is based on the costs of the most recent purchase

Just-in-time (JIT) Inventory

Inventory system in which goods are manufactured or purchased just in time for sale.

Yes

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

A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:

Quick Analysis Tool

The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers? RANDOM(1000,5000) RAND BETWEEN(1000,5000) RAND() BETWEEN(1000,5000)

RAND BETWEEN(1000,5000)

Lower-of-cost-and-net-realizable-value (LCNRV) rule

Requires that an asset be reported in the financial statements at whichever is lower -- its historical cost or its net realizable value

Cash (p. 358

Resources that consist of coins, currency, checks, money orders, and money on hand or on deposit in a bank or similar depository.

After a query is created, which action must take place to display the results of the query? Go Run Get Retrieve

Run

Gross Profit

Sales revenue minus cost of goods sold. Also called gross margin

Doughnut Chart

Shows relative values of different categories to the whole. Displast multiple sets of data.

Stock Chart

Shows stock market data like highs, lows, opening price and closing price.

Name Box

Shows the address of the active cell Ex: A1

date stamp

Shows the date a workbook was created or the time period it represents

sparkline chart

Shows trends and variations in a range of data within a single cell

Insertion Point

Shows various forms based on the function being performed and the location to which the mouse is pointing. When you are inserting text, it is an I-beam.

Jane wants to determine how many FBLA students have registered for the state conference from the Coastal region. Which query view would she use? Design View Simple Query View Query Design View Query Wizard

Simple Query View

What can you use to easily filter PivotTables and cube functions interactively in a worksheet? Slicer Cutter Division Sliver

Slicer

What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? Slivers Patials Slicers Movers

Slicers

Liquidity (p. 58

The ability of a company to pay obligations that are expected to become due within the next year or operating cycle. Liquidity ratios (p. 59) Measures of the short-term ability of the company to pay its maturing obligations and to meet unexpected needs for cash.

Securities and Exchange Commission (SEC

The agency of the U.S. government that oversees U.S. financial markets and accounting standard-setting bodies.

Net Realizable Value (NRV)

The amount a business could get if it sold the inventory less the cost of selling it

Legal capital (p. 577

The amount of capital that must be retained in the business for the protection of corporate creditors.

Cost

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

Contribution margin (CM

The amount of revenue remaining after deducting variable costs.

Contribution margin per unit (p. 949

The amount of revenue remaining per unit after deducting variable costs; calculated as unit selling price minus unit variable cost.

Authorized stock (p. 576

The amount of stock that a corporation is authorized to sell as indicated in its charter.

Stated value (p. 577

The amount per share assigned by the board of directors to no-par stock.

Paid-in capital (p. 577

The amount stockholders paid in to the corporation in exchange for shares of ownership.

Sheet tab

The area at the bottom of a worksheet that identifies the worksheet; clicking a sheet tab makes the worksheet active.

Going concern assumption (p. 66

The assumption that the company will continue in operation for the foreseeable future.

Normal capacity (p. 1142

The average activity output that a company should experience over the long run.

Average collection period (p. 711

The average number of days that receivables are outstanding; calculated as receivables turnover divided into 365 days.

Primary value axis

The axis in a column chart that displays the primary values associated with the heights of each column.

Secondary value axis

The axis in a column chart that displays the secondary values associated with the heights of each column.

Formula bar

The bar located above the workbook window in which the contents of a cell are displayed.

T account (p. 111

The basic form of an account.

Name box

The box located on the far left of the Formula bar in which the cell reference to the active cell is also displayed.

Name Box

The box that contains the cell address

Excel Help Button

The button located at the right end of the ribbon and labeled with a question mark (?), that provides access to the Excel Help system

Cell reference

The column letter and the row number. Ex: B12

Find

The command to locate specific letters and numbers in a workbook.

Scroll Bars

The navigation buttons are located on the bottom of the vertical and horizontal scroll bar to move up, down, left or right in the typing area

Cash (net) realizable value (p. 402

The net amount a company expects to receive in cash from receivables.

Direct labor quantity standard (p. 1142

The time that should be required to make one unit of product.

Title Bar

The title bar text changes to display the name of the active document. Located at the top of the document

Chart Title

The title or name of chart usually identifying what data depicts, most often found at center top of chart area

Cost of goods sold (p. 228

The total cost of merchandise sold during the period.

Simple interest

The type of interest in which the interest paid is equal to a percentage of principal for each period that the money had been lent.

Note Payable

a liability repersented by a written promise that requires future payment

Border

a line that indicates a boundary of a cell or range

border

a line that surrounds a cell or range

sparkline

a miniature chart contained in a single cell

What is typically included in the range of data selected to create a chart? Titles only Numeric data and totals only Numeric data, totals, and titles Numeric data and titles

Titles only

Drag and drop

To move an item (either text or a graphic) by selecting it and dragging it with the mouse.

Delete

To remove a cell or cells from a worksheet, shifting the remaining worksheet cells into the space previously occupied by the deleted cell or cells; also to remove a worksheet entirely from a workbook.

Cut

To remove data from a cell and place it on the Office Clipboard.

Rename sheet

To rename a sheet in a workbook. Right click the sheet tab ,click rename.

zoom out

To shrink the appearance of a worksheet or chart

Descending order

To sort data in Z>A order

Refresh

To update

Cost of goods manufactured (p. 758

Total cost of work in process less the cost of the ending work in process inventory.

Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this? Export Share Workbook Tracking Changes Protect Workbook

Tracking Changes

Sales returns and allowances (p. 237

Transactions in which the seller either accepts goods back from the purchaser (a return) or grants a reduction in the purchase price (an allowance( so that the buyer will keep the goods.

Accrual-basis accounting (p. 66)

Transactions that change a company's financial statements are recorded in the periods in which the events occur.

The data that displays in the Formula Bar is referred to as the:

Underlying Value

Another name for a constant value.

Value

Data label

Value or name assigned to individual data points.

John would like to display the count of employees last name on the y-axis. What area would he drag this information to in order to display correctly? Report Filter Legend Fields Axis Fields Values

Values

assumptions

Values in cells that you can change to determine new values for formulas

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?

Formulas

What term refers to mathematical equations used in Excel to perform calculations?

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?

Alignment

When data is entered into a cell, the default alignment is labels to the left and values to the right

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?

True

When you hide a column in Microsoft Excel, the column doesn't appear, but the data is still there. (T/F)

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?

Page Layout

Which Page View shows how a worksheet will appear on a printout?

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?

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.

=$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?

The data header information must be bold

Which is NOT necessary for organizing data to make it easier to sort?

Ctrl

Which key should you press if you wanted to select cells that are noncontiguous or not beside one another?

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?

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?

Text file

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

Indirect labor (p. 755

Work of factory employees that has no physical association with the finished product, or for which it is impractical to trace the costs to the goods produced.

False

You access the hide/unhide command for a group of selected cells by left clicking on the selected cells. (T/F)

True

You can change the chart type even after it has been created. (T/F)

A mouse pointer shaped like a hand when on a cell means

You can grab and move the cell contents

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?

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?

Partnership

a business that has more than one owner, where for legal and tax purposes, the business and the owners are considered the same

Column Heading

a column letter above the grid that identifies each column

formula

a combination of cell references, operators, values, and/or functions used to perform a calculation

record

a complete set of data for an entity

spreadsheet program

a computer application used to create a modify spreadsheets

Filter

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

color scale

a conditional format that displays a particular color based on the relative value of a cell's contents to other selected cells

icon set

a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range

AutoSum

a function that automatically adds selected cells

nested function

a function that contains another function embedded inside one or more of its arguments

Chart

a graphic representation of values used to identify trends and contrasts in data

x axis

a horiztonal line that borders the plot area to provide a frame of reference for measurement

gridline

a horiztonal or vertical line that extends from the horizontal or vertical axis through the plot area

legend

a key that identifies color, gradient, picture, texture, or pattern fill assigned to each series in a chart


Kaugnay na mga set ng pag-aaral

When delivering 2022 Armada, what should you tell new owners will happen if the vehicle is not operated for 14 consecutive days?

View Set

Lost colony of Roanoke/ Jamestown

View Set

research citations and documentations

View Set

CS232: Computer Organization Final Exam

View Set

Managing People Quiz Questions for Test 1

View Set