Excel placement test with answers for free
MS Excel proficiency test
Part 1: Theoretical part. ( 60 points )
Question 1: Choose ONLY ONE answer for each of the following questions: ( 35 points )
1 If you need to save an Excel file, you need to press …................ .
a) Ctrl+S b) Alt+S c) Ctrl+V d) Alt+V ( 1 points )
2 The keyboard shortcut to open a new file in Excel is ….............................. .
a) Alt+Tab b) Alt+Insert c) Ctrl+N d) Ctrl+O ( 2 points )
3 Any normal Excel formula should start with …................. .
a) <> b) () c) = d) \\ ( 1 points )
4 The keyboard shortcut to search for text in Excel is ….............................. .
a) Ctrl+S b) Ctrl+F c) Ctrl+R d) Ctrl+G ( 1 points )
5 What is the result of the following formula: =2+5*3-5/10
a) 16.5 b) 1.6 c) -1.4 d) 0.6 ( 4 points )
6 The extension of Excel 2007 file and later versions is ….............. .
a) .exl b) .xlsx c) .exe d) .xls ( 2 points )
7 Excel file can be exported to the following formats except
a) .txt b) .csv c) .pdf d) .ppt ( 2 points )
8 The intersection between a column and a row in an excel sheet is known as .... .
a) format b) border c) cell d) center ( 1 points )
9 How to write 8 to the power of 2 in excel
a) =8*2 b) =8^2 c) =8$2 d) =8#2 ( 2 points )
10 If cell A1 =20%, and we changed its format to number, the result will be...
a) 0.2 b) 20 c) 20% d) 2000 ( 2 points )
11 What are the Arabic numbers ?
a) 1,2,3… b) ١,٢,٣… c) i,ii,iii,… d) 一,二,三,… ( 3 points )
12 When B2=10% ,the result of this formula =IF(B2>0.2,"X","Y") is
a) 0.2 b) 10 c) X d) Y ( 3 points )
13 What is the Boolean data type in excel?
a) Numbers b) True,False c) Text d) errors ( 3 points )
14 To start a new line in the same cell , the keyboard shortcut is … .
a) Shift+Enter b) Ctrl+Enter c) Alt+Enter d) Tab+Enter ( 4 points )
15 The formula in B5 is =A$1, if you copied the cell B5 to C10, what would be the formula in C10
a) =A$1 b) =C$10 c) =B$1 d) =B$5 ( 4 points )
Question 2: Write a formula for the following: ( 25 points )
1 Write a formula using the VLOOKUP function, where your look up value is in A1, and your reference table is Table1, and your target is the 3rd column at Table1 , and you need an exact match. ( 10 points )
Answer: =VLOOKUP(A1,Table1,3,False)
2 Write a formula to sum the numbers from 1 to 100 and write its result (the formula should not exceed 10 characters). ( 15 points )
Answer: =100*101/2