Question: I have a cell that displays a number ( for example $ 1 0 0 . 0 0 ) , but is really a formula

I have a cell that displays a number (for example $100.00), but is really a formula pointing to different cells. I want to save the number but delete the formula in the cell, what steps do I need to take?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Agee Company purchased 70% of the outstanding common stock of Himes Corporation. Explain the relationship between Agee Company and Himes Corporation. eTextbook and Media How should Agee account for...

Q:

ITBP301 Security Principles and Practices Lab#2: ASYMMETRIC ENCRYPTION Objectives Giving you hands-on experience with RSA algorithm and the RSA key generation process. Overview: Public-Key...

Q:

help me out with correct demands for 2 and 3 Excel McGraw Hill Excel Question - Saved x Search (Option + Q) File Home Insert Draw Formulas Data Review View Help 051 A B C E 2. Xercise Cycles Company...

Q:

Lab 1 Understanding Public Key Encryption Preparation: Review textbook explanation on public key encryption, understanding this encryption method needs each user to have a pair of two keys (public...

Q:

Launch Microsoft Excel provided with this exercise and open the spreadsheet You may see a warning message informing you that the workbook contains macros. Since you will not need these macros to use...

Q:

please i need help with this exercise: Exercise 3-Excel File Notes about this le: I There are 3 tabs: Data, Analysis, and Presentation. I The data in the Data tat] represent the Time on Taslt in...

Q:

https://ccnymailcuny-my.sharepoint.com/:x:/g/personal/malam008_citymail_cuny_edu/EQNuFz9ESMBBi1zuzV0w9uYB2I2aaFXcclMlPPc6JndcLQ?e=cNOPhp can you help me with FSA Income statement SFAM Income...

Q:

Please do this code in C programming language The code cellCount.c : #include #include #define IMAGE_SIZE 10 // this function prints the array void printImgArray(int array[IMAGE_SIZE][IMAGE_SIZE]) {...

Q:

Sullivan Ranch Corporation has purchased a new tractor and has provided you with information about the purchase. The controller has asked you to calculate the depreciation for the new piece of...

Q:

Calculating Depreciation Schedules - Using Straight-Line, Units-of-Production, and Double-Declining-Balance Methods in Excel: *Please Include the Excel Formulas in Your Answer* A B C D...

Q:

IN C programming language, You only need to complete two functions, Partial implementation is given to start. void color(int image[IMAGE_SIZE][IMAGE_SIZE]) int cellCount(int...

Q:

1) A sample consisting of 1.00 mol of an ideal gas at 27 C is expanded reversibly and isothermally from an initial pressure of 3.00 atm to a final pressure of 1.00 atm. a. Draw a picture showing this...

Q:

How can finished grades be established in machine control projects?

Q:

13.9 Use Bartletts test at the 0.01 level of significance to test for homogeneity of variances in Exercise 13.5 on page 539.

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Discuss the key ambient conditions and their effects on customers.

Q:

Understand the roles of signs, symbols, and artifacts.

Q:

Know the theoretical foundation from environ-mental psychology that helps us understand how customers and employees respond to service environments.