Which formula is properly constructed

Which Formula Is Properly Constructed

Answers

Answer 1

Answer:

Option 4 is correct ,=(B2+C9)

Explanation:

In excel a formula starts with an equal sign followed by the expression.

In first option the formula is incorrect inside the brackets. where 4 is equating to bracket. In 2nd option opening and closing brackets are not same. First closing bracket is missing an opening bracket. In third option all the formula is correct except the part where # is used in formula. Hash tags cannot be used in formula as a value. Here in option D  B2 and C9 are cell in excel, whereas parentheses are only used for better readability.


Related Questions

When a hacker steals personal information with the intent of impersonating another individual to commit faur, it is known as?

Answers

The answer is identity theft

A résumé formatted so that it can be posted to the Internet and which can contain sophisticated graphics, is a _______.

Answers

Answer:

Web resume

Explanation:

A web resume is a digital resume that is used instead of the regular traditional ones, it can be sent and received over the internet and it can be formatted in such a way that it can contain high definition images, graphics and even videos so as draw employers interest.  

Answer:

Web resume

Explanation:

To see a custom, object-specific action on the palette of the page layout editor: A. Click Layout Properties on the page layout editor. B. Select Mobile & Lightning Actions in the list of element types. C. First customize the action in the action layout editor. D. Select Quick Actions in the list of element types. Check the quiz to earn 100 points

Answers

Answer:

Select Mobile & Lightning Actions in the list of element types

Explanation:

Option B is correct Answer.

A 'array palindrome' is an array which, when its elements are reversed, remains the same (i.e., the elements of the array are same when scanned forward or backward) Write a recursive, bool-valued function, isPalindrome, that accepts an integer -valued array , and the number of elements and returns whether the array is a palindrome.

An array is a palindrome if:

the array is empty (0 elements ) or contains only one element (which therefore is the same when reversed), or

the first and last elements of the array are the same, and the rest of the array (i.e., the second through next-to-last elements ) form a palindrome.

Answers

Answer:

This code is written in MATLAB.

function [result] = isPalindrome(array,length)

if length == 0 || length == 1 %if the array is empty or contains only one element, the array is a palindrome

result = 1;

else

for i = 1:length/2 %check all the elements forward and backward until the middle is reached

if array(i) ~= array(end+1-i)

result = 0;

return

end

end

result = 1;

end

Explanation: Please read the comments in the code. In MATLAB, Boolean values are 1 or 0 instead of True or False.

Identify an attribute selector used to select an element based on its class value.

Answers

Answer:

elem.class  is the correct answer for the above question.

Explanation:

In CSS(cascading style sheet), When a user wants to use any property for any attribute and if there are multiple attributes on which he wants to apply the same property then he needs to use the attribute selector based on class.

Just, for example, suppose there is a two image in an HTML document and both need to fill the green color then the user needs to give the same class to both div and use that class property in a CSS to define the green color which can be applied on the image.To use the class property in a CSS, a user needs to define like---

elem.class (where 'elem' is the name of the tag ('img' tag in the above example) and class is the name of the defined class(which is same on the bothe 'img' tag)).The Question asked about the attribute selector of class in CSS and the answer is elem.class, which is defined above.

To protect your wireless devices and the information they hold, you should set up encryption such as ____.

Answers

Answer:

The correct answer for the given question is "WPA2".

Explanation:

The encryption process is used for security purposes.WPA2 is a type of encryption that provides the security of Wi-Fi networks.WPA2  provides a unique key for each Wi-Fi user that are connected to the Wi-Fi networks.A single unique key allowing only one user can connect only 1  Wi-Fi network at a time.WPA2 is encryption that protected the wireless device and the information.

What is a service-oriented architecture? Group of answer choices A business-driven enterprise architecture that supports integrating a business as linked, repeatable activities, tasks, or services. The capability of two or more computer systems to share data and resources, even though they are made by different manufacturers. A business task. The capability of services to be joined together on demand to create composite services, or disassembled just as easily into their functional component.

Answers

Answer:

Option A is correct -

business-driven enterprise architecture that supports integrating a business as linked, repeatable activities, tasks, or services

Explanation:

This kind of services are special unit of function that can be accessed remotely and acted upon and update independently such as retrieving your email password.

