Microsoft Offie Excel Units A,B,C,D & E Essay Example

in excel, the electronic spreadsheet you work work in is called a ______

A) tablet

B) databook

C) numericsheet

D) worksheet

D) worksheet

in excel, a worksheet is contained in a file is called

A) workbook

B) workpad

C) notebook

D) datapad

A) workbook

you can use the spreadsheet to _____ by using variable values to investigate and sample different outcomes

A) represent values graphically

B) organize data

C) create what-if data scenarios

D) perform calculations

C) create what-if data scenarios

all excel formulas begin with the ____

A) +

B) *

C) =

D) slash

C) equal sign

Excel recognizes any entry as a value if it is a number or it begins with _____

A) +

B) =

C) $

D) all of the above

D) all of the above

you can use the _____ key(s) on the keyboard to navigate a worksheet

A) [Ctrl]

B) zoom

C) arrow

D) [enter]

C) arrow

to move one screen to the left press _____

A) [Ctrl][Home]

B) [Atl][Page Up]

C) [Ctrl][Page Left]

D) [Alt][Page Down]

B) [Atl][Page Up]

to quickly jump to the last cell in a worksheet press ____

A) [Alt][Page Down]

B) [Shift Down]

C) [Page Down]

D) [Ctrl][End]

D) [Ctrl][End]

the Undo button allows you to reverse up to ____ previous actions, one at a time

A) 1

B) 10

C) 100

D) 1,000

C) 100

Possible paper orientations for printing a worksheet are landscapes and _____

A) preview

B) portrait

C) normal

D) page break

B) portrait

In the formula =(G15-G14)*$M$3/4, which mathematical operation if performed first?

A) $M$3/4

B) (G15-G14)*$M$3

C) (G15-G14)

D) (G15-G140)/4

C) (G15-G14)

which method of entering a function requires the user to know the name and initial characters of a function?

A) manually typing the function

B) using the Insert Function button

C) using the Sum button

D) using the Sum list arrow

A) manually typing the function

when cells are copied using Excel’s copy function, what happens to the data in the copied cells?

A) the data is permanently deleted from the copied cells

B) the data is temporarily deleted from the copied cells

C) that data remains in its original function

D) the data is moved to another location and removed from its original location

C) the data remains in its original location

Which tab and group will allow the insertion of rows and columns in a worksheet?

A) HOME tab, Styles group

B) PAGE LAYOUT tab, Page Format group

C) HOME tab, Cells group

D) PAGE LAYOUT tab, Cells group

C) HOME tab, Cells group

to insert cells, click the Insert list arrow in the Cells group on the _____ tab, then click Insert Cells






an Excel user should use a relative cell reference when it is important to ____.

A) preserve the relationship to the formula location

B) never change the formula

C) preserve the exact cell address in a formula

D) memorize the formula

A) preserve the relationship to the formula location

which formula contains a mixed cell reference?

A) =(A6=A7)*.20

B) =($A$6+A7)*.20

C) =($A$6+$A$7)*.20

D) =($A6+$A$7)*.20

D) +($A6+$A$7)*.20

A(n) ____ cell reference tells excel to substitute new cell references within the copied formulas as necessary.

A) mixed

B) absolute

C) relative

D) parameter

C) relative

Which of the following is NOT a Paste list arrow option?

A) pasting values only

B) pasting values with number formatting

C) pasting cell selectors

D) pasting formulas only

C) pasting cell selectors

t0 continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

A) SUM function

B) redo

C) fill handle

D) copy/paste

C) fill handle

Excel templates make a creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template

A) formulas

B) formatting

C) labels

D) data

D) data

the file extension .xltx indicates what type of Excel file?

A) excel template

B) excel workbook

C) excel worksheet

D) excel formulas only worksheet

A) excel template

the default file extension for an Excel 2013 workbook is ____

A) .xltx

B) .xslx

C) .xlsx

D) .xlts

C) .xlsx

the ____ of a cell determines how the labels and values look.

A) value

B) formula

C) label

D) format

D) format

the default Accounting number format adds dollar signs and ____ decimal places to the data

A) one

B) two

C) three

D) four

B) two

to apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in ____ group on the HOME tab, and the clock a style in the gallery.

A) Alignment

B) Styles

C) Cells

D) Editing

B) Styles

In the _____ window you can search for online pictures (or Clip Art) in, through the Bing search engine, or on your SkyDrive.

A) Find Images

B) Insert Pictures

C) Add Clip Art

