Have an account?
Skip to Content
Build your own quiz
Suggestions for you
Professional Development
Professional Development
Starter Quiz - Excel for Finance Practitioners
15 questions
Show Answers
See Preview
- 1. Multiple Choice
Which of the following is not not a valid data type in Excel?
Number
Label
Date/Time
Character
- 2. Multiple Choice
Which area in Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
- 3. Multiple Choice
Concatenation of text can be done using
Exclamation (!)
Hash (#)
Apostrophe (')
Ampersand (&)
- 4. Multiple Choice
A numeric value can be treated as label value if .... precedes it.
Hash (#)
Exclamation (!)
Apostrophe (')
Ampersand (&)
- 5. Multiple Choice
Getting data from a cell located in different sheet is called...
Functioning
Referencing
Accessing
Updating
- 6. Multiple Choice
How do you rearrange the data in ascending or descending order?
Data, Form
Data, Subtotals
Data, Table
Data, Sort
- 7. Multiple Choice
In Excel, you can sum a large range of data by simply selecting a tool button called...
Auto Format
Auto Sum
Auto Fill
Auto Correct
- 8. Multiple Choice
What do you mean by Workspace?
Group of Workbooks
Group of Worksheets
Group of Rows
Group of Columns
- 9. Multiple Choice
How do you change the column width to fit the contents?
Single - click the boundary to the left of the column heading
Double - click the boundary to the right of the column heading
Press ALT and single - click anywhere in the column
- 10. Multiple Choice
###### means
You've entered a number wrong
You've misspelled something
The cell is not wide enough
- 11. Multiple Choice
The formula --- = ((A2+B5)*5% is valid.
True
False
- 12. Multiple Choice
In Excel, a Formula and a Function are the same things.
True
False
- 13. Multiple Choice
On an Excel sheet, the active cell is indicated by...
A dark wide border
A dotted border
A blinking border
None of the above
- 14. Multiple Choice
If cells: A1=10 A2=20 A3=30 A4=40 A5=50. What will be your formula if you are going to get the total?
=SUM(A1 - A5)
=SUM(A1:A5)
=TOTAL(A1-A5)
=TOTAL(A1:A5)
- 15. Multiple Choice
Which formula can add all the numeric values in range of cells, ignoring those which are not numeric, and place the result in a different cell?
Count
Average
Sum
- Answer choicesTagsAnswer choicesTags