WorksheetsExcel Functions
Total questions: 20
Worksheet time: 50mins
which of the following VLOOKUP formulas should be entered in cell B2 to show the result "8.2%"
=VLOOKUP(B1,A5:C8,2,FALSE)
=VLOOKUP(B1,A5:C8,2,TRUE)
=VLOOKUP(B1,A5:C8,3,FALSE)
=VLOOKUP(B1,A5:C8,3,TRUE)
If you want to generate values for a target output by changing multiple inputs and setting multiple constraints on the inputs, you should use the ______ function in Excel.
Solver
Scenario
Goal Seek
Data Table
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of above
When starting a formula what is the first thing you type in the cell?
&
=
%
+
When number signs (#####) are displayed in the cell, it means:
The formula in the cell is wrong
There are too many characters in the cell to be displayed with the current cell width
The decimal point placement in the cell is wrong
The function COUNTA is specific for _________________
Counting text
Counting cells
Counting number
Counting tables
What is the result of this statement: IF(5>4 AND 4>5, 1, 2)?
TRUE
2
1
FALSE
Use CONCATENATE to combine the text strings in cells A1, B2, and C3.
CONCATENATE(A1:B2:C3)
CONCATENATE(ALL)
CONCATENATE(A1,B2,C3)
CONCATENATE(A1B2C3)
Which function returns the number of characters in cell T4?
TEXTLENGTH(T4)
EXACT(T4)
LEN(T4)
CHAR(T4)
=RIGHT("COMFORTABLE",5)
TABLE
COMFO
=LEFT("TECHNOLOGY",4)
LOGY
TECH
=CONCATENATE("ICSE", "-","CURRICULUM")
icse-curriculum
ICSE-CURRICULUM
=ROUND(7.1467,2)
7.14
7.15
A_________ is a built in mathematical formula included in excel.
Function
Cell
Formula
=COUNT("apple",100,125,150,"orange")
5
2
3
null
=INT(79.99) will return what value?
79
79.9
80
None of these
What does the function TRIM do in Excel?
Removes leading and trailing spaces from a text string
Converts text to uppercase
Counts the number of characters in a text string
None of the above
How can you freeze panes in Excel?
Go to View tab and click on Freeze Panes
Use the shortcut Alt + F4
Right-click on the cell and select Freeze Panes
Freezing panes is not possible in Excel
What is the purpose of the CONCAT function in Excel?
To concatenate two or more strings
To count the number of characters in a cell
To round off a number to the nearest integer
To find the maximum value in a range of cells
What does the function CONCATENATE do in Excel?
Combines two or more strings
Converts text to uppercase
Counts the number of characters in a text string
None of the above
