INFO SYSTEMS PROBLEM SOLVING
INFO SYSTEMS PROBLEM SOLVING CIS 301
Popular in Course
Popular in Computer Information Systems
This 2 page Class Notes was uploaded by Ms. Kirk Daugherty on Monday October 12, 2015. The Class Notes belongs to CIS 301 at Idaho State University taught by D. Beard in Fall. Since its upload, it has received 19 views. For similar materials see /class/222176/cis-301-idaho-state-university in Computer Information Systems at Idaho State University.
Reviews for INFO SYSTEMS PROBLEM SOLVING
Report this Material
What is Karma?
Karma is the currency of StudySoup.
Date Created: 10/12/15
CIS301 Sample Midterm Open Book Open Notes N E Before you open your laptop answer the questions on the attached page and turn it in at the instructor s table in the back of the room Use the Excel workbook named midtermFile Rename this workbook as your last name This workbook includes a sheet containing 200 names and addresses Add the following column headings Name Addressl Address2 Ci y State Country Zip Develop a pivot table from the provided data that can address the following questions Type in the answers to these questions on your spread sheet below the pivot table a How many individuals are living in Idaho b How many individuals are living in Chicago The combination of the two functions isnumbersearch foo A1 will return true if and only if cell A1 contains the string foo search returns the a number indicating the position of foo in Al and isnumber returns true if search returns a number indicating that foo actually was somewhere in the string Using these two functions add a column to the provided data that contains true if the individual lives in an apartment and otherwise contains false Note that the word apt may be in either column B or column C Label this column apt Answer the following questions before you open your laptop computer 1 2 What does the formula NOTORB2B25 mean What does the formula ANDB4B40 mean What will be the result of the formula 30526 Ifthere are three rules eg IF displayed in the range D3F3 show a logical function to determine if none of the rules are true