×

### Let's log you in.

or

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

×

or

## CSE 1111 Midterm #1 Study Guide

by: Megan Hageman

226

0

2

# CSE 1111 Midterm #1 Study Guide CSE 1111

Megan Hageman
OSU
GPA 3.806
Intro to Computer Problem Solving
Cindy Grimme

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

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

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

×
Unlock Preview

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...
COURSE
Intro to Computer Problem Solving
PROF.
Cindy Grimme
TYPE
Study Guide
PAGES
2
WORDS
KARMA
50 ?

## 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.

×

## Reviews for CSE 1111 Midterm #1 Study Guide

×

×

### What is Karma?

#### 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

×

×

### BOOM! Enjoy Your Free Notes!

×

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

Forbes

#### "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

#### STUDYSOUP CANCELLATION 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 support@studysoup.com

#### STUDYSOUP REFUND POLICY

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: support@studysoup.com

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 support@studysoup.com