×

### Let's log you in.

or

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

×

or

22

0

2

# Note for CS 285 with Professor Wright at UA-Microcomputer Appl II-Exam 2 Review

Marketplace > University of Alabama - Tuscaloosa > Note for CS 285 with Professor Wright at UA Microcomputer Appl II Exam 2 Review

No professor available

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

COURSE
PROF.
No professor available
TYPE
Class Notes
PAGES
2
WORDS
KARMA
25 ?

## Popular in Department

This 2 page Class Notes was uploaded by an elite notetaker on Friday February 6, 2015. The Class Notes belongs to a course at University of Alabama - Tuscaloosa taught by a professor in Fall. Since its upload, it has received 22 views.

×

## Reviews for Note for CS 285 with Professor Wright at UA-Microcomputer Appl II-Exam 2 Review

×

×

### 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: 02/06/15
CS 285 Exam 2 Review You will have to bubble in your name CWID number Test it in column K and the best answer to each question on the Scantron Bring sharpened 2 pencils Study Info 1 Review Tutorials 610 in the Excel 2007 textbook review Cases 610 in the CaseGrader and review aH notes 2 Give an example of a 3D cell reference pg 288290 296 3 What is a cell comment 4 Use the tab on the Ribbon to create a table from a list range of cells 5 Know how to name a table 6 Know how to use a structured reference in a formula pg 344 7 Know how to group consecutiveadjacent worksheets 8 Review the VLookup COUNTIF SUMIF IF AND and OR functions 9 Review nested functions 10 Review the PMT IPMT PPMT DB and SLN functions 11 Where are the compare values located in a vertical lookup table 12 What component of the Excel window can be used to define a range name name a cell 13 What are the 3 parts of Data Validation 14 With Data Validation the message serves as a reminder message and will display when the cell is selected 15 By default all worksheet cells have the property turned on 16 cells can not be modified 17 Review macros 18 With data tables the cell is the cell with the formula and it contains the outcome you want to examine 19 When you change a value in a worksheet to see what effect this change has on a formula s result you are performing the 20 Know how many input cells and how many result cells can be displayed in a onevariable data table 21 Know how many input cells and how many result cells can be displayed in a twovariable data table 22 What are the 3 items in Goal Seek gure 1 u we r l A a V w D E F s H 1 Vehicle Chevy Tahoe Dawn Pm Mumth Paymem Inleresl Paid 2 Vehicle Price 40000 5000 660 49 4629 59 3 Down FMT 5000 0 755 5291 4 APR 5 1000 736 5159 5 Term 5 2000 717 5026 6 Monthly Payment 55049 3000 698 4894 7 Total Repaid 3952959 4000 679 4762 8 llnterest Paid 452959 5000 660 4630 9 6000 642 4497 10 7000 523 4365 11 12 Vehlcle Price 13 660 49 30000 34000 38000 42000 46000 14 0 41667 483 33 550 00 61667 683 33 15 1 427 34 495 72 564 09 632 47 700 84 16 2 43819 508 31 578 42 648 53 718 64 17 3 449 22 521 09 592 97 664 84 736 72 18 4 460 41 534 08 607 75 681 41 755 08 19 5 47178 547 27 622 75 698 24 773 72 20 6 483 32 560 65 637 98 715 31 792 64 21 7 495 03 574 23 653 44 732 64 81185 23 In Figure 1 what is the input cell for the onevariable data table 24 In Figure 1 what is the row input cell for the onevariable data table 25 In Figure 1 what is the column input cell for the onevariable data table 26 In Figure 1 what are the result cells for the onevariable data table 27 In Figure 1 m are the input values in the onevariable data table 28 In Figure 1 what is the result cell for the twovariable data table 29 In Figure 1 what is the row input cell for the twovariable data table 30 In Figure 1 what is the column input cell for the twovariable data table 31 Locate the row input values and the column input values in the 2 var data table 32 How can you name cells using their labels in the worksheet 33 How do you create a Scenario Summary Report 34 How many input changing cells can be displayed in a scenario summary report 35 How many result cells can be displayed in a scenario summary report

×

×

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

Amaris Trozzo George Washington University

#### "I made \$350 in just two days after posting my first study guide."

Bentley McCaw University of Florida

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