entry that has the address of 192.168.101.0 and the wildcard mask of 0.0.0.255. What is the range of IPv4 addresses that will be affected by this ACL?

Answers

Answer:

192.168.101.0 through 192.168.101.255 is the correct answer.

Explanation:

The following answer is correct because the address of the ACL entry is 192.168.101.0 and 0.0.0.255 is the wildcard mask then, the range of the IPv4 addresses is 192.168.101.0 through 192.168.101.255 that affected by the ACL.

ACL is referred as the access control list that acts as the firewall which secures the VPC network of the user.

The range of IPv4 addresses affected by the given ACL is from 192.168.101.0 to 192.168.101.255. The wildcard mask of 0.0.0.255 indicates that the last octet can vary from 0 to 255. Therefore, all addresses within this range will be either permitted or denied based on the ACL configuration.

The question pertains to Access Control Lists (ACLs) in network settings using IPv4 addresses. The IPv4 address given, 192.168.101.0, with a wildcard mask of 0.0.0.255, affects a specific range of IP addresses.

Step-by-Step Explanation :

An IPv4 address is a 32-bit address divided into four octets, with each octet represented by a number ranging from 0 to 255. The address 192.168.101.0 falls into this range.A wildcard mask is used in ACLs to specify a range of IP addresses. The given wildcard mask, 0.0.0.255, means that the last octet can vary from 0 to 255.Combining the IPv4 address and the wildcard mask, the range of IP addresses affected includes all addresses from 192.168.101.0 to 192.168.101.255.

Therefore, the range of IPv4 addresses that will be affected by this ACL is from 192.168.101.0 to 192.168.101.255.

A data mart differs from a data warehouse in that: Group of answer choices it deals with a particular component or functional area of the business. data mart users do not have the data management expertise of data warehouse employees. Both it has a smaller database and it deals with a particular component or functional area of the business All of these it has a smaller database.

Answers

Answer:

A Data Warehouse is a corporate database that integrates purified information from the various sources in the organization. This information must be homogeneous and reliable, it is stored in a way that allows its analysis from many different perspectives, and that it is in turn of the optimal response times. For this, the information is highly denormalized and modeled in a way quite different from transactional systems, mainly the star models (star scheme) and snowflake (snowflake scheme) that we will study later.

A Data Warehouse is much more than what we have commented so far. According to Bill Inmon it is characterized by being:

Theme-oriented: data is organized by topics to facilitate user understanding, so that all data related to the same element of real life is linked together. For example, all customer data can be consolidated in the same table, all product data in another, and so on.

Integrated: the data must be integrated into a consistent structure, eliminating the inconsistencies involved between the various operational systems. The information is structured in various levels of detail to suit the needs of users. Some of the most common inconsistencies that we usually find are: in nomenclature, in units of measure, in date formats, multiple tables with similar information (for example, having several applications in the company, each with customer tables) .

Historical (time variant): the data, which may vary over time, must remain reflected in such a way that these changes are consulted and the reality that was at the time they were stored is not altered, thus avoiding the problem that occurs in the operational systems, that specifically only the state of the present business activity. A Data Warehouse must save the different values ​​that take a variable over time. For example, if a client has lived in three different cities, he must specify the period he lived in each of them and associate the facts (sales, returns, incidents, etc.) that occurred at any time to the city in which He lived when they occurred, and did not associate all historical facts with the city in which he currently lives. If a customer, during all the time we have been selling has gone through three civil states (single, married and divorced) we must know what marital status he had at the time we made each of the sales.

This is a formal document used to describe in detail for software developers a product's intended capabilities, appearance, and interactions with users.

Answers

Answer:

Functional specification

Explanation:

Functional specification is a formal statement, more like a contract between a software developer and an employer on what he (the developer) should do. the document is use to describe in detail for the developers what a product is suppose to do, how the user interface of the product should look like, how it should interact with users and much more.

What is an IP address?
the 32-bit numeric address identifying a specific computer or device on a network the 30-bit numeric address identifying a group of computers or devices on a network
the 42-bit numeric address identifying a specific computer or device on a network
the 15-bit numeric address identifying a group of computers or devices on a network

Answers

Answer:

the 32-bit numeric address identifying a specific computer or device on a network

Explanation:

