All categories

3 years ago

A file extension of .xlsx means that the file contains what?

1 answer:

3 0

A .xlsx file tells you that the file is an Excel workbook that utilizes XML files to create the various spreadsheets as well as macros and other hidden codes used to perform certain functions (which is why there's an X at the end; older .xls files had no indication of this external code being present, which is why they're almost never recommended for modern use).

You might be interested in

Write a Python 3 program to read from a .csv file containing rates from power companies. Your program should determine the avera

aliya0001 [1]

Answer:

In python:

file = open("rates.csv", "r")

ratecount = 0

ratesum = 0

mylist = []

rates = file.readlines()

for nums in rates:

num = nums.rstrip('\n')

mylist.append(int(num))

for i in num:

ratesum= ratesum + int(i)

ratecount = ratecount + 1

print("Maximum Rate: "+str(max(mylist)))

print("Minimum Rate: "+str(min(mylist)))

print("Average Rate: "+str(ratesum/ratecount))

Explanation:

This opens the csv file

file = open("rates.csv", "r")

This initializes the number of rates in the file

ratecount = 0

This initializes the sum of the rates

ratesum = 0

This initializes an empty list

mylist = []

This reads the rates into lines

rates = file.readlines()

This iterates through the rates (as a string)

for nums in rates:

This removes the newline character \n in the rates

num = nums.rstrip('\n')

This appends the rates (as an integer) to the empty list

mylist.append(int(num))

The following counts the rates in the file and also sum them up

for i in num:

ratesum= ratesum + int(i)

ratecount = ratecount + 1

This prints the maximum of the rates

print("Maximum Rate: "+str(max(mylist)))

This prints the minimum of the rates

print("Minimum Rate: "+str(min(mylist)))

This calculates and prints the average rate

print("Average Rate: "+str(ratesum/ratecount))

6 0

3 years ago

This component is responsible for the logical order of processing?

Svetradugi [14.3K]

Answer:

A) ALU

Explanation:

The arithmetic logic unit (ALU) performs the arithmetic and logical functions that are the work of the computer.

So, the correct option is - A) ALU

6 0

3 years ago

Design a program that asks the user to enter a series of 20 numbers. The program should store the numbers in a list and then dis

Aleksandr-060686 [28]

Answer:

The following are the program in the Python Programming Language.

#declare the list

lst=[]

#set the for loop

for num in range(1,21):

#get the element of the list from the user

n=int(input('Enter the {} element :' .format(num)))

#add elements in the list

lst.append(n)

print()

#print the minimum number in list

print('The lowest number in the list: ',min(lst))

#print the maximum number in list

print('The highest number in the list: ',max(lst))

#print the total of the list

print('The total of the numbers in the list: ',sum(lst))

#print the average of the list

print('The average of the numbers in the list: ',sum(lst)/len(lst))

Output:

Enter the 1 element :53

Enter the 2 element :65

Enter the 3 element :41

Enter the 4 element :23

Enter the 5 element :21

Enter the 6 element :12

Enter the 7 element :96

Enter the 8 element :85

Enter the 9 element :74

Enter the 10 element :98

Enter the 11 element :75

Enter the 12 element :41

Enter the 13 element :54

Enter the 14 element :56

Enter the 15 element :36

Enter the 16 element :25

Enter the 17 element :14

Enter the 18 element :12

Enter the 19 element :45

Enter the 20 element :65

The lowest number in the list: 12

The highest number in the list: 98

The total of the numbers in the list: 991

The average of the numbers in the list: 49.55

Explanation:

The following are the description of the program.

Firstly, we declare the empty list type variable 'lst' to store elements.
Then, set the for loop statement that iterates from 1 and end at 20.
Then, set a variable that get elements of the list from the user and appends those user defined inputs in the list type variable 'lst'.
Finally, print the lowest and the largest elements in the list as well as print the total and average of the elements in the list.

6 0

3 years ago

Richard Palm is the accounting clerk of Olive Limited. He uses the source documents such as purchase orders, sales invoices and

sdas [7]

Answer:

Lack of segregation of duties

Explanation:

Internal Controls are set of rules and guidelines that are followed to ensure effectiveness of business operations. The main risk in the business is weak internal controls. There are some organizations with strong internal controls but implementation of such controls is a challenge for organizations. There are human errors, IT security risks, fraud and compliance risk.

The risks associated with Olive limited is that there is no segregation of duties, Richard Palm is preparing journal vouchers, posts the journal vouchers and reconciles the balance himself. If he makes an error in recording a transaction there is no one who reviews his work and can identify an error. Also if Richard is involved in a fraud and collaborates with purchase department or sales department staff, he can pass a transaction without any supervision.

5 0

3 years ago

It is appropriate to leave sections of an application blank ? True or False

sergiy2304 [10]

false because if you leave them blank then ther will be no use to add them in the first

3 0

3 years ago