|
Name*
|
|
|
Company
|
|
|
Email*
|
|
|
Phone*
|
|
|
Human Verification-Enter code:
|
|
|
1) Which of this is not a correct way to add a new sheet ?
|
None of the below
Click Insert Worksheet tab.
Shift+F11
Right click any sheet and click on Insert worksheet
|
|
2) Which shortcut is used to get today's date ?
|
None of the below
Ctrl+;
Ctrl+@
Ctrl+T
|
|
3) Which shortcut changes time to a dd-mmm-yyyy format ?
|
None of the below
Ctrl+Shift+2
Ctrl+Shift+3
Ctrl+Shift+F2
|
|
4) Which is the best alternate to Merge and Center ?
|
None of the below
Wrap Text
Center Across Selection
Merge Horizontal
|
|
5) Which is the quick and best method to know sum of few cells ?
|
None of the below
Select the cells and check status bar
Write a sum formula in another cell
Use a calculator
|
|
6) Which option is not a correct way to paste only formats ?
|
None of the below
Copy-PasteSpecial-Formats
Format Painter
Conditional Formatting
|
|
7) Which is the correct method to freeze cell H7 in a formula ?
|
None of the below
=G7*$H7$
=G7*H$7
=G7*$H$7
|
|
8) Which tab in the ribbon has the option to remove gridlines ?
|
None of the below
Home
View
Review
|
|
9) Which formula will extract month name from a date ?
|
None of the below
Text
Format
MonthName
|
|
10) Which of these is not a correct way to go to a named range ?
|
None of the below
Ctrl+G (Goto)
Select Named range from Name Box
Enter the named range in formula bar
|
|
11) If a1=20,a2=30,a3=40 then what is the formula for average ?
|
None of the below
=AVERAGE(A1:A3)
=AVG(A1:A3)
=AVG(A1,A2,A3)
|
|
12) Which of these is a correct IF Function ?
|
None of the below
=IF(A1>35,Pass,Fail)
=IF(A1>35,"Pass","Fail")
=IF(A1>"35","Pass","Fail")
|
|
13) Which of these function would be used to sum a column based on multiple conditions ?
|
None of the below
SumIF
SumIFs
SumAndIF
|
|
14) Which of these formula will give the count of non-empty cells ?
|
None of the below
Count
Counta
Countblank
|
|
15) What is the shortcut to copy the first value till the end in a selection ?
|
None of the below
Ctrl+R
Ctrl+Down Arrow
Ctrl+D
|
|
|