1 / 9

CSE 1520 -- Computer Use: Fundamentals

Learn about logical functions like AND, IF, NOT, as well as text functions like LEFT and MID in Excel. Practice exercises included.

mdonovan
Download Presentation

CSE 1520 -- Computer Use: Fundamentals

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CSE 1520 -- Computer Use: Fundamentals • Week 5: • Glade Manual Chapter 4 • Gates and Circuits (Dale & Lewis Ch. 4)

  2. CSE 1520 -- Computer Use: Fundamentals Glade Manual • Ch. 4 – More on Logical, Information, and Text Functions • Go to “Resources” “Support Files” “Chapter 4” • There are 2 exercises in Ch. 4 In exercise 1, there are 3 sub-exercises (Ex 1.1, 1.2, 1.3)

  3. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • Logical Functions: There are seven functions listed in the logical category in Excel – the functions AND, FALSE, IF, NOT, OR, TRUE and IFERROR. The more traditional Boolean operators are AND, OR, NOT. These are used to build complex Boolean expressions. NOT() is the inverter. So NOT (TRUE) = FALSE NOT (FALSE) = TRUE

  4. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • IS Functions: These functions are often used as the Logical_test in an IF function.

  5. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • Example: • it's possible that the cell a formula will use as the divisor might be blank. The formula would then produce an error because the blank cell has value 0, and division by 0 is impossible For example: a column called “Average” that calculates the formula: “Total/Count” could be calculated as follows: = IF (ISBLANK (Count), "", Total / Count) This formula “looks” at the current value of “Count” to see if the cell is empty. If it is, the cell is left blank.

  6. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • Text Functions:

  7. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • Text Functions: Example 1: = LEFT ("Hi ho", 2) returns the string “Hi”. It copies 2 characters from the left end of the string. Example 2: = MID ("Hi ho", 2, 3) produces the string “i h”, i.e. 3 characters starting from position 2

  8. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4: Homework • Ex 1.2 In the “Accounts” sheet. It lists “Surnames” and “Given Names” for a group of fictitious people. Your task is to create another column in which to calculate each person’s user identification number. The rule for these IDs is to join the first letter of the “Given Name” to the whole “Surname”, and convert the resulting string to UPPERCASE. • The logic procedure should be: • Use “LEFT” to get the leftmost character from “Given Name” 2. Use “CONCATENATE” to combine the result from step 1 and the “Surname” 3. Use “UPPER” to convert the resulting string to UPPERCASE

  9. CSE 1520 -- Computer Use: Fundamentals Glade Manual – Chapter 4 • Ex 1.3 In this exercise you implement a spreadsheet that converts 8-digit (natural) binary numbers to decimal with the 8-digit binary number has the form: The formula that converts 8-digit (natural) binary numbers to decimal is: Example: the 8-bit binary numbers 0000 0110 is converted to decimal 6:

More Related