NEW
Font size
WorksheetsMS EXCEL FORMULAS, FUNCTIONS AND ANALYSIS
Total questions: 10
Worksheet time: 3mins
Referencing in =$B3+B$4 formula is
Absolute
Relative
Mixed
Proper
To arrange data in ascending order of age we will
Filter it
Sort it
Apply Conditional Formatting
Rearrange data manually
To display only those records where temperature is below 0 degree you will
Manually extract the data
Sort the data
Filter the data
Use Goto option
To colour those cells blue where temperature is above 50 degree you will
Apply filtering
Use fill colour option
Shade Cells
Use Conditional Formatting
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
To change chart layout, style, type of inserted chart you need to go to
Format Tab
Insert Tab
Design Tab
View Tab
To display the date and time in a manner such that it gets updated automatically you will
Type Date/Time and update it time to time
Use Date and TIme function
Use Today function
Use Now function
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
