1.1 Define what is a Big data and what is loT in detail? ​

Answer:

Explanation:

Answer:

1. What is the keyboard shortcut key to lock cell references in a formula

2. What are the shortcut keys for Auto Sum?

3. What are the shortcut keys to insert a new row in an Excel spreadsheet?

4. What are the shortcut keys to group rows so you can expand/contract a section of data?

5. Which of the following Excel features allows you to select/highlight all cells that are formulas?

6. What are the keyboard shortcut keys to paste special?

7. Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?

8. What are the keyboard shortcut keys to edit formula in a cell?

9. What are the keyboard shortcut keys to insert a table?

10. In which tab of the ribbon can you change Workbook Views to Page Break Preview?

11. What is the best practice for financial modeling in excel?

12. Which of the following features cannot be found in the Data ribbon?

13. The shortcut keys to increase the number of decimal places are

14. What are the shortcut keys to open up the Find and Replace window?

15. Which tab of the ribbon should you go to for removing grid lines on a worksheet?

16. What is a cell address in Excel?

17. What do you mean by Relative cell referencing and Absolute cell referencing in MS Excel?

18. How can you restrict someone from copying a cell from your worksheet?

19. How is a Formula different from a Function in Excel?

20. Mention the order of operations used in Excel while evaluating formulas.

21. What is the difference between count, counta, and countblank?

22. What is the shortcut to add a filter to a table?

23. How can we merge multiple cells text strings in a cell?

24. How many report formats are available in Excel?

25. What is a Pivot Table?

26. How do you find duplicate values in a column?

27. How can you remove duplicate values in a range of cells?

28. What are the wildcards available in Excel?

29. What is Data Validation? Illustrate with an example.

30. How do you create a column in a pivot table?

31. How does a Slicer work in Excel?

32. What are macros in Excel?

33. What is the What-If Analysis in Excel?

34. What is the difference between a function and a subroutine in VBA?

35. What is the difference between This Workbook and Active Workbook in VBA?

36. How do we check whether a file exists or not in a specified location?

37. Write a VBA function to calculate the area of a rectangle.

38. Write a VBA function to check if a number is a prime number or not.

Explanation:

I think these questions are enough for you.

In the network constructed, we need to use 3 switches to  be able to connect a single client PC to the single server. Therefore:

The maximum distance for ethernet connection is known to be about 100 meters and it is one that is often used in the transmission speeds.

Note that when one has added to the network switches, the distance need to be increased to about 200 meters and thus about 900 meters of distance need to exist between the client PC and the server.

The Ethernet network need to be designed as:

Connect server to switch 1        (225 m)

Connect switch 1 to switch 2     (225 m)

Connect switch 2 to switch 3    (225 m)

Connect switch 3 to client PC   (225 m)

Note that Total distance covered = 225 + 225 + 225 + 225

                                                       = 900 meters

Therefore, In the network constructed, we need to use 3 switches to  be able to connect a single client PC to the single server.

Learn more about Ethernet from

https://brainly.com/question/16947988

#SPJ1

Answer:

"

for author in authors:

   print(author)

"

Explanation:

So, to go through a list, you simply use a for loop as such:

"

for element in list:

   # code

"

For each iteration, the current element value will be assigned to the variable "element" in the code, and the code in the for loop will run as well.

So to print out each author in the list, you simply do:

"

for author in authors:

   print(author)

"

Also it doesn't matter what I put in between the "for" and "in", it can be any variable name, although I would have to change the "print(author)" so that it prints that variable. The only restrictions you have on this, is that variable names cannot be keywords like "in", "for", "pass", "def", etc...

Answer:

This is one of the most common causes of paper jams. Loading paper that is stuck together, frayed, curled or bent can cause a jam. Overloading the paper tray, loading different thicknesses of paper in the tray or using paper that isn't appropriate for your particular printer can all result in a jammed printer.

An action which takes place in the Define step of the game development cycle is: C. determining the goals of the game.

GDLC is an acronym for game development life cycle and it can be defined as a strategic methodology that defines the key steps, phases, or stages that are associated with the design, development and implementation of high quality gaming software programs (applications).