D) Add Images

B) Insert Pictures

you can apply font styles and alignment options using the ____ tab of the Ribbon






You can apply font styles and alignment options using the _____ dialog box

A) format cells

B) insert

C) conditional formatting

D) autocorrect

A) format cells

Font _____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet

A) styles

B) formats

C) fonts

D) clip arts

A) styles

the format painter button is found in the _____ group on the HOME tab of the Ribbon.

A) Alignment

B) Styles

C) Clipboard

D) Font

C) Clipboard

which of the following removes only the contents of a selected row or column

A) the Delete button

B) the [Delete] key

C) the Delete common on a shortcut menu

D) All of the above

D) all of the above

you insert a comment in a worksheet by using a command on the ____ tab on the Ribbon






____ shows you how a fill color will look before you apply it

A) Sneak Peek

B) Live Preview

C) Quick Look

D) Advance Look

B) Live Preview

a theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon






the default format for cells that meet a condition with conditional formatting is

A) dark blue fill with light red text

B) light red fill with dark red text

C) light blue fill with dark blue text

D) dark red fill with light red text

B) light red fill with dark red text

if you create a conditional formatting rule you can modify it using the Conditional Formatting _____

A) Rules Options dialog box

B) Rules template

C) Rules Wizard

D) Rules Manager

D) Rules Manager

you can add multiple worksheets to a workbook by clicking the HOME tab on the Ribbon, pressing and holding ____, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want to add, clocking the Insert list arrow in the Cells group on the HOME tab, then clicking Insert Sheet.

A) [Esc]

B) [Shift]

C) [F4]

D) [Alt]

B) [Shift]

the spelling button is found in the proofing group on the _____ tab on the Ribbon.






each value in a cell selected for a chart is called a ____

A) data marker

B) tick mark

C) data point

D) data series

C) data point

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

A) line

B) area

C) column

D) pie

C) column

To show how individual volume changes over time in relation to total volume, us a(n) ______

A) area chart

B) bar chart

C) column chart

D) line chart

A) area chart

a pie chart ______

A) compares distinct, unrelated objects over time using a horizontal format

B) compares trends over even time intervals

C) compares trends over uneven time or measurement intervals

D) compares sizes of pieces as part of a whole

D) compares trends over uneven time or measurement intervals

a combination chart can add a(n) ____ axis to chart related data

A) combo

B) secondary

C) tertiary

D) clustered

B) secondary

In a pipe chart, slices that are pulled away are said to be ____

A) identified

B) exploded

C) opened

D) extracted

B) exploded

a common example of a text delimiter is ____

A) ,

B) =

C) +

D) (

A) ,

the CONCATENATE function joints two or more ___ into one.

A) strings

B) formulas

C) cells

D) function

A) strings

which excel function averages cells in a range based on a specific condition?






which button do you click on the Function Library group to select SUMIf from the list of functions?

A) statistical

B) Math & Trig

C) Math Functions

D) Trig & Calculus

B) Math & Trig

Which error code will display if a formula contains a text error?

A) #NA

B) #NUM!


D) #####


Which error code will display if a value in a formula is not available?




D) #NA

D) #NA

which error code will display if a number is used invalidly in a cell?

A) #NUM!




A) #NUM!

when used in formulas, names become ____ cell references by default.

A) absolute

B) relative

C) linked

D) unlinked

A) absolute

which of the following is not a valid named range?

A) Alaska59

B) New quote

C) salary

D) Top_Sales

B) New Quote

a condition that can be answered with a true or false response is called a(n) ____

A) logical test

B) what-if analysis

C) True_False condition

D) IF analysis

A) logical test

Chapter 8 The Electronic Claim

Accredited Standards Committee X12

The United States standards body formed by the American National Standards Institute (ANSI) for cross-industry development, maintenance, and publication of electronic data exchange standards.

Accredited standards Committee X12 Version 5010

System developed by the American National Standards Institute that meets HIPAA standards for the transmission of either ICD-9 or ICD-10 diagnostic code data.

application service provider

A practice management system available over the internet in which data are housed on the server of the ASP, but the accounts are managed by the health care provider’s staff.

back up

A duplicate data file, such as tape, CD-ROM, disk, or zip disk, used to record data; it may be used to complete or redo the operation if the primary equipment fails.


A group claims for different patients from one office submitted in one computer transmission.

business associated agreement

Contract between the provider and a clearinghouse that submits the electronic claims on behalf of the provider.

cable modem

