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

Many of the special staff teams require leadership training, which is offered to staff with more than 1 year of service at Camp

Sveta_85 [38]

Answer:

The answer to this question can be defined as follows:

Explanation:

In the given question attachment file is missing so, following the code to this question:

using function IF:

=IF(Logical test, how to do it when testing is right, how to do it when testing is wrong)

In this scenario, a leader development Worker should pass 2 tests

In the First test may not finish his training

If yes-" satisfied"

It is not true, it will go to 2nd test

In the second test, If employee served a service period of even more than 1 year (to be performed in a first check if not correct)

If, It is yes=" yes" else not ="No"

= IF(Leader Training = Yes, "Completed," IF(Service time> 1," Yes ","No")

That's means,

The sort IF(I2 = "Yes","Completed"),IF(D2>1," Yes","No") must be used in cell M2)

Copy Cell M2 Then the selected M3 over M30

8 0

3 years ago

Dynamically allocatе mеmory for a DNA objеct and storе its addrеss in a variablе namеd dnaPtr

borishaifa [10]

Answer:

DNA obj =new DNA;//obj object created dynamically.

DNA *dnaPtr=&obj.//dnaPtr to store the address of the object.

Explanation:

The above written statements are in C++.The DNA object is created dynamically and it is done in C++ by using new keyword which allocates the heap memory for the object.

Then a dnaPtr is created of type DNA so that it can store the address of the DNA objects.

4 0

3 years ago

Your computer uses 4 bits to represent decimal numbers (0, 1, 2, 3 and so on) in binary. What is the SMALLEST number

lord [1]

Answer:

Explanation:

I believe this is because you cannot represent the number sixteen with only four binary bits. The highest you can go is 15.

8 0

3 years ago

Write a date transformer program using an if/elif/else statement to transform a numeric date in month/day format to an expanded

boyakko [2]

I wrote it in Python because it was quick so i hope this is helpful

Answer:

date = input('Enter Date: ')

split_date = date.split('/')

month = split_date[0]

day = split_date[1]

if month == '1':

english_month = 'January'

spanish_month = 'Enero'

elif month == '2':

english_month = 'February'

spanish_month = 'Febrero'

elif month == '3':

english_month = 'March'

spanish_month = 'Marzo'

elif month == '4':

english_month = 'April'

spanish_month = 'Abril'

elif month == '5':

english_month = 'May'

spanish_month = 'Mayo'

elif month == '6':

english_month = 'June'

spanish_month = 'Junio'

elif month == '7':

english_month = 'July'

spanish_month = 'Julio'

elif month == '8':

english_month = 'August'

spanish_month = 'Agosto'

elif month == '9':

english_month = 'September'

spanish_month = 'Septiembre'

elif month == '10':

english_month = 'October'

spanish_month = 'Octubre'

elif month == '11':

english_month = 'November'

spanish_month = 'Noviembre'

elif month == '12':

english_month = 'December'

spanish_month = 'Diciembre'

US_English = f'{english_month} {day}'

International_Spanish = f'{day} {spanish_month}'

print(f'US English Form: {US_English}')

print(f'International Spanish Form: {International_Spanish}')

Input:

3/5

Output:

US English Form: March 5

International Spanish Form: 5 Marzo

Explanation:

You start by taking input from the user then splitting that at the '/' so that we have the date and the month in separate variables. Then we have an if statement checking to see what month is given and when the month is detected it sets a Spanish variable and an English variable then prints it to the screen.

Hope this helps.

7 0

3 years ago

A microphone is a type of electronic.<br><br> True/Faulse

GenaCL600 [577]

Yes, True, a microphone IS a type of electronic

4 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