In Computer science, there are seven (7) phases involved in the development of a gaming software program and these include the following;

In this context, we can infer and logically deduce that determining the goals of the game is an action which takes place in the Define step of the game development cycle.

Read more on software here: brainly.com/question/26324021

#SPJ1

Which action takes place in the Deploy stop of the game development cycle?

Answer: is D. Releasing the game and collecting feedback from users

Since the user wants to visualize a highly complex 3D model using a Virtual Reality headset, the best way for the user to do this is to connect a tethered headset to a very powerful PC.

VR headsets is known to be one that is found or is one that do replace the human's or user's natural environment with that of a virtual reality content, e.g. a movie, a game or what we call a kind of a prerecorded 360-degree VR environment.

Note that this is one that often allows the user to be able to turn and also look around, just like the person is in the physical world.

Hence, Since the user wants to visualize a highly complex 3D model using a Virtual Reality headset, the best way for the user to do this is to connect a tethered headset to a very powerful PC.

Learn more about Virtual Reality from

https://brainly.com/question/26705841

#SPJ1

Using the knowledge in computational language in JAVA it is possible to write a code that Design a class Dog, making sure it is appropriately encapsulated

public class Dog {

private String Name,Breed;

public Dog(String N,String B)

{

SetName(N);

SetBreed(B);

}

private String FirstCapitalLetter(String N)

{

String first = N.substring(0, 1);

String second = N.substring(1);

first = first.toUpperCase();

String finalStr = first + second;

return finalStr;

}

public Dog()

{

}

public void SetName(String N)

{

this.Name = FirstCapitalLetter(N);

}

public void SetBreed(String B)

{

this.Breed = FirstCapitalLetter(B);

}

public String getName()

{

return this.Name;

}

public String getBreed()

{

return this.Breed;

}

public static void main(String[] args) {

Dog MyObj = new Dog("tommy","zebraDog");

System.out.println(MyObj.getName()+" "+MyObj.getBreed());

}

}

See more about JAVA at brainly.com/question/12975450

#SPJ1

The risk of using you mobile cell phone or external WLAN as a wi-fi connection point is that  it is one that do lacks the right security measures to be able to keep the network safe from intrusion.

The Risks of a Public Wi-fi is that a free Wi-Fi security is one that helps a any hacker to be able to put or position themselves between the user and the connection point.

Note that in this case, the user instead of they talking directly with the hotspot, they are known to be sending their information to the hacker, who is said to often relays it on.

Hence, The risk of using you mobile cell phone or external WLAN as a wi-fi connection point is that  it is one that do lacks the right security measures to be able to keep the network safe from intrusion.

Learn more about WLAN from

https://brainly.com/question/26956118

#SPJ1

The statement about broadcasting a slideshow online that is true is D. PowerPoint has a free, built-in service for broadcasting online.

This refers to the presentation feature in a presentation-based system or software that makes use of images, and diagrams moving sequentially in a pre-timed manner.

Hence, we can see that based on the broadcast of slideshows online, one can see that the true statement from the list of options is option D which states that PowerPoint has a free, built-in service for broadcasting online.

Read more about slideshows here:

https://brainly.com/question/23427121

#SPJ1

Answer:

it may be linear gradient.

Answer:try to change the name of the file not adding any symbols not accepted as file, or try to change the destination of the file, ex. an external usb. Or double check if the destination folder is not full.

Explanation:

errors when saving may occur because of the above

The Summary fields helps to calculates values that are obtained from the related records, such as those that can be found in a related list.

A roll-up summary field is known to be that field of work that helps one to be able to calculates values that are gotten from related records, such as those seen in a related list.

Note that via this field, one can be able to  form a roll-up summary field to show a value in the case of a master record based that is seen on the values of fields found in a detail record.

Note that The detail record need to be associated to the master via a master-detail relationship.

Hence,  The Summary fields helps to calculates values that are obtained from the related records, such as those that can be found in a related list.

Learn more about Summary fields from

https://brainly.com/question/14362737

#SPJ1

By trying the moves and decisions that players of the game will be unlikely to make is a good strategy for debugging a game so the answer is option A : Yes, because making unexpected moves is likely to test the game's limits.

