What is Excel Test?
Excel Test is the tool to measure the knowledge of the Excel and is usually conducted by the employers during the recruiting process. The aim behind it is to test the skill level in excel as it reduces human work and makes it very easy.
In this excel test, we provide you with the top 18 frequently asked questions (multiple choice questions) in basic excel.
Excel Test Questions and Answers
Following are the few question and answers of the excel test asked by the employers while recruiting the employees –
1 – What is the shortcut key for the AutosumAutosumThe Excel SUM Shortcut is a function that is used to add up multiple values by simultaneously pressing the “Alt” and “=” buttons in the desired cell. However, the data must be present in a continuous range for this function to function.?
- ALT and =
- CTRL and =
- ALT and S
- CTRL and S
Answer: (a) ALT and =
2 – What is the formula for inserting the Random numbers in excel?
- RAND ()
- RANDBETWEENRANDBETWEENRANDBETWEEN excel formula determine random numbers between two extreme variables (bottom and top numbers). The user needs to fill in the bottom and top numbers in the syntax =RANDBETWEEN (bottom, top) to acquire the random integer. (BOTTOM, TOP)
- RANDBETWEEN (TOP, BOTTOM)
- RAND (TOP, BOTTOM)
Answer: (b) RANDBETWEEN (Bottom, Top)
3 – What is the formula for finding the average of numbers?
- AVERAGE (NUMBER1, NUMBER2, MUMBER3, NUMBER….)
- AVERAGE (SUM OF NUMBERS)
- AVERAGE (NUMBER1 + NUMBER 2 + NUMBER 3….)
- AVERAGE (VALUE1, VALUE2, VALUE3…)
Answer: (a) AVERAGE (NUMBER1, NUMBER2, MUMBER3, NUMBER….)
4 – How to find the current date and time in excel?
- Now ()
- Current date ()
- Date time ()
- Today ()
Answer: (a) Now ()
5 – What is a short cut to insert the table?
Answer: (b) CTRL+ T
6 – Shortcut for expanding or collapsing the formula bar?
- CTRL+ Alt+ A
- CTRL+ Shift + U
- CTRL+ Alt + U
- Alt+ Shift
Answer: (b) CTRL+ Shift + U
7 – Company X is looking into three of the potential projects and will accept the project only if the IRR from the project is expected to be 12% or above. What is the formula which shows whether to accepts or Reject the projects under consideration?
Answer: (b) IF(B3>13,”accept”,”reject”)
8 – What is the Formula for Rounding off the Number fully without any decimal?
Answer: (a) =ROUND(NUMBER,0)
9 – What is the table tool for evaluating and analyzing the data?
Answer: (d) Pivot Table
10 – What is the formula for calculating EMI in Excel?
- =PMT (rate,nper,pv)
- =PMT (nper, rate, pv)
- =PMVT (rate, nper, pv)
- =PMET (rate, nper, pv)
Answer: = (a) PMT (rate, nper, pv)
11 – A taken Loan of $ 5,00,000 for 5 years, rate of interest is 9% p.a calculate EMI?
- $ 3750
- $ 3820
- $ 3978
- $ 3650
Answer: (a) $ 3750
12 – What is the shortcut to insert the hyperlinkInsert The HyperlinkTo insert a hyperlink, right-click on the cell, click on hyperlink, and then choose the last option, which will open a wizard box to insert a hyperlink. Then, in the field for an address, type the hyperlink's URL.?
Answer: (a) CTRL+K
13 – What is the shortcut for entering the current time?
- Ctrl + Shift + ;
- Ctrl + Shift + :
- Ctrl + :
- Ctrl + ;
Answer: (b) Ctrl + Shift + :
14 – Shortcut for Copying the Formula from the above row?
- Ctrl + “
- Ctrl + ‘
- Alt + :
- Alt +’
Answer: (b) Ctrl + ‘
15 – Shortcut for Copying the value from the above cell?
- Ctrl + Shift + “
- Ctrl + “
- Alt + Shift + “
- Alt +’
Answer: (a) Ctrl + Shift + “
16 – Shortcut for selecting the entire column?
- Ctrl + Spacebar
- Ctrl + A
- Ctrl + Q
- Alt + Spacebar
Answer: (a) Ctrl + Spacebar
17 – Shortcut for activating the previous workbook?
- Ctrl + Shift + Fn
- Ctrl + Shift + Tab
- Ctrl + Shift + Spacebar
- Ctrl + Shift + Capslock
Answer: (b) Ctrl + Shift + Tab
18 – Formula used for totaling the numbers?
- Sum (the selected numbers)
- Autosum (the selected numbers)
- Total (selected numbers)
- Calculate (the selected numbers)
Answer: (a) Sum (the selected numbers)
This has been a guide to What is Excel Test & its Definition. Here we discuss the top 18 excel test questions with answers. You can learn more about from the following articles –