02 - Range Properties Quiz
Quiz Summary
0 of 8 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 8 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 8
1. Question
The correct syntax for making Cell A1 bold is
Range("A1").Font = Bold
CorrectIncorrect -
Question 2 of 8
2. Question
The default property for a Range is :
CorrectIncorrect -
Question 3 of 8
3. Question
If you wanted to get the Absolute address (with all the dollar signs aka $A$1) of cell A1, you would type the following. . .
CorrectIncorrect -
Question 4 of 8
4. Question
To have Excel Select a certain cell or range, such as our "tax_table", you'd type
Range("tax_table").Select
CorrectIncorrect -
Question 5 of 8
5. Question
In the following example:
These two lines of code will return the same data from cell A1 in a Message Box:
Msgbox Range(“a1”).Valueand
Msgbox Range(“a1”).TextCorrectIncorrect -
Question 6 of 8
6. Question
It is possible to assign a formula to a cell using VB and then take the output from the formula and assign it to the same cell; basically replacing the formula (so an edit in values used for the calculation will not change the value in the cell for the future).
CorrectIncorrect -
Question 7 of 8
7. Question
To code a range of numbers to be formatted for percentages with TWO decimal places, which code would be correct?
CorrectIncorrect -
Question 8 of 8
8. Question
The COUNT property for a range will display the total of all the values in the cells of the range.
CorrectIncorrect