MSIS

The order of operations in math, which excel follow, is?

()^*/+-

In order o multiply items in Excel you would see

*

According to the video "A Packet's Tale" what is the total time for the request and the webpage to be displayed? 1 second 15 seconds 30 seconds 45 seconds 1 minute

1 second

Data is information put into context

False

How do you know a range is active?

Two of the above are correct

A kilobyte is 1024 bytes. A megabyte is 1024 kilobytes. A gigabyte is 1024 megabytes. What is a petabyte? 1024 megabytes. 1024 Yottabytes 1024 Terabytes 1024 Zetabytes None of the above

1024 Terabytes

What is the result of the following formula? =27/3+5-2^3+(17-8)/3^2

7

What is the result of the following formula :=8(7/(2+5)^2-1/3)*3

8

What is the result of the following formula: =(5-3)^2/1*2

8

A formula begins with

=

If cells are: A1=90,A2=85,A3=80,A4=75,A5=75.What will be your formula if you are going to get the average?

=average(A1:A5)

A range in microsoft Excel refers to

A group of celss

A protocol is which of the following? A. A standard B. A language C. A resource D. A derivce

A standar

Which of the formulas below contain the correct syntax (formula arguments) for the VLOOKUP function? A. =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) B. =VLOOKUP(table_array, lookup_value, col_index_num, range_lookup) C. =VLOOKUP(lookup_value, table_array, col_index_num, value) D. =VLOOKUP(table_array, col_index_num, lookup_value,range_lookup)

A. =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Through the use of apps (application software) your smart phone can access devices that are connected to a network. What technology does the smart phone use to connect to the network? A. Cellular radio B. Satellite microwave C. Cable D. DSL E. Fiber Optics

A. CELLULAR RADIO

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 command on the Formulas tab D. Any of the above

A.Sort A to Z and Sort Z to A buttons

A example of a range is

A1:B3

Which of the following is not open source applications software? A.Linux B. R C. Adobe Photoshop D. Firefox E. Cassandra by Facebook

Adobe Photoshop

How do businesses make money on the Internet? Selling product Paid for showing advertising Paid for content Paid for obtaining customers All of the above

All of the above

Metadata defines the _________. Incorrect Response Format of date fields Required data fields Database business rules Number of characters in a text field All of the above

All of the above

Which of the following is not a job that companies hire MIS graduates to do? A.Systems Analyst B.Business Analyst C.Database Administrator D. Information Assurance Analyst E. All of the above are jobs that companies hire MIS graduates to do.

All of the above are jobs that companies hire MIS graduates to do.

Which of the following is a way that people provide content on the internet? Reviews of restaurants. Liking a products Facebook page. Blogging about food. Posting your location on social media. All of these provide content.

All of these provide content.

What is the function of the autofit?

Automatically change the width of a column to fit the longest entry or change the height of a row to fit the font

In EXCEL, you can sum a large range of data by simply selecting a tool button called

Autosum

Your Internet Service Provider (ISP) says that your network runs at 50 gigabit per second. This is the _______. A. Latency B. bandwidth C. Throughput D. Porcessing Power

B. bandwidth

What is the first step for creating a Pivot Table? A. Clicking on the Insert Tab and inserting a Pivot Table. B. Create or select data that needs to be analyzed. C. Deciding on which fields (column and row labels) to use to analyze the data. D.None of this

B.Create or select data that needs to be analyzed.

Your Excel workbook has four sheets. You name a range on sheet 1. Which of the following is true. A.You can only use that named range on worksheet 1 B.You can use that named range only on worksheets 1 and 2 C. You can use that named range on all worksheets in the workbook D. If you add another worksheet to the workbook, you cannot use that named range in the new worksheet.

C. You can use that named range on all worksheets in the workbook

What is a Pivot Table? A. A table containing data that is organized horizontally. B. A table used to calculate financial pivot values. C.A tool used to summarize data. D.A table containing only black, grey and white formatting.

C.A tool used to summarize data.

When you sign onto a LAN through WiFi, you have a ______ IP address and the LAN router has a _______ IP address. A.Static, Moving B. Dynamic, Stationary C.Dynamic, Static D. Moving, Stationary

C.Dynamic, Static

In "= Sum( number1[,number2][,number3],...]) number 1, number2, and number 3 may be numbers of

Cell references

Which of the following is not a valid data type in Excel?

Character

A fast way to add up this column of numbers is to click in the cell below the numbers and then:

Click the AutoSum button on the Standard toolbar, then press Enter

If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next? Click the Paste button on the Standard toolbar. Click the arrow on the Paste button on the Standard toolbar, then click Formulas. Click the arrow on the Paste button on the Standard toolbar, then click Values. Right click on the cell and select Paste from the dropdown menu.

Click the arrow on the Paste button on the Standard toolbar, then click Values.

If you want to paste a formula result, but not the underlying formula, to another cell, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?

Click the arrow on the Pasted button on on the Standard toolbar, then click Values.

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:

Click wrap text

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: Abbreviate all text Reduce the font size to 8 pt Click Wrap text Delete one column

Click wrap text

Which is not the function of "Edit, Clear" command?

Delete cell

Which of the following is one way to change column width to fit the contents

Double-click the boundary to the right of the column heading.

You can complete the entry of a cell formula that contains cell references by pressing

Enter Key

A URL has two parts. The first part is the protocol identifier, and the second is the domain name. A URL does not need to have an IP address associated with it.

False

A formula and function are the same thing

