# Excel - Online Assessment

45 Questions | Total Attempts: 58

Settings

Related Topics
• 1.
The symbol for division is...
• A.

\$

• B.

\

• C.

*

• 2.
What is a pivot table?
• A.

A report

• B.

• C.

A filter

• D.

Vlookup

• 3.
An nested if statement only allows for one argument?
• A.

True

• B.

False

• 4.
If the range lookup is false in a vlookup what does it mean?
• A.

The result will return an exact match

• B.

The result will return the nearest match

• C.

It will return a negative

• D.

None of the above

• 5.
By default how many worksheets are in a workbook?
• A.

1

• B.

2

• C.

3

• D.

4

• 6.
How many conditions can the sumif check for?
• A.

1

• B.

2

• C.

3

• D.

4

• 7.
A macro is a part of a conditional format?
• A.

True

• B.

False

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

True

• B.

False

• 9.
What is a scenario?
• A.

Figures which switch between varying amounts

• B.

A conditional format

• C.

A macro

• D.

An IF statement

• 10.
The sumif function has the...... range, criteria, sum_range?
• A.

True

• B.

False

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

True

• B.

False

• 12.
The feature that enables you to automatically complete a list of 12 months after you key one month is
• A.

Cell style

• B.

Fill handle or Autofill

• C.

Page layout

• D.

Find

• E.

Replace

• 13.
• A.

Merge and Center

• B.

Align

• C.

Freeze columns

• D.

Indent

• E.

Split

• 14.
• A.

Mixed reference

• B.

Absolute reference

• C.

Relative reference

• D.

• E.

Money reference

• 15.
What type of operation is being preformed in the formula =A4*B5
• A.

• B.

Subtraction

• C.

Division

• D.

Percentage

• E.

Multiplication

• 16.
Which orientation is taller than it is wide?
• A.

Landscape

• B.

Portrait

• 17.
What term describes a model workbook used as the basis for other workbooks?
• A.

Form

• B.

Demonstration

• C.

Template

• D.

Cell styles

• E.

Page Layout

• 18.
How can you start Edit mode to edit a formula?
• A.

Tools

• B.

Format

• C.

F4

• D.

F2 or double-click cell

• E.

Find and replace

• 19.
Three types of data visualation are:
• A.

Tools, Columns, Styles

• B.

Data bars, Color scales, Icon sets

• C.

Cell styles, Bold, Italics

• D.

Home, Edit, Fill

• E.

Shapes, Arrows, Clip art

• 20.
Name the function that adds cell values only if they meet your criteria.
• A.

Average()

• B.

Count()

• C.

Mean()

• D.

SumIF()

• E.

Round

• 21.
What function would display the highest sales amount in a column?
• A.

Min()

• B.

Avg()

• C.

Max()

• D.

Most()

• E.

Sum()

• 22.
Which logical function shows the opposite of the condition?
• A.

NOT function

• B.

False function

• C.

Nper function

• D.

Sum function

• E.

PMT function

• 23.
What is the term used to describe a function inside a function?
• A.

Conditional

• B.

Argument

• C.

Nested

• D.

Double

• E.

• 24.
• A.

• B.

Displays a website

• C.

Formats worksheet

• D.

Hides worksheets

• 25.
Which function enters the current date?
• A.

Now()

• B.

Days()

• C.

DDYYMM

• D.

TODAY()