Excel Exam 2018

25 Questions  Settings  • 1.
When pound signs (######) appear in a cell, it means you have an incorrect formula.
• A.

True

• B.

False

• 2.
An employee ID # would be entered as a label by preceding it with an apostrophe.
• A.

True

• B.

False

• 3.
The mathematical operator used in formulas to multiply values is a forward slash.
• A.

True

• B.

False

• 4.
Cell addresses are used to develop formulas--not the values themselves.
• A.

True

• B.

False

• 5.
To undo a currency format in a cell, you simply click the \$ sign button on the ribbon.
• A.

True

• B.

False

• 6.
A defined area of the worksheet, such as (A1:A20), is called a series.
• A.

True

• B.

False

• 7.
An Invoice is an itemized bill.
• A.

True

• B.

False

• 8.
Each cell has a unique address made up of a row number and a column letter.
• A.

True

• B.

False

• 9.
Gross pay is the amount one receives after deductions have been taken away.
• A.

True

• B.

False

• 10.
A cell can contain the following:
• A.

Number

• B.

Formula

• C.

Text

• D.

All of the above

• 11.
A spreadsheet is a software program that allows one to:
• A.

Organize data

• B.

• C.

Chart data

• D.

All of the above

• 12.
The formula =E6-(F6+G6) directs the spreadsheet to:
• A.

Add two numbers first, then subtract them from the first number

• B.

Multiply two numbers first, then subtract the first number

• C.

Subtract the first number and add the following two numbers

• D.

Divide the first number by the sum of the second two numbers

• 13.
All money amounts should be formatted to how many decimal places?
• A.

One

• B.

Two

• C.

Zero

• D.

It depends

• 14.
The __________________________________ preceding a formula is important because it alerts Excel that you are entering a formula and  not text.
• A.

Exclamation point

• B.

Asterisk

• C.

Equal sign

• D.

Apostrophe

• 15.
To compute "Net Pay" in the following example, the formula would be:
• A.

=E6-F6-G6-H6

• B.

=E6+F6+G6

• C.

=E6-(F6+G6)

• D.

None of the Above

• 16.
The formula=MIN(A12:E12) will return the highest value in a range.
• A.

True

• B.

False

• 17.
Numbers are left-aligned in a cell.
• A.

True

• B.

False

• 18.
Which of the following would characterize or indicate the active cell on a worksheet?
• A.

Heavy border around it

• B.

Appears in the name box

• C.

It will appear in the name box and also have a heavy border around it.

• 19.
An Amortization Table will tell you:
• A.

Payment Amounts

• B.

Term of the Loan

• C.

Interest Rate

• D.

All of the above

• 20.
The y axis on a chart typically represents...
• A.

The horizontal scale

• B.

The axes titles

• C.

The diagonal scale

• D.

The vertical scale

• 21.
Under which part of the ribbon would you find the ability to print gridlines?
• A.

Insert

• B.

Data

• C.

Page Layout

• D.

Home

• 22.
The chart/graph that shows the relationship of each value to the whole would be:
• A.

Bar Chart

• B.

Column Chart

• C.

Pie Chart

• D.

Area Chart

• 23.
The picture below is an example of:
• A.

Filter

• B.

Sort

• 24.
Microsoft Excel is the only application for which one can download templates.
• A.

True

• B.

False

Related Topics