What is Excel Test?

This Excel test provides you with the top 18 frequently asked questions (multiple choice) in basic Excel.

Excel Test Questions and Answers

Following are the few question and answers to 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.read more?

  • ALT and =CTRL and =ALT and SCTRL and S

Answer: (a)  ALT and =

2 – What is the formula for inserting the Random numbers in excelRandom Numbers In ExcelWe use random numbers in Excel when we wish to generate absolutely random random numbers to randomize our data for a sample evaluation, . In Excel, there are two built-in functions that offer us random numbers in cells: the =RAND() function provides us any value from 0 to 1, and the =RANDBETWEEN() function takes user input for a random number range.read more?

  • 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.read more (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 ()Today ()Today function is a date and time function that is used to find out the current system date and time in excel. This function does not take any arguments and auto-updates anytime the worksheet is reopened. This function just reflects the current system date, not the time.read more

Answer: (a) Now ()

5 – What is a shortcut to insert the table?

  • CTRL+SCTRL+TCTRL+AAlt+T

Answer: (b) CTRL+ T

6 – Shortcut for expanding or collapsing the formula bar?

  • CTRL+ Alt+ ACTRL+ Shift + UCTRL+ Alt + UAlt+ Shift

Answer: (b) CTRL+ Shift + U

7 – X Co. 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 formula shows whether to accept or reject the projects under consideration?

Solution

  • IF(B$13>12,”accept”,”reject”)IF(B13>12,”accept”,”reject”)IF(B$13>12,accept,reject)IF(B13>12,accept,reject)

Answer: (b) IF(B3>13,”accept”,”reject”)

8 – What is the Formula for Rounding off the Number fully without any decimal?

  • =ROUND(NUMBER,0)=ROUND(NUMBER,1)=ROUND(NUMBER,2)=ROUND(NUMBER)

Answer: (a) =ROUND(NUMBER,0)

9 – What is the table tool for evaluating and analyzing the data?

  • Pie chartPie ChartMaking a pie chart in excel can help you with the pictorial representation of your data and simplifies the analysis process. There are multiple kinds of pie chart options available on excel to serve the varying user needs.read moreInsert TableInsert ChartPivot TablePivot TableA Pivot Table is an Excel tool that allows you to extract data in a preferred format (dashboard/reports) from large data sets contained within a worksheet. It can summarize, sort, group, and reorganize data, as well as execute other complex calculations on it.read more

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.read more?

  • CTRL+KCTRL+QCRTL+EALT+K

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 – What is the shortcut for copying the formula from the above row?

  • Ctrl + “Ctrl + ‘Alt + :Alt +’

Answer: (b) Ctrl + ‘

15 – What is the shortcut for copying the value from the above cell?

  • Ctrl + Shift + “Ctrl + “Alt + Shift + “Alt +’

Answer: (a) Ctrl + Shift + “

16 – What is the shortcut for selecting the entire column?

  • Ctrl + SpacebarCtrl + ACtrl + QAlt + Spacebar

Answer: (a) Ctrl + Spacebar

17 – What is the shortcut for activating the previous workbook?

  • Ctrl + Shift + FnCtrl + Shift + TabCtrl + Shift + SpacebarCtrl + Shift + Capslock

Answer: (b) Ctrl + Shift + Tab

18 – What is the 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 article has been a guide to What Excel Test is and its definition. Here, we discuss the top 18 Excel test questions with answers. You can learn more about it from the following articles: –

  • Excel Interview QuestionsCtrl-Shift Enter in Excel#VALUE! Error in ExcelExcel Group Sum