Question

4. If we wish to name a cell "Temp" so that we can use "Temp" as a variable name in a calculation and as an absolute
reference, how do we do this? Multiple answers possible, and all must be selected for credit.
Define a name in the Name Box.
Define a name using the Name Manager.
Hold down Ctrl-Shift-N then type in the name.
Define a name using the Formula Bar.
Just type it into the cell to the left of the cell that you want to name.
5. Which of the following numbers, text strings, or dates on the left side of each arrow could we put into a single cell and

Answer 1

Answer:

Explanation:

A.      Define a name in the Name Box.

Correct!  This is a suitable way to create a name in Excel.

B.       Define a name using the Formula Bar.

Incorrect.  Variables cannot be named in the Formula Bar.

C.       Define a name using the Name Manager.

Correct!  This is a suitable way to name variables in Excel.

D.      Hold down Ctrl-Shift-N then type in the name.

Incorrect.  This is NOT a way that we can name variables in Excel.

E.       Just type it into the cell to the left of the cell that you want to name.

Incorrect.  This will not work to create a name in Excel.

Answer 2

Hold down Ctrl-Shift-N then type in the name.

If we wish to name a cell "Temp" so that we can use "Temp" as a variable name in a calculation and as an absolute reference.

• Ctrl+Shift+n in Firefox for Windows reopens the most recently closed window. So unless it was a pop-up that closed quickly or automatically so you didn't notice it, you should be able to recognise the website.
• There is no spoken shortcut for Ctrl+Shift+N; instead, you would define it for your macro. Hit Alt+F8 to choose your macro in the Macro Name pane when you've finished creating it. Press the Shift key and the N key while the cursor is blinking in the "Ctrl+" field after clicking the Options button.
• A keyboard shortcut can also be used to launch an Incognito window: Linux, Windows, or Chrome OS Input Ctrl, Shift, and n.
• The line or selected text will be positioned to the right of the screen. Ctrl + M. The paragraph is indented. Ctrl + N. fresh document

#SPJ2