A modem used to connect a computer to a cable television system that offers online services.

claim attachments

Documents that contain information, hard copy or electronic, related to a completed insurance claim that assists in validating the medical necessity or explains the medical service or procedure for payment (e.g., operative report, discharge summary, invoice).


a service company that recieves electronic or paper claims from the provider, checks and prepares them for processing, and transmits them in HIPAA-complaint format to the correct carriers

code sets

Any set of codes with their descriptions used to encode data elements, such as tables of terms, medical concepts, medical diagnostic codes, or medical procedure codes.

covered entity

same as definition in Chapter 2

data elements

Medical code sets used uniformly to document why patients are seen (diagnosis, ICD-9-CM) and what is done to them during their encounter (procedure, CPT-4, HCPCS).

digital subscriber line

A high-speed connection through a telephone line jack and usually a means of accessing the Internet.

direct data entry

Keying claim information directly into the payer system by accessing over modem dial-up or DSL. This is a technology to directly enter the information into the payer system via the access whether it is dial-up or DSL.

electronic data interchange

The process by which understandable data items are sent back and forth via computer linkages between two or more entities that function alternatively as sender and receiver.

electronic funds transfer

A paperless computerized system enabling funds to be debited, credited, or transferred, eliminating the need for personal handling of checks.

electronic remittance advice

An online transaction about the status of a claim.

clearing house

Software that receives insurance claims from the providers; performs, edits and sends them to the insurance carriers.


An add-on software program to practice management systems that can reduce the time it takes to build or review insurance claims before batch transmission to the carrier.

National Standard Format

The name of the standardization of data to reduce paper and have more accurate information and efficient organization.

HIPAA Transaction and Code Sets Rule

This regulation under Health Insurance Portability and Accountability Act (HIPAA) defines the standardized methods for transmitting electronic health information. The TCS process includes any set of HIPAA-approved codes with their descriptions used to encode data elements, such as tables of terms, medical concepts,medical diagnostic codes, or medical procedure codes. TCS regulations were implemented to streamline electronic data interchange.


A combination of letters and numbers that each individual is assigned to access computer data.

real time

Online interactive communication between two computer systems allowing instant transfer of information.

standard transactions

The electric files in which medical data are compiled to produce a specific format.


A T-carrier channel that can transmit voice or data channels quickly.

taxonomy codes

Numeric and alpha provider specialty codes that are assigned and classify each health care provider when transmitting electronic insurance claims.

trading partner

same as definition for Business associate in Chapter 2


To assign a code to represent data. This is done for security purposes.

trading partner agreement

Contract between the provider and a clearinghouse that submits the electronic claims on be half of the provider.


American National Standards Institute


Accredited Standards Committee X12


administrative simplification enforcement tool


application service provider


automated teller machine


direct data entry


Department of Health and Human Services


Digital Subscriber Line


electronic data interchange


electronic funds transfer


electronic health record


electronic medical claim


explanation of Medicare benefits


electronic protected health information


electronic remittance advice


Health Plan Identifier


Internal Revenue Service


Medicare Transaction System


National Drug Code


National Standard Format


practice management software

TCS Rule

HIPAA Transaction and Code Set Rule


Uninterruptible Power Source

Exchange of data in a standardized format through computer systems is a technology known as..

Electronic Data Interchange (EDI)

The act of converting computerized data into a code so that unauthorized users are unable to read it is a security system known as….


Payment to the provider of service of an electronically submitted insurance claim may be received in approximately…

Two Weeks or Less

Medical Practices that do not use the services of clearinghouses submit claims through a ____to the insurance company…

Carrier-Direct/Direct Links

The benefits of using HIPAA standard transaction and code set

A).Translations of various formats to the HIPAA-complaint standard format

B).Reduction in time of claims preparation

C).Fewer Claim Rejections

D).Cost-Effective method through loss prevention’

E).Fewer delays in processing and quicker response time

F).More accurate coding with claims edits

G).Consistent Reimbursement

Dr. Morgan has 10 or more full-time employees and submits insurance claims for his Medicare patients. Is his medical practice subject to the HIPAA transaction rules?

Yes-Compliance is Required

Dr. Maria Montez does not submit insurance claims electronically and has five full-time employees. Is she required to abide by HIPAA transaction rules?

It is not required to comply

Standard Code Sets used for the following….

)( Physician Services)-(CPT), Current Procedural Terminology

(Diseases and Injuries)-International Classification of Diseases, Ninth Revision, Clinical Modifications, Volumes 1 and 2 (ICD-9-CM)

