Ml1 Final Exam Review Part I

10 Questions | Total Attempts: 188

Settings

ML1 Final Exam Review Part I

Questions and Answers
• 1.
Which of the icons shown stands for "Save"? (1) (2) (3) (4)
• A.

1

• B.

2

• C.

3

• D.

4

• 2.
What feature automatically copies a formula to a range?
• A.

Ctrl x

• B.

Paste function

• C.

AutoFill

• D.

Paste

• 3.
A formula in MS Excel starts with
• A.

#

• B.

~

• C.

&

• D.

=

• 4.
What is 7.54% represented as the decimal:
• A.

7.54

• B.

0.754

• C.

0.0754

• D.

75.4

• 5.
Which menu allows you to enter headers / footers?
• A.

View

• B.

Edit

• C.

Insert

• D.

Tools

• 6.
The correct formula that sums up the range B2:B8 is:
• A.

(B2+B8)

• B.

=SUM(B2:B8)

• C.

SUM(B2:B8)

• D.

B2+B8

• 7.
Which of these formulas divides the value in cell D2 by 3?
• A.

D2:3

• B.

D2/3

• C.

(D2/3)

• D.

=D2/3

• 8.
Which Excel function is used to choose one of 2 given values?
• A.

COUNT

• B.

MAX

• C.

AVERAGE

• D.

IF

• 9.
What is the way to underline text in a cell?
• A.

Format Cells ----> Font

• B.

Format Cells ----> Number

• C.

Format Cells ----> Alignment

• D.

Format Cells ----> Patterns

• 10.
Which menu is used to change the height of a row?
• A.

View

• B.

Insert

• C.

Format

• D.

Tools

Back to top