WorksheetsExcel Multiple Choices
Total questions: 30
Worksheet time: 16mins
What is the intersection of a column and a row on a worksheet called ?
Column
Address
Cell
Formula bar
Which one is not a Function in MS Excel ?
VLOOKUP
MAX
SUM
AVG
The Excel worksheet contains _______ columns.
16394
16384
16398
16388
What is the function used to find the highest value in a range of cells in MS Excel ?
MIN
MAX
AVERAGE
SUM
Which function is used to search for a value in the first column of a table and return a value in the same row from another column ?
VLOOKUP
HLOOKUP
INDEX
MATCH
What is the shortcut key to open the 'Format Cells' dialog box in MS Excel ?
Ctrl + F
Ctrl + Shift + F
Ctrl + 1
Ctrl + 2
What function is used to return the remainder after a number is divided by another number in MS Excel ?
MOD
ROUND
CEILING
FLOOR
How many worksheets can a workbook contain in MS Excel ?
256
255
257
No Limit
Which function is used to count the number of cells that contain numbers in MS Excel ?
COUNT
COUNTA
COUNTIF
COUNTBLANK
What is the function used to find the lowest value in a range of cells in MS Excel ?
MIN
MAX
AVERAGE
SUM
How can you freeze the first row and first column in MS Excel ?
Freeze Panes
Split
Lock Cells
Hide
Which function is used to round a number down to the nearest integer in MS Excel ?
ROUND
ROUNDDOWN
ROUNDUP
CEILING
What is the shortcut key to open the 'Find and Replace' dialog box in MS Excel ?
Ctrl + F
Ctrl + Shift + F
Ctrl + H
Ctrl + R
How many rows are there in an Excel worksheet by default ?
1048576
65536
524288
262144
What is the function used to find the average value in a range of cells in MS Excel ?
MIN
MAX
AVERAGE
SUM
Which function is used in Excel to enter current date & Time?
Today()
Now()
Date()
CurrentDate()
To fix the formula in a cell so that absolute cell reference is used, _____ key is used in Excel.
F2
F3
F4
F8
The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is
C1:10H
C1:H10
C1:H-10
C1:H:10
In Excel, which of the following is Text Concatenation operator?
"
*
$
&
In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Workday
Networkdays
Date
EDate
In MS-Excel which of the following is an absolute cell reference?
$A1
$A$1
A$1
A1
What option displays row data in a column or column data in a row?
Hyperlinks
Rows
Column
Transpose
In Excel, to remove extra spaces with in data which function you can use?
PROPER
TRIM
FIND
REPT
_________ function we can use to find out the Principal payment in excel
NPER
PPMT
PMT
IPMT
Which function can u use to convert text values into numeric values
T()
VALUE()
NUMERIC()
TEXT()
What is the function used to count the number of cells that are not empty in MS Excel ?
COUNT
COUNTA
COUNTIF
COUNTBLANK
To apply a currency format to a cell in Excel, you would use the format button in the
Font group on the Home tab
Number group on the Home tab
Alignment group on the Home tab
Styles group on the Home tab
Which function in Excel is used to count the number of cells that meet a specific condition?
COUNT
COUNTIF
SUMIF
COUNTA
Which Excel feature allows you to summarize data from multiple sheets or workbooks?
Consolidate
Merge
Link
Group
What does the formula =IF(A1>B1, "Yes", "No") do in Excel?
Adds A1 and B1 if they are greater than zero
Checks if A1 is greater than B1 and returns "Yes" if true, otherwise "No"
Multiplies A1 and B1
Checks if A1 equals B1 and returns "Yes" if true, otherwise "No"
