Post-Training Excel Assessment

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

Name*
Company
Email*
Phone*
Human Verification-Enter code:
1) Is it possible to hide the ribbon in Excel? None of the below
Yes
No
May be
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-yy format ? None of the below
Ctrl+Shift+2
Ctrl+Shift+3
Ctrl+Shift+F2
4) Which formula extracts the day from a date ? None of the below
Text
Weekday
Format
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*$H7
8) Which tab in the ribbon has the option to remove gridlines ? None of the below
Home
View
Review
9) Which type of charts can you produce using excel ? None of the below
Bar and Pie Chart only
Only Line Charts
Bar Chart, Line Chart, Pie Charts
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