TOSA Excel – Format, Alignment, Filter

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

0

You have 10 minutes to complete this quiz

No more time to complete the quiz

---

1 / 10

What happens when you extend with the fill-handle, the contain of a cell that contains a day in letter?

You create a list of the days of the week (Monday, Tuesday, ....)

Nothing

You copy the word Monday

You copy the width of the cell for the other columns

2 / 10

How do you remove the Excel Gridlines?

View > Gridlines

Page Layout > Gridlines > View

Coloured the border of each cell with the same colour as the background

File > Options > Accessibility > Gridlines

3 / 10

What is the purpose of the icons with an arrow in the header of each column?

Erase the format in the column

Erase the value

Sort data

Filter on the values (text, number, date)

Filter on the colour

Sort on the colour

4 / 10

You want to copy the range of cells A1:M5 to a new blank worksheet. What is the only thing that WON'T be copied?

The colors

The conditional formatting

The values

The borders

The column's width

5 / 10

Which alignment options were used to write text across multiple columns (2 responses)?

Group

Justify

Fill

Merge & Center

Center across selection

Center

6 / 10

What is the menu that allows you to change the print orientation of the pages in Excel?

File > Print > Portrait Orientation > Sheet

File > Print > Collated

File > Print > Page Setup > Sheet

File > Print > Print Active Sheets > Order

7 / 10

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

The column B is hidden

It's a bug

The width of the column is 1 pixel

The column B has been deleted from the worksheet

8 / 10

What is the purpose of the icon Format Painter?

Duplicate the format to another cell

Add background colour to your cell

Erase the contain of the cell

Change the colour of the text of the cell

9 / 10

Is it possible to filter the cells without colour?

No

Yes

10 / 10

You want to sort the data with the following sorting key

1. Commande_ID in increasing order
2. Category in increasing order
3. Quantity in decreasing order

Which option do this task?

<img class='alignnone size-full wp-image-32326' src='https://excel-tutorial.com/wp-content/uploads/2023/07/Answer-Sort-2.png' alt='Answer Sort 2' width='586' height='268' />

<img class='alignnone size-full wp-image-32328' src='https://excel-tutorial.com/wp-content/uploads/2023/07/Answer-Sort-4.png' alt='Answer Sort 4' width='586' height='268' />

<img class='alignnone size-full wp-image-32327' src='https://excel-tutorial.com/wp-content/uploads/2023/07/Answer-Sort-3.png' alt='Answer Sort 3' width='586' height='268' />

<img class='alignnone size-full wp-image-32325' src='https://excel-tutorial.com/wp-content/uploads/2023/07/Answer-Sort-1.png' alt='Answer Sort 1' width='586' height='268' />

Your score is

The average score is 0%

Share your score with your network

LinkedIn Facebook

Restart quiz

Send feedback

Other Excel Assessment

• Beginner Excel Test
• Excel Advanced Test
• Tests Excel for Expert users
• TOSA Excel – Assessment of the Excel functions
• TOSA Excel – Format, Alignment, Filter

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!