Module 2: Entering and Editing Data- text, values, formulas, saving
Module 3: Worksheet modification and editing: Moving and copying data, formula. References (absolute versus relative. Editing ranges, rows, and columns
Module 4: Functions – how to use them eg AutoSum
Module 5: Text, number and row formatting (including conditional)
Module 6: Basic Charts and how to format them
Module 7: Graphics, pictures, smartgraphics
Module 8: Printing worksheets
Course duration and fees: Ms Office Excel Beginners 2013 Training Course
Our two day training course is designed so that the knowledge acquired is applied practically, so that the business environment can be enhanced.
Please consult schedule for course costs or contact BOTI for a quote.
Recommended Prior Experience and Knowledge: Ms Office Excel Beginners 2013 Training Course
The course (Ms Office Excel Beginners 2013 Training Course) is designed for the following attendees:
This is aimed at delegates who wish to acquire the knowledge necessary to, edit, create and print and format basic worksheets within Microsoft Office Excel.
For the Ms Office Excel Beginners 2013 Training Course it is advisable that you have the following experience/knowledge:
Basic or equivalent experience in Windows 7.
Excel Essentials Quiz
Time limit: 0
Quiz-summary
0 of 10 questions completed
Questions:
1
2
3
4
5
6
7
8
9
10
Information
You must specify a text.
You must specify a text.
You must specify a text.
You must specify a number.
You must fill out this field.
Free test of your Excel Essentials Knowledge- click below:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
Question - Excel - Essential0%
Please also do our advanced Excel Quiz
1
2
3
4
5
6
7
8
9
10
Answered
Review
Question 1 of 10
1. Question
1 points
What is a worksheet?
Correct
Incorrect
Question 2 of 10
2. Question
1 points
How do you save a file?
Correct
Incorrect
Question 3 of 10
3. Question
1 points
Autofill creates copies of cells based on the cell’s contents – true or false?
Correct
Incorrect
Question 4 of 10
4. Question
1 points
What is Flashfill?
Correct
Incorrect
Question 5 of 10
5. Question
1 points
How do you create a custom view?
Correct
Incorrect
Question 6 of 10
6. Question
1 points
What are some Arithmetic operators?
Correct
Incorrect
Question 7 of 10
7. Question
1 points
A formula is a mathematical expression that you build yourself – true or false?
Correct
Incorrect
Question 8 of 10
8. Question
1 points
All functions begin with an addition sign – true or false?
Correct
Incorrect
Question 9 of 10
9. Question
1 points
=SUM(A6*A7) and =SUM(A6:A7) are:
Correct
Incorrect
Question 10 of 10
10. Question
1 points
What are Sparklines?
Correct
Incorrect
Upcoming Public Courses
Please click on link below for related public course/s:
Accredited Computer Courses
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
There are no upcoming events at this time.
Book or Obtain Instant Quote
In addition to the related public courses, we offer the above course across the country: Anytime, Anywhere. Click on the link to get an instant proposal or book your course NOW:
We are a diverse and dynamic team of passionate training specialists who believe that self-betterment and additive education are transformative elements that can help people realise their full potential. We are in the constant pursuit of excellence and proud of our authentic BBEEE roots. We want to work with companies who share our vision. Learn More