On the Direct Marketing worksheet, create appropriate range names for Design Fee (cell B8), Cost Per Ad (cell B9), Total Clicks
1 answer:
Answer:
See explanation below
Explanation:
Named ranges are a very important tool in Microsoft Excel. It is used in assigning a name to a particular number of cells. It is great for automation and makes formula much easy to understand and use.
One way to create named ranges is theory the Name Box.
To create named ranges in the design marketing sheet we do this;
1) We click on cell B8 and then navigate to the name box at the top right corner of the sheet just above the column A.
•The name box is where the cell address of any cell that is active is displayed.
•You would see that “B8” is displayed on the name box.
• Double click on the name box and type in the appropriate name, in this case - Design_Fee.
• Press enter and you have your named range.
You do the same for the other named ranges.
Note that: Named ranges must contain letters, numbers or underscore.
You might be interested in
Answer:
#include<cstdlib>
#include<bits/stdc++.h>
#include<time.h>
using namespace std;
class Colors{
string colors[7];
public:
void setElement(int,string);
void printAllColors();
void printRandomColor();
};
void Colors::setElement(int index,string color){
colors[index] = color;
}
void Colors::printAllColors(){
cout << "Printing all the colors:\n";
for(int i=0;i<7;i++){
cout << colors[i] <<"\t";
}
}
void Colors::printRandomColor(){
srand (time(NULL));
int index = rand() % 7;
cout<< "\n\nThe random picked color:";
cout << colors[index] << endl;
}
int main(){
Colors color;
color.setElement(0,"red");
color.setElement(1,"orange");
color.setElement(2,"yellow");
color.setElement(3,"green");
color.setElement(4,"blue");
color.setElement(5,"indigo");
color.setElement(6,"violet");
color.printAllColors();
color.printRandomColor();
}
to get the random color we are using srand and rand function. we are using time as seed to srand() function,because every time the time is changed. And based on that we are using rand() function and doing mod with 7 with the random number to get the index between 0 to 6, as ut array size is 7(0 to 6).
In the setElement(int index,string color) method we are inserting the value of colors in the colors array based on index.
In the printAllColors() function we are printing all the colors in the array.
In the printRandomColor() er are printing any random color based on rand() function.
and in main() we are initializing the string array with colors and calling the functions.
