free online excel courses with certificate ms excel free
Get 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
Click to Apply FREE ms Excel Course
.
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
Share this to your Friends
See the channel for All Details in Telugu;-
.
.
.
.
.
For More Govt Jobs Click;- www.shamsh.in,
Engineering Govt Jobs in India,
Government Jobs for Engineering Students,
Polytechnic Diploma Govt Jobs,
Click for State / Central Govt Jobs,
free online excel courses with certificate ms excel free
Please Leave your Comment below / Ask doubts ? / Suggestions
Posted in 
Tags: 
