Question 5 / 15

Computers and Technology

2 answers:

inysia [295]1 year ago

8 0

Answer:

$1,020 that is my answer because it will be that one

erastova [34]1 year ago

7 0

The value that would be returned based on the formula [=COUNTIF(A43:A47, "NP*")] in cell A49 is 4.

Microsoft Excel can be defined as a software application that is designed and developed by Microsoft Inc., so as to avail its end users the ability to analyze and visualize spreadsheet documents.

In Microsoft Excel, there are different types of functions (predefined formulas) and these include:

Sum function

Average function

Minimum function

Maximum function

Count function

A count function is typically used to to calculate the number of entries in a cell or number field that meets a specific (predefined) value set by an end user.

In this scenario, "NP*" is the specific (predefined) value that was set and as such the value that would be returned based on the formula in cell A49 is 4 because A43, A44, A45 and A46 contain the value "NP."

Read more on Excel formula here: brainly.com/question/25219289

You might be interested in

What kind of command can you access from the mini toolbar in Microsoft Word?

qaws [65]

Paint,calculator,camera,snipping tool,file,store,and photis

5 0

2 years ago

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100

kobusy [5.1K]

Answer:

David can apply filter to the data in order to show only records that meet the criteria.

Explanation:

Filter is a very helpful option that displays the records that you want to view, hiding rest of the unwanted records.
Sometimes you want to extract and view only the records that match a specific criteria instead of viewing all the records.
For example in the CUSTOMERS table which contains names, addresses, countries of customers. There are several customers from different countries but you only want to view the customers from Spain. So you can use filter feature to view all the customers from country Spain.
In MS Access you can apply filters using Sort & Filter group in the Home tab by selecting the desired column. In SQL, WHERE clause can be used along with SELECT to for filtering and extracting certain records. SELECT will select the records from the table and WHERE clause will specify the criteria to select the certain records.

7 0

3 years ago

George has to present the goals of information management to his team member. What is a goal of information management? The goal

Law Incorporation [45]

Answer:

The purpose of information management is to: design, develop, manage, and use information with insight and innovation. support decision making and create value for individuals, organizations, communities, and societies.

Explanation:

5 0

3 years ago

What does ALU stand for?

ValentinkaMS [17]

It stands for arithmetic logic unit

3 0

3 years ago

Read 2 more answers

Consider a system which has a memory access time of 300 nsec. An average page fault takes around 10 millisecond to get serviced.

vladimir1956 [14]

Answer 72 ncs is the answer im pretty sure