Quiz: Take The MS Excel Assessment Test 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.
Calculate answers
- 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
Back to top