SDE311 - Final Test Tips Quiz

An Excel Table cannot have both a Criteria and Output Range.

• True

• False

Answer explanation

Actually, an Excel Table can stand alone, have a Criteria Range where the results are shown 'in-table' and have an Output Range, where the results are shown there.

Label the parts of an IF Statement by dragging and dropping.

a

b

c

d

Function

Condition

If False

If True

From what's listed, below, what is not part of how an Excel Table functions or looks or works?

• Let's you filter.

• Let's you sort.

• Allows Table Styles

• Shows Charts

Answer explanation

You can create a chart from almost any kind of data, including data in an Excel Table, but it doesn't show you charts on its own.

What, below, best describes how Excel's AutoFit works?

• Changes all column widths to 12 points.

• Makes all column widths the same so they all display in a wide format.

• Changes all column widths to hold the largest value in a column.

• Changes all column widths to hold the smallest value in a column.

Is Times New Roman an AODA-compliant font?

• Yes

• No

Answer explanation

Times New Roman is a serif-based font, so it is not AODA-compliant.

What is the one thing wrong with this IF Statement: =if(F5<>100,high","low") ​ (a)  

• Missing Quotation Mark
• Bracket Missing
• No false condition
• No true condition
• Nothing

Examine the three cells in the picture. Which one is formatted to Accounting?

• First/top one.

• Second/middle one.

• Third/last one.

• None of them.

Answer explanation

Accounting formatting places the dollar sign to the left side of the cell, no matter how wide the cell is.

Reorder the following parts of an Excel Table.

• Field names, copied to the bottom.

• Sort/Filter Button

• Field names, copied to the top.

• Criteria Range

• Main data you're working with.

• Excel Table

• Down arrow beside every field name.

• Output Range.

For an Excel Table, what description below does not represent what an Advanced Filter can do?

• Automatically create a chart.

• Use a list range.

• Use a criteria range.

• Copy filtered results to another location.

What is one of the major advantages, in your own words, of using an Excel Table?

Answer explanation

Here are several advantages in using an Excel Table:

• * Organization

• * Sorting

• * Filtering

• * Easy to view data

• * Aesthetics