71 terms

MSIS Final (extra study guide)

STUDY
PLAY

Terms in this set (...)

When you buy something online you are _______.
A) Interfacing with a business system
B) Providing content
C) Using a customer-facing information system
D) Using a social media system
C) Using a customer-facing information system
Learning objective one is to develop skill in using Excel by applying it to solve problems.
A) True
B) False
A) True
When you use a credit card to make a purchase, several different companies' information systems are involved in your purchase
A) True
B) False
A) True
Google Maps is a GIS system that utilizes a GPS system to provide information about the physical world.
A) True
B) False
A) True
Information is data put into context.
A) True
B) False
A) True
Knowledge is defined as facts, information, and skills acquired by a person through experience or education.
A) True
B) False
A) True
Knowledge that is gained from a book is called ________ knowledge.
A) Implicit
B) Explicit
C) Tacit
D) Externalized
B) Explicit
Which of the following is not related to Moore's law?
A) Computer memory increases every year.
B) Computer costs decrease every year
C) The number of transistors on a chip doubles ever 12 to 18 months.
D) The distance between people in social networks decreases every year.
D) The distance between people in social networks decreases every year
A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024 megabytes. What is a terabyte?
A) 1024 megabytes.
B) 1024 petabytes
C) 1024 terabytes
D) 1024 gigabytes
E) None of the above
D) 1024 gigabytes
Which of the following is an open source application software?
A) Linux
B)R
C)Open Office
D) Firefox
E) All of the above
E) All of the above
Through the use of apps (application software) your smart phone can access devices that are connected to a network. What installed technology does the smart phone not use to connect to the network?
A) Cellular radio
B) WiFi
C) Bluetooth
D) DSL
D) DSL?
When you sign onto a LAN through WiFi, the router or LAN access point assigns you a _______ IP address.
A) Static
B) Dynamic
C) Novel
D) Moving
B) Dynamic
All computer devices communicate over a network using binary or machine language.
A) True
B) False
A) True
You have a LAN at home so that all of your IoT devices can be reached through the Internet. All of the devices are connected by WiFi and have a dynamic IP address assigned by the router.
A) True
B) False
A) True
When you use VMWare to work on the software on the university servers, you are using a_______.
A) Virtual machine
B) Client application
C) An installed application
D) Open source software
A) Virtual Machine
Protocols are used by which of the following?
A) Browsers
B) Cell phones
C) The Internet
D) Web pages
E) All of the above
E) All of the above
A relational database cannot have a many to many relationship between entities.
A) True
B) False
A) True
A ____________ shows the relationships between the tables in a relational database.

Entity Relationship Diagram
Entity Relationship Diagram
Because a properly designed relational database only has single data entry, variables that can be calculated are not in the database.
A) True
B) False
A) True
Metadata defines the ______________
A) all of the above
A) all of the above
The DBMS is used to create database business rules
A) true
B) false
A) true
A manufacturing company that uses an enterprise information system will likely use an _____________
ERP
Labels are aligned at the _______ edge of the cell
A) Left
B) Right
C) top
D) bottom
a) left
you can complete a cell formula entry by passing _________
A) enter key
B) an arrow key
C) another cell
A) enter key
if you choose a larger font size, the height of the row is automatically made taller
A) true
B) false
A) true
which button allows you to copy cell formats from one cell to another
A) enter
B) autofit
C) format painter
D) esc
C) format painter
A_______ is a group of cells that form a rectangle on the screen
A) label
B) workbook
C) ribbon
D) range
D) range
how do you know a range is active?
A) it has a dashed line around it
B) it has a bold solid line around it
C) the data changes to bold to let me know its active
D) im psychic and i just know
B) it has a bold solid line around it
An example of a range is
A) A1;B3
B)A1-B3
C) A1=B3
D) A1:B3
D) A1:B3
A fast way to add up this column of numbers is to click in the cell below the numbers and then:
A) click subtotals on the data menu
B) view the sum in the formula bar
C) click the autosum button on the standard toolbar, then press ENTER
D) use the sum function from the math functions
C) click the autosum button on the standard toolbar, then press ENTER
what is the result of the following formula =(5-3)^2/1*2\
A) 2
B) 4
C) 6
D) 8
E) 1
D) 8
which of the following is one way to change column width to fit the contents?
A) single click the boundary to the left of the column heading
B) double-click the boundary to the right of the column heading
C) press ALT and single click anywhere in the column
C) Press tab + S
B) double-click the boundary to the right of the column heading
there are three workbooks with every new workbook. you can change that automatic number if you want to
A) true
B) false
B) false
###### in a cell means
A) youve entered a number wrong
B) youve misspelled something
C) the cell is not wide enough
D) the formula is incorrect
C) the cell is not wide enough
to add a new row, click a cell in the row immediately above where you want the new row, right click and select insert
A) true
B) false
b) false
to copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs
A) true
B) false
B) false
which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
A) count
B) average
C) sum
D) median
E) count if
C) sum
is it possible to insert a jpeg image from a file into an excel spreadsheet
A) yes
B) no
A) yes
on an excel sheet the active cell is indicated by______
a) a dark solid border
B) a dotted border
C) a blinking border
d) all of the above
a) a dark solid border
what is the result of the following formula: =8+(7/(2+5)^2-1/7)*3

