Excel Quiz

On this page, you can test your excel knowledge through some excel quiz questions.

Excel is a great software that we can use for various purposes. If we have more knowledge about it, then we can most probably maximize its potential further to help us.

Should we want to gauge our excel knowledge, one way to do it is by answering some excel questions. From there, we can understand what we still don’t know about excel and can make our learning plans accordingly.

Thus, this is why Compute Expert has created this page for you. We hope by testing yourself through some questions here, you will be more knowledgeable about excel. In the end, it can serve as a platform for your improvement in mastering excel usage further.

Want to start answering our excel quiz questions right away? Take a look at the list of the questions below immediately!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Excel Quiz Questions

Here are some questions we have gathered that can test your knowledge about excel. We will add more when we find other excel questions that look interesting and useful to answer.

You can see the answer to each question by visiting the link below the question. The page on the link contains the question, answer, and a bit of explanation on the answer if needed.


In excel, columns are labelled as …

1. Letters (A, B, C, …)
2. Numbers (1, 2, 3, …)
3. Rows
4. Letters and numbers (A1, B1, A2, …)
5. None of the above

See the answer to the above question


Microsoft Excel’s main use is an application we use to…

1. Process text
2. Process numbers
3. Manage documents
4. Communicate
5. Search information

See the answer to the above question


Which of the following is not a part of a worksheet?

1. Column
2. Row
3. Cell
4. Range
5. Query

See the answer to the above question


Which of the following is a valid cell address in excel?

1. 84
2. 3F
3. B5
4. BB
5. F0

See the answer to the above question


Columns are represented by cell sequences …

1. Flatly
2. Horizontally
3. In a landscape orientation
4. Vertically
5. Diagonally

See the answer to the above question


A spreadsheet in Excel is also called as …

1. Worksheet
2. Slide
3. Document
4. Jobsheet
5. Toolsheet

See the answer to the above question


The maximum number of rows and columns in excel is …

1. 256 columns and 65356 rows
2. 256 columns and 65536 rows
3. 256 columns and 65635 rows
4. 265 columns and 65256 rows
5. 256 columns and 63536 rows

See the answer to the above question


The VLOOKUP And HLOOKUP functions are used to read a …

1. Table
2. Data
3. Chart
4. Formula
5. Cell

See the answer to the above question


The right steps to save a file in Ms. Excel are …

1. Office Button - Save - give a file name - Save
2. Office Button - Save - give a file name - OK
3. Office Button - Save - OK
4. Office Button - Save - determine the file location - Save
5. Office Button - Save as - determine the file location - give a file name - Save

See the answer to the above question


Microsoft Excel is most suitable for …

1. Data tables creation, calculation, data visualization, and logic functions
2. Letter writing
3. Office presentation
4. Graphic design
5. Multimedia files creation

See the answer to the above question


Microsoft Excel is a … program

1. Word processor
2. Presentation
3. Animation
4. Spreadsheet
5. Desktop publishing

See the answer to the above question


Which Microsoft software is used to perform mathematical calculations?

1. Microsoft Word
2. Microsoft Excel
3. Microsoft Powerpoint
4. Microsoft Access
5. Microsoft Outlook

See the answer to the above question


One method to save an excel workbook is by using …

1. Ctrl + B
2. Ctrl + P
3. Ctrl + C
4. Ctrl + V
5. Ctrl + S

See the answer to the above question


The right steps to open an excel file are …

1. File - Open
2. File - Open - Computer - My Document
3. File - Open - Computer - My Document
4. File - Open - Computer - My Document - choose a file name - OK
5. File - Open - Computer - My Document - choose a file name - Open

See the answer to the above question


The right steps to create a new excel file are …

1. Office Button - Blank Workbook - OK
2. Office Button - New - Create
3. Office Button - New - Blank Workbook - Create
4. File - New - OK
5. File - Create Workbook - OK

See the answer to the above question


Which of the following is not a statistical function in excel?

1. =AVERAGE( )
2. =COUNT( )
3. =MIN( )
4. =MAX( )
5. =IF( )

See the answer to the above question


Mention the steps to start up Ms. Excel!

1. Start - Program - Ms Office - Ms Word
2. Ms Excel - Start - Program - Ms Office
3. Program - Ms Excel - Start - Ms Office
4. Start - Program - Ms Office - Ms Excel
5. All correct

See the answer to the above question


The intersection between row and column is called …

