CS 105 Study Guide - Midterm Guide: France 3, Pivot Table

• School: University of Illinois
• Department: Computer Science
• Course: CS 105
• Professor: All

Document Summary

For the next three questions, consider the following microsoft office documentation to a built-in function in excel that you have not seen as part of cs 105: Find locates one text string within a second text string, and return the number of the starting position of the first text string from the first character of the second text string. The text you want to find. within_text required. The text containing the text you want to find. start_num optional. Specifies the character at which to start the search. The first character in within_text is character number 1. If you omit start_num, it is assumed to be 1. =find(ill, illinois) - find(ino, illinois): -3, -1, 0, 1, 3. The following spreadsheet contains historical data on the average price of crude oil. Note that some rows are excluded to save space, but data exists in all rows from 2 to 69.