Debugging as defined in computer programming  is known to be a kind of a  multistep procedure which involves the act of knowing a problem, and also isolating the origin of the problem, and lastly one can correct the issue or know a way to work around the issue.

Note that the last step of debugging is to test the correction that was made or one can  workaround and make sure that it works or functions well.

Hence, By trying the moves and decisions that players of the game will be unlikely to make is a good strategy for debugging a game so the answer is option A : Yes, because making unexpected moves is likely to test the game's limits.

Learn more about debug  from

https://brainly.com/question/15079851

#SPJ1

Answer:

class Book:
   def __init__(self, book_title, book_author, book_publisher):

       self.__book_title = book_title

       self.__book_author = book_author

       self.__book_publisher = book_publisher

Explanation:

Python kind of haves private data attributes, although technically they don't.

Take for example the following code:

"

class A:

   def __init__(self):

       self.__privateAttribute = 0

x = A()

print(x.__privateAttribute)

"

all this really does is rename the variable name, and if you run the following code:

print(dir(x))

it will print the attributes of "x" which include "_A__privateAttribute" which is the attribute that was initialized.

Anyways getting that out of the way, you need to now about the __init__ method, which runs each time you initialize a new instance of the class. It's a way of setting up some necessary values that will be used in the objects methods (the functions inside the class)

So, because we simply cannot know what the book_title, book_author, and book_publisher are (since they vary book to book...), we take them as arguments using the __init__ method, and then initialize their values in their.

"

class Book:
   def __init__(self, book_title, book_author, book_publisher):

       self.__book_title = book_title

       self.__book_author = book_author

       self.__book_publisher = book_publisher

"

I just realized I completely forgot to even mention what the "self" variable stands for. Whenever you initialize a variable, or call a method from an instance of the class, the first argument passed will be the instance of the class. Take for example the following class

"

class A:

   def __init__(self, b):
       self.b = b

   def printB(self):
       print(self.b)

def printB(self):

   print(self.b)

c = A(3)

d = A(4)

c.printB()

printB(c)

d.printB()

printB(d)

"

The two lines

c.printB() and printB(c) are the same exact thing, the only difference is when you call c.printB(), you automatically pass the "c" as the first argument, and the same thing for d.printD(), it's implicitly passed whenever you call a method from an instance of the class.

Answer:

Shor's algorithm is a quantum computer algorithm for finding the prime factors of an integer. It was developed in 1994 by the American mathematician Peter Shor. . The efficiency of Shor's algorithm is due to the efficiency of the quantum Fourier transform, and modular exponentiation by repeated squaring.

Answer:

 <link rel="stylesheet" href="exam.css">

Explanation:

href is the file name assuming its in the same path

also get an extension called grepper, it helps debug a lot quicker

Answer:

<link rel="stylesheet" href="exam.css">

Explanation:

Answer:

With 0.5,0.7,0.9 drivers

Answer:

search your question in gogle

Answer:277E

Explanation:

The graphic representation below will clarify how it unfolded.

Answer:

Explanation:

Referential integrity is the state in which all values of all foreign keys are valid. Referential integrity is based on entity integrity . Entity integrity requires that each entity have a unique key.

Hope this helped and have a good day

The turtle module that prints "HELLO" in python programming is given below:

# Python program to

# demonstrate printing HELLO

# using turtle

# Here frame is initialized with

# background colour as "White"

import turtle

frame = turtle.Screen().bgcolor("White")

draw = turtle.Turtle()

# The colour, width and speed of the pen is initialized

draw.color("Green")

draw.width(3)

draw.speed(10)

# Now lets get started with actual code

# printing letter H

draw.left(90)

draw.forward(70)

draw.penup()

draw.goto(0, 35)

draw.pendown()

draw.right(90)

draw.forward(30)

draw.penup()

draw.goto(30, 70)

draw.pendown()

draw.right(90)

draw.forward(70)

# printing letter E

draw.penup()

draw.goto(40, 0)

draw.pendown()

draw.right(180)

draw.forward(70)

draw.right(90)

draw.forward(35)

