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

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

The cell format is Text

The cell doesn't contained a date

The cell format is General and not Date

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

2 / 10

How to customize the date format to display the months in letters?

dd mmmm yyyy

dd/mm/yyyy

dd mmm yyyy

dd mmmmmmmmmm yyyy

3 / 10

What happens when you click on these icons at the bottom of an option group?

Nothing

Hide the ribbon

Open a dialog box with more cell options

Full Screen Mode

4 / 10

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

Home > Insert > Insert Worksheet

Click on the + after the last worksheet

Right-Click on any tab > Insert > Worksheet

Page Layout > Insert > Worksheet

Insert > New Worksheet

5 / 10

In Excel, how do you keep the leading zero?

Add a quote (') before the number

Validate the cell with Ctrl + Enter

Apply Text format for your number

Use the Courrier New font

6 / 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 column's width

The borders

The values

The conditional formatting

The colors

7 / 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' />

8 / 10

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

File > Print > Print Active Sheets > Order

File > Print > Collated

File > Print > Page Setup > Sheet

File > Print > Portrait Orientation > Sheet

9 / 10

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

(m):mm:ss

h:mm:ss

The standard Time format

[h]:mm:ss

10 / 10

Which display option allows you to view the print margins of your document

File > Print > Show the margin

View > Page Break Preview

Page Layout > Margin

Page Layout > Print Area

Your score is

The average score is 0%

Share your score with your network

LinkedInFacebook

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!