Excel Quiz - Compute Expert

# Excel Quiz

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

## 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
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 …
2. Title bar
3. Formula bar
4. Toolbar
5. All correct

See the answer to the above question

Microsoft Excel is a … software
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
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
3. Excel file
4. Word document
5. None of the above

See the answer to the above question

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. *

See the answer to the above question

Which category in the Excel Options dialog box contains the option to change the user name?
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

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:

Get updated excel info from Compute Expert by registering your email. It's free!