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
JulijaS [17]
4 years ago
6

Elsa has collated information for a meeting using Excel. Due to certain developments, some of the data in her worksheet is now r

edundant. She deletes three rows from her worksheet to reflect the developments. Which of the following will happen to the rest of the rows in the worksheet when Elsa deletes three rows?
A. ​There will be an empty space where the deleted rows were.B. ​The data from the rows will be shifted to rows at the bottom of the worksheet.C. ​The data from the rows will be shifted to the rows at the beginning of the worksheet.D. ​The remaining rows will shift up to take the place of the rows that were deleted.
Computers and Technology
1 answer:
xxTIMURxx [149]4 years ago
4 0

Answer: Option(d) is the correct option

Explanation:

Excel sheets are the spreadsheets which consists of rows and columns for arrangement and display of values.It is used for mathematical function and computation .

According to the question, as Elsa is performing deletion of three rows is done for development, other rows will tend to shift upwards and settle in the deleted row spaces accordingly as per arrangement.

  • Other options are incorrect because deleted rows will not be indicated through empty spaces,row data won't shift to bottom of sheet and neither shift of data will take place at the starting of sheet.
  • Thus the correct option is option(d).
You might be interested in
Write a program to calculate student's average test scores and the grade. You may assume the following input data:
Brums [2.3K]

Answer:

def gradeAverage():

   grades = []

   i = 0

   while i < 5:

       a = int(input('enter score ' + str(i + 1) + ': '))

       grades.append(a)

       i = i+1

   #print(grades)

   average = sum(grades)/len(grades)

   #print(average)

   return average

def lettergrade(a):

   letter = 'A'

   if a < 60:

       letter = 'F'

   elif 59 < a < 63:

       letter = 'D-'

   elif 62 < a < 67:

       letter = 'D'

   elif 66 < a < 70:

       letter = 'D+'

   elif 69 < a < 73:

       letter = 'C-'

   elif 72 < a < 77:

       letter = 'C'

   elif 76 < a < 80:

       letter = 'C+'

   elif 79 < a < 83:

       letter = 'B-'

   elif 82 < a < 87:

       letter = 'B'

   elif 86 < a < 90:

       letter = 'B+'

   elif 89 < a < 94:

       letter = 'A-'

   elif 93 < a < 101:

       letter = 'A'

   return letter

numOfStudents = int(input('How many students: '))

names = []

aver = []

grade =[]

while numOfStudents > 0:

   studentName = input('Enter students name: ')

   names.append(studentName)

   a = gradeAverage()

   aver.append(a)

   grade.append(lettergrade(a))

   numOfStudents = numOfStudents - 1

for name in names:

       for score in aver:

           for letter in grade:

               if names.index(name) == aver.index(score) == grade.index(letter):

                   print('%s : Average =  %d  Letter Grade:  %s \n' %(name, score, letter))

                   break

Explanation:

The programming language used is python.

Two functions were created, the first function gradeAverage() was used to calculate the average values of the scores.

The second function lettergrade(a) was used to get the letter grade i.e(A, A-, C, D, e.t.c.) and it takes its argument from the average.

The main block of code asks for how many students are there and prompts the user to input their names and scores for all the students.

It takes that data calculates the average and the letter grade and prints out the names of the students, their average and their letter grade.

7 0
3 years ago
Which network protocol is used to route ip addresses?.
IgorLugansk [536]

Answer:

the Internet Protocol (IP)

3 0
2 years ago
A company is performing an analysis on the computers at its main office. The computers are spaced along a single row. The analys
harina [27]

Answer:

array = input("Enter the list of computer memory: ").split(',')

int_arr = [int(x) for x in array]

segment = int(input("Enter the length of segment to analyze: "))

list_len = len(int_arr)

segList = []

mini = []

for x,i in enumerate(int_arr):

   seg = int_arr[i-1:segment+i-1]

   if len(seg) == segment:

       segList.append(seg)

for x in segList:

   mini.append(min(x))

result = mini.index(min(mini))

print("Segment with the minimum memory is: ",segList[result])

Explanation:

The python program prints out the segment after analysis, with the smallest disk memory space. The code gets the array of computer rows from the user input and segments the array with the number of segment input, then the minimum is compared for all segments in the network.

5 0
3 years ago
Write a program that reads in 10 numbers and displays the number of distinct numbers and the distinct numbers in their input ord
Alla [95]

Answer:

Explanation:

The following code is written in Python. It creates a for loop that iterates 10 times, asking the user for a number every time. It then checks if the number is inside the numArray. If it is not, then it adds it to the array, if it is then it skips to the next iteration. Finally, it prints the number of distinct numbers and the list of numbers.

numArray = []

for x in range(10):

   num = input("Enter a number")

   if int(num) not in numArray:

       numArray.append(int(num))

print("Number of Distince: " + str(len(numArray)))

for num in numArray:

   print(str(num), end = " ")

8 0
3 years ago
Can you just switch out routers?
lord [1]

You can use your own router instead.

<h3>Can the routers just be changed?</h3>
  • You may use your own router in its place, and there are several compelling reasons to do so: A better and more dependable connection could be provided via a new router.
  • Simply disconnect, remove, and configure the new router. This involves changing the network name and password as normal, as well as connecting an Ethernet connection from the router to the modem.
  • Most Internet service providers let you buy your own modem and router separately or a unit that includes both; the choice is yours. You can access the Internet with either choice. Be aware that if you acquire a combination device and one component breaks (such as the modem or router),

To learn more about router refer to:

brainly.com/question/24812743

#SPJ4

5 0
2 years ago
Other questions:
  • Assign sub_lyric by slicing rhyme_lyric from start_index to end_index which are given as inputs. Sample output with inputs: 4 7
    12·1 answer
  • Public class Robot
    15·1 answer
  • Python: Write a program that asks the user how many Fibonnaci numbers to generate and then generates them.
    10·1 answer
  • 20 PTS URGENT!!! Derek’s organization uses an emerging technology that uses specialized software to place an image on an object,
    6·2 answers
  • PLEASE HELP!!!!!!!!!!!!!!!!!!!!
    13·1 answer
  • write a loop that reads positive integers from standard input and that terminates when it reads an integers that is not positive
    11·1 answer
  • William would like to sort a list of items after the data is already entered.
    5·1 answer
  • Consider a multidimensional array A stored in row-major order with 22 rows and 6 columns whose subscripts start at 0. If each el
    8·1 answer
  • Freee poiiiiintttttssss​
    14·2 answers
  • Help pleaseeeeeeeeeeeeeeeeee
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!