Ip address is a 32 bit number that is used to identify the computer or devices on the network.

It is the unique address that is assigned to computer or nodes in the network. It is a unique address that helps to send data or packet to the desired destination from any other computer on the network.

It is same like as the address of the home. A unique address is assigned to the home. That cannot be similar to any other home address.

It consist of 32 bits which means that 2^ 32 unique address can be generated with the help of 32 bits.

e.g.

192.168.3.3

The above number is an example of IP address where each digit consist of 8 bits.

Which control chart would you use to track rejections in a maintenance projeg when bug arrival pattern is not constant?

Answers

Answer:

P chart is the control chart that is used to monitor the rejection or acceptance whenever the bug arrival in pattern is not constant.

Explanation:

In case of only two possible outcomes, such as yes or no, accept or reject, P chart is used as control chart to track rejections. It is used to track rejections whenever the pattern of rejection is not constant. In this type of charts we collect the information from last few days to analyze and predict the next data to track rejections.

For example:

If we want to know that, in admission department of the university, how many students arrives to take admission in university, does not meet the qualification criteria each week. In this case there are only two options available either they meet criteria or not. In this case we use P chart with the help of previous week data to analyze the no. of students who are meeting qualification criteria in this week.

James, a system administrator, is tasked to update the BIOS and firmware of the computer in his organization. What are the reasons to update them?

Answers

Answer:

One reason to update BIOS and firmware is to ensure they support new hardware like CPU model or graphic card. In some cases, the updates can also resolve overheating issue or motherboard issue.  

However, this is not always the case that we must update the BIOS every time there is a new release because the latest update may cause problem to existing system as well.

As a general rule, only when there are some problems with the existing BIOS and firmware, we are only required to update them.

Final answer:

Updating the BIOS and firmware of computers ensures enhanced security, improved compatibility with new hardware and software, and increased stability and performance, all of which are essential for maintaining an efficient and secure computing environment.

Explanation:

James, a system administrator, is tasked with updating the BIOS and firmware of computers in his organization. There are several reasons to perform these updates:

Enhanced Security: Updates can include patches to protect against new vulnerabilities, helping to keep the organization's data safe.Improved Compatibility: Firmware updates may enable hardware to work better with new devices or software, ensuring smooth operations.Increased Stability and Performance: Bug fixes and improvements in the updates can lead to a more stable and efficient computing environment, which is crucial for productivity.

Just as an operating system is essential for a computer's operations, keeping system firmware up-to-date ensures the infrastructure of the computers remains reliable, efficient, and sustainable, avoiding the costly disruptions that come with outdated or malfunctioning systems.

You have an email that you are sending to a friend. You want to ensure it retains its integrity during transit, so you decide to digitally sign the email. When using a PKI system, what is used to encrypt the hash digest of the email to create a digital signature?

Answers

Answer:

Private key

Explanation:

A digital signature is created when a private key is used with the email document to generate a hash digest of the original email. The private key is used with a known public key, so even if an attacker sees the public key, he won't see the private one.

The hash digest is a randomly generated encryption line of text which makes no meaning until a private e is used to decrypt the text by the receiving party.

Which is the most common way to install memory in a laptop?
At an angle
From the bottom
From the side
From the top

Answers

From the side is the most common way to install memory in a laptop.

From the side.

Explanation:

A physical memory can be connected to a laptop from the side of the laptop where the connection port is provided. Mostly, laptops are slim when contrasted with a personal computer, the memory banks are even with the PC. So from the side we can install memory in a laptop.

The memory must be embedded at an edge (roughly 75 degrees). When it is in the opening, push down on the memory to adjust it properly. At long last, when introducing the memory, convey the weight equitably by pushing on the two corners of the memory module.

When a policy setting in Computer Configuration and User Configuration in the same GPO conflict, the Computer Configuration policy setting takes precedence. True or False?

Answers

Answer:

True

Explanation:

Computer Configuration policy applied first. This happens when the Computer system boots up. Then the user policy is applied when the user logs on. This takes place when the user object is in the same organizational unit.

So Computer Config policy setting takes precedence. User configurations is applied to local users only while computer configuration is applied to the machine itself. First the Computer GPO is applied and then the User GPO.  Loopback processing in replace mode enforces the Computer GPO over the user GPO.

