Excel Assessment

Fill in your basic details before continuing to take the excel test

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
Contact us today at info@upskilltechnologies.com or call us at +91-9985130004