All categories

2 years ago

What are the 49 questions for creat and edit Excel assessment

Computers and Technology

1 answer:

castortr0y [4]2 years ago

4 0

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.

You might be interested in

Write statements that output variable numComputers as follows. End with a newline

gavmur [86]

Complete Question:

Write statements that output variable numComputers as follows. End with a newline. There are 10 computers.

#include <iostream>

using namespace std;

int main()

{

int numComputers;

cin >> numComputers; // Program will be tested with values: 10.

...

return 0;

}

Answer:

cout << "There are ";

cout << numComputers;

cout << " computers." << "\n";

Explanation:

Using three cout statements the string "There are 10 computers." is printed out, notice that the variable numComputers is entered by the user when the program is run. Another way of concatenating an integer variable and string for printout is by the use of the + (plus) operator.

8 0

2 years ago

: Compute the 9 partial derivatives for the network with two inputs, two neurons in

lions [1.4K]

Using the python code we can say that it will be possible to calculate the neutrons and organize them as:

<h3>The code can be written as:</h3>

def get_total_derivative(self,l_id):

def sigmoid(x, div = 0):

if div == 1:

return np.exp(-x) / (1. + np.exp(-x))**2.

if div == 2:

return - np.exp(x) * (np.exp(x) - 1) / (1. + np.exp(x))**3.

return 1. / (1. + np.exp(-x))

def linear(x, div = 0):

if div == 1:

return np.full(x.shape,1)

if div > 2:

return np.zeros(x.shape)

return x

See more about python at brainly.com/question/18502436

#SPJ1

8 0

2 years ago

#Write a function called "scramble" that accepts a string #as an argument and returns a new string. The new string #should start

mojhsa [17]

Answer:

def scramble(s):

if len(s) % 2 == 1:

index = int(len(s)//2)

else:

index = int(len(s)/2)

return s[index:] + s[:index]

Explanation:

Create a function called scramble that takes one parameter, s

Check the length of the s using len function. If the length is odd, set the index as the floor of the length/2. Otherwise, set the index as length/2. Use index value to slice the s as two halves

Return the second half of the s and the second half of the s using slice notation (s[index:] represents the characters from half of the s to the end, s[:index] represents the characters from begining to the half of the s)

8 0

3 years ago

An internal _____ refers to a specific representation of an internal model, using the database constructs supported by the chose

boyakko [2]

Answer:

An internal schema

Explanation:

The internal schema refers to the physical storage structure of database.
It refers to the lowest level of abstraction.
This is also called physical schema.
It contains multiple instances of multiple internal records.
It provides information about the representation of the whole database that what data is stored in DB and in what form e.g the data is stored in the records form on the disk.
This schema gives detailed description of internal model which involves storage structure of the database, representation and classification of stored data. This format of data is only understandable by the Database management system.

7 0

3 years ago

can someone please help me with my school work you can look under my questions please help me my mom is going to kill me when s

Snezhnost [94]

Answer:

hey panda I'm doing good how about you

5 0

3 years ago

What are the 49 questions for creat and edit Excel assessment​

What are the 49 questions for creat and edit Excel assessment