acct 628 unit n
Terms
undefined, object
copy deck
- compare and merge workbooks command
- to merge workbooks, you need to add the ) ) ) ) command to the quick access toolbar by clicking the office button, clicking excel options, and clicking customize
- xml
- storing data in _ format allows you to use in different situations
- merge
- instead of putting the shared workbook on a server, you might want to distribute copies to your reviewers via email. once everyone has entered their changes and _ the chagned copies into one master workbook that wil contain all changes
- xml
- once you import the _ data,you can analyze it using excel tools you can also import data from an excel workbook to an _ file
- share
- when you _ excel files with others, you need to set up your workbooks so that several users can ) them, which menas they can simultaneously open them from a network server, modify them electronically, and return their revisions to you for incorporation w/ others' chagnes
- changes
- when you sharea workbook, you can have excel keep a list of all _ to the workbook, which you can view and print at any time
- blue
- i there is text in the cell, the text format changes to become a _ underlined hyperlink or the color the current workbook theme usings for hyperlinks
- msn money website
- you can use built in excel queries to import stock quotes and currency rates from the _ _ _
- map
- once a schema is attached to a workbook, a schema is called a _
- passowrd
- when you place a shared workbook on a server, you may want to use a _ so that only authorized people will be able to open it or make chagnes to it
- shared workbook
- you can make an excel file a _ _ so that several users can open and modify it at the same time.
- customized web query
- easiest way to retrieve data from a particular web page on aregular basis is to create a _ _ _
- web
- you can paste data rom a _ page into a worksheet and then manipulate and format it using excel
- track
- when you share workbooks, it is often helpful to ) modifications, or id who made which changes. you can accept the changes you agree with, and if you disagree with any changes, you can reject them
- schema
- contains the rules for the xml file by listing all of the fields in the xml document and their characteristics, such as the type of data they contain
- share
- when you _ workbooks, you have to consider how you will protect information that you don't want everyone to see and how you can control revisiosn others will make to your files
- hyperlinks
- in excel worksheets, you can create _ to information on the web
- map
- when you _ an element to a worksheet, you place the element name on the worksheet in a specific location
- schema
- you can import xml data without a _ and excel wil create one for you
- change history
- each change is id'd with the username and date. in addition to highlighting changes, excel keeps track of changes in a ) ) , a list of all changes that you can keep track of changes in a _ _
- validate
- when a schema is not used, you are unable to _ the data that is imported
- web query
- often you'll want to incorporate information from the web into an excel worksheet or analysis. using excel, you can obtain data from a website by using a ), then save the info in an existing or new excel workbook
- passowrd
- remember if you lose your _, you will not be able to open or change workbok. they are case sensitive, so you must type them exactly as you want users to type them
- xml
- a universal data format for business and industry information sharing
- populated
- the mapped elements on the worksheet will fill with (or be _ with) data from the xml file
- mapping
- after _ is complete, you can import an xml file w/ a structure that conorms to the workbook schema.
- schema
- to import xml data, excel requires a file called a _ that describes the structure of the xml file
- advanced tab
- the _ _ of the share workbook dialog box allows you to specify the length of time the change hsitory is saved and when the files will be updated with the changes
- validate
- a schema is used to ) xml data, making sure the data follows the rules given in the file
- XML
- you can import _ data into an excel workbook