To sort data in excel choose:-
Tools ---> Sort
Data ---> sort
View ---> Sort
Window ---> sort
Excel's _______ provide an easy way to select the function.
Tool bar
Function wizard
Auto sum
None
The key pressed to change the reference
F2
F3
F4
F6
X - axis is the _________ axis.
Vertical
Bottom
Horizontal
None of these
A ________ is a recipe for performing calculations on numerical data.
Function
Constants
Formula
_______ to conduct conditional tests on values and formulas.
IF
LEN
COUNT
LN
Chart is included in _______ menu
File
Insert
Edit
Data
To create mixed reference relative in a cell absolute in row from relative reference press F4
Once
Twice
Thrice
Four times
_________ function returns the absolute value.
COS
LOG
ABS
Chart wizard button is on the.
Standard toolbar
Formatting toolbar
Status bar
Title bar
