Advance excel exam

Welcome to your Advance excel exam

How many conditions can the submit check for?

By default how many worksheets are in a workbook?

An nested if statement only allows for one argument?

If the range lookup is false in a vlookup what does it mean?

What is a pivot table?

A template is a worksheet which has all the necessary features you require?

What is a scenario?

The sumif function has the...... range, criteria, sum_range?

A lookup table counts the columns in the Col_index_No and not the cell reference?

To copy cell contents using drag and drop press the

When you use the fill effects in the format data series dialog box, you can not

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

Hyperlinks cannot be

To drag a selected range of data to another worksheet in the same workbook, use the

_______ tab, in the Editing group, click Find & Select, and then click Go To.

What term refers to a specific set of values saved with the workbook?

Which menu option can be sued to split windows into two

You can activate a cell by

Select the fields to be shown. Others will be hidden. Drag and drop to rearrange the order.
  • Image
  • SKU
  • Rating
  • Price
  • Stock
  • Availability
  • Add to cart
  • Description
  • Content
  • Weight
  • Dimensions
  • Additional information
Click outside to hide the comparison bar