More Example Text Manipulation
Problems.
C. Powley, CSCI 1041 (copyright 2014-2015)
Suggestions - break these into sub-problems. If you
cant solve a problem, try to solve part of it, or a
simpler version of it.
1. Given a list of social security numbers,
Math Formulas Exercises
these slides contain example math formula
exercises collected in one place; some of
the exercises come from other slides
Curt Powley
CSCI 1041
Formula Exercise:
Evaluate this Formula
Formula Exercise:
Evaluate this Formula
Answer i
Excel Introduction
Text Manipulation Functions
(LEFT, RIGHT, MID, LEN, SEARCH,
CONCATENATION), MOD, COMBIN
Curt Powley
CSCI 1041
Hawaii Pacific University.
C. Powley copyright 2003-2015
Exercise: For List of Names
in Format First M. Last, Write
General Fo
IF Function,
Comparison Operators
CSCI 3201, Hawaii Pacific University.
C. Powley copyright 2003-2015
if function
Make a test to control a cells contents
Example enter this formula in C5:
=IF(B5>0,"Let's party!","I'm broke")
Note use of double quotati
Excel Introduction
Text Manipulation Functions
(LEFT, RIGHT, MID, LEN, SEARCH,
CONCATENATION), MOD, COMBIN
Curt Powley
CSCI 1041
Hawaii Pacific University.
C. Powley copyright 2003-2015
Exercise: For List of Names
in Format First M. Last, Write
General Fo
Excel Introduction
Cell References, Formulas, Functions
Curt Powley
CSCI 1041
Hawaii Pacific University. C. Powley
copyright 2003-2015
Excel and Spreadsheets
l
l
l
l
We will study Excel in this class
Excel is example of a spreadsheet
application
There are