Skip to Content

Home
About Us
Professional Training
Courses
Teens Advantage
Recruitment Service
Forum
Events

⁰
Sign in
Contact Us

⁰

Home
About Us
Professional Training
Courses
Teens Advantage
Recruitment Service
Forum
Events

Sign in
Contact Us

Courses
Intro. to Microsoft Excel - Course 2
Module 2 - Excel Essentials

Nav

Home └Intro. to Microsoft Excel - Course 2 └Module 2 - Excel Essentials

Intro. to Microsoft Excel - Course 2

0 %

Completed

Course content

Course Materials
- Course Materials
Module 0
- Module 0- Introduction
Module 1
- Module 1 - Excel Fundamentals 10 xp
  - Quiz
Module 2
- Module 2 - Excel Essentials 10 xp
  - Quiz
Module 3
- Module 3 - Excel Formulas 10 xp
  - Quiz
Module 4
- Introduction to Excel Functions
- Date and Time Function
- Text Function
- Maths and Conditional Aggregate Function
- Statistics
- Logical Function
- Lookup Function
- Quiz 10 xp
Module 5
- Module 5 - Analysis Data with Pivot Tables 10 xp
  - Quiz
Module 6
- Module 6 - Creating Charts 10 xp
  - Quiz
Assignment -Lab
- Assignment Lab

Module 2 - Excel Essentials

10 XP

Fullscreen Share

About
Comments (0)

Rating

0 0

There are no comments for now.

Join this Course

to be the first to leave a comment.

1. What does the "Fill Handle" do in Excel?

A) Fills cells with data from the clipboard B) Copies data into cells by dragging C) Deletes the contents of selected cells D) Replaces text in a cell

2. Which of the following is a feature of AutoFill in Excel?

A) Automatically fills in dates and numbers in a series B) Automatically formats text in bold C) Automatically resizes columns D) Automatically adds formulas to cells

3. What is a "Custom AutoFill List"?

A) A list of predefined Excel functions B) A series of numbers added manually C) A list of items Excel can automatically fill based on user-defined entries D) A tool for sorting data in Excel

4. What is "Transposing" in Excel?

A) Moving rows and columns in a worksheet B) Changing cell references C) Changing the formatting of cells D) Switching rows and columns in a selection

5. Which of these is NOT a type of conditional formatting in Excel?

A) Data Bars B) Icon Sets C) Color Scales D) Text Effects

6. How can you sort data in a range in Excel?

A) By using the Filter button B) By using the Sort option under the Data menu C) By manually rearranging the cells D) By using the Fill Handle

Additional Resources

Join this Course to access resources

Useful Links

Home
About us
Products
Services
Privacy Policy
Contact us

About us

We are a team of passionate people whose goal is to improve everyone's life through disruptive products. We build great products to solve your business problems.

Our products are designed for small to medium size companies willing to optimize their performance.

Connect with us

Contact us
info@scholarsdna.com
+234 (704) 110-0009

Follow us

Copyright © ScholarsDNA

Powered by

- The #1 Open Source eCommerce

We use cookies to provide you a better user experience on this website. Cookie Policy

Only essentials I agree