NEW
Font size
WorksheetsExcel Quiz
Total questions: 15
Worksheet time: 8mins
Which functioning Excel tells how many numeric entries are there ?
NUM
COUNT
SUM
None of these
Statistical calculations and preparation of tables and graphs can be done using?
Notepad
Power Point
Excel
Adobe Photoshop
Which one is not a Function in MS Excel ?
SUM
MAX
MIN
AVG
Functions in MS Excel must begin with ___
An Equal Sign
A Plus Sign
A > Sign
An () sign
In Excel, Columns are labelled as ___
A, B, C, etc
1,2,3 etc
A1, A2, etc.
$A$1, $A$2, etc.
Which bar show the used formula of selected active cell?
Menu bar
Ribbon
Formula bar
Scroll bar
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
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
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
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
To Add up entries from D6 to D10, we use the formula?
=Add(D6:D10)
=Sum(D6:D10)
Both A & B
None of these
The intersection of row and column is called?
Pointer
Cursor
Sheet
Cell
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
Excel files have a default extension of?
XLW
XLS
DOC
WK1
Which feature allows you to create specific rules?
Pivot Table
Sorting
Data Validation
None of these
