Excel Quiz 29 Posted on January 9, 2016September 25, 2021 by Vijay A. Verma Quiz 29 This is a general quiz to test your Excel knowledge. There are a total of 10 questions to answer. To pass, you need to answer at least 6 questions correctly. Please fill in your Name & Email to take the Quiz (Name and E Mail are not shared with anybody else. E Mail is used to mail the pdf certificate to you when you pass) 1 / 10 What is the maximum number of arguments in a function 512 256 255 64 2 / 10 An Excel formula can start with % @ # + 3 / 10 What does the following formula do? =SUM(Sheet1:Sheet6!A1) Equals to the value stored in A1 of Sheet6 Sums up the values contained in A1 of all sheets between Sheet1 and Sheet6, Sheet1 and Sheet6 excluded Equals to the value stored in A1 of Sheet1 Sums up the values contained in A1 of all sheets between Sheet1 and Sheet6, Sheet1 and Sheet6 included 4 / 10 To copy and paste the column data into row, what functionality to use Transpose Transfer Reverse Paste Horizontal Paste 5 / 10 What does following short cut do? CTRL+SHIFT+1 Formats a number with two decimal places and puts thousand separator and puts a negative sign for negative number Formats a number with thousand separator Formats a number with two decimal places and puts thousand separator Formats a number with two decimal places and puts thousand separator and puts removes negative sign from negative number 6 / 10 To go to the next line within the same cell Press ALT+TAB Press Enter PRESS CTRL+Enter Press ATL+Enter 7 / 10 What would be the answer for =REPLACE("TIMOTHY",2,0,"g") T gIMOTHY TGIMOTHY TgIMOTHY TMOTHY 8 / 10 What would be the answer for following =SUBSTITUTE("TIMOTHY","m","k") TIkOTHY TImOTHY TIKOTHY TIMOTHY 9 / 10 How do you recognize an active cell Cell has a dotted border Cell becomes red Cell has bold text Dark border which a square in lowermost right corner 10 / 10 What would be the answer for following =ODD(-8) -7 9 7 -9 Your score is LinkedIn Facebook Twitter Retake quiz Exit