Consider the following program segment. ifstream inFile; //Line 1 int x, y; //Line 2 ... //Line 3 inFile >> x >> y; //Line 4 Which of the following statements at Line 3 can be used to open the file progdata.dat and input data from this file into x and y at Line 4?

Answers

Answer:

inFile.open("progdata.dat");

Explanation:

This command opens the file which is passed to it as an argument. We are quite used to the C++'s cin and cout functions contained in iostream library for reading and writing data, however, when working will real-life stuff, we find ourselves working with huge data saved as separate files and require our programs to read them, manipulate them and possibly write back to the files... The first operation usually carried out before a file can be read or written to is open

Suppose that you purchase a wireless router and connect it to your cable modem. Also, suppose that your ISP dynamically assigns your connected device (your wireless router) one IP address. Also suppose that you have six PCs at home that use 802.11 to wirelessly connect to your wireless router. How are IP addresses assigned to the six PCs? Does your wireless router use NAT? Why or why not?

Answers

Answer:

The six PCs are assigned private IP addresses via Dynamic Host Configuration Protocol (DHCP)

Yes, the wireless router uses Network Address Translation.(NAT)

Explanation:

Network Address Translation. (NAT) allows a private unregistered network to connect to the internet using one IP address. It is the role of DHCP to assign the private IP addresses to all 6 PCs in the wireless LAN. NAT allows communication between these two different networks by translating the private IP address into a registered public IP address for internet access.

When publishing a Website, a Website developer using a GUI HTML editor has which advantage over a developer using an HTML text editor?

Answers

Answer:

The main advantage is the presence of an FTP tool that GUI editors have, which is usually in-built. The FTP or "File Transfer Protocol" makes it easy for users to upload and download files on the server.

Explanation:

NOTE: in mathematics, the square root of a negative number is not real; in C therefore, passing such a value to the square root function is an error. Given a double variable named areaOfSquare write the necessary code to read in a value, the area of some square, into areaOfSquare and print out the length of the side of that square. HOWEVER: if any value read in is not valid input, just print the message "INVALID".

Answers

Answer:

# include<math.h>

# include<stdlib.h>

# include<stdio.h>

int main()

{

    int choice;

    double area;

    printf("Enter the area of Square:");

    scanf("%lf", &area);

    printf("Enter the choice: 1, 2:");

    scanf("%d", &choice);

    switch(choice)

    {

        case 1:if(area<0.00)

                        {

                        printf(" INVALID");

                        break;

                        }

                      else

                        {

                        printf("side of square: %lf", sqrt(area));

                        break;

                       }

                       break;

        case 2: break;

    }

return 0;

}

Explanation:

Here, if area is less than 0 then invalid message is printed out. And if area is more than 0 then the sqrt is calculated and the side of a square length is being printed out. And that is what is required. lf is for double. And math.h is included to make use of the sqrt function.

You need to place a wireless access point in your two-story building. While trying avoid interference, which of the following is the best location for the access point?
1. On the top floor
2. In the kitchen area
3. Near the backup generators
4. In the basement

Answers

Answer:

2 In the kitchen area

Explanation:

This place has less people coming in and it's not that crowded to cause interference. And the closer the access point is to the user the stronger the coverage will be.

The top floor and the basement would have been too far.

The backup generators generate noise that may cause interference of signals

___________ apps generate graphic images that are superimposed on pictures of real objects, such as rooms and roads. For instance, a mobile phone user might point her phone camera at an office building and activate an app that generates the logos of all food services, such as Starbucks and Pizza Hut, inside the building.

Answers

Answer:

Augmented reality

Explanation:

Augmented reality apps are software applications which merge digital visual such as pictures, images and even sometimes audio and other types of files content into the users real world environment. examples are AcrossAir, Google sky map, Lookator, SpotCrime, PokemonGo etc.

By using the latest information technology it is possible to substitute information for inventory and other logistics expenses.

a. True
b. False

Answers

Answer:

True

Explanation:

Which of the following are true about the PUSH instruction?

A. It decrements the stack pointer (by 2 or 4) and copies the operand into the stack at the location pointed to by the stack pointer.
B. It increments the stack pointer (by 2 or 4) and copies the operand into the stack at the location pointed to by the stack pointer.
C. It increments the stack pointer by 1 and copies the operand into the stack at the location pointed to by the stack pointer.
D. It copies the operand into the stack at the location pointed to by the stack pointer, and then decrements the stack pointer (by 2 or 4).

