New User Special Price Expires in

Let's log you in.

Sign in with Facebook


Don't have a StudySoup account? Create one here!


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

CSE 1111 Midterm #1 Study Guide

by: Megan Hageman

CSE 1111 Midterm #1 Study Guide CSE 1111

Megan Hageman
GPA 3.806
Intro to Computer Problem Solving
Cindy Grimme

Almost Ready


These notes were just uploaded, and will be ready to view shortly.

Purchase these notes here, or revisit this page.

Either way, we'll remind you when they're ready :)

Preview These Notes for FREE

Get a free preview of these Notes, just enter your email below.

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Hey guys, here is a study guide for our midterm coming up on Oct. 20th. I included all the sections we covered and notes on important things to remember for the exam. I hope it's helpful and good l...
Intro to Computer Problem Solving
Cindy Grimme
Study Guide
50 ?




Popular in Intro to Computer Problem Solving

Popular in Computer Science and Engineering

This 2 page Study Guide was uploaded by Megan Hageman on Thursday October 15, 2015. The Study Guide belongs to CSE 1111 at Ohio State University taught by Cindy Grimme in Summer 2015. Since its upload, it has received 226 views. For similar materials see Intro to Computer Problem Solving in Computer Science and Engineering at Ohio State University.

Popular in Computer Science and Engineering


Reviews for CSE 1111 Midterm #1 Study Guide


Report this Material


What is Karma?


Karma is the currency of StudySoup.

You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 10/15/15
CSE 1111 Midterm 1 Study Guide Exam Date Oct 20th Excel Intro Remember order of operations and evaluated before and Relational operators gtltltgt ltgt Cell Referencing Absolute Addressing keep the formula the same when copying it across the row or down the column use before the row letter or column number Advanced Excel Functions Common Functions SUMnumber 1 number 2 AVERAGEnumber 1 number 2 MNnumber 1 number 2 MAXnumber 1 number 2 COUNTvalue 1 value 2 ignores text COUNTAvaue 1 value 2 use to count cells with text ROUNDnumber number of digits COUNTFrange criteria use if criteria is text or a Boolean expression ex COUNTFA1A10 quotgt5quot SUMFrange criteria sumrange AVERAGEFrange criteria averagif range Cha s Linearea charts changes or trends Scatter charts functional relationship BarColumn charts discreet values Pie charts parts of a whole 100 Large Workbooks Reference cell on a different worksheet SheetnameCe Reference Boolean Functions Always give a TRUE or FALSE result Use reationa operators ltgtltgtltgt or AND OR and NOT ANDogica 1 logical2 all arguments must be true for the statement to return TRUE key words every both all ORogica 1 ogica 2 only one argument has to be true for the statement to return TRUE key words any some at least one NOTlogica reverses the argument f were looking for none use NOTORogical FfuncUon DOES NOT RETURN TRUE OR FALSE IFogicatest valueiftrue valueiffalse Logicaltest value or expression that will return TRUE or FALSE Valueiftrue value returned if ogicatest is TRUE Valueiffalse value returned if ogicatest is FALSE You can use Boolean functions as the ogicatest Nestedifs you can add in another IF statement into the valueiftrue or valueiffalse spots if there are further criteria after you determine to rst statement is true or false Reference Functions Use LOOKUP function instead of using a bunch of nestedifs LOOKUPookupvaue lookupvector resutvector Lookupvaue criteria to lookup Lookupvector range that you are comparing the criteria to MUST BE IN ASCENDING ORDER Resutvector range that contains corresponding values you wish to nd THE ALGORITHM WILL GIVE YOU THE GREATEST VALUE THAT DOES NOT EXCEED THE VALUE BEING SEARCHED FOR Financial Functions PV present value PVltrategtltnpergtltpmtgtltfvgtlttypegt FV future value FVltrategtltnpergtltpmtgtltpvgtlttypegt PMT payment per period PMTltrategtltnpergtltpvgtltfvgtlttypegt RATE rate per period RATEltnpergtltpmtgtltpvgtltfvgtlttypegt NPER of payment periods NPERltrategtltpmtgtltpvgtltfvgtlttypegt Outgoing cash incoming cash Type 1 at the beginning of the period 0 end of the period Remember to plug in rate as rate of periods When using the NPER function pay attention to if it s asking for how many months years etc


Buy Material

Are you sure you want to buy this material for

50 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

Why people love StudySoup

Jim McGreen Ohio University

"Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Janice Dongeun University of Washington

"I used the money I made selling my notes & study guides to pay for spring break in Olympia, Washington...which was Sweet!"

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."


"Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

Become an Elite Notetaker and start selling your notes online!

Refund Policy


All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email


StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here:

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.