Excel Quizzes & Trivia

Do you know MS Excel well? I'm referring to Microsoft's spreadsheet if you can't tell. If you've spent some time moving from worksheet to worksheet, you could say some of its functions are quite neat. We have a spreadsheet (actually just web pages) of quizzes for you. It's time to show that you are an Excel guru.

Do you know how to convert a number into text data? What's the easiest way to fill a series? How do you create charts and tables? What kind of operations can you perform using formulas? This is all but basic. The solution can come with a mouse click. It's really not that tough, just some elementary stuff. Give it a try! You might just excel in these quizzes…

Questions: 22 | Attempts: 3543 | Last updated: Dec 16, 2020

Sample Question
Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Count

Average

Sum

Data Analyst Excel Quiz

A Data Analyst is skilled enough to translate numbers into comprehensible words and meanings of business data, sales and logistics. He collects the data and information and uses it to promote a company or help it make a...

Questions: 10 | Attempts: 1923 | Last updated: Aug 17, 2020

Sample Question
What add-in program serves as the data analyzing tool in Excel?

Excel Analyse

Analyse Tool Excel

Analyz Tools

Analysis Toolpak

Scenario Manager In Excel Quiz: Test!

Questions: 10 | Attempts: 1064 | Last updated: Sep 29, 2020

Sample Question
What term refers to a specific set of values saved with the workbook?

Range

Scenario

Trend line

What-if analysis

Goal Seek

Questions: 8 | Attempts: 1069 | Last updated: Jan 24, 2013

Sample Question
What Excel feature will tell you how to achieve your desired output?

Data Table

Data Validation

Scenarios

Goal Seek

Cmp 540 Excel Trivia Questions Quiz

CMP 540 Excel Trivia Questions Quiz

After taking the Excel tutorial, take this quiz.

Questions: 8 | Attempts: 3021 | Last updated: Jun 7, 2019

Sample Question
The advantage of using a spreadsheet is:

Calculations can be done automatically.

Changing data automatically updates calculations (as long as Excel is not set to calculate manually).

More flexibility.

All of the above.

Topics

advanced excel Advanced Excel Quizzes

word Word Quizzes

Computer Software Computer Software Quizzes

Word Processor Word Processor Quizzes

Microsoft Office Microsoft Office Quizzes

Word Word Quizzes

Computer Computer Quizzes

Excel Questions & Answers

What is the first thing that you have to enter when typing an equation into a cell?

The first thing that you have to enter when you want to write a formula through excel is the equal sign. If you would start the formula with something else, expect that you are going to get the error message. A red triangle may appear on the side of

What would the resulting formula be?

The correct answer to this question is =$c$3d3 . This formula would be used in Microsoft Excel, which is a spreadsheet program. It was released on September 30, 1985 and is the most used spreadsheet program. Microsoft Excel is compatible with de

Which steps is the quickest way to copy formatting from a selected cell to other cells(on the same worksheet)?

The quickest way to copy formatting from a selected cell to two other cells on the same worksheet is to click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to. This is a procedure that is done

What is the difference between Rows and Columns?

Rows and columns refer to how things are arranged either vertically or horizontally. Rows are horizontal, from left to right, and columns are organized vertically from top to bottom. When describing a row of things or people, we refer to these being