Have an account?
Skip to Content
Build your own quiz
Suggestions for you
15 questions
Show Answers
See Preview
- 1. Multiple Choice
Which functioning Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
None of these
- 2. Multiple Choice
Statistical calculations and preparation of tables and graphs can be done using?
Notepad
Power Point
Excel
Adobe Photoshop
- 3. Multiple Choice
Which one is not a Function in MS Excel ?
SUM
MAX
MIN
AVG
- 4. Multiple Choice
Functions in MS Excel must begin with ___
An Equal Sign
A Plus Sign
A > Sign
An () sign
- 5. Multiple Choice
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
- 6. Multiple Choice
Which bar show the used formula of selected active cell?
Menu bar
Ribbon
Formula bar
Scroll bar
- 7. Multiple Choice
When all the number between 0 to 100 in a range should be displayed in Red color, Apply
Use =if() function to format the required number red.
Apply Conditional Formatting command on format Menu
Select the cell that contain number between 0 to 100 then click Red color on Text color tool
All of the above
- 8. Multiple Choice
What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?
Count
IF
SUM
CountA
- 9. Multiple Choice
Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array?
Lookup
VLookup
NOW
CountIF
- 10. Multiple Choice
Which ONE of the following is not true?
Excel sheets have the extension *.doc
A new workbook is called Book 1
You can have Word and Excel open together
You can also create graph in excel sheets
- 11. Multiple Choice
To Add up entries from D6 to D10, we use the formula?
=Add(D6:D10)
=Sum(D6:D10)
Both A & B
None of these
- 12. Multiple Choice
The intersection of row and column is called?
Pointer
Cursor
Sheet
Cell
- 13. Multiple Choice
Finds minimum value among a range of cell from A4, A5, A6, A7 and A8 in MS-Excel?
=MIN(A4 to A8)
=MIN(A4-A8)
=MIN(A4:A8)
All of the above
- 14. Multiple Choice
Excel files have a default extension of?
XLW
XLS
DOC
WK1
- 15. Multiple Choice
Which feature allows you to create specific rules?
Pivot Table
Sorting
Data Validation
None of these
- Answer choicesTagsAnswer choicesTags