Font size
WorksheetsFunctions and calculation in spreadsheet
Total questions: 25
Worksheet time: 13mins
Which feature of excel is used here?
Merge and Centre
Wrap Text
Multiple span
Which feature is used here?
Merge and Center
Wrap Text
Mulltiple span
______ symbol is compulsory to use before any formula
=
+
/
$
What is concatenation?
(a)
Write short cut key for Copy
(a)
Write short cut key for Paste
(a)
You can also copy the formula using the _____
Fill Handle
Merge and Center
Auto Sum
=(c3+c4+c5) changes automatically to =(d3+d4+d5). This is an example of which cell reference?
Absolute
Mixed
Relative
This type of cell reference consists of the column letter and row number, each preceded by a $ sign
Mixed
Absolute
Relative
#REF! is which type of error?
Invalid data
Invalid cell reference
Division by zero
Invalid argument
##### is which error?
Invalid data
column not wide enough to accomodate data
Invalid range name
#N/A is which type of error?
Value not available
Invalid cell reference
Invalid argument
The arguments of a function must be enclosed within brackets
True
False
=COUNT(C5:C10,C16:C20,C29) will count all the cells in the three arguments that are included in parentheses.
True
False
It is the default option of Autosum feature :
Average
Sum
Max
Min
It shows the lowest value in the given range of cells :
Max
Min
To select a range of non-adjacent cells in a formula, separate each cell address by a (a)
A _________ is a set of mathematical instructions used in Excel to perform calculations
Absolute
Formula
Pointing
The SUM() is present under the _______ function category.
Logical
Financial
Maths & Trig
Text
Which function must be used to show current date : (a)
(a) cell reference recognizes the change in location of a cell and updates the formula accordingly.
Which function should be used to calculate the number of characters in a text string : (a)
(a) is a small square used to copy cell contents to the adjacent cells
Cell reference $E1 is a valid mixed cell reference
(a)
What is the default cell reference in Excel 2013?
Absolute
Mixed
Relative
Fixed
