announcement

Share the latest technology trends or photos of gadgets you love.

Quiz to Test Your Basic Microsoft Excel Skills

Quiz to Test Your Basic Microsoft Excel Skills

For those of you who need to use Microsoft Excel spreadsheets very frequently, knowing shortcuts and important little things about its usage becomes a very essential necessity. We have come up with a basic excel test that will test your skills and help you know more about this software.
Christina Andrew
Last Updated: Apr 9, 2018
How Microsoft Excel Came into Existence
The first ever electronic spreadsheet was VisiCalc, to which Microsoft created MultiPlan in 1982 as a competitor. However, it lost fame to Lotus 1-2-3 on MS-DOS systems. This drove Microsoft to create Excel for Mac OS in 1985 and for Windows in 1987.
Any software takes some time to learn, and having used it just a couple of times doesn't make us an expert on it. So is the case with Microsoft Excel. The use of spreadsheets has made organizing, billing, accounting, and more, a piece of cake. It has a vast functionality and can do anything you can imagine and would want in your spreadsheet. These functionalities include date and time functions, engineering functions, financial functions, information functions, logical functions, lookup and reference functions, math and trigonometry functions, statistical functions, text functions, external functions, and so on.

This basic quiz we have for you is informative, helpful, and would test your Excel skills! Take the quiz to know where you stand!
1. Which keyboard shortcut will you use to switch between the worksheet tabs?
  • A. ALT + TAB
  • B. ALT + PgDn
  • C. CTRL + UpArrow
  • D. CTRL + PgDn

2. Does every formula in Excel start with an equal sign?
  • A. Yes
  • B. No

3. When you press CTRL + Plus (+) when a row is selected, what will happen?
  • A. The contents of the row will be copied
  • B. The SUM of the values in the row will be calculated
  • C. A new row will be inserted below the selected row
  • D. A new row will be inserted above the selected row

4. What will happen if you press CTRL + 2?
  • A. Text in the selected cells will be underlined
  • B. Bold formatting will be applied to the text in the selected cells
  • C. Italics formatting will be applied to the text in the selected cells
  • D. Two copies of the selected text will be inserted into the same worksheet

5. Which keyboard shortcut will you use to enter the system date into a cell?
  • A. CTRL + #
  • B. CTRL + ;
  • C. CTRL + :
  • D. CTRL + *

6. Which function key should be used to repeat the previous action?
  • A. F2
  • B. F4
  • C. F6
  • D. F8

7. Can you enter formulas at the end of rows and at the bottom of columns?
  • A. Yes
  • B. No

8. Which function should you use to change a list of randomly capitalized names to appropriately capitalized names?
  • A. UPPER
  • B. TRIM
  • C. PROPER

9. What does the red triangle at the top-right corner of a cell signify?
  • A. An error has occurred in the cell
  • B. A comment is associated with the cell
  • C. No formula can be entered into the cell
  • D. The font color for text in the cell is red

10. It is possible to insert an image from a file into an Excel spreadsheet. True or False?
  • A. True
  • B. False

11. How can a hyperlink be created in text in Excel?
  • A. By copying the URL to clipboard, selecting the text and following edit --> paste special --> paste hyperlink
  • B. By selecting the text and following insert --> hyperlink --> enter URL
  • C. By browsing hyperlink location in Internet Explorer and selecting Add Favorite, then in the Excel selecting text and following tools --> paste URL

12. If you press Ctrl+9 when a row is selected, what will happen?
  • A. The selected row(s) will be hidden
  • B. A new row above the selected row will be inserted
  • C. The row will be deleted
  • D. The content of the row will be copied to the clipboard

13. What will happen if you press Ctrl+' ?
  • A. Quote marks will be added around the contents of the cell
  • B. Value from the cell above the active cell will be copied
  • C. Formula from the cell above the active cell will be copied
  • D. A new blank cell will be inserted

14. What will happen if you press Shift+F2?
  • A. You can edit the active cell
  • B. You can open the Insert/Edit comment box
  • C. The Insert Function dialog box is displayed
  • D. A new blank cell is inserted

15. Which shortcut key should you use to display the function dialog box?
  • A. Ctrl+F5
  • B. F5
  • C. F3
  • D. Shift+F3

16. What will happen if you press Ctrl+"?
  • A. Quote marks will be added around the contents of the cell
  • B. The value from the cell above the active cell will be copied
  • C. The formula from the cell above the active cell will be copied
  • D. A new blank cell will be inserted

17. Having the same function, what do the shortcut keys Ctrl+T and Ctrl+L do?
  • A. Open the font dialog box
  • B. Select the text in the active cell
  • C. Display the Create Table dialog box
  • D. Display the Layout dialog box

18. What will happen if you press Ctrl+Shift+~?
  • A. Text formatting
  • B. Italics will be applied to contents of the cell
  • C. General number formatting will be applied
  • D. A minus sign will be put in front of a number

19. Which keyboard shortcut should you use to select a row of active cells?
  • A. SHIFT + SPACEBAR
  • B. CTRL + SPACEBAR
  • C. SHIFT + END
  • D. CTRL + END

Your score is 0 out of 19.