1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Tamiku [17]
3 years ago
8

The syntax used for referencing cells with their worksheet names is the sheet name, followed by ____, then the usual column lett

er and, finally, the row number.
Computers and Technology
1 answer:
Snezhnost [94]3 years ago
4 0

Answer:

Exclamation mark " ! "

Explanation:

Microsoft Excel is a spreadsheet application used for data analysis. It is used to analyze and represent data in statistical diagrams for easy comprehension. It has various tools and formulas.

It's workbook can contain several worksheets. The worksheet is made of cells located by a row and column. To locate and use a cell in another worksheet, the name of the worksheet followed by and exclamation mark and then the column alphabet and row number of the cell.

Eg: travel ! B9 ( where 'travel' is the worksheet name)

You might be interested in
3. (20 points) Write a C++ recursive function that finds the maximum value in an array (or vector) of integers without using any
Luden [163]

Answer:

Following are the code to this question:

In option (i):

#include <iostream>//defining header file

using namespace std;

int findMax(int B[], int x)//defining recursive method findMax

{

if (x == 1)//defining condition when value of n==1

return B[0];//return array first element

return max(B[x-1], findMax(B, x-1)); // calling recursive method inside max method and return value

}

int main() //defining main method  

{

int B[] = {12, 24, 55, 60, 50, 30, 29};//defining array B

int x= 7;//defining integer variable and assign a value

cout << "Maximum element value of the array is: "<<findMax(B, x)<<endl;//calling method findMax and print value

return 0;

}

Output:

Maximum element value of the array is: 60

In option (ii):

\Rightarrow \ T(n) = 1 + T(n-1)\\\Rightarrow  1 + 1 + T(n-2)\\ \Rightarrow  1 + 1 + 1 + ... n \ times \\\Rightarrow  O(n) \\

Explanation:

In the above-given program a recursive method "findMax" is defined, which accepts an array "B" and an integer variable "n" in its parameter, inside the method a conditional statement is used that, checks value of x equal to 1.

  • If the above condition is true it will return the first element of the array and find the max number.
  • Inside the main method, an array B is declared that assigns some values and an integer variable is declared, that also assigns some values, in the last step print method is used that pass value in method and prints its return value.
  • In the option (ii) we calculate the Big-O notation algorithm value.
5 0
4 years ago
Which expresses 6y : 9y in its simplest form?
Gwar [14]
<span>This problem is an example of ratio and proportion. You are given 6y:9y. You are required to convert this into its simplest form. The 6y:9y is also equivalent to 6y/9y. The ‘y’ variable can be eliminated since it has the same exponent and base. You are left with 6/9. The common factor for 6 and 9 is 3 so divide each number by 3. So 6/3 is 2 and 9/3 is 3. You get 2/3. This is its simplest form.</span>
6 0
3 years ago
What's the most common method used to configure a vlan-capable switch?
Charra [1.4K]
Eating is. Sorry i dont know the answer i just need points
6 0
3 years ago
How to get this on your screen in 2k20 on Xbox
MrMuchimi
D pad hope this helps
6 0
3 years ago
Read 2 more answers
What are some of the challenges that could arise from setting up a file management system on a computer?
son4ous [18]
It could glitch out or be hacked or deleted.
8 0
3 years ago
Other questions:
  • Which resource do programmers sometimes have to refer to and use during planning the logical steps of the solution?
    10·2 answers
  • printStars is a method that accepts a single int argument and returns no value. It prints as many stars as indicated by its argu
    9·1 answer
  • What is needed to create a good problem statement?
    10·1 answer
  • What is an advantage of using a meta-search engine?
    14·1 answer
  • A very simple device that connects network components and sends packets of data to all other connected devices is called a _____
    5·1 answer
  • _____ is the software that protects you computer from harmful files, Trojan horses, and worms.
    13·2 answers
  • Research shows that a passive close to a cover letter leads to more interviews. Please select the best answer from the choices p
    8·2 answers
  • 1. It is a set of integrated devices that input, output,
    11·1 answer
  • John's father specifically asked him to get a magnetic disk from the store in his neighborhood. What should John buy?
    5·1 answer
  • Whats th diffence between a fwireless speaker and a wird speakr
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!