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. How can you quickly highlight all the BLANK cells in the table shown in image?

CTRL A -> F5 -> Special -> Blanks

CTRL F -> Find blank data

Press SHIFT, select every blank cells

Press CTRL, select every blank cells

2 / 15

Category: Excel: Entering & Editing Worksheet Data

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

This button is available beside your Formula Bar in Excel.

3 / 15

Category: Excel: Formula Basics

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

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

Insert a new chart

Insert a function

Toggle between the 5 primary Excel functions

4 / 15

Category: Excel: Formula Basics

4. 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

=O$4 * $N5

=O4:S4 * N5:N10

=$O$4 * $N$5

=O$4 * N$5

=O4 * N5

=$O4 * $N5

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

Merge & Center

Join cells

Unmerge Cells

6 / 15

Category: Excel: Worksheet Formatting

6. What are the steps to use this Format Painter command?

1. Select cell(s) with the formatting you like

2. Select something else to automatically apply the formatting

3. Click Format Painter

7 / 15

Category: Excel: Printing Your Workbook

7. You want to make sure that the PURPLE and GRAY colored areas are always visible while you are working with the data, i.e., if you scroll down, the PURPLE area will always be visible, and if you scroll right, the GRAY area will always be visible.

Fill in the blanks for the correct input:

Select cell
Go to ribbon
Select command

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 Row 1 – Row 3 which are considered as your Table Headers. How can you achieve this?

Page Layout -> Print Titles -> 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!

Print the data separately from the Table Headers

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

9 / 15

Category: Excel: Making Charts

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

Value captions

Annotations

Data labels

Legend entries

10 / 15

Category: Excel: Making Charts

10. Which chart is the best suited to represent a Sales Growth Trend Over the Years?

Bar chart

Pie chart

Line chart

Column chart

11 / 15

Category: Excel: Shortcuts

11. Shortcut 7

Move to the next sheet in a workbook

Highlight all data

Highlight the entire column

Highlight the entire row

12 / 15

Category: Excel: Shortcuts

12. Shortcut 10

Paste the copied cell’s value only

Paste copied selection, including all formatting and formula

Insert the current date

Fill the highlighted range with the current entry

13 / 15

Category: Excel: Shortcuts

13. Shortcut 19

Paste copied selection, including all formatting and formula

Fill the highlighted range with the current entry

Insert the current date

Paste the copied cell’s value only

14 / 15

Category: Excel: Shortcuts

14. Shortcut 12

Insert the current date

Copy the contents of the current cell down

Paste the copied cell’s value only

Fill the highlighted range with the current entry

15 / 15

Category: Excel: Shortcuts

15. Shortcut 6

Fill the highlighted range with the current entry

Move to the next sheet in a workbook

Highlight the entire column

Highlight the entire row

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