WorksheetsCH.4 Excel- Formula and Functions
Total questions: 10
Worksheet time: 5mins
Q.1 What is the extension of excel file?
.xlsx
.pptx
.docx
.psd
Q.2 Every cell in a worksheet has a unique address, also called__________
Cell
Row
Cell Reference
Cell Range
Q.3 _______ operators used to perform mathematical calculations.
Comparison
Reference
Arithmetic
Logical
Q.4 All formula begin with ________ sign in Excel.
+
&
/
=
Q.5 _________ is a sequence of cell reference and operators to do calculations.
Reference
Formula
Value
Variable
Q.6 The range reference includes both anchor points separated by ____________
Colon
Hyphen
Comma
Semi comma
Q.7 A range name must start with a ______________
Number
Letter
Symbol
Equal Sign
Q.8 A group of related cells in a worksheet is called a ____________
Address
Cell Reference
Cell Range
Row
Q.9 Which function is used to find loan term in Excel?
Goal Seek
Sum
Average
PMT
Q.10 What is the meaning of argument in Excel function?
Cell Reference
Column
Cell Range
Row address
