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!
Table of Contents:
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 …
- Letters (A, B, C, …)
- Numbers (1, 2, 3, …)
- Rows
- Letters and numbers (A1, B1, A2, …)
- None of the above
See the answer to the above question
Microsoft Excel’s main use is an application we use to…
- Process text
- Process numbers
- Manage documents
- Communicate
- Search information
See the answer to the above question
Which of the following is not a part of a worksheet?
- Column
- Row
- Cell
- Range
- Query
See the answer to the above question
Which of the following is a valid cell address in excel?
- 84
- 3F
- B5
- BB
- F0
See the answer to the above question
Columns are represented by cell sequences …
- Flatly
- Horizontally
- In a landscape orientation
- Vertically
- Diagonally
See the answer to the above question
A spreadsheet in Excel is also called as …
- Worksheet
- Slide
- Document
- Jobsheet
- Toolsheet
See the answer to the above question
The maximum number of rows and columns in excel is …
- 256 columns and 65356 rows
- 256 columns and 65536 rows
- 256 columns and 65635 rows
- 265 columns and 65256 rows
- 256 columns and 63536 rows
See the answer to the above question
The VLOOKUP And HLOOKUP functions are used to read a …
- Table
- Data
- Chart
- Formula
- Cell
See the answer to the above question
The right steps to save a file in Ms. Excel are …
- Office Button - Save - give a file name - Save
- Office Button - Save - give a file name - OK
- Office Button - Save - OK
- Office Button - Save - determine the file location - Save
- 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 …
- Data tables creation, calculation, data visualization, and logic functions
- Letter writing
- Office presentation
- Graphic design
- Multimedia files creation
See the answer to the above question
Microsoft Excel is a … program
- Word processor
- Presentation
- Animation
- Spreadsheet
- Desktop publishing
See the answer to the above question
Which Microsoft software is used to perform mathematical calculations?
- Microsoft Word
- Microsoft Excel
- Microsoft Powerpoint
- Microsoft Access
- Microsoft Outlook
See the answer to the above question
One method to save an excel workbook is by using …
- Ctrl + B
- Ctrl + P
- Ctrl + C
- Ctrl + V
- Ctrl + S
See the answer to the above question
The right steps to open an excel file are …
- File - Open
- File - Open - Computer - My Document
- File - Open - Computer - My Document
- File - Open - Computer - My Document - choose a file name - OK
- 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 …
- Office Button - Blank Workbook - OK
- Office Button - New - Create
- Office Button - New - Blank Workbook - Create
- File - New - OK
- File - Create Workbook - OK
See the answer to the above question
Which of the following is not a statistical function in excel?
- =AVERAGE( )
- =COUNT( )
- =MIN( )
- =MAX( )
- =IF( )
See the answer to the above question
Mention the steps to start up Ms. Excel!
- Start - Program - Ms Office - Ms Word
- Ms Excel - Start - Program - Ms Office
- Program - Ms Excel - Start - Ms Office
- Start - Program - Ms Office - Ms Excel
- All correct
See the answer to the above question
The intersection between row and column is called …
- Range
- Cell
- Sheet
- Toolbar
- Workbook
See the answer to the above question
A group of cells in excel is called …
- Sheet
- Column
- Row
- Range
- Gridline
See the answer to the above question
The extension used to save excel files is …
- “.cdr
- .xls
- “.exl
- pp!
- .xcl
See the answer to the above question
Which of the following is a logical function in excel?
- IF
- SUMIF
- LOGIF
- COUNTIF
- FIND
See the answer to the above question
The file extension used by Excel 2007 is …
- *.cdr
- *.xlsx
- *.ppt
- *.exlx
- All correct
See the answer to the above question
The place to write an excel formula is called …
- Menu bar
- Title bar
- Formula bar
- Toolbar
- All correct
See the answer to the above question
Microsoft Excel is a … software
- Spreadsheet
- Word processor
- Graphic design
- Programming language
- Database application
See the answer to the above question
The title in Microsoft Excel is also called as …
- Title bar
- Menu bar
- Toolbar
- All wrong
- All correct
See the answer to the above question
Besides processing numbers, we can also use excel to create …
- Text
- Chart
- Data value
- Map diagram
- Presentation file
See the answer to the above question
The steps to change the measurement unit in excel are …
- Start - Setting - Control Panel - Regional - Currency
- Tools - Options - Print
- Office Button - Open
- Office Button - Excel Options - Save - Default File Location
- 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
- Home
- Insert
- Page Layout
- References
- Mailings
See the answer to the above question
What Excel interface item displays the address of the current cell?
- Formula bar
- Name box
- Status bar
- Title bar
- Ribbon
See the answer to the above question
Below are the things we can use Excel for except …
- Calculate data
- Create a chart
- Create a table
- Create a paper
- Draw an object
See the answer to the above question
What is the extension name of a Microsoft Excel 2010 file?
- Xls
- Ppt
- Xlsx
- Doc
- Exe
See the answer to the above question
Which of the following cannot be used to run Excel?
- Excel shortcut on the desktop
- Start menu
- Excel file
- Word document
- None of the above
See the answer to the above question
Which Excel Add-In will help you find a target?
- Analysis Toolpak
- Solver
- Power Query
- Power Pivot
- Power BI
See the answer to the above question
The fastest way to choose a chart recommended by Excel is …
- Pivot Charts
- All Charts
- Custom Charts
- Recommended Charts
- Combo Charts
See the answer to the above question
Which of the following characters are wildcards in Excel? (Check all that apply)
- #
- *
- ?
- $
- @
See the answer to the above question
Which function returns the leftmost five characters in Excel?
- =TRIM(B3,5)
- =RIGHT(B3,5)
- =MID(B3,5)
- =LEFT(B3,5)
- =FIRST(B3,5)
See the answer to the above question
Which of the following is a valid cell range in Excel?
- A1;C4
- A1-C4
- A1:C4
- C4;A1
- C4:A1
See the answer to the above question
Which of the following is not an Excel function category?
- Math & Trig
- Algebra
- Statistical
- Text
- Financial
See the answer to the above question
Which among the following is the divide symbol in Excel?
- /
- –
- (
- +
- *
See the answer to the above question
Which category in the Excel Options dialog box contains the option to change the user name?
- Advanced
- General
- Account Settings
- Trust Center
- Data
See the answer to the above question
Microsoft Excel is a software program that uses the WYSIWYG system which means …
- What you get will be seen
- What you see is what you get
- What you want is what you get
- Make calculation processes easier
- 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: