Advance Excel Online Test

A worksheet range is a

The Chart wizard term data categories refers to;

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

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

Tab scrolling button

Concatenation of text can be done using

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

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

Which of the following will not cut information?

You can activate a cell by

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

How do you select an entire column?

How can you print three copies of a workbook?

To create a formula, you first:

How do you delete a column?

How can you find specific information in a list?

You can use the horizontal and vertical scroll bars to

to view a cell comment

To save a workbook, you:

You can edit a cell by

You can use the drag and drop method to

How can you delete a record?

Right clicking something in Excel:

Documentation should include

Comments can be added to cells using

To copy cell contents using drag and drop press the

When you copy a formula

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 is not a web Browser ?

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 ?

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?

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

Red triangle at the top right corner of a cell indicates

Which of the following is concantenating operator?

Data can be arranged in ascending or descending order by using

What symbol is used to enter number as text?

The number of rows in a worksheet is

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

Which is not a social networking site ?

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

'DTP' computer abbreviation usually means ?

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

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

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

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


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

487 days 1 hours 20 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.

957 days 2 hours 34 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.

965 days 7 hours 26 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

1038 days 18 hours 43 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 ...

1047 days 43 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) .

1061 days 5 hours 15 minutes ago


Please test the answer on Q28

1083 days 11 hours 23 minutes ago

Essay Expert

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

1137 days 22 hours 34 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.

1180 days 49 minutes ago


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

1180 days 14 hours 53 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 | 15269 Attempts

Internet Basics
45 Questions | 1239 Attempts

Computer Basics
17 Questions | 1897 Attempts