This Microsoft Excel Foundation training course will provide you with the most thorough understanding of MS Excel, the most extensively used spreadsheet. This course will teach you how to use Excel to create workbooks, tables, and cells, as well as how to create dashboards, interactive components, charting, filtering, sorting, and the PIVOT Table, as well as how to process data with real-world data sets

About the Course

Our Microsoft Excel Foundation training course gives you the most comprehensive insight into the most widely used spreadsheet, MS Excel. This course would help you learn Excel workbook, tables, cells, creating dashboard, interactive components, charting, filtering, sorting, PIVOT Table and data processing with real-world data sets.

MS Excel Complete Course

This self-paced course will help you hone your skills in MS Excel

This MS Excel course will help you acquire a comprehensive understanding of MS Excel as a tool and explore its numerous features and functions like sort, filter, import, etc. You will be able to make use of MS Excel for the tracking and management of data-driven projects, which is essential in the IT industry.

This course includes:

• 15 Hours of self paced learning
• Quizzes and Assignments
• Lifetime Access
• Enroll now and get certified

MS Excel skills you will learn

Data Sorting

Data Filtering

Chart Creation

Various Techniques of Charting

Pivot Tables in Excel

IF condition

Data Analysis

Charting

Logical Functions

Dashboards

Apply Link

Ms Excel Test Answers ( 100% Correct Answers Here) 

1. How are rows designated?

Numbers

2. A cell is a ?

area where columns and rows intersect

3. A set of buttons to carry out common commands, such as opening a file, printing, cut,copy, paste, etc.

Standard Toolbar

4. Which filename extension is used for Excel workbooks?

.xls

5. If A1=30, A2 = 20, I want to multiply these two cells and show output in C6. Which formula should I use?

Write in cell C6, =A1*A2

6. Which direction do columns run in a spreadsheet?

Vertical

7. A spreadsheet is a ?

grid made of columns and rows

8. Which of these would add up the numbers from A3 to A6?

-Sum(A3:A6)

9. I want to add cells value from C5 to C70, and show output of this addition in cell A3. Which formula should I use?

Write in Cell A3, =SUM(CS:C70)

10. In a spreadsheet formula which symbol is used to multiply?

*

Quiz Competition International Yoga Day : Click Here

 

11. Which one of the following is a spreadsheet application?

Microsoft Excel

12. What is the name of the area within a worksheet that is current, or ready to receive information?

Active Cell

13. A list of pull-down menus for doing most functions in an application?

menu bar

14. Contains the name of the application and the document name? Market An

Title Bar

15. Place where data, text, or equations are entered into a cell 7

Formula Bar

16. Lists the address of the active cell?

Name Box

17. Which direction do rows run in a spreadsheet?

Horizontal

18. To copy the formatting of one cell to another you would use the ?

Format Painter

19. What is the name given to the intersection of a row and a column in a spreadsheet?

Cell

20. What is the name given to the bar that allows you to enter values and perform calculations in a spreadsheet?

Formula bar

21. A row is?

horizontal and designated by a number

22. A formula in the spreadsheet should always start with?

An equals sign

23. In a spreadsheet formula which symbol is used to divide?

/

24. The cell where data will be entered?

Active Cell

25. How are columns designated?

Letters

26. A column is?

vertical and designated by a letter