free online excel courses with certificate ms excel free.



Posted by Sh@msh.in on June 26th, 2023

free online excel courses with certificate ms excel free

free online excel courses with certificate ms excel Free Gate 100% FREE ms Excel Online Certificate. free online excel courses with certificate ms excel free. Intellipaat free online MS Excel Complete Course. Course Details:


About the MS Excel Online Course:-


The 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 etc.,

Details>free online excel courses with certificate ms excel free

Details about the course;-


15 hours of self paced learning

Quizzes & Assignments

Lifetime Access

Enroll now & 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

Certificate :





MS Excel Quiz Model Question & Answers:-

free online excel courses with certificate ms excel free
A Cell is a?
Ans:-area where columns and rows intersect
A column is?
Ans:- vertical and designated by a letter

A row is?
Ans:- horizontal and designated by a number
How are rows designated?
Ans:- Numbers

How are columns designated?
Ans:- Latters
A set of buttons to carry out common commands, such as opening a file, printing, cut, copy paste?
Ans:- Standard Tool bar

Which file name extension is used for Excel workbooks?
Ans:- .xls
If A1=30, A2=20, I want to multiply these two cells and show output in C6. Which formula should i use?
Ans:- Write in cell C6, = A1*A2

Which direction do columns run in a spread sheet?
Ans:- Vertical
A Spread Sheet is a?
Ans:- grid ade of columns and rows

Which of these would add up the numbers from A3 to A6?
Ans:- -Sum(A3:A6)
I want to add cells value from C5 to C70, and show out put of this addition in cell A3, Which formula should i use?
Ans:- Write in Cell A3,=SUM(CS:C70)

In a spread sheet formula which symbol is used to multiply?
Ans:- *
Which one of the following is a spread sheet application?
Ans:- Microsoft Excel

What is the name of the area within a worksheet that is current, or ready to receive information?
Ans:- Active Cell
A List of pull-down menus for doing most functions in an application?
Ans:- menu bar

Contains the name of the application and the document name? Market An
Ans:- Title Bar
Place where data, text, or equations are entered into a cell7
Ans:- Formula Bar

Lists the address of the active cell?
Ans:- Name Box
Which direction do rows run in a spread sheet?
Ans:- Horizontal

To copy the formatting of one cell to another you would use the?
Ans:- Format Painter
What is the name given to the intersection of a row and a column in a spreadsheet?
Ans:- Cell

What is the name given to the bar that allows you to enter values and perform calculations in spreadsheet?
Ans:- Formula Bar
A forluma in the spreadsheet should always start with?
Ans:- An equals sign

In a spreadsheet formula which symbol is used to divide?
Ans:- /
The cell where data will be entered?
Ans:- Active Cell

free online excel courses with certificate ms excel free.