Answers

Answer:

Option A.

Explanation:

Only option A satisfies the definition of push statements. So it is only the correct option.

One of the advantages of off-the-shelf software is that ________________. a. the software contains important features, thus eliminating the need for future modification and customization b. b. an organization does not have to pay for features that are not required and never used

Answers

Answer:

One of the advantages of off-the-shelf software is that the initial cost is lower because the software firm can spread the development costs over many customers.

Explanation:

Two other choices are missing in the question all choices are:

a. the software contains important features, thus eliminating the need for future modification and customization  

b. an organization does not have to pay for features that are not required and never used

c. the software always matches current work processes and data standards.

d. the initial cost is lower because the software firm can spread the development costs over many customers.

Off-the-shelf software can be used by the customer without customization. It is ready made and not developed according to the customer's specifications. Therefore, these software are cheaper than the custom developed software and can easily found and purchased.

Since off-the self software can be used by multiple customers, its initial cost is lower.  

Example of off-the-shelf software are Salesforce CRM, Linux operating system, MySQL database, Microsoft Office, anti-virus programs.

Rebecca completed work on a computer and is verifying the functionality of the system when she finds a new problem. This problem is not urgent and can be easily fixed. The policy at Rebecca’s company is that all problems need to be reported and given a priority code before they can be assigned to someone.What should Rebecca do about this new problem?a. Report the new problem.b. Troubleshoot the new problem.c. Ignore the new problem.d. Determine whether fixing the first problem caused the second problem.

Answers

Rebecca should Determine whether fixing the first problem caused the second problem.

d. Determine whether fixing the first problem caused the second problem.

Explanation:

Rebecca completed work on the computer and is verifying the functionality of the system when she finds a new problem.

Keeping in mind the fact that Rebecca's company's policy is that all problems need to be reported and given a priority code before they can be assigned to someone, she should go ahead and determine whether fixing the first problem caused the second problem to arise.

Although the company's policy does not approve of this, before reporting a problem she should check whether the problem is worth the effort. As mentioned, the problem is not urgent and can easily be fixed, she should go ahead with this option.

