All categories

4 years ago

A _____ is a prewritten formula that is built into Excel.

1 answer:

3 0

The answer is a function.
In Microsoft Office Excel, a function refers to the pre-written formula that is built. There are a lot of functions in Microsoft Office Excel like the arithmetic functions such as sum or total, difference, and an average of numbers. In Excel, these functions are defined using Visual Basic.

You might be interested in

write a program that computes an integer's checksum. to compute the checksum, break the integer into its constituent

Serggg [28]

Using the knowledge in computational language in python it is possible to write a code that computes an integer's checksum.

<h3>Writting the code:</h3>

def checkSum(n): # Function definition

total = 0 # total variable which returns sum

c = 0 # counter variable which count the even position

while(n!=0): # running a loop while n != 0

r = int(n%10) #breaking the number into digits

c=c+1 # increase counter

if c%2==0: # if counter is even position then double the number

r = r*2

while(r!=0): # do the process

total = total + int(r%10)

r = int(r/10)

n=int(n/10)

else: # if counter is odd position then simple add the digit

total = total + r # into total

n=int(n/10)

return total # in the last return the sum of digits

# Driver code

n = int(input("Enter Number:")) # asking user to enter the number

print(checkSum(n)) # calling the function

See more about python at brainly.com/question/18502436

#SPJ1

8 0

2 years ago

The variable sentence stores a string. Write code to determine how many words in sentence start and end with the same letter, in

irina [24]

Answer:

sentence = "hello wow a stores good"

same_letter_count = 0

sentence_list = sentence.split()

for s in sentence_list:

if s[0] == s[-1]:

same_letter_count += 1

print(same_letter_count)

Explanation:

*The code is in Python.

Initialize the sentence with a string

Initialize the same_letter_count as 0

Split the sentence using split method and set it to the sentence_list

Create a for loop that iterates through the sentence_list. If the first and last of the letters of a string are same, increment the same_letter_count by 1

When the loop is done, print the same_letter_count

4 0

3 years ago

Which of the following is not true about managing your privacy settings? (select all that apply)

Evgesh-ka [11]

I'm going with
The things that you post online become public information.
and
Employers screen job candidates based on social medias.

Because when you post online, you can very easily make your account private, or only share the post to a specified group of people.

Employers also screen job candidates based on their backround, personality, etc.

4 0

4 years ago

Read 2 more answers

A person you respect who offers you advice and assistance is known as a(n) _____.

Archy [21]

This would be a mentor-D. They role is to mentor or guide you with advice or assistance. A role model is a similar answer in that they respect you, but they might not offer advice or assistance which makes it incorrect.

7 0

3 years ago

Write a loop that reads c-strings from standard input where the c-string is either "land", "air", or "water". The loop terminate

Anvisha [2.4K]

Answer:

I am writing a C++ code.

#include <iostream> // for input output functions

using namespace std; // identifies objects like cin cout

int main() { //start of main() function body

string c_string; // stores the string entered by user from land water or air

int land=0; // contains the number of times land string is read in

int air=0; //contains the number of times air string is read in

int water = 0; //contains the number of times water string is read in

cin>>c_string; //reads the string entered by user from air water or land

/*while loop continues to execute until user enters xxxxx or maximum length of a string exceeds 8 */

while(c_string!= "xxxxx" && c_string.length()<=8) {

if(c_string=="land"){ // if string entered by user is land

land = land + 1;} //counts and increments each occurrence of land string by 1

else if(c_string=="air"){// if string entered by user is air

air = air + 1;}// counts and increments each occurrence of string air by 1

else if(c_string=="water"){// if string entered by user is water

water = water + 1;}//counts and increments each occurrence of air by 1

cin>>c_string;}

/* keeps reading the string entered by user from land air or water, until the loop breaks after the user enters xxxxx or user enters a string whose length is greater than 8 */

//prints the number of times land, air and water are read in

cout << "land:"<<land;

cout << endl<<"air:"<<air;

cout << endl<< "water:"<<water; }

Explanation:

Everything is well explained in the comments above.

The program prompts the user to input strings. These strings are either land air or water. The while loop continues to read the input strings until user enters xxxxx or the string entered by user exceeds the length 8. Both these terminating conditions are added in the while loop. After the loop terminates, the number of times land, air and water strings are read is displayed on the output screen. Any other string entered by user other than these 3 is ignored. The program along with the output is attached.

3 0

3 years ago