# Ml1 Final Exam Part1 Day1

10 Questions | Total Attempts: 69

Settings

Each question is 4 points.

• 1.
How do you format a cell for currency?
• A.

Format --> Font

• B.

Right click menu --> Clear Contents...

• C.

Right click menu --> Format Cell...

• D.

Tools--> Options

• 2.
The following formula =D12*4%
• A.

Finds what is 4% of the the value in D12

• B.

Divides the value in cell D12 by 4

• C.

Multiplies the value in cell D12 by 4

• D.

Finds the value in cell D12 as 12 multiplied by 4

• 3.
If A5 = 1, then the following formula =A5^2 + 2*A5 will produce?
• A.

0

• B.

3

• C.

5

• D.

4

• 4.
2.45% as a decimal is
• A.

2.45

• B.

0.245

• C.

0.0245

• D.

24.5

• 5.
The volume of a cube is s3. What would be an Excel formula to to find the volume of cube whose side value is placed in cell D3.
• A.

=B3*D3

• B.

=D3*3

• C.

=D3^3

• D.

=D3*D3

• 6.
What function counts the average value of the items in a list?
• A.

AVERAGE

• B.

SUM

• C.

IF

• D.

MEDIAN

• 7.
What function adds up the values in the highlighted cells?
• A.

Count

• B.

Sum

• C.

If

• D.

Average

• 8.
What is the symbol for auto-sum?
• A.

• B.

A

• C.

X

• D.

Σ

• 9.
What is the keystroke to reveal all formulas?
• A.

Alt &

• B.

Ctrl x

• C.

Shift F7

• D.

Control ~

• 10.
Which menu allows you to change the page orientation (Portrait/Landscape)?
• A.

Edit

• B.

Format

• C.

File

• D.

Tools