Free Online Course on Microsoft Excel with Certificate

/ Edu Courses / By
Online Course on Microsoft Excel Certificate

Organizer: Educourse Online Learning.

About the Course

  • Topic: Free Online Course on Microsoft Excel with Certificate
  • 100% Free Course
  • Mode: Online
  • Open to All
  • Own PC/Laptop for hands-on training
  • Level: Beginner
  • Language: English
  • Minimum 80% Passed the Exam Every Lesson
  • Completion of assignments
  • Submission of mini project
  • Certificate of All Participation

Course on Microsoft Excel Content:

  1. Getting to know Excel
  2. Working with Cells
  3. Modifying Columns, Rows, and Cells
  4. Formatting Cell
  5. Understanding Number format in Excel
  6. Using Find & Replace
  7. Formulas and Functions
  8. Most Used Functions

Professional Skills Developed:

This course develops practical, workplace-ready spreadsheet and data-management skills. Learners will gain competencies in:

  • Creating, editing, and structuring spreadsheets.
  • Formatting cells, columns, rows, and number types.
  • Using formulas and functions for accurate calculations.
  • Applying data-organisation techniques for clarity and efficiency.
  • Managing worksheets, workbooks, and structured datasets.
  • Using tools like Find & Replace, AutoFill, and sorting functions.
  • Understanding common Excel functions for business use.
  • Presenting data in a clean, readable format.

Apply Link

100% Correct Answers Online Course on Microsoft Excel Here

Microsoft Excel Certificate Course 1. Getting to know Excel Getting to know Excel – Quiz

To show the Ribbon, click the _ command at the top of screen.
Commands
Options
Expand Ribbon
Quick Access
ans. Expand Ribbon ✅

You can adjust how the Ribbon is displayed with the _.
Quick Access Toolbar
OneDrive
Workbooks
Ribbon Display Options
ans. Ribbon Display Options ✅

Located just above the Ribbon, the _ lets you access common commands no matter which tab is selected
Quick Access Toolbar
Page
Layout
Save As
ans. Quick Access Toolbar ✅

True or false? Normal view is the default view for all worksheets in Excel.
True
False
ans. True

_: You’ll use this command to create a copy of a workbook while keeping the original.
Save As
Lesson
Layout
Page Layout
ans. Save As ✅

Excel files are called _
Ribbon
Workbooks
Quick Access Toolbar
Microsoft Files
ans. Workbooks ✅

If you’ve opened the desired workbook recently, you can browse your _ rather than search for the file.
Recent Workbooks
Workbooks
Blank Workbook
ans. Recent Workbooks

If you’re saving the file for the first time, the _ pane will appear in Backstage view.
Save As
Undo
Click
Sharing Workbooks
ans. Save As ✅

Microsoft Excel Certificate Course 2. Working with Cells Working With Cells – Quiz

True or false? Cells are not apart of the Excel worksheet.
False
True
ans. False

Every worksheet is made up of thousands of rectangles, which are called _.
Pixels
Cubes
Cells
ans. Cells ✅

True or false? There is an important difference between deleting the content of a cell and deleting the cell itself.
True
False
ans. True ✅

What type of data can each cell contain?
Text
Formatting
Formulas
Functions
ans. Text, Formulas, Functions.

List a few ways that you can put content into a cell
Copy & Paste
Cut & Paste
Drag & Drop
Cut & Drop
ans. Copy & Paste, Cut & Paste, Drag & Drop

Microsoft Excel Certificate Course 3. Modifying Columns, Rows, and Cells Modifying Columns, Rows, and Cells – Quiz

When you open a new, blank workbook, the cells are set to ?
A new size
Default size
Previous size
ans. Default size ✅

What command do you have to click to modify columns ?
Column width
Home Tab
Format
ans. Format ✅

If a cell contains more text than can be displayed what can you choose to do ?
Wrap Text
Reassemble Text
Unify Cell
Type into a new cell
ans. Wrap Text ✅

A group of cells is known as _.
A cell range
A group of cells
Cells
ans. A cell range ✅

Microsoft Excel Certificate Course 4. Formatting Cell Formatting Cell – Quiz

Single Choice. You can also use the _ and Decrease Font Size commands or enter a custom font size using your keyboard.
Font Color
Increase Font Size
Bold
Cell Styles
ans. Increase Font Size ✅

Single Choice. You can also use the Increase Font Size and _ commands or enter a custom font size using your keyboard
Decrease Font Size
Click
Calibri
Century Gothic
ans. Decrease Font Size ✅

Single choice. Along with Calibri, standard reading fonts include Cambria, _, and Arial.
Copy/Paste
Excel
Times New Roman
Decrease Font Size
ans. Times New Roman ✅

Single choice. Click the _ command on the Hometab, then choose the desired style from the drop-down menu
Bold
Font
Increase Font Size
Cell Styles
ans. Cell Styles ✅

Microsoft Excel Certificate Course 5. Understanding Number format in Excel Number Format – Quiz

true or false? a number format is a special code to control how a value is displayed in excel.
True
False
ans. True. ✅

Single choice. Below this menu to the right, there is small button to access all number formats, including custom formats: This button opens the _ dialog box.
Input Code
Format Cells
Percentage
Excel
ans. Format Cells ✅

Single choice. You can select standard number formats (General, Number, Currency, Accounting, _, Long Date, Time, Percentage, Fraction, Scientific, Text) on the home tab of the ribbon using the Number Format menu.
Charts
Short Date
Input Code
Excel Format
ans. Short Date ✅

Single choice. You can select standard _____s (General, Number, Currency, Accounting, Short Date, Long Date, Time, Percentage, Fraction, Scientific, Text) on the home tab of the ribbon.
Number Format
Alphabetical Format
Descending Format
Ascending Format
ans. Number Format ✅

Microsoft Excel Certificate Course 6. Using Find & Replace Using Find and Replace – Quiz

Single choice. Generally, it’s best to avoid using _____because it doesn’t give you the option of skipping anything you don’t want to change.
Click
Close
Excel
Replace All
ans. Replace All ✅

Single choice. Click _ to find further instances or Find All to see every instance of the search term
Find Next
Find Each
Find One
Find and Replace
ans. Find Next ✅

Single choice. Choosing __ will replace individual instances, while Replace All will replace every instance of the text throughout the workbook.
Click
Find
Replace
Excel
ans. Replace ✅

Microsoft Excel Certificate Course 7. Formulas and Functions Formulas and Functions – Quiz

True or False? A formula is an expression which calculates the value of a cell.
False
True
ans. True ✅

True or False? Functions are undefined formulas and are already available in Excel.
True
False
ans. False

If a part of the formula is in parentheses, what is the process in which it will be calculated ?
It won’t be calculated
It will be calculated last
It will be calculated first
ans. It will be calculated first ✅

What will every function have ?
Different structures
Same structure
No Structure
ans. Same structure ✅

Microsoft Excel Certificate Course 8. Most Used Functions Most used Functions – Quiz

Single choice. Use INDEX and MATCH to perform a two-column _.
SUM
Function
Lookup
ans. Lookup ✅

Single choice. To find the _ value, use the MIN function.
Maximum
Minimum
Match
ans. Minimum ✅

Single choice. To calculate the sum of the products of corresponding numbers in one or more ranges, use Excel’s powerful .
VLOOKUP Function
COUNTIF Function
SUMPRODUCT Function
ans. SUMPRODUCT Function ✅

Single choice. Use INDEX and _ in Excel to perform advanced lookups.
SUM
VLOOKUP
MATCH
ans. MATCH ✅

Scroll to Top