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…

Top Trending

Excel Intermediate 2013

CLICK HERE to access the training videos for this course.

Questions: 29 | Attempts: 1769 | Last updated: May 4, 2016

Sample Question
From the following list, select the choice that is a 3D formula in Excel.

(A) =SUM(Sheet1!A1,A2,A3)

(B) =SUM(Sheet2!C2-Sheet2!D3)

(C) =SUM(Sheet3!$A:$A)

(D) =SUM(Sheet1:Sheet2!A1)

Microsoft Excel Quiz Questions And Answers

Questions: 22 | Attempts: 1951 | Last updated: Apr 25, 2018

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

Quiz: Take The Ms Excel Assessment Test Questions

Quiz: Take The MS Excel Assessment Test Questions

Questions: 25 | Attempts: 1864 | Last updated: Oct 23, 2020

Sample Question
When pound signs (

##) appear in a cell, it means you have an incorrect formula.

True

False

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: 800 | 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

Microsoft Excel

Choose the correct answer from the choices provided.

Questions: 10 | Attempts: 303 | Last updated: Jun 18, 2013

Sample Question
The ___calculates totals automatically.

Auto Format

Auto Sum

Auto Fill

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