1. Range
2. Cell
3. Sheet
4. Toolbar
5. Workbook

See the answer to the above question


A group of cells in excel is called …

1. Sheet
2. Column
3. Row
4. Range
5. Gridline

See the answer to the above question


The extension used to save excel files is …

1. “.cdr
2. .xls
3. “.exl
4. pp!
5. .xcl

See the answer to the above question


Which of the following is a logical function in excel?

1. IF
2. SUMIF
3. LOGIF
4. COUNTIF
5. FIND

See the answer to the above question


The file extension used by Excel 2007 is …

1. *.cdr
2. *.xlsx
3. *.ppt
4. *.exlx
5. All correct

See the answer to the above question


The place to write an excel formula is called …

1. Menu bar
2. Title bar
3. Formula bar
4. Toolbar
5. All correct

See the answer to the above question


Microsoft Excel is a … software

1. Spreadsheet
2. Word processor
3. Graphic design
4. Programming language
5. Database application

See the answer to the above question


The title in Microsoft Excel is also called as …

1. Title bar
2. Menu bar
3. Toolbar
4. All wrong
5. All correct

See the answer to the above question


Besides processing numbers, we can also use excel to create …

1. Text
2. Chart
3. Data value
4. Map diagram
5. Presentation file

See the answer to the above question


The steps to change the measurement unit in excel are …

1. Start - Setting - Control Panel - Regional - Currency
2. Tools - Options - Print
3. Office Button - Open
4. Office Button - Excel Options - Save - Default File Location
5. Office Button - Excel Options - Advanced - Display - Ruler Units

See the answer to the above question


We use the … tab to insert a statistical chart in excel

1. Home
2. Insert
3. Page Layout
4. References
5. Mailings

See the answer to the above question


What Excel interface item displays the address of the current cell?

1. Formula bar
2. Name box
3. Status bar
4. Title bar
5. Ribbon

See the answer to the above question


Below are the things we can use Excel for except …

1. Calculate data
2. Create a chart
3. Create a table
4. Create a paper
5. Draw an object

See the answer to the above question


What is the extension name of a Microsoft Excel 2010 file?

1. Xls
2. Ppt
3. Xlsx
4. Doc
5. Exe

See the answer to the above question


Which of the following cannot be used to run Excel?

1. Excel shortcut on the desktop
2. Start menu
3. Excel file
4. Word document
5. None of the above

See the answer to the above question


Which Excel Add-In will help you find a target?

1. Analysis Toolpak
2. Solver
3. Power Query
4. Power Pivot
5. Power BI

See the answer to the above question


The fastest way to choose a chart recommended by Excel is …

1. Pivot Charts
2. All Charts
3. Custom Charts
4. Recommended Charts
5. Combo Charts

See the answer to the above question


Which of the following characters are wildcards in Excel? (Check all that apply)

1. #
2. *
3. ?
4. $
5. @

See the answer to the above question


Which function returns the leftmost five characters in Excel?

1. =TRIM(B3,5)
2. =RIGHT(B3,5)
3. =MID(B3,5)
4. =LEFT(B3,5)
5. =FIRST(B3,5)

See the answer to the above question


Which of the following is a valid cell range in Excel?

1. A1;C4
2. A1-C4
3. A1:C4
4. C4;A1
5. C4:A1

See the answer to the above question


Which of the following is not an Excel function category?

1. Math & Trig
2. Algebra
3. Statistical
4. Text
5. Financial

See the answer to the above question


Which among the following is the divide symbol in Excel?

1. /
2. –
3. (
4. +
5. *

See the answer to the above question


Which category in the Excel Options dialog box contains the option to change the user name?

1. Advanced
2. General
3. Account Settings
4. Trust Center
5. Data

See the answer to the above question


Microsoft Excel is a software program that uses the WYSIWYG system which means …

1. What you get will be seen
2. What you see is what you get
3. What you want is what you get
4. Make calculation processes easier
5. Help to solve problems

See the answer to the above question

Additional Note

You can score yourself too when you go through the questions we have here.

To do that, first, answer the number of questions you want from our questions list (set a time limit and use a timer if you want it to be more challenging!). After you have finished doing that, check the answer for each question you answer to see whether you answer them correctly.

Then, just grade yourself according to the number of questions you got right! For the questions you got wrong, you might want to read the explanation of the answer on the answer link. That way, you can immediately improve your excel knowledge further!



Some excel articles/tutorials you might want to read: