0
What else can I help you with?
What box on the formula bar will allow you to select any cell by entering its cell number?
The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.The Name Box, beside the formula bar, allows you to select a cell by entering its cell address.
When keying a formula in a spreadsheet what must you key to inform the program that you are entering a formula instead of entering text?
An equal sign because in order for the formula to go through correctly it has to have an (=)
What must you type before entering a formula?
A formula must begin with the equal sign (=).
What alerts excel that you are entering a formula of function?
an equal sign =
Where does the answer will display after entering the formula into the cell?
The answer will display in the cell itself.
What can you use to simplify entering ranges in formula?
Range Names.
How does Excel recognize that you are entering a formula into a cell?
All formulas must begin with the equals sign. That is how Excel knows it is a formula.
After entering a formula that calculates numbers you get nothing or number sign for an answer. What is causing the problem?
After entering a formula that calculates numbers, you get: #### for an answer. What is causing the problem? ANSWER:One of the cells referenced in the formula was hidden Excel did not recognize the function you used The column width is too narrow to display the formula result The workbook on which you are working has become corrupted One of the cells referenced in the formula was formatted as text
Which mode is suggested for entering a cell reference in a formula?
You can type it while in Edit mode, or click on the cell while typing your formula, which can referred to as point mode.
When adding cell addresses in a formula you must use uppercase letters?
You can use lower case letters, but Excel will convert them to uppercase after you have finished entering the formula.
What happen when you enter the formula g15 into a cell?
Unless you're entering it into cell G15, you'll put the value from G15 into the cell you're entering into.
How do you tell excell you are typing a formula?
To tell Excel that you are typing a formula, start by typing an equal sign "=" in the cell where you want the formula. This signals to Excel that you are entering a calculation or function. You can then proceed to input the formula or function you want to use in that cell.
