What is the user asking excel to do

Assignment Help Computer Engineering

Reference no: EM133551282

A worksheet has addresses with zip codes in column D. If a user wants to extract the zip codes from the string and enters a formula =RIGHT(D2,5), what is the user asking Excel to do? Extract the five characters from the right in cell D2, which is the zip code. Extract the zip code and add it in a new column to the right in the worksheet. Extract the five characters from the right in cell D2, which are blank spaces after the zip code.

Reference no: EM133551282

Questions Cloud

How do we determine the value of works of art : How do we determine the value of works of art? Is there something intrinsic to the work that determines the price? Is it simply a matter of what the market

Explain when teacher-directed and student direct instruction : Why are each important? Consider the age level you intend to teach. Explain when teacher-directed and student directed instruction would most effective and why?

Create and maintain cyber security awareness program : Create and maintain Cyber Security Awareness Program a) Create a program to promote cyber security awareness. This Cyber Security Awareness Program

Preventing adverse childhood experiences : Select one of the ACE prevention strategies from Preventing Adverse Childhood Experiences

What is the user asking excel to do : what is the user asking Excel to do? Extract the five characters from the right in cell D2, which is the zip code. Extract the zip code and add it

What implications do you draw from your experience : What implications do you draw from your experience and the research to inform your future practice?

E2 was the first cell in the zip code column : Excel deleted the leading zero in some of the zip code cells. Why would you use =TEXT(E2,"00000") if E2 was the first cell in the zip code column

Create a function for each math operation : Create a function for each math operation (add, div, mult, sub). The application will run forever (while True), you will ask the user to continue or not

How the assessments can inform teaching and student learning : Describe two other types of assessment teachers can use and explain how these assessments can inform teaching and student learning.

User Account

All Pages