﻿ Techflames - Online
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