Do you know your Excel (Beginner) skill level?

Try out our Excel Beginner Assessment

/15

EXCEL BEGINNER TEST

This test is developed to test your skill and knowledge related to Excel as Beginner. There are a total of 15 questions for which the passing mark is set to 80%. Upon passing, you will be automatically given an e-Certificate thru your email, so please make sure to enter a valid email address.

Topics covered in this test are:

Entering & Editing Worksheet Data
Formula Basics
Worksheet Formatting
Printing Your Workbook
Making Charts
Excel Shortcuts

GOOD LUCK!

1 / 15

Category: Excel: Entering & Editing Worksheet Data

1. Holding down the key and scrolling the mouse wheel forward will zoom

2 / 15

Category: Excel: Entering & Editing Worksheet Data

2. Holding down the key and scrolling the mouse wheel will zoom out.

3 / 15

Category: Excel: Formula Basics

3. Based on the image, choose the option(s) which will give you the correct formula in the RED cell so that you will be able to produce all the answers needed in the GRAY cells.

Multiple answers

=O4:S4 * N5:N10

=$O$4 * $N$5

=O4 * N5

=O$4 * N$5

=$O4 * $N5

=O$4 * $N5

This button is available beside your Formula Bar in Excel.

4 / 15

Category: Excel: Formula Basics

4. What will this button help you do in Excel?

Toggle between the 5 primary Excel functions

Show the sum, count, or average of the selected cells

Insert a new chart

Insert a function

5 / 15

Category: Excel: Worksheet Formatting

5. Which command can quickly merge all individual cells in every row into multiple row cells as shown in image?

Merge Across

Join cells

Merge & Center

Unmerge Cells

6 / 15

Category: Excel: Worksheet Formatting

6. What is the name of this command?

Fill Color

Format Painter

Paint Brush

Font Color

7 / 15

Category: Excel: Printing Your Workbook

7. You want to print your report from Excel as shown in image and you want to make sure that every page will have the important information from Row 1 – Row 3 which are considered as your Table Headers. How can you achieve this?

Print the data separately from the Table Headers

Print Preview -> Page Setup -> Sheet -> Select Rows to repeat at top

It is not possible to do this in Excel. Instead, you need to copy the table into Word first!

Page Layout -> Print Titles -> Sheet -> Select Rows to repeat at top

8 / 15

Category: Excel: Printing Your Workbook

8. You want to print your report from Excel as shown in image and you want to make sure that every page will have the important information from Column A – Column B which are considered as your Row Labels. How can you achieve this?

It is not possible to do this in Excel. Instead, you need to copy the table into Word first!

Print Preview -> Page Setup -> Sheet -> Select Columns to repeat at left

Print the data separately from the Row Labels

Page Layout -> Print Titles -> Sheet -> Select Columns to repeat at left

9 / 15

Category: Excel: Making Charts

9. You are given data as shown in the image and your manager wants you to present it in a chart. Which one is the most suitable chart type?

Line chart

Waterfall

Pie chart

Treemap

Column chart

10 / 15

Category: Excel: Making Charts

10. What is the text around the pie chart called?

Annotations

Data labels

Legend entries

Value captions

11 / 15

Category: Excel: Shortcuts

11. Shortcut 5

Highlight the entire row

Move to the beginning of a worksheet

Return to the first selected cell of the highlighted range

Insert the current date

12 / 15

Category: Excel: Shortcuts

12. Shortcut 1

Copy the contents of the current cell down

Paste the copied cell’s value only

Move to the beginning of a worksheet

Save workbook

13 / 15

Category: Excel: Shortcuts

13. Shortcut 14

Undo operation

Save workbook

Copy selection

Cut selection

14 / 15

Category: Excel: Shortcuts

14. Shortcut 18

Highlight all cells in the chosen arrow direction

Highlight the entire column

Highlight the entire row

Highlight all data

15 / 15

Category: Excel: Shortcuts

15. Shortcut 8

Move to the next sheet in a workbook

Move to the beginning of a worksheet

Move to the edge of the current data region

Return to the first selected cell of the highlighted range

Please fill-up the information fields should you require an e-Cert sent to your email. You will receive occasional update news about our training opportunities unless you choose to opt out from our email blast list. To opt out, you can leave the form blank and go direct to the result.

Thank you so much for participating in the online assessment.

NameEmail

Your score is

Anonymous feedback

Thank you for your review!

By Wordpress Quiz plugin

Discover more from Cadisc Enterprise

Subscribe to get the latest posts sent to your email.

Cadisc Enterprise