Welcome to the Excel Skills Assessment based on TOSA standards! This test is designed to evaluate your proficiency in essential Excel functionalities, specifically focusing on number format, text alignment, filter, sort, and page layout. The questions follow the TOSA (Test On Software Applications) standards, comprehensively assessing your skills.

Assessment Overview

This assessment will evaluate your knowledge of key Excel functionalities, focusing on:

Number Format: Decimal, Accounting number, Leading zero, ....
Text Alignment: Orientation, Increase the font size, Break line in a cell
Filter data: Color, Values, Remove filter
Sort data: Manage the sorting keys
Page Layout: Print Area, Page Orientation

You have 10 minutes to complete this quiz

No more time to complete the quiz

1 / 10

The cell F1 should display a date but instead, you have a number. What is the reason?

The cell doesn't contained a date

The user didn't write the date with the expected format.

The cell format is General and not Date

The cell format is Text

2 / 10

Why the column B is missing and replaced by a big separator?

The width of the column is 1 pixel

The column B is hidden

It's a bug

The column B has been deleted from the worksheet

3 / 10

What is the purpose of the icon Format Painter?

Add background colour to your cell

Erase the contain of the cell

Duplicate the format to another cell

Change the colour of the text of the cell

4 / 10

How to insert a break-line in your text?

Shift + Enter

Wrap Text

Ctrl + Enter

Alt + Enter

5 / 10

Which tool number allows you to insert indentation in your cells?

6 / 10

Which Format Number displays your number like in this?

Number

Accounting

Text

Currency

7 / 10

What is the action of the comma icon on your numbers?

Display your numbers with 2 digits

Add a thousand separator comma for all your numbers

Add a currency symbol after each numbers

Write in red the negative numbers

8 / 10

Which Time format allows you to display the time over 24 hours?

h:mm:ss

The standard Time format

[h]:mm:ss

(m):mm:ss

9 / 10

How do you remove the sparklines in a worksheet? Select the range of cells with the Sparklines, and then ..... (2 answers)

Home > Clear > Clear All

Press the Delete key?

Sparkline > Clear

Home > Conditional Formatting > Clear the rules

10 / 10

How to add a new worksheet to a workbook? (many answers)

Home > Insert > Insert Worksheet

Click on the + after the last worksheet

Insert > New Worksheet

Right-Click on any tab > Insert > Worksheet

Page Layout > Insert > Worksheet

Your score is

The average score is 0%

Other Excel Assessment

Excel-Tutorial.com, your training partner.

The purpose of Excel-tutorial.com is to help users master Excel through a series of tests, tutorials, and online training programs. Whether you're a beginner or an advanced user, our resources are designed to build your skills step by step.

Our certified experts have developed detailed training programs tailored to all skill levels. Our courses cover various Excel topics, from basic data processing to advanced data analysis and visualization. You'll find clear instructions, easy-to-follow lessons, and structured content that ensures steady progress.

Excel-tutorial.com stands out for its interactive teaching approach. Our lessons include exercises, real-life use cases, and engaging quizzes to solidify your understanding. This lets you apply your new skills immediately to real-world tasks, making learning both practical and impactful.

Plus, you can track your progress and test your knowledge with quizzes that provide instant feedback. Our goal is to help you gain confidence in Excel, one concept at a time. Join us at Excel-tutorial.com and start transforming your data skills today!

TOSA Excel – Format, Alignment, Filter

Assessment Overview

Other Excel Assessment

Excel-Tutorial.com, your training partner.

Most Viewed Posts