Excel Quiz 7 Posted on March 3, 2015September 24, 2021 by Vijay A. Verma Quiz 7 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 In Excel 2010 / 2013, Conditional Formatting is contained in which tab Home Formulas Data View 2 / 10 You can't copy table from Excel to Word FALSE TRUE 3 / 10 if Shift is held while pressing tab, the movement will be in the direction Right to Left Top to Bottom Left to Right Bottom to Top 4 / 10 CTRL+Home is shortcut for what? Take you to the first cell of the sheet i.e. A1 Takes you to the first unused cell of the sheet Takes you to the first used cell of the sheet Takes you to the last cell of the sheet 5 / 10 If A1 = Vijay and A2 = Smith, then what would be the answer for =Left(A1,1)&Right(A2,1) Vs Vh vS VS 6 / 10 What would be the answer for =TEXT(TODAY(),"ddd") Will give the 3 letter day of the week for today e.g. Sat Will give error Will give full day of the week for today e.g. Saturday Will give the day of the week for today in number format 7 / 10 When do you get #NUM! error? When a number is added to a character When a number is multiplied to True or False When a number is divided by 0 When a formula or function contains numeric values that aren’t vali 8 / 10 What would following formula do? =COUNTIF(A:A,"*") Counts all numeric cells in column A Counts all blank cells in column A Counts all non-numeric cells in column A Counts all non blank cells in column A 9 / 10 If A1=64, what would be the answer for =A1^(1/3) 8 16 4 3 10 / 10 Total number of characters that a cell can contain 32767 16384 256 1024 Your score is LinkedIn Facebook Twitter Retake quiz Exit