a)8
b)15
c)9
d)29
e)7
a)8
a formula and a function are the same thing
a) true
b) false
b) false
in order to multiply items in an excel you would use the _______
a) ^
B) @
c) *
d) #
c) *
a formula begins with
a)+
b)#
c)=
d)-
c) =
if cells are: A1=90, A2=85,A3=80, A4=75, and A5=75. what will be your formulaif you are going to get the average?
a)A1+A2+A3+A4+A5
b) +(A1+A2+A3+A4+A5)
C) +SUM(A1+A2+A3+A4+A5)/5
D) =SUM(A1:15)
E) =AVERAGE(A1:A5)
E) =AVERAGE(A1:A5)
Which menu option can be used to split windows into two?
a) format-> window
b) view -> window -> split
c) window -> split
d) view -> split
c) window -> split
which of the following is not a valid data type in excel?
a)number
b) character
c) label
d) date/time
b) character
which area in an excel window allows entering values and formulas?
a) title bar
b) menu bar
c) formula bar
d) standard tool bar
c) formula bar
an excel is a collection of ________
a) workbooks
b)worksheets
c)charts
d) worksheets and charts
d) worksheets and charts
in excel, you can sum a large range of data by simply selecting a tool button called _____?
a) autofill
b) auto correct
c) auto sum
d) auto format
c) auto sum
which is not the function of "edit, clear" command?
a)delete contents
b) delete notes
c) delete cells
d)delete formats
c) delete cells
what happens when dollar signs ($) are entered in this address, $B$2:$B$10?
a) an absolute cell address is created
b) cell address will change when it is created copied to another cell
c)the range address is absolute
d) the status bar does not display the cell address
a) an absolute cell address is created
what are the tabs that appear at the bottom of each worksheet called?
a) reference tabs
b) position tabs
c)location tabs
d) sheet tabs
d) sheet tabs
what is represented by the small, black squares in the lower-right corner of an active cell or range?
a)repeat handle
b) fill handle
c) insert handke
d) border
b) fill handle
A ___________ is a grid with labeled columns and rows
A) dialog box
b) worksheet
C) clipboard
d) toolbar
b) worksheet
formatting data only changes the appearance of data, it does not affect the data itself
a) true
b) false
a) true
if a formula contains several nested functions, excel starts with the outermost function and then moves inward
a) true
b) false
b) false
an easy way to sort data when there is only one sort field to use the sort A to Z or sort Z to A buttons
a) true
b) false
a) true
the cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ________
A) B1-G10
b) B1; G10
C) B1.G10
D) B1:G10
D) B1:G10
once data is entered into a cell, can it be edited after saving the file?
a)yes, but it has to be saved as a different file
b) no, once it is saved it cannot be changed
c) yes, even after saving the file, double click on the cell where data is to be changed to edit
c) yes, even after saving the file, double click on the cell where data is to be changed to edit
to select several cells or ranges that are not touching each other, you would ___________ while selecting
a) hold down the CTRL key
b) hold down the SHIFT key
c) hold down the ALT key
d) none of the above. you cannot select cells that are not touching each other
a) hold down the CTRL key
a range in excel refers to
a) a group of cells
b) a calculation that describes the relationship between cells
c) a way of arranging data in a particular order
d) a place where you graze cattle
a) a group of cells
which is the part of the excel screen where you can find all the commands or buttons, depending on the tab you selected before?
a) ribbon
b) formula bar
c) tab
d) backstage
a) ribbon
what is the function of autofit
a) a symbol that represents a specific function
b) a way of arranging data in a particular order
c) automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
d) spandex
c) automatically change the width of a column to fit the longest entry or change the height of a row to fit the font
if you have data that runs across five columns, from column A to column E, one way to center a title acorss the top of the data would be
a) type the data in A1 and merge cells A1:A5
b) type the data in A1 and merge cells A1:E1
c) type the data in C1
d) choose center from the format menu
b) type the data in A1 and merge cells A1:E1
to sort data in an excel worksheet you can use the ________
a) sort a to z and sort z to a buttons
b) quicksort options
c) sort commands on the formulas tab
d) all of the above
d) all of the above
=FUNCTION (arguement1, arguement2) is
a) the syntax of writing optional arguements
b) an example of a formula
c) the general syntax of all functions
d) the general syntax of all formulas
c) the general syntax of all functions
what is the result of the following formula: =27/3+5-2^3+ (17-8)/3^2

a)9
b)6
c)7
d)11
e)14
c)7
if you have columns that are truncating your content (not showing all the content), but you cannot increase the width of the worksheet and be able to print on one page, a solution for making the text visible without losing data would be to:
a) abbreviate all text
b) reduce the font sixe to 8 pt
c) click wrap text
d) delete one column
c) click wrap text
in "=SUM (number1[,s=number2][number3]....)" number 1 and number 2 and number 3 may be numbers or
a) letters
b)cell references
c) symbols
d)formulas
b)cell references
the name of the active cell appears in the _____________________
a) formula bar
b) name box
c) column
d) row
b) name box
the order of operations in excel is
a)*/^()-+
b) ^()+-*/
c) ()*/^+-
d) ()^*/+-
d) ()^*/+-
YOU MIGHT ALSO LIKE...
STUDY GUIDE