# Excel Basics 101

10 Questions | Total Attempts: 105  Settings  This quiz is to enforce Excel fundamentals

Related Topics
• 1.
If you want to add only A1 and D1 cells together, which answer is the best answer?  (Choose all that apply)
• A.

=A1+D1

• B.

=sum(A1+D1)

• C.

=sum(A1:D1)

• D.

Sum(A1+D1)

• 2.
If you want to add the range of cells A1 through D1 cells together, which answer is the best answer?  (Choose all that apply)
• A.

=A1:D1

• B.

=sum(A1+D1)

• C.

=sum(A1:D1)

• D.

Sum(A1:D1)

• 3.
If you want to add only A1 and B1 cells together and then subtract D1, which answer is the best answer?  (Choose all that apply)
• A.

=sum(A1+B1)D1

• B.

=sum(A1+B1)-D1

• C.

=(A1+B1)-D1

• D.

Sum(A1+B1)-D1

• 4.
If you want to add A1 and B1 cells together and then subtract the sum of C1 and D1, which answer is the best answer?  (Choose all that apply)
• A.

Sum(A1+B1)-(C1+D1)

• B.

=(A1+B1)-(C1-D1)

• C.

=(A1+B1)-(C1+D1)

• D.

=sum(A1+B1)-(C1+D1)

• 5.
The only time you need to use the sum function is when you want to add a range of cells?
• A.

True

• B.

False

• 6.
What are the things you want to do when you sort data?  Choose all that apply
• A.

Make sure you select all of your data

• B.

Create a column with sequential numbers

• C.

Select only the column of data that you want to sort

• 7.
If you want to format a cell for Money with change, how do you do that?  Choose all that apply
• A.

Right Click on cell, Click Format and change the format to Number with 2 decimal

• B.

Right Click on cell, Click Format and change the format to Currency with 2 decimal

• C.

Select all of the cells that you want to format and click the \$ button in the toolbar

• D.

Right Click on cell, Click Format and change the format to General

• 8.
What does CSV stand for?
• A.

Common Separated Values

• B.

Comma Separated Values

• C.

Colon Separated Values

• D.

Colin K's SuperBowl 48 Victory