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 Quizzes

Excel Intermediate 2013 Quiz

Here is an interesting quiz about 'Excel Intermediate 2013' that is designed to test your knowledge of this subject. Do you have a good understanding of the Excel Intermediate 2013? If your answer is yes, then you must...

Questions: 29 | Attempts: 12507 | Last updated: Nov 23, 2021

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

Could You Pass The Ms Excel Assessment Trivia Quiz?

Could You Pass The MS Excel Assessment Trivia Quiz?

Microsoft Excel is a spreadsheet software program provided by Microsoft Office suite, used for creating spreadsheets in the form of rows and columns like a big table. It is the most popular program used since 1985 for...

Questions: 10 | Attempts: 3518 | Last updated: Jun 19, 2019

Sample Question
How do you spell check an Excel worksheet?

Under the Tools menu, click Spelling.

Press F7.

Click the button with ABC Check Mark icon.

Any of the above will perform a spell check.

Scenario Manager In Excel Quiz: Test!

Questions: 10 | Attempts: 2078 | 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: 1793 | 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

Recent Quizzes

Office 365: Word, Excel And PowerPoint Assessment

Office 365: Word, Excel and PowerPoint Assessment

Questions: 10 | Attempts: 52 | Last updated: Jan 3, 2020

Sample Question
Times New Roman, Comic Sans, Calibri are called ...........

Fonts

Variations

Font Sizes

Basic Excel Quiz For Learners!

Basic Excel Quiz for Learners!

SMAN1 Bunguran Timur Laut

Questions: 8 | Attempts: 118 | Last updated: May 3, 2019

Sample Question
What is an cell?

In a spreadsheet, the intersection of a row and column.

An elementary unit of storage for data (bit) or power (battery).

A geographic area in a cellular phone system. See cellphone.

Microsoft Excel Trivia Quiz Questions!

Questions: 40 | Attempts: 854 | Last updated: Jul 19, 2019

Sample Question
The Shortcut keyborad for COPY ?

CTRL+V

CTRL+P

CTRL+C

CTRL+Z

Advanced Excel Online Test

The excel online is probably an interesting verdion of the excel, which is not so widely used but interestingly delivers some advanced functions than the traditional version of the excel. It is the only version of excel that is...

Questions: 10 | Attempts: 2205 | Last updated: Mar 15, 2018

Sample Question
Does excel online have advanced sort features?

Yes

No

None

Unknown

Business Analyst Excel Quiz

Business Analyst Excel quiz

A business analyst uses excel software as his main tool of modeling to achieve a certain level of record keeping and reporting required to be informed, up-to-date, and able to track finances accurately and plan for the future. Do...

Questions: 10 | Attempts: 163 | Last updated: Mar 13, 2018

Sample Question
Which of these is not a predefined formula for analysis in excel?

IF

SUM

VLOOKUP

NUL

Data Analyst Excel Quiz

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

Financial And Excel Modelling Quiz

Financial and excel modelling quiz

Financial modeling entails building up an abstract representation, aslo known as a model of a real world financial situation. It is a mathematical build representation which has been assited alot with the use of Microsoft excel....

Questions: 10 | Attempts: 476 | Last updated: May 11, 2021

Sample Question
What is the first step to take while create a model on excel?

Begin the design

Decide on the layout to use

Begin to fill in informations

Contact an accountant

MS Excel Assessment Test: Questions & Answers

Ms Excel Assessment Test: Questions & Answers

Think you are an expert in MS Excel? How much do you know about spreadsheets, cells, columns, etc.? Can you apply formulas on cells to get desired results? Take the online quiz to test your knowledge and brush up on your basics...

Questions: 25 | Attempts: 2577 | Last updated: May 5, 2021

