WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Test

Excel Test

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 Autosum?

  1. ALT and =
  2. CTRL and =
  3. ALT and S
  4. CTRL and S

Answer: (a)  ALT and =

2 – What is the formula for inserting the Random numbers in excel?

  1. RAND ()
  2. RANDBETWEEN (BOTTOM, TOP)
  3. RANDBETWEEN (TOP, BOTTOM)
  4. RAND (TOP, BOTTOM)

Answer: (b) RANDBETWEEN (Bottom, Top)

3 – What is the formula for finding the average of numbers?

  1. AVERAGE (NUMBER1, NUMBER2, MUMBER3, NUMBER….)
  2. AVERAGE (SUM OF NUMBERS)
  3. AVERAGE (NUMBER1 + NUMBER 2 + NUMBER 3….)
  4. AVERAGE (VALUE1, VALUE2, VALUE3…)

Answer: (a) AVERAGE (NUMBER1, NUMBER2, MUMBER3, NUMBER….)

4 – How to find the current date and time in excel?

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  1. Now ()
  2. Current date ()
  3. Date time ()
  4. Today ()

Answer: (a) Now ()

5 – What is a short cut to insert the table?

  1. CTRL+S
  2. CTRL+T
  3. CTRL+A
  4. Alt+T

Answer: (b) CTRL+ T

6 – Shortcut for expanding or collapsing the formula bar?

  1. CTRL+ Alt+ A
  2. CTRL+ Shift + U
  3. CTRL+ Alt + U
  4. 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?

Excel Test - question 7

Solution

Excel Test - question 7.1

  1.  IF(B$13>12,”accept”,”reject”)
  2. IF(B13>12,”accept”,”reject”)
  3. IF(B$13>12,accept,reject)
  4. 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?

  1. =ROUND(NUMBER,0)
  2. =ROUND(NUMBER,1)
  3. =ROUND(NUMBER,2)
  4. =ROUND(NUMBER)

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

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

  1. Pie chart
  2. Insert Table
  3. Insert Chart
  4. Pivot Table

Answer: (d) Pivot Table

10 – What is the formula for calculating EMI in Excel?

  1. =PMT (rate,nper,pv)
  2. =PMT (nper, rate, pv)
  3. =PMVT (rate, nper, pv)
  4. =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?

  1. $ 3750
  2. $ 3820
  3. $ 3978
  4. $ 3650

Answer: (a) $ 3750

12 – What is the shortcut to insert the hyperlink?

  1. CTRL+K
  2. CTRL+Q
  3. CRTL+E
  4. ALT+K

Answer: (a) CTRL+K

13 – What is the shortcut for entering the current time?

  1. Ctrl + Shift + ;
  2. Ctrl + Shift + :
  3. Ctrl + :
  4. Ctrl + ;

Answer: (b) Ctrl + Shift + :

14 – Shortcut for Copying the Formula from the above row?

  1. Ctrl + “
  2. Ctrl + ‘
  3. Alt + :
  4. Alt +’

Answer: (b) Ctrl + ‘

15 – Shortcut for Copying the value from the above cell?

  1. Ctrl + Shift + “
  2. Ctrl + “
  3. Alt + Shift + “
  4. Alt +’

Answer: (a) Ctrl + Shift + “

16 – Shortcut for selecting the entire column?

  1. Ctrl + Spacebar
  2. Ctrl + A
  3. Ctrl + Q
  4. Alt + Spacebar

Answer: (a) Ctrl + Spacebar

17 – Shortcut for activating the previous workbook?

  1. Ctrl + Shift + Fn
  2. Ctrl + Shift + Tab
  3. Ctrl + Shift + Spacebar
  4. Ctrl + Shift + Capslock

Answer: (b) Ctrl + Shift + Tab

18 – Formula used for totaling the numbers?

  1. Sum (the selected numbers)
  2. Autosum (the selected numbers)
  3. Total (selected numbers)
  4. Calculate (the selected numbers)

Answer: (a) Sum (the selected numbers)

Recommended Articles

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 –

  • Excel Interview Questions
  • Ctrl-Shift Enter in Excel
  • #VALUE! Error in Excel
  • Excel Group Sum
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

New Year Offer - All in One Financial Analyst Bundle (250+ Courses, 40+ Projects) View More