Font size
WorksheetsMS-EXCEL FUNCTIONS
Total questions: 16
Worksheet time: 8mins
Each spreadsheet is made up of ____________ and ______________
(a)
What is a sheet in Excel?
A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.
A single document that typically contains labels, values, formulas, functions, and graphical representations of data.
A single file that typically contains labels, values, formulas, functions, and graphical representations of data.
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen
The past cell in a worksheet. It is indicated by a dark border onscreen
When starting a formula what is the first thing you type in the cell?
&
=
%
+
What is the Sum formula?
Sum( )
Sum( )=
=( )Sum
=Sum( )
For multiplying numbers in A1 AND B1,you use the following formula
=A1/B1
=A1*B1
A1%B1
A1*B1
To arrange data in ascending order of age we will
Filter it
Sort it
Apply Conditional Formatting
Rearrange data manually
Referencing in =$B3+B$4 formula is
Absolute
Relative
Mixed
Proper
The various elements of a chart are
data label, chart title, legend
data legend, chart title, label
chart legend. chart label, chart title
none of the above
What is the output of the function =if(A1=A2,"Unequal","Equal")
when A1=10 A2 = 11
Equal
Unequal
Error
None of these
A) =Count("String")
B) =Len("String")
Both will give the same output
Both will give an error
A) is correct B) is wrong
A) is wrong B) is correct
Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is
=A4+B5
=A3+B4
=B4+B5
=B3+C4
Tab that provides the facility for sorting
(a)
What is IF?
Takes 3 arguments
Checks a condition takes a suitable action
Collection of unarranged facts
Task that is performed to produce a result
