Mis test 3 2019
caption
Alternate text that appears instead of a field's actual name in datasheets, forms, and reports.
liability
An amount owed by a business
credit
An arrangement to receive cash, goods, or services now and pay for them in the future.
Object
An item in an Access database, such as a table, query, form, or report
types of values ( data validation)
Any value whole number decimal list dates time text length custome
asset
Anything of value that is owned
The warning alert
Do not prevents an entry from being stored in the cell
One-to-one
Each entity in the relationship will have exactly one related entity
data validation controls
Ensure that specific data values are correct
Press and hold down the ______ key, and click the worksheet tabs you want to select.
CTRL
to select Non adjacent sheets in a workbook use:
CTRL
Normalization
The process of applying rules to a database design to ensure that information is divided into the appropriate tables.
Intranet vs. Internet
Intranet=local, Private; Internet=World Wide, Public.
If you want your inserted content to update automatically when you edit the source, you should
LINK
LAN
Local Area Network
destination
When you save a workbook that contains external reference formulas Excel stores the most recent results of those formulas in the ____ file.
key
Which of the following are used as common fields across tables so that fields can be accessed, organized, and manipulated in Access?
IP address
a unique string of numbers separated by periods that identifies each computer using the Internet Protocol to communicate over a network.
80% of finance is about
behavior
Focusing on the desired outcomes of your presentation forces you to make it more
audience-oriented
Table
collection of fields and group of related records
Database
collection of related tables and other objects
Data marts
contains a subset of data warehouse information
Intranets are also called
corporate portals
expenses
cost of goods and services
fixed costs
costs that remain constant as output changes
display on data validation
criteria input message error
field
describes the entity; an attribute or characteristic of the entity
To customize theme colors, click the _____ tab.
design
If an Excel table is COPY+PASTED into a Word document, what happens when the Excel table is updated?
destination document do not change
If an Excel table is EMBEDDED a Word document, what happens when the Excel table is updated?
destination document do not change
error data validation
determines what happens after incorrect data is added
name manager dialog box
displays all of the names in the workbook
If an Excel table is LINK a Word document, what happens when the Excel table is updated?
document change
If you trust the provider of source files, you can choose to ____ the content, which allows the external reference formulas to function and updates the links in the destination workbook.
enable
best software for budget
excel
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
external
A(n)__________is a secure network that uses the Internet and Web technologies to connect intranets of business partners so that communication between organizations is possible.
extra net
The Net and the Web are the same thing
false
The information alert prevents an entry from being stored in the cell.
false
A column heading database table is called a
field
A link is a connection between two ____ allowing information to be transferred from one to the other.
files
________________ multiple sheets allow you to quickly process data based on the same structure
grouping
option for arranging your workbooks?
horizontal, vertical, cascade
____ are usually represented by words with colored letters and underlines or images.
hyperlinks
When you build a worksheet for other users, you may decide to add a(n) _____ message to a cell even if you do not validate the data in that cell.
input
If you delete a value from one cell in a worksheet group, the content is also deleted from the same cell in all the worksheets in the group.
is deleted in all
Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.
is made to all
url
is the common name of the location of a document or site on the Internet.
Once you have determined your focus, the next step is to identify the _____ of your presentation
key points
Data warehouses
large computer files that store millions and even billions of pieces of individual data
Which of the following is NOT an option for arranging your workbooks?
lateral
workbook protection
limits users' ability to make changes to the workbook's structure and windows
If you need to use data located in one workbook in the other workbook, you have to create a(n) ____ between the two workbooks.
link
by default
lock protection is on on each cell and worksheet protection is off
The best way to automate the creation of donor letters with different names and addresses is through:
mail merge
CAN /MAN
metropolitan area network
investments
Money put into an account intended for growth
If Excel successfully accessed the link and updated the values from the source document, the status in the Edit Links dialog box will be ___
OK
(PAN)
Personal Area Network
Database Management System (DBMS)
Provides secure access to shared data for client applications that request database services.
webs are constructed using
HTML
When you import a formatted Word outline, each heading formatted with the ____ style in Word becomes a slide title
Heading 1
Validation criteria
Rules that dictate the data to enter a cell
to select adjacent sheets in a workbook use:
SHIFT
text lenth
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only text of a specified number of characters.
Directories
Indexes of information based on keywords embedded in documents which allows search engines to find what is being looked for
DNS (Domain Name System)
The Internet's system for converting alphabetic names into numeric IP addresses.
cascade
The ____ arrangement option layers the open workbooks on the screen.
Primary Key
The field that uniquely identifies each record in a table
Business intelligence
Information collected from multiple sources such as suppliers, customers, competitors, partners, and industries that analyzes patterns, trends, and relationships for strategic decision making
credit
money available for a client to borrow that becomes debt
edit and delete defined names
name manager
Nima wants to create a hyperlink to a location in her current workbook. She clicks the Hyperlink button in the Links group on the Insert tab. What option should she select from the Link to list?
place in this document
There are three stages to developing a presentation:
planning, creating, and preparing your delivery
warning ( data validation)
prevent data from being stored but can be override
stop ( data validation)
prevent data from being stored on cell
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets
range
Text size can indicate
relative importance
To delete the hyperlink but keep the text, right-click the hyperlink cell, and then click ____ Hyperlink. D. Remove
remove
The default ____ for a hyperlink is the folder location and the name of the file to which you will link.
screen tip
message error appears as:
screen tip
how to create a defined name
select cell, go to name box and type name
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ____.
single quotation mark
If the destination file is closed when you make a change in the ____ file, you can choose whether to update the link to display the current values when you open the destination file.
source
When you link an object, a direct connection is created between the ____ and destination programs.
source
The following are Excel-supported error alert types
stop warning information
adding a ______________________ helps sum values from multiple sheets of the same structure
summary sheet
To move a worksheet or worksheet group to another location in the same workbook, select the worksheets and then drag and drop them by the selected sheet ____.
tab
Database Administrator (DBA)
the person responsible for coordinating, controlling, and managing the database
Data mining
the process of analyzing data to extract information not offered by the raw data alone
Business Analytics
the use of current business data to solve business problems using mathematical analysis
When a worksheet group is selected, the ____ includes text to indicate this.
title bar
net worth
total assets minus total liabilities
The Stop alert prevents an entry from being stored in the cell.
true
To remove a worksheet group, you can right-click the sheet tab of a sheet in the group and then click ____ on the shortcut menu.
ungroup sheets
A(n) _____ identifies a Web page and is the address of a document or site on the Internet.
url
common word to type into a browser to find a web site
url
other ways to protect data corruption
workbook protection
To save a workbook with macros, the default Excel Workbook format needs to change to a macro-enabled workbook, which has the _____ file extension.
xlsm
excel files have a(n) ____ extension.
xlsx
All template files have a(n) ____ extension.
xltx
Presentations created and presented by a team of people are referred to as _____ presentations.
collaborative
When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.
!
reference cell d10 another sheet named Sales Data on the same workbook
'Sales Data'!D10
database objects
1. tables 2. queries 3. forms 4. reports 5. macros 6. modules
when was invented the internet
1969
The 7x7 rule refers to a presenter having no more than
7 bullet points per slide, 7 words per bullet
when was invented the World Wide Web
80s
template
A ____ is a workbook that you can open with the text, formats, and formulas already built into it.
search engine
A _____ is an information system that enables users to retrieve data from the Web by using keywords related to their topic of interest.
record
A collection of fields that appear as a row in a database or table.
Input messages
A description or instructions for data entry
external reference
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
internet
A global network connecting millions of computers, making it possible to exchange information.
XML (Extensible Markup Language)
A markup language that is designed to carry data instead of indicating how to display it.
budget
A plan for making and spending money
foreign key
A primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables
application
A program run by the operating system to meet particular needs of a user.
Browser
A program that allows the user to find and view pages on the world wide web.
3D reference
A reference to the same cell or range in multiple worksheets in the same workbook
Many-to-many
A relationship between two entities in which can be related to two or more instances of entity
One-to-many
A relationship where one record in a table may have links to many records in another table.
Wizard
A series of dialogue boxes that guide you step-by-step through a process.
Internet Protocol (IP)
A set of rules responsible for disassembling, delivering, and reassembling packets over the Internet.
Data Validation
A set of rules that determine what users can enter in a specific cell or range
query
A specification that describes how a set of records should be sorted, filtered, calculated, or presented
WWW (World Wide Web)
A system of interlinked hypertext documents contained on the Internet
Table Design view
A view in which you can add, edit, and delete fields from a table, change field types and description, set a primary key and more
Form
A view of a table or query's data, designed for lookup or input of records
defined name
A word or string of characters associated with a single cell or range
group
A worksheet ____ is a collection of two or more selected worksheets.
If you receive a destination workbook but the source files are not included, click the ____ Link button in the Edit Links dialog box to replace the external references with the existing values.
Break
Click the button marked ____ in the accompanying figure to replace the link to a source file with the current values for the linked cells.
Break Link
copy/paste and embedded
DO NOT update automatically when you edit the source, you should
The worksheet range ____ references the worksheets, "Sheet1," "Sheet2," "Sheet3," and "Sheet4."
Sheet1:Sheet4
to create a reference to cell B6 on the Summary Info worksheet
Summary Info!B6
invented the World Wide Web
Tim Berners-Lee
Encrypt
To add protection to a file so others cannot read it.
link
To create a connection between two files, or the connection itself.
embed
To insert an object created with one program into a file created with a different program.
Navigational tools
Used to travel from website to website - as in surf the Internet
To create a macro, you can enter a series of commands in the _____ programming language
VBA
destination
When two files are linked together, is the file that receives the information.
WAN
Wide Area Network
The general format of a 3-D cell reference is ____.
WorksheetRange!CellRange
developer
You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab
The ____ caption indicates a worksheet group.
[Group]
reference the cell D10 in another workbook named Houston.xlsl on the work sheet Sales Data?
[Houston.XLSX]'Sales Data'!D10
insert
_______ tab can be use To create a link, click the tab, and then in the Links group, click the Hyperlink button.
Internet Service Provider (ISP)
a company that provides access to the internet for a monthly fee
variable cost
a cost that varies with changes in the level of output
Copy/Paste
a method of copying text or a graphic; allows the user to place it in another location in a document
Intranet
a network designed for the exclusive use of computer users within an organization that cannot be accessed by users outside the organization
Information ( data validation)
accept the data entry but give the option to cancel and re type entry
Delete a value from one grouped sheet, cell content will be deleted from all grouped sheets
all sheets change
by grouping 12 sheets of the same structure, you can run calculations once instead of 12 times
all sheets change
create a name from selection
allow to assign names from selected values
debt
an obligation to pay borrow money
sheet tap
can be use To ungroup worksheets by clicking a sheet not in the group.
the Excel data _____ feature restricts data entry to follow a defined set of rules.
data validation
Big Data Applications
deals with large amounts of unstructured data from the internet, photos, video, audio, social, networks, and sensors.
Who invented the internet?
dep of defense
ARPANET (Advanced Research Projects Agency Network) was created by
dep. of defense