40 points

dedylja [7]

In Excel the sum B2 and B6 simply means that B2 and B6 Numbers are adding to get a Sum, it actually like the normal Calculator, but in Excel it helps to do the calculation of your your data simple and easy, there is no hard work.

8 0

2 years ago

Write a C console application that will be used to determine if rectangular packages can fit inside one of a set of spheres. You

MatroZZZ [7]

Answer:

#include <cmath>

#include <iostream>

using namespace std;

int getSphereSize(double length, double breadth, double height) {

double diagonal = sqrt(length * length + breadth * breadth + height * height);

if (diagonal <= 4)

return 4;

if (diagonal <= 6)

return 6;

if (diagonal <= 8)

return 8;

if (diagonal <= 10)

return 10;

if (diagonal <= 12)

return 12;

return 0;

}

int main() {

double length, breadth, height;

int sphereCounts[5] = {0};

int sphereSize;

while (true) {

// Get dimensions of the box

cout << "Enter the dimensions of the box:\n";

cout << "Length: ";

cin >> length;

cout << "Breadth: ";

cin >> breadth;

cout << "Height: ";

cin >> height;

if (length <= 0 || breadth <= 0 || height <= 0)

break;

sphereSize = getSphereSize(length, breadth, height);

if (sphereSize == 0)

cout << "The box cannot fit in any of the spheres";

else

cout << "The box can fit in the " << sphereSize << "-inch sphere";

// Increment the counter

if (sphereSize == 4)

sphereCounts[0]++;

else if (sphereSize == 6)

sphereCounts[1]++;

else if (sphereSize == 8)

sphereCounts[2]++;

else if (sphereSize == 10)

sphereCounts[3]++;

else if (sphereSize == 12)

sphereCounts[4]++;

cout << "\n\n";

}

cout << "\nNumber of 4-inch spheres: " << sphereCounts[0];

cout << "\nNumber of 6-inch spheres: " << sphereCounts[1];

cout << "\nNumber of 8-inch spheres: " << sphereCounts[2];

cout << "\nNumber of 10-inch spheres: " << sphereCounts[3];

cout << "\nNumber of 12-inch spheres: " << sphereCounts[4];

cout << endl;

return 0;

}

Explanation:

The "cmath" library is included in the c++ program. The getSphereSize function is used to return the sphere size the rectangle dimension can fit into. It program continuously prompts the user for the length, breadth, and height of the rectangle and passes the values to the getSphereSize function in the while but breaks if any or all of the variable value is zero.

The sizes of the sphere objects in inches are collected in an array of five integer values of zeros and are incremented by one for every match with a rectangle.

7 0

2 years ago

What are the 49 questions for creat and edit Excel assessment

castortr0y [4]

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.

4 0

2 years ago

A user saves a password on a website the user logs into from a desktop. Under which circumstances will the password be saved on

artcher [175]

Answer:

same encryption certificate

Explanation:

only logical xD

4 0

3 years ago

Which storage device would you most likely use to share a file with a classmate?

valina [46]

You’d probably use a USB Flash Drive.

6 0

3 years ago

Read 2 more answers