Rearrange the following code so that it forms a correct program that prints out the letter Q: } public static void main(String[] a) { } System.out.println("Q"); public class Q {

Answers

Answer:

The code after rearrange the question segment:

public class Q// Class declaration of Q name.

{// Open the class body.

     public static void main(String[] a) // Main function declaration.

{ //Open the main-function body.

            System.out.println("Q"); // Print statement which print Q.

} //close the main-function body.

}//close the class body.

Output:

Q

Explanation:

The correct form of the question segment is written in the answer part. Now, this program can print Q. The syntax used above is described below--

Firstly the user needs to define the class so the class declaration statement is defined above.Then the user needs to open the braces to tell the compiler about the body of the class Then the user needs to define the main function which tells the compiler that the execution starts from there.Then the user needs to open the braces to tell the compiler about the body of the main function.Then the user needs to define the print statement which helps to print 'Q'.Then the user needs to close the braces to tell the compiler that the main function body id closed.Then the user needs to close the braces to tell the compiler that the class body id closed.

Which of the following is necessary to connect a computer outside of the hospital to the hospital's server?
A. WANB. LANC. VPND. FOV

Answers

Answer:

The answer is "Option C"

Explanation:

VPN reflects virtual private networking, providing secure networking and strong links between private networks. It helps us to use remote machines, that are like on the same local site, and we use VPN to reach the hospital website. And other choices which could be listed as follows that is not correct:

In option A, WAN represents a wide area network, it's used to connect computers through networking, that's why it's not correct. In option B, LAN stands for local area network, it shares a common line or wireless links for communication, that's why it is not correct.In option D, FOV stands for field of view that is used for gaming purposes, that's why it is not correct.

Holding an NREMT certification may help you in which of the following situations?A. Establishing protocolsB. Providing prehospital careC. Gaining reciprocityD. Passing an EMT examination

Answers

Answer:

Option(c) is the correct answer for the given question.

Explanation:

NREMT certification helps in giving the EMT certification in a very easy manner, due to this we will move in or out to the other state in a very easy manner Holding the  NREMT certification gives the practice of the national scope.

Holding an NREMT certification does not mean established protocols, Providing prehospital care it gives the EMT certification we do not need to pass any EMT examination for holding the NREMT certification.So  Option(a),Option(b) and Option(d) are incorrect for the prospective point of view of holding an NREMT certification.

A system administrator is selecting an operating system for use by the company’s research and development team. The team requires an OS that can be easily modified and changed to meet its particular requirements. Which of the following operating systems will be the best choice for the users?

A. Windows 10 Enterprise
B. Mac OS X
C. Linux
D. Windows 7 Professional

Answers

Answer:

Linux

Explanation:

Linux is the open source operating system that can be modified at any time as per requirement of the client or user.

Answer:

the correct answer would be linux i believe.

Other Questions
use your____ on poorly lit or rural roads Karl and Pete produce cars and trucks. Karl can produce 10 cars per hour or 5 trucks per hour. Pete can produce 12 cars per hour or 4 trucks per hour.Based on the scenario, Petes opportunity cost of one truck is:a.6 cars.b.4 cars.c.1 1/3 cars.d.3 cars.e.3/4 car. A gas is said to be compressed adiabatically if there is no gain or loss of heat. When such a gas is diatomic (has two atoms per molecule), it satisfies the equation PV1.4 = k, where k is a constant, P is the pressure, and V is the volume. At a given instant, the pressure is 23 kg/cm2, the volume is 35 cm3, and the volume is decreasing at the rate of 4 cm3/min. At what rate is the pressure changing? What equation in slope intercept form represents the line that passes through the two points (5,8) (7,3) The overwhelming majority of U.S. prison guards during the Iraqi War did not engage in abuse, so the reasons for such abuse, when it occurs, don't lie entirely in the __________, but in the __________ of the guards. 4. All vehicles must stop at least ___ ft from the nearest railroad crossing if a signal or flagger is warning of an oncoming train. What were Southern states required to do before applying for readmission to the Union following the Civil War? which of the following farming practices use water most efficiently? select two-tilling soil-planting perennial crops-using drip irrigation -planting annual crops-using sprinklers The Nullification Crisis was caused by which political idea?a.constitutionalismb.checks and balancesc.separation of powersd.states rights One reason Italy and Germany were not major colonial powers in the 16th and 17th centuries was that theybelonged to opposing alliancesrejected the practice of imperialismhad self-sufficient economieslacked political unity A kitten sits in a lightweight basket near the edge of a table. A person accidentally knocks the basket off the table. As the kitten and basket fall, the kitten rolls, turns, kicks, and catches the basket in its claws. The basket lands on the floor with the kitten safely inside. If air resistance is negligible, what is the acceleration of the kitten-basket system while the kitten and basket are in midair? A The acceleration is directed downward with magnitude less than g because the basket is light. B The acceleration is directed downward with magnitude equal to g because the system is a projectile. C The acceleration fluctuates because of the rolling, turning, and kicking motion of the kitten. D The acceleration cannot be determined without knowing how hard the basket is pushed. What is the importance of having standard framework for networking and the evolution of networks? Graph y=1/3x+3 .I just need to know the plots The majority of community hospitals are what type of organization?governmentprivatenonprofitnursing which of these is the most important element in summerizing a supreme court dissent In the Tuskegee syphilis experiment, researchers from the U.S. Public Health Service ____. Which ecosystem has a better chance ofsurviving when environmental conditions changeover a long period of time?a. one with a great deal of genetic diversityB.one with plants and animals but no bacteriaC.one with animals and bacteria but no plantsd. one with little or no genetic diversityooo The local deli charges a fee, f, for delivery. On Monday, they delivered two dozen bagels, b, to an office at a total cost of 58. On Tuesday, three dozen bagels were delivered at a total cost of $11. Which system of equations could be used to find the cost of a dozen bagels? Alice is working on a web page to attract the maximum number of people to join her cause. She wants to inform people about the benefits of adopting eco-friendly methods of living. Which writing style should she use to get visitors to join her cause?A. formal writing styleB. informal writing styleC. standard writing styleD. persuasive writing style#. Which is the standard unit of time in the metric system? Steam Workshop Downloader