Advance Excel Online Test

When you copy a formula

To copy cell contents using drag and drop press the

Comments can be added to cells using

Documentation should include

Right clicking something in Excel:

How can you delete a record?

You can use the drag and drop method to

You can edit a cell by

To save a workbook, you:

to view a cell comment

You can use the horizontal and vertical scroll bars to

How can you find specific information in a list?

How do you delete a column?

To create a formula, you first:

How can you print three copies of a workbook?

How do you select an entire column?

Which of the following is not a basic step in creating a worksheet?

You can activate a cell by

Which of the following will not cut information?

Which of the following methods can not be used to enter data in a cell

Data can be arranged in a worksheet in a easy to understand manner using

Concatenation of text can be done using

Tab scrolling button

Getting data from a cell located in a different sheet is called …

A worksheet range is a

The Chart wizard term data categories refers to;

Which of the following is not an example of a value?

Which of the following formulas will Excel Not be able to calculate?

Which symbol must all formula begin with?

Which of the following formulas is not entered correctly?

What symbol is used before a number to make it a label?

Which of the following is an absolute cell reference?

Which keyboard shortcut opens the Go To dialog box?

A quick way to return to a specific area of a worksheet is to type in the _____

If you require more than two conditions or if you want to analyze a list using Excel 2003's database functions, you must define which filter?

If you wanted to sort an employee file so that they would be listed alphabetically by last name and first name within individual zip codes (smallest to largest), which of the following would be the correct order of the sort?

To keep specific rows and columns from scrolling off the screen you first must position the cell pointer

When you create two or four separate windows containing part of the spreadsheet that can be viewed, you have created

The process of identifying specific rows and columns so that so that certain columns and rows are always visible on the screen is called

The accounting style shows negative numbers in

To move to the previous worksheet press

Which of the following component displays the contents of active cell?

How many sheets are there in Excel Workbook by default?

Cell E23 has a date value and you wish to place that date on an invoice prefaced with the text located in B15. What is the command to do that?

Which device is used as the standard pointing device in a Graphical User Environment ?

Which of the following devices have a limitation that we can only information to it but cannot erase or modify it ?

'DTP' computer abbreviation usually means ?

On the Task bar the time is shown in the...?

How do the main components of the computer communicate with each other?

.BAK' extension refers usually to what kind of file?

'.TMP' extension refers usually to what kind of file?

Which is not a web Browser ?

Which is not a social networking site ?

When a formatted number does not fit within a cell, it displays?

The number of rows in a worksheet is

What symbol is used to enter number as text?

Data can be arranged in ascending or descending order by using

Which of the following is concantenating operator?

Red triangle at the top right corner of a cell indicates

To select multiple non-adjecent cells in a worksheet you will click them holding


All Students are welcomed for this Tests


Connie Lesole

some questions you have to purposely answer incorrectly to get a mark,thats not good at all

585 days 19 hours 23 minutes ago

Karim Shaik

Messages like "Hungry, think consistently?" or something similar, different messages work for all so seek out what works for most people.

1055 days 20 hours 37 minutes ago

Karim Shaik

Luckily, I broke the chains of my upbringing sap fiori. I realized I would have a job for life, but ended up being not what was going different me perfect. I wanted more, I needed more.

1064 days 1 hours 29 minutes ago

Elena Isayenko

This test is full of grammatical errors and incorrect content that refers to outdated versions of Excel and also uses irrelevant questions to test Excel knowledge - which one is not a social network?? How is that an Excel related question. Creator should review and update to keep relevancy. And rename this to "Advanced" already. I am shocked companSee more

1137 days 12 hours 45 minutes ago

Virtual Router

In this project, you will download and install the Virtual Router application to set up ... You should now see the Virtual Router Manager setup window as shown in ...

1145 days 18 hours 46 minutes ago

Overclock Gpu is hosting its first HWBOT challenge. The challenge: overclock a HD5450 DDR3 GPU. Time: June 23th 0:01am - July 23th 23:59pm EST (-5GMT) .

1159 days 23 hours 18 minutes ago


Please test the answer on Q28

1182 days 5 hours 26 minutes ago

Essay Expert

I am essay expert & this is a very good test & it will enhance the learning skills.

1236 days 16 hours 37 minutes ago

J Carter

Many of these questions refer to 2003 and 2007. I had to guess the menu layout for those and got so many wrong.

1278 days 18 hours 52 minutes ago


Those assignment and analysis are good with so that they can avail test.

1279 days 8 hours 56 minutes ago

Provide skills for IT Career Boosting
Tests: 4

Your Facebook Friends on WizIQ

More Tests By Author

Computer Fundamental (CCC) By RB Technosoft
100 Questions | 15272 Attempts

Internet Basics
45 Questions | 1242 Attempts

Computer Basics
17 Questions | 1904 Attempts