MIS exam 3 review
Anything of value that is owned by an individual.
Asset
Focusing on the desired outcomes of your presentation forces you to make it more _____.
Audience oriented
When you reference a cell or range in a different worksheet, the ____ separates the sheet reference from the cell reference.
!
When you reference a cell or range in a different worksheet, the ___________ separates the sheet reference from the cell reference.
!
Net income is $4,000 a month. You should PYF 20% each month for savings. What is the amount?
$800
Careers
-Financial careers (accounting or finance) -Procurement (supply chain) -Chem HQ (supply chain) -ExxonMobil IT( EMIT)
Why exxon?
-Work and live programs -Health, savings, retirement -Base salary -Diverse workforce -Employee resource groups
The internet started in ________.
1969
What portion of the world's population uses the internet in 2019?
56%
The 7x7 rule refers to a presenter having no more than ________.
7 bullet points per slide, 7 words per bullet
Describe what is meant by database.
A persistent and organized store of data
To select adjacent sheets in a workbook, use:
SHIFT.
What language do database use to search (query)?
SQL
A _____ is an information system that enables users to retrieve data from the Web by using keywords related to their topic of interest.
Search engine
A query is when you:
Search the database
The worksheet range ____ references the worksheets, "Sheet1", "Sheet2", "Sheet3", and "Sheet4".
Sheet1:sheet4
To select adjacent cells or worksheets, can use the ________ key.
Shift
When you reference cells and ranges in other worksheets, if the worksheet name contains spaces, you must enclose the sheet name in ___
Single quotation marks
Who invented the world wide web?
Sir Tim Berners-Lee
When you link an object, a direct connection is created between the __________ and the destination programs.
Source
SQL stands for?
Standard Query Language
The following are Excel-supported error alert types: _____.
Stop, Warning, and Information
Protecting the __________ of a workbook prohibits users from renaming, deleting, hiding, or inserting worksheets.
Structure
Adding a __________ sheet helps sum values up from multiple sheets of the same structure over time.
Summary
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.
Text Length
If an Excel table is embedded into a Word document, what happens when the Excel table is updated?
The word document does not change
If an excel table is copy+pasted into a word document, what happens when the excel table is updated?
The word document does not change
________ invented the world wide web.
Tim Berners- Lee
Some websites use a 'cookie' to save data on your computer. Why might they want to do this?
To show you adverts, to track what you looked at, so you don't have to log in again.
By grouping 12 sheets of the same structure, you can run calculations once instead of 12 times.
True
Delete a value from ONE grouped sheet, cell contents will be deleted from ALL sheets.
True
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.
True
If you delete a value from one cell, the content is also deleted from the same cell in all the worksheets in the group.
True
Once you group a collection of worksheets, any changes you make to one worksheet are applied to all sheets in the group.
True
The Stop alert prevents an entry from being stored in the cell.
True
The formula entered in the Paris sheet shown below will also appear in all sheets in the selection.
True
Using multiple worksheets with identical layouts enables you to use 3-D references to quickly summarize the data in another worksheet.
True
A(n) _____ identifies a Web page and is the address of a document or site on the Internet.
URL
A(n) ________ is the common name of the location of a document or site on the internet.
URL
A/an _______ is a common word you type into a web browser to find a website.
URL
To create a macro, you can enter a series of commands in the _____ programming language.
VBA
The Excel data _____ feature restricts data entry to follow a defined set of rules.
Validation
The excel data _______ feature restricts data entry to follow a defined set of rules.
Validation
A _________ expense and income that change over time.
Variable
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
If you do not want your inserted content to update automatically when you edit the source, you should _______.
Copy/paste or embed.
Intranets are also called _____.
Corporate portals
Money granted as a loan that creates debt.
Credit
Press and hold down the ______ key, and click the worksheet tabs you want to select. (Highlight.png)
Ctrl
Relational database help to reduce:
Data redundancy
Text, Integer, Decimal, Boolean are all examples of which of these?
Data type
A collection of related tables is called a __________.
Database
What does DBMS stand for?
Database Management System
An obligation to repay borrowed money.
Debt
Which US organization designed ARPAnet - the precursor to the internet?
Dep. of defense
To customize theme colors, click the ________ tab.
Design
You can turn off the macro recorder by clicking the Stop Recording button in the Code group on the _____ tab.
Developer
_____ are unique identifiers of computer or network addresses on the Internet.
Domain names
How do you ensure data stolen by hackers can't be read easily?
Encrypt it
The net and the web are the same thing.
False
A column heading in the database table is called a _________.
Field
A ________ expense and income that do not change over time.
Fixed
A worksheet _________ is a collection of two or more selected worksheets.
Group
_________ multiple sheets allows you to quickly process data based on the same structure.
Grouping
When you import a formatted Word outline, each heading formatted with the ________ style in word becomes a slide title.
Heading 1
To create a link, on the ribbon, click the _________ tab, and then in the Links group, click the Hyperlink button.
INSERT
The internet is a collection of:
Millions of computers
The _____ dialog box displays all of the names in the workbook.
Name Manager
Total value of a person's assets minus their liabilities.
Net worth
When you _____ a workbook, you control the ability users have to make changes to the file.
Protect
Like cell ____, a worksheet group can contain adjacent or nonadjacent sheets.
Ranges
Two or more tables linked together by common attributes is called a:
Relational Database
Text size can indicate ___________.
Relative importance
They said that ______________ is key to success because they prepare you very well.
Rockwell career center
Why do you need a Primary Key in a database?
Because you must have a unique identifier
Personal finance is about 80%__________?
Behavior
A monthly plan for how you are going to save and spend income.
Budget
One way to make sure you have enough money to cover your needs and wants is to create a __________.
Budget
To select nonadjacent cells worksheets, you use the __________ key.
CTRL
To select non-adjacent sheets in a workbook, use:
CTRL.
Presentations created and presented by a team of people are referred to as _________ presentations.
Collaborative
The cost of goods and services.
Expenses
A formula can include a reference to another workbook (called an ____ reference), which creates a set of linked workbooks.
External
The Federal Express Tracking System allows customers to enter a package's tracking number and locate any package still in the system as well as prepare and print shipping forms, get tracking numbers, and schedule pickups. Federal Express is an example of a(n) ____.
Extranet
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.
Extranets
James gets a job at a multinational corporation. On his first day at work, he finds out that the numerical code assigned by the Internet Corporation for Assigned Names and Numbers (ICANN) to his computer system is 115.248.178.233. This numerical code is referred to as a(n) _____.
IP address
The numerical location of a website is:
IP address
Which of the following is/are not mentioned the Bad Email Reply - What not to say to your professor..."video?
Inappropriate Photos
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
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
Companies like Verizon, Comcast, and AT&T are called:
Internet service providers(ISP)
Which of these is not a real web browser?
Internetium
Money put into an account intended for growth over time.
Investments
Once you have determined your focus, the next step is to identify the ___________ of your presentation.
Key points
Which of the following are used as common fields across tables so that fields can be accessed, organized, and manipulated in access?
Keys
Anything you owe; a debt.
Liability
A/an _______ automates data processing.
Macro
The best way to automate the creation of donor letters with different names and addresses is through:
Mail merge
Web pages are constructed using a language called HTML. What could you use the <b> "tag" for?
Making some text bold
You want to budget your monies coming in and monies going out. The best software to use is ___________.
Microsoft Excel
Meta-Four Houston's performance illustrates the impact of:
Our phones and the internet on our critical thinking capabilities
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
What is a foreign key?
Primary Key in another table
The "Lightbeam for Firefox" video reminds us to be mindful of our ______ as we interact with websites.
Privacy