# Excel Basic 102

10 Questions | Total Attempts: 55

Settings

This quiz is to enforce Excel fundamentals

Related Topics
• 1.
What formula allows you to combine 2 or more strings together?
• A.

Merge

• B.

Concatenate

• C.

Exact

• D.

Bind

• 2.
A comma is used to separate parameters in a function?
• A.

True

• B.

False

• 3.
What does the Fx symbol mean?
• A.

• B.

Format Wizard

• C.

Cell format

• D.

Function Wizard

• 4.
Which formula creates the below sentence using A2 for the name and B2 for the dollar amount?
• A.

=CONCATENATE("Dear ",A2,", you currently owe \$",B2,".")

• B.

=("Dear ",A2,", you currently owe \$",B2,".")

• C.

=CONCATENATE("Dear A2 you currently owe \$B2.)

• D.

=EXACT("Dear ",A2,", you currently owe \$",B2,".")

• 5.
What are all of the parts needed to average a range between A1 and A4?  Choose all that apply
• A.

=

• B.

( )

• C.

,

• D.

:

• E.

Sum

• F.

A1

• G.

A2

• H.

A3

• I.

A4

• J.

Average

• 6.
When figuring out a formula, what are some good rules of thumb to go by?  Check all that apply
• A.

Work from the middle

• B.

Break into smaller pieces

• C.

Write it or talk it out and find the primary reference point

• D.

Keep it simple

• 7.
It is True that if you are using 2 functions inside a formula, it is required to have 2 =.
• A.

True

• B.

False

• 8.
When building a spreadsheet, which statements are true:  Choose all that apply
• A.

If you want sales tax, you should hard code it into the formula

• B.

If you want sales tax, you should have it based upon a cell outside of the formula

• C.

It is OK to create multiple columns to break out the data

• D.

A single formula should be able to handle everything you need to do

• 9.
If you have a single cell for GP% and you want to paste a formula down a page without excel auto incrementing the formula, what special symbol do you need to use?
• A.

@

• B.

#

• C.

&

• D.

\$