×

### Let's log you in.

or

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

×

or

87

0

4

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

Marketplace > University of Alabama - Tuscaloosa > Note for CS 285 with Professor Wright at UA Microcomputer Appl II Exam 1 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
4
WORDS
KARMA
25 ?

## Popular in Department

This 4 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 87 views.

×

## Reviews for Note for CS 285 with Professor Wright at UA-Microcomputer Appl II-Exam 1 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
1 10 11 12 Exam 1 Study Questions I Explain the purpose of the a Name Box b Formula bar c Sheet tabs d Office button e Quick Access toolbar f Insert Function g Format Painter h Etc Know the difference between AutoFill and AutoComplete Write the formula that will total the values in cells 32316 Use the SUM function and use cell references in the formula What is AutoSum Excel provides several ways to navigate a worksheet using keyboard shortcuts For each of the keystrokes explain the active cell movement a CtrlHome b CtrlEnd c Home Know the difference between function syntax and function arguments You may enter multiple lines of text in one cell by using the keystrokes To edit cell contents in a worksheet you can work in editing mode Explain one way to enter editing mode Explain how to increase the width of column B so that each entry automatically fits in the column Write the formula as you would enter it into a cell that will multiply the value in cell C6 by the value in cell D6 Write the formula as you would enter it into a cell that will add the values in cells E6E10 Use the SUM function Write the formula as you would enter it into a cell that will multiply the total branch bonus in cell BS by 85 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Write the formula as you would enter it into a cell that will divide the value in cell B4 by the value in cell BS Use the tab on the Ribbon to use the Spelling Checker How would you insert a new worksheet into your file Explain how to rename a worksheet Explain how to delete a worksheet How do you access the Mini toolbar Know about the Accounting Number Format Write today s date three different ways as it could be formatted in a cell Explain how to merge and center the title in cell A4 across the range A4F4 You can use the to quickly copy formats from one range of cells to another Using Paste Special you can use the option to paste a range of numbers from a row into a column When you want to apply a theme to a worksheet you select any cells in the worksheet and then click the tab on the Ribbon Use the tab on the Ribbon to change the page orientation In Excel an absolute cell reference is marked with a sign before each row and column designation Give one example of an absolute cell reference Use the key while in edit mode to change the cell reference type from relative to mixed to absolute etc The of a function refers to the numbers text or cell references used by the function to return a value Optional arguments are always placed in the argument list Function arguments are always separated by a Write the formula using the TODAY function that will return the current date What is the name of the Date function that will return the current date and time 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 If cell A3 is greater than cell A4 you want to display the text string OK otherwise you want to display the text string REI39RY Write the correct formula to accomplish this You want to take out a loan for 130000 The APR for the loan is 5 You intend to pay back the loan over 20 years Write the formula that will calculate the monthly payment for this loan Give an example ofa comparison operator Write the three arguments of the IF function Write the three required arguments of the PMT function Use the tab on the Ribbon to create a new chart The is the range of cells that contains the data you want to display in the chart What is a data series You want to create a chart that will compare relative values of different categories to the whole You should choose the chart type The chart type compares values of different categories and is used to show trends and changes over time What is an embedded chart A sheet is an Excel sheet that contains only a chart with no worksheet cells The area is the rectangular box containing the chart and all other chart elements The area is the part of the chart that contains the graphical representation of all the data series in the chart What is a data marker The is a component of a chart that labels the markers or symbols used in the chart What will happen to a chart if the values in the data source cells change How do you move an embedded chart to a new location within the same sheet How do you move an embedded chart to a Chart sheet 53 How do you delete an embedded chart 54 Use the Chart Tools tab on the Ribbon to change the 3D rotation of an existing chart 55 Know how to use the Chart Tools tabs to format and edit charts 56 In a 2D chart the xaxis horizontal is called the axis 57 In a 2D chart the yaxis vertical is called the axis For Tutorial 5 know the following 1 Terms Field record header row 2 How to create a table from a range of cells 3 How to insert a Total Row 4 How to Freeze Panes 5 How to filter a table by one field 6 How to sort a table by more than one field 7 What 2 things you must do to an Excel table before you can display Subtotals 8 How to display Subtotals 9 Subtotals outline views 10 How to use Conditional Formatting 11 How to convert a table to a normal range Review all pages in your Excel textbook for Tutorials 15 Study all CaseGrader diagrams and review the formulas

×

×

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

Allison Fischer University of Alabama

#### "I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over \$600 per month. I LOVE StudySoup!"

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

Parker Thompson 500 Startups

#### "It's a great way for students to improve their educational experience and it seemed like a product that everybody wants, so all the people participating are winning."

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