(Pharmaceuticals and Biologicals)-National Drug Code (NDC)

The staff at College clinic submits professional health care claims for each of their providers and must use the industry standard electronic format called_______________ to submit them electronically

ASC X12N 837P

The billing department at college clinic must use the industry standard electronic format called ___________ to transmit health care claims electronically

ASC X12N 837I

The Medicare fiscal intermediary (insurance carrier) uses the industry standard electronic format called____to transmit payment information to the college clinic and college hospital.

ASC X12N 835

It has been 3 weeks since Gordon Marshall’s health care claim was submitted to the XYZ insurance company and you wish to inquire about the claim.The industry standard electronic format that must be used to transmit this inquiry is called_________

ASC X12N 276/277

Dr.Practons insurance billing specialist must use the industry standard electronic format called __________to obtain information about beatrice garcia’s health policy benefits and coverage from the insurance plan.

ASC X12N 270/271

The family practice taxonomy code is..


The American National Standards Institute formed the___which developed the electronic data exchange standards.


Refer to table 8-4 in the handbook to name the levels of data collected to construct and submit a electronic form

High-level information

Claim-level information

Specialty claim-level information

Service line-level information

Specialty service line-level information

Other information

HIPAA electronic standards for claim submission were upgraded to version ________ and all providers,payers, and clearinghouses were required to use it effective January 1, 2012


The claims attachment standards have not yet been adopted;however the health insurance specialist should prepare for the final rule that is expected to be published no later than __________

January 1, 2014

The _______ is an all numeric 10-character number assigned to each provider and required for all transactions with health plans effective May 23, 2007


The most important function of a practice management system is _________

accounts receivable

To look for and correct all errors before the health claim is transmitted to the insurance carrier,you may print an insurance billing worksheet or perform a front-end audit or


much of the patient and insurance information required to complete the cms-1500 form can be found on the ___________ form that is used to post charges.


Add on software to a practice management system that can reduced the time it takes to build or review a claim before batching is known as a / an


Software that is used in a network that serves a group of users working on a related project allowing access to the same data is a /an


Many insurance companies, such as Medicare, provide instant access to information about pending claims though online _______________

ERA-electronic remittance advice

An electronics funds transfer agreement may allow for health plans to ___________ overpayments from a provider’s bank account.


The medicare electronic remittance advice was previously referred as a/an _________________________

EOMB-explanation of medicare benefits

On completion of a signed agreement and approval of enrollment with a third party payer for electronic claims submission, the provider will be assigned a ________________________ number.


When computer software is upgraded, the physician must submit a batch of ___________________ to the insurance carrier to determine if claims can be transmitted successfully.

test files

Under HIPAA transaction standard ASC X12 version 5010,a _____________ digit zip code is required to report service facility locations.


The ________________________________ is a electronic tool that enables organizations to file a complaint against a noncompliant covered entity that is negatively impacting the efficient processing of claims.


Access controls allow organizations to create _____________ for each job category that will restrict access to certain data.


Under HIPAA, ________________ efforts must be made to limit the use and disclosure of PHI.


Electronic claims are submitted by means of


Today most claims are submitted by means of


The online error process allows providers to

correct claim errors prior to transmission of the claim

Under HIPAA, data elements that are use uniformly to be documented why patients are seen (diagnosis) and what is done to them during their encounter(procedure) are known as

medical code sets

The standard transaction that replaces the paper cms-1500 (02-1200) claim form and more than 400 versions of the electronic national standard format is called the


The next version of the electronic claims submission that will be proposed for consideration once lessons are learned from implementation of version 5010 will be

version 6020

A standard unique number that will be assigned to identify individual health plans under the affordable care act is referred to as an


Uniform patient identifiers

were required on all claims effective may 23 2007

Encounter forms should be reviewed annually for changes that may have been made to

diagnosis codes

procedure codes

HCPCS codes

A technique for entry of data which can save time and keystrokes by recording commands into memory is referred to as use of


An authorization and assignment of health benefits signature for a patient who was treated in the hospital but has never been to the providers office

is not required;the authorization obtained by the hospital applies to that provider’s claim filing.

A paperless computerized system that enables payments to be transferred automatically to a physician’s bank account by a third party payer may be done via

EFT-electronic funds transfer

An electronic Medicare remittance advice that takes the place of a paper medicare explanation of benefits (EOB) is referred to as

ANSI 835

A method for submitting claims electronically by keying information into the payer system for processing is accomplished through use of