False

All computer devices communicate over a network using computer languages such as Python or C#.

False

All webpages are written in hyper text markup language or HTML. Each browser has it's own transmission protocol to read the HTML. Safari because it was created by Apple uses a different transmission protocol than Google's Chrome.

False

An Information Assurance Analyst identifies current risks associated with software and hardware systems. They work with other security experts and employees to hack into the company to gain access to the company's digital assets for personal gain.

False

Casandra, R, Firefox, and Linux are examples of open source software. While the source code is available to view, anyone that wants to modify it must pay a fee to the organization that controls the software, such as Apache.org.

False

Formatting data changes the appearance of data, and it changes the data itself.

False

Information is defined as facts, knowledge, and skills acquired by a person through experience or education

False

The AutoSum function can be accessed through a button on both the Home tab and the Formulas tab. The AutoSum function in Excel only works on a data in a column.

False

The IP Address defines your device whereas the Mac address defines your location on the network.

False

There are three worksheets with every new work book. You can change that automatic number if you want to.

False

To add a new row, click a cell in the row immediately above where you want the new row, right click, select insert and press eneter

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.

False

You have a LAN at home so all of your IoT devices can be reached through the Internet. All of the devices are connected by WiFi and have a static IP addresses.

False

Which of the following transmission protocols is not a wireless network protocol?

Fiberoptics

What is represented by the small, black square in the lower- right corner of an active cell or range?

Fill handle

Which button allows you to copy cell formats from one cell to another

Format Painter

Which area in an Excel window allows entering values and formulas

Formula Bar

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

G10:B1

To select several cells or ranges that are not touching each other, you would _____ while selecting

Hold down the CTRL key

To select several cells or ranges that are not touching each other, you would _____ while selecting Hold down the CTRL key Hold down the SHIFT key Hold down the ALT key None of these. You cannot select cells that are not touching each other.

Hold down the CTRL key

Where is a Pivot Table insert?

It depends on whether you select to insert the Pivot Table in the current worksheet or a new worksheet and where you cursor is.

Labels are aligned at the____edge of the cell

Left

The name of the active cell appears in the

Name box

On an Excel sheet the active cell is indicated by

None of above

When you access your University's Learning Management System (LMS), the LMS is where? On your computer On a client On a browser On a server

On a server

When you post a review on a business you are _______. Interfacing with a business system Providing content Using an ebusiness-facing information system Using a social relationship system

Providing content

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before?

Ribbon

Which is the part of the Excel screen where you can find all the commands or buttons, depending on the tab you selected before? Correct Answer Ribbon Formula Bar Incorrect Response Tab Backstage

Ribbon

What are the tabs that appear at the bottom of each worksheet called?

Sheet tabs

To sort data in an Excel worksheet you can use the

Sort A to Z and Sort Z to A buttons

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?

Sum

In order to perform a skill, the knowledge must be internalized. This is call ______knowledge

Tacit

###### in a cell means

The cell is not wide enough

=FUNCTION(argument1, argument2,....) is

The general syntax of all functions

Moore's law states that _______________. Computers get faster every two years. Computer memory increases every year. Computer costs decrease every year The number of transistors on a chip doubles every 18 to 24 months. The distance between people in social networks decreases every year.

The number of transistors on a chip doubles every 18 to 24 months.

What happens when dollar signs are entered in this address, $B$2:$B$10?

The range address is absolute

In a VLOOKUP formula, what does the argument "column_index_number" mean? This is the secret INDEX number that each column in an Excel worksheet has. This is the number of the column within the selected table_array where the lookup result is located. This is a numerical representation of the letters at the top of a worksheet. For example, A = 1, B = 2, etc. This is numbers that you assign to columns in your worksheet.

This is the number of the column within the selected table_array where the lookup result is located.

An easy way to sort data when there is only one sort field is to use the Sort A o Z or sort Z to A buttons.

True

Formatting data only changes the appearance of data, it does not affect the data itself.

True

Google Maps is a GIS system that utilizes a GPS system to provide information about the physical world.

True

If a formula contains several nested functions, Excel starts with the outermost function and then moves inward

True

If you choose a larger font size, the height of the row is automatically made taller.

True

In Excel, you can trace all of the cells referenced in a formula through the trace precedents function.

True

Learning objective one is to develop skill in using Excel by applying it to solve problems.

True

TCP/IP defines how data is sent over the internet

True

Tacit knowledge requires that an individual the internalize a skill.

True

There are three main types of enterprise systems. They are supply chain management (SCM), enterprise resource planning (ERP), and customer relationship management (CRM). All of these information systems support the business by automating routine tasks, providing routine reports, and providing all employees the data and information needed to do their jobs.

True

When you use a credit card, you are using several different companies' information systems.

True

A ______ is a group of cells that form a rectangle on the screen.

Two of the above are correct

If you have data that runs across five columns, from column A to column E, one way to center a title across the top of the data would be to:

Type the data in A1 and Merge cells A1:E1, Then center text

Which menu option can be used to split window into two?

View- split

A ______ is a grid with labeled columns and rows

Worksheet

An excel Workbook is a collection of

Worksheets

Is it possible to insert a jpeg image from a file into an Excel spreadsheet?

Yes

Once data is entered into a cell, can it be edited after saving the file?

Yes, even after saving the file, double click on the cell where data is to be changed to edit.

Which of the following is NOT possible with VLOOKUP

You can lookup values located in a column to the left of the column that contains the lookup value