Excel & Google Sheets for Business

Excel Course Introduction

1 Topic

A Quick Word on the Course Completion Certificate

Introduction to Excel/Google Sheets for Business

Formatting a Worksheet

2 Topics

Advanced Worksheet Formatting

All About Conditional Formatting

Worksheet Views, Printing, Sharing & Collaboration

3 Topics

Worksheet Views, Setting up Printing, File Sharing, Collaboration and Download Options

Sorting and Filtering a Worksheet

All About Find & Replace

Protecting Worksheets & Ranges

Data Validation for Worksheet Entries

Removing Duplicate Entries From a Worksheet

Handling Text Delimiters

Formulas & Functions

4 Topics

Familiarising Yourself With the Functions Library

Getting to Grips with Math Functions

Mastering Date Functions

Mastering Text Functions

Charts & Graphs

1 Quiz

Quiz – Excel & Google Sheets

Quiz – Excel & Google Sheets

Excel & Google Sheets for Business Charts & Graphs Quiz – Excel & Google Sheets

Time limit: 0

Quiz Summary

0 of 16 questions completed

Questions:

Information

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 must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 16 questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

Unfortunately, you have failed this quiz. You may go over the course again and retake this test.

The pass mark to be eligible for a certificate is 70%
Congrats! You’ve passed the quiz.
You are eligible for a course completion certificate. The course certificate is optional and you can request for it via the link below:

Excel & Google Sheets Certificate

A small fee of GHC30 applies for your certificate to be issued to you.

Thanks!

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

Current
Review
Answered
Correct
Incorrect

Question 1 of 16

1. Question
What formula would I have to write to produce the text “West-Africa” in Cell C1 Select any that applies
- #NUM!Question
- Answer TypeQuestion0
- Answer Type-Question
- Answer TypeQuestion
- Answer Type-Question
Correct

Incorrect

Question 2 of 16

2. Question

You have been given this worksheet with 10 columns to print. When you clicked on the print button, only 8 columns showed up on the 1st page, the other 2 columns spilled over onto page 2. What scaling adjustment will you need to do to get all the 10 columns legibly showing on one page before you print? (You want to avoid scrambling all the data into just a small part of the sheet, making the sheet unreadable)

Fit to width

Fit to height

Fit to page

Custom Number (Select 80%)

Normal (100%)

Correct

Incorrect

Question 3 of 16

3. Question

What do you need to do to make sure the Column headers display at the top of this and every other page of the worksheet?

Select: Repeat frozen rows

Select: Sheet Name

Select: Workbook Title

Select Formatting

Correct

Incorrect

Question 4 of 16

4. Question

What tool in Google Sheets makes it possible to only enter a pre-defined set of data such as the months of the year into a cell? (the cell will reject or show an error message if you attempt to enter any other data that does not meet the pre-defined criteria)

Protect sheet tool

Goal Seek tool

Pivot Table tool

Data Validation tool

Conditional Formatting tool

Correct

Incorrect

Question 5 of 16

5. Question

Which of these should I click to help me change the format of Column G (highlighted) to Nigerian Naira?

More Formats

Currency

Accounting

Number

Scientific

Correct

Incorrect

Question 6 of 16

6. Question

If I want to arrange the contents of Colum G (Customer Name) in reverse alphabetical order, which of these should I select?

Group

Filter views

Sort sheet by column G, Z – A

Slicer

Sort sheet by column G, A – Z

Correct

Incorrect

Question 7 of 16

7. Question

What will the entry in cell K2 be if it had the following function: =Left(J2,8)

FUR-BO-1

FUR-BO

10001798.0

-10001798.0

Correct

Incorrect

Question 8 of 16

8. Question

What will the entry in cell K2 be if it had the following function: =Len(J2)

10001798.0

FUR-BO

15.0

FUR-BO-10001798

6.0

Correct

Incorrect

Question 9 of 16

9. Question

What would be a correct formula for SUM in Excel/Google Sheets?

0
SUM(A3:A9)
@SUMA3+A9
@ADD(A3:A9)

Question 10 of 16

10. Question

Which formula gets the biggest value of a range of cells?

SUM
LARGE
MIN
MAX

Question 11 of 16

11. Question

Which symbol must all formula begin with?

(
$
+
@
=

Question 12 of 16

12. Question

Which formula will automatically capitalize the first letter of a word?

Upper-case
Capitalize
Proper
abra-ka-dabra

Question 13 of 16

13. Question

Which tab contains the “Freeze Panes” or “Freeze Rows” tool?

Rows
Tools
View
Page Layout
Home

Question 14 of 16

14. Question

Which Text function is used to join the text from two or more cells?

Join
Left
Concatenate
Add

Question 15 of 16

15. Question

What number should be in E1 (based on the formula)?

10.0

6.0

5.0

9.0

Correct

Incorrect

Question 16 of 16

16. Question

What is used to convey a visual representation of data?

Chart
Picture
Table
Text Box

Scroll to Top