direct data entry-DDE

A report that is generated by a payer and sent to the provider to show how many claims were received as electronic claims and how many were automatically rejected and will not be processed is called an

transaction transmission summary

The HIPAA transaction standard ASC X12 version 5010 requires that anesthesia services be reported

per minute

Which section of the HIPAA security rule recommends unique usernames and passwords to log on to any computer with access to PHI?

technical safeguards

Which section of the HIPAA security rule recommends use of screensavers that will activate 1 to 60 minutes of inactivity

physical safeguards

Verification of successful backups by comparing original records with copied records should be performed

once a week

An acceptable method for ensuring that ePHI cannot be recovered from a hard drive that is being disposed of is by

deletion of files

formatting hard drives


Like paper claims electronic claims require the performing physicians signature


Claims must be submitted to various insurance payers in a single batch electronic transmission


under hipaa insurance payers can require health care providers to use the payers own version of local code sets


as icd and cpt codes are deleted and become obsolete they should immediately be removed from the practices computer system


hipaa has brought forth electronic formats for determination of eligibility for a health insurance plan


hipaa’s electronic standard transactions are identified by a four digit number that proceeds asc x12n


implementation of icd-10 resulted in a upgrade to hipaa transaction standard asc x12 version 6020


hipaa requires that the npi number be used to identify employers rather than inputting the actual name of the company when submitting claims


hipaa limits how computer systems may transmit data and formats for storage of data


a paper remittance advice is generated by medicare when using ansi 835 version 5010


hipaa transaction standard asc x12 version 5010 allows employers identification numbers to be used to report as a primary identifier


when transmitting electronic claims inaccuracies that violate the hipaa standard transaction format are known as syntax errors


an organization may file a complaint online against someone whose actions impact the ability of a transaction to be accepted or efficiently processed by using the administrative simplification enforcement tool (ASET)


incidental uses and disclosures of protected health information(PHI) are permissible under hipaa when reasonable safeguards have been used to prevent inappropriate revelation of phi


deleting files or formatting the hard drive is sufficient to keep electronic protected health information from being accessed


Physical Science Chapter 4 Homework

Water beads up on wax paper because its cohesive forces are greater than the adhesive forces.


Water molecules move back and forth between the liquid and gaseous phases

At all times.

What is the temperature that is the same numerical value on both the Fahrenheit and Celsius scale?


Molecules are the smallest units of matter with the characteristic properties of a substance.


What is the average temperature of healthy humans on the Celsius scale?


The process by which gases form solids without first becoming a liquid is known as


The nutritionist’s Calorie is really a kilocalorie.


The sum of all the energy of the molecules of an object is called the temperature of that object.


Which thermodynamic law says that you cannot convert 100 percent of a heat source into mechanical energy?

second law of thermodynamics

Which of the following involves the greatest amount of heat when warming 100 grams of ice?

evaporating the water

Liquid water at 0ºC has to give up energy in order to become ice at 0ºC.


The amount of heat needed to increase the temperature of 1 gram of a substance 1 degree Celsius is known as

specific heat.

The water in a swimming pool is cooler than the surrounding sidewalk because it

has a higher specific heat.

A statement that the energy supplied to a system in the form of heat, minus the work done by the system, is equal to the change in internal energy represents the

first law of thermodynamics.

The attractive forces between unlike molecules is called


When water vapor condenses to a liquid

it transfers heat to the surroundings.

A passive solar home with direct solar gain requires

all of these. (storage mass without carpets or drapes, a large, open window space, and a calculated overhang.)

The transfer of heat that occurs when energy moves from molecules to molecule is called


Temperature is a measure of the amount of heat stored in a substance.


Adding heat to a substance

sometimes does not result in a temperature change.

Your body judges temperature

very poorly, sensing only heat flow.

Molecules in a solid

are held in nearly fixed positions by strong attractive forces.

The degrees on the Celsius scale are larger than degrees on the Fahrenheit scale.


The molecules of a gas are much farther apart than molecules in a solid or liquid.


Iron heats up more rapidly than does aluminum because it has a greater specific heat.


The heat needed to warm one gram of water one Celsius degree is called a


When the evaporation rate equals the condensation rate, the space above the liquid is


The heat death of the universe is a theoretical time in the future when the universe is supposed to

freeze at a uniform low temperature.

The process by which solids vaporize without first becoming a liquid is called


In the equation: q=mC(Delta)T, the C stands for the

specific heat.