draw.penup()

draw.goto(40, 35)

draw.pendown()

draw.forward(35)

draw.penup()

draw.goto(40, 0)

draw.pendown()

draw.forward(35)

# printing letter L

draw.penup()

draw.goto(90, 70)

draw.pendown()

draw.right(90)

draw.forward(70)

draw.left(90)

draw.forward(35)

# printing letter L

draw.penup()

draw.goto(135, 70)

draw.pendown()

draw.right(90)

draw.forward(70)

draw.left(90)

draw.forward(35)

# printing letter O

draw.penup()

draw.goto(210, 70)

draw.pendown()

for i in range(25):

   draw.right(15)

   draw.forward(10)

Read more about python programming here:

https://brainly.com/question/26497128

#SPJ1

Answer:

Website: a set of related web pages located under a single domain name, typically produced by a single person or organization

Webpage: a hypertext document on the World Wide Web

The term “web site” is commonly used to describe a collection of web pages and related content published simultaneously on at least one server and identified by a common domain name. A web site is a collection of many web pages that are linked together under the domain name of the same company.

Web pages are a type of hypertext document which can be found on the World Wide Web. In a web browser, a user can view a web page that has been delivered by a web server to their computer. It is the name “web page” itself that is a metaphor for the binding of paper pages together to make a book.

Hope this helps :)

Answer: Application straming

Explanation: Thats what Quiznet says.

There are four main parts that make up a cellular communication system: mobile subscriber units (MSUs), public switched telephone network (PSTN), and mobile telephone switching office (MTSO) (MSU).

No direct mobile to mobile communication exists; all communication takes place between a mobile and a base station. Within each base station's cell, which is a specific geographical area, there is a dedicated set of radio channels or frequencies.

These networks are becoming used for purposes other than entertainment and phone calls as cellular devices become more and more common.

Cellular networks are high-speed, high-capacity voice and data communication networks that can handle cellular devices and have increased multimedia and seamless roaming capabilities.

Therefore, The ability of a cellular network to reuse frequencies to boost capacity and coverage is its major feature.

Learn more about cellular network here:

https://brainly.com/question/27960045

#SPJ2

Answer:

using System;

class Program

{

   public static void Main(string[] args)

   {

       Random rnd = new Random();

       int tries = 0;

       while (true)

       {

           tries++;

           Console.Write("What do you think the total of two six-sided die will be? ");

           int guess = int.Parse(Console.ReadLine());

           int total = rnd.Next(1, 7) + rnd.Next(1, 7);

           Console.Write($"The total was {total}. ");

           if (total == guess)

           {

               Console.WriteLine($"Congratulations! It took you {tries} tries to guess successfully.");

               break;

           }

           else

           {

               Console.WriteLine("Try again!");

           }

       }

   }

}

Explanation:

Worst case you could be guessing forever...

One can structure of a table change in sql and the general types of changes that are possible is that:

The SQL ALTER TABLE command is known to be the tool that is often used to alter the structure of an existing table.

Note that it is one that can helps to add or delete columns, make or destroy indexes, alter the type of existing columns, and others.

Hence, One can structure of a table change in sql and the general types of changes that are possible is that:

Learn more about table structure from

brainly.com/question/26125587

#SPJ1

The type of malware that is best known for carrying other malware as a payload is a Trojan.

A Trojan, short for Trojan horse, is a type of malicious software that disguises itself as a legitimate program or file to trick users into downloading and executing it. Once inside a system, a Trojan can carry out various malicious activities, including delivering other forms of malware, such as viruses, worms, ransomware, spyware, or botnets.

Trojans often act as a delivery mechanism, allowing other malware to be covertly installed on the infected system without the user's knowledge. They may exploit system vulnerabilities, social engineering techniques, or disguise themselves as seemingly harmless files, making it challenging for users to detect their malicious intent.

To protect against Trojans and other malware, it's essential to practice safe browsing habits, keep software and security patches up to date, use reputable antivirus/antimalware software, and exercise caution when downloading files or clicking on links from untrusted sources.

Learn more about Trojans here:

https://brainly.com/question/32506022

#SPJ3