Question

6. You have decided to name a cell in your worksheet which contains a key figure that you will be using in lots of different calculations across your whole workbook. You know that spaces are not allowed in Names in Excel. How many of the following statements are also true in relation to Names? Select all options that apply. ? The name cannot be any combination of text and numbers which is also a cell reference. ? Names can mix letters and numbers, but the text characters must come first. ? Names are case sensitive.

          6. You have decided to name a cell in your worksheet which contains a key figure that you will be using in lots of
different calculations across your whole workbook. You know that spaces are not allowed in Names in Excel. How
many of the following statements are also true in relation to Names? Select all options that apply.

? The name cannot be any combination of text and numbers which is also a cell reference.
? Names can mix letters and numbers, but the text characters must come first.
? Names are case sensitive.

Show more…

6. You have decided to name a cell in your worksheet which contains a key figure that you will be using in lots of
different calculations across your whole workbook. You know that spaces are not allowed in Names in Excel. How
many of the following statements are also true in relation to Names? Select all options that apply.

? The name cannot be any combination of text and numbers which is also a cell reference.
? Names can mix letters and numbers, but the text characters must come first.
? Names are case sensitive.

Added by Jill A.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Mauya Mitchell

08/12/2024

Step 1

"The name cannot be any combination of text and numbers which is also a cell reference." - This statement is true. Excel will not allow you to name a cell with a combination of text and numbers that could be interpreted as a cell reference. For example, you cannot Show more…

Show all steps

lock

Thanks for your feedback!

Play audio

Feedback

Powered by NumerAI

Mauya Mitchell and 101 other subject AP CS educators are ready to help you.

Ask a new question

Labs

Want to see this concept in action?

NEW

Explore this concept interactively to see how it behaves as you change inputs.

View Labs

Key Concepts

Recommended Videos

Recommended Textbooks

Transcript

Ace is your personal tutor. It breaks down any question with clear steps so you can learn.

Start Using Ace

Continue solving this problem

Create a free account to:

View full step-by-step solution
Ask follow-up questions with Ace AI
Save progress and study later