WorksheetsTNPL Excel Quizzz 1
Total questions: 15
Worksheet time: 8mins
What function will result in the total number of entries in the cell range B5 to B14?
COUNT
MAX
MIN
SUM
A function inside other function is called _________
Nested Function
Round Function
Inner Function
None of the above
A features that displays only the data in column (s) according to specified criteria is called _________
Formula
Pivot
Filtering
Sorting
What function will produce results that indicate whether a student has passed or failed a course by enter the text "Pass" or "Fail"?
Count
CountA
IF
SUM
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?
CountIF
SUM
Lookup
Vlookup
Which function returns the current date?
TIME
DATE
NOW
THEN
You can select the current row in MS-Excel Worksheet by pressing?
Ctrl + Space bar
F8 + arrow key
Shift + arrow key
Shift + Space bar
You can select the current column in MS-Excel Worksheet by pressing?
Ctrl + Space bar
F8 + arrow key
Shift + arrow key
Shift + Space bar
Getting data from a cell located in a different worksheet is called?
Accessing
Referencing
Updating
Functioning
The address of last cell in MS-Excel is?
IV 16384
ZZ 16384
ZX 8192
ZZ 8192
The intersection point of row and column is called?
Pixel
Cell
Track
Pointer
To Add up entries from D6 to D10, we use the formula?
Add D6 to D10
@Sum(D6..D10)
Add D6.. D10
@Add(D6..D10)
The spreadsheet can be used by?
Finance Professionals
Engineers
Stock Brokers
All the above
How many numbers of sheets contain a single spreadsheet?
100
155
230
255
Which of the following is not a valid bar in MS-Excel?
Paint Bar
Title Bar
Formula Bar
Menu Bar