Sample Question
When pound signs (

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

True

False

Weekly Updates For 7/31 - 8/4

Weekly Updates for 7/31 - 8/4

Questions: 5 | Attempts: 67 | Last updated: Aug 14, 2017

Sample Question
Agents can add comments about the Zestimate on an HDP

True

False

Basic Knowledge Test On MS Excel! Quiz

Basic Knowledge Test on MS Excel! Quiz

Questions: 25 | Attempts: 415 | Last updated: Jun 1, 2020

Sample Question
Labels are aligned at the ________ edge of the cell.

Left

Right

Top

Bottom

Basic Excel Trivia Quiz

What we have here is a Basic Excel Trivia Quiz. Most people are not able to understand Microsoft excel on a higher level and that being said, some practice would come in handy, and the quiz below is one of many that will help you...

Questions: 13 | Attempts: 609 | Last updated: Sep 23, 2019

Sample Question
A function must always start with

=sumif

=sum

=

=sumif(

Test How Much Do You Know About Excel Sheets! Trivia

How well do you know excel?

Questions: 20 | Attempts: 175 | Last updated: Sep 17, 2020

Sample Question
You need to sort a column of names alphabetically. What do you do?

Select the column you need to sort. Click the Data tab and click the Sort button

Select the column you need to sort. Click the Insert tab and click the Group button

Manually arrange the data properly

Excel 2007 Intermediate Course Short Quiz

Questions: 13 | Attempts: 44 | Last updated: Mar 7, 2016

Sample Question
A formula cannot contain any of the following: functions, references, operators, and constants.

False

True

Excel High Income Fund Quiz

This quiz is a recap of the Excel High Income Fund webinar presentation which took place on Wednesday December 10th, 2014. Successful completion will result in the issuance of Continuing Education Credits.

Questions: 7 | Attempts: 59 | Last updated: Nov 28, 2014

Sample Question
How much of the World's Growth in 2015 is forecasted to come from Emerging Markets?

53%

66%

84%

17%

Excel Sheet Format For Quiz Questions

Excel sheet format for quiz questions

The use of excel spreadsheets is one of the hard things to comprehend in the computer use. However, not everyone really uses excel, but it is widely used especially for official purposes. The quiz below tests this and more,

Questions: 75 | Attempts: 35 | Last updated: Jan 11, 2018

Sample Question
Trong Microsoft Excel，phuong an nao duoi day khong phai la dia chi o?

AS12

$A$12

$12$A

Responsi Excel

Ini merupakan soal-soal uji sertifikasi aplikasi perkantoran dengan materi Spreadsheet. Uji ini digunakan untuk mengukur penguasan materi Spreadsheet sebagai umpan balik atau Responsi kegiatan Lab Komputer. Mohon maaf pada...

Questions: 26 | Attempts: 132 | Last updated: Jun 26, 2013

Sample Question
Program pengolah angka dikenal juga dengan nama....

Word Processor

Browser

Spreadsheet

Image Editor

Excel Advanced Questions By Akshay Magre

Excel Advanced Questions by Akshay Magre

This Set of Questions are for Target Audience already aware of Basic Excel Concepts. Questions : 20Time Limit : 40 minsPass Criteria : 60 %

Questions: 20 | Attempts: 273 | Last updated: Apr 11, 2015

Sample Question
Which of the following is correct Syntax in excel?

=IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)

=IF(LOGICAL TEST,FALSE RESULT,TRUE RESULT)

=IF(LOGICAL TEST,TRUE RESULT)(LOGICAL TEST, FALSE RESULT)

ALL OF THE ABOVE

Excel Basic Questions! Trivia Quiz

Basic Excel Question in this Evaluation. Questions : 20 Time Limit : 40 mins (Max) Pass Criteria : 60 %

Questions: 20 | Attempts: 534 | Last updated: Jun 7, 2019

Sample Question
Which of the following methods cannot be used to edit the content of cell?

Pressing the Alt key

Clicking the formula bar

Pressing F2

Double clicking the cell

MS Excel Final Test (Tett)

Ms Excel Final Test (TETT)

Questions: 8 | Attempts: 37 | Last updated: Apr 1, 2013

Sample Question
د ایکسل پروګرام عبارت دی له wahat is excel program ?

It is uses for counting

It is uses for typing

Both are wrong

Advanced Excel For Actuaries Quiz

Advanced Excel for Actuaries Quiz

See if you got the correct answers to the assignment.

Questions: 5 | Attempts: 247 | Last updated: Aug 25, 2013

Sample Question
On the Summary tab, what formula did you use to get Region 6's Aug value (cell G9)?

=INDIRECT("'"&F$1&"'!"&$L9)

=INDIRECT("'"&G$1&"'!"&$L2)

=INDIRECT("'"&G$1&"'!"&$L9)

=SUM(INDIRECT(H1&"!"&"B2:B13"))

Excel 2007 (Pre Test)

Questions: 15 | Attempts: 58 | Last updated: Sep 3, 2013

Sample Question
Is addition of rows and columns is possible beyond defined limit

Yes

No

None of the above

Excel 2007 Advanced Post Test

Questions: 15 | Attempts: 189 | Last updated: Feb 28, 2013

Sample Question
Once you hide a row, it remains hidden as long as the workbook is active.

True

False

IT's All About Excel Basics Quiz

It's all about Excel basics quiz

Questions: 10 | Attempts: 378 | Last updated: Jun 15, 2017

Sample Question
Numbers are aligned at the ________ edge of the cell.

Left

Right

Excel 2010 (Level 3 - Advanced)

Knowledge Excel Level 3 (Advanced)

Questions: 10 | Attempts: 699 | Last updated: Feb 28, 2013

Sample Question
How many conditions can the sumif check for?

1

2

3

4

Soal MS Excel Pertemuan 1

SOAL MS EXCEL PERTEMUAN 1

Pilihlah jawaban yang paling benar!

Questions: 10 | Attempts: 324 | Last updated: Aug 17, 2015

Sample Question
PROGRAM PENGOLAH ANGKA DIBAWAH INI ADALAH...

MS EXCEL

MS WORD

WORD STAR

COREL DRAW

AUTOCAD

« Previous12 3 Next »