Excel Quizzes, Questions & Answers

Recent Quizzes

UJIAN TEORI ONLINE TIK KELAS 8 SMP LABSCHOOL JAKARTA Materi Microsoft Excel 2003

Questions: 50 | Attempts: 2026 | Last updated: Mar 22, 2023

Sample Question
Selain menggunakan mouse, keyboard juga dapat digunakan untuk mengaktifkan menu. Perintah berikut yang digunakan untuk mengaktifkan menu file adalah :

Ctrl + F

Ctrl + O + F

Alt + F4+ F3

Alt + F

This quiz was made to go along with the Learning Excel website for Cal Poly Pomona. This quiz will test students on how to make calculations in excel.

Questions: 10 | Attempts: 320 | Last updated: Mar 18, 2023

Sample Question
In Excel, if you want to add up an entire column you have to use a calculator and add up the entire column yourself and then write the answer in one of the cells.

False, in Excel you can use the SUM function to add up an entire column.

True, Microsoft should really add an addition feature.

False, in Excel you can use the ADDITION function to add up an entire column.

False, in Excel you can use the AVERAGE function to add up an entire column.

Pivot Charts

Questions: 10 | Attempts: 758 | Last updated: Mar 22, 2023

Sample Question
You have created a PivotChart showwing sales by quarter by sales rep. Before presenting it ti management, you notice the name of a rep who has since been fired. How do you delete this rep from the chart without deleting the data?

Make the emloyee's data points and axis titles invisible.

Click the arrow next to the Sales Rep field and remove the employees name

You can't delete the rep from the chart without first deleting the data.

Hide that rep's row(s) in the underlying list, which automatically removes that rep from the chart

Scenario Manager In Excel Quiz: Test!

Scenario Manager in Excel Quiz: Test!

Do you know how to use Excel proficiently? Can you pass this quiz based on Scenario Manager in Excel with more than 80%? Take up the test and check how proficient you're when it comes to using Microsoft excel. Scenario...

Questions: 10 | Attempts: 3234 | Last updated: Jul 1, 2023

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

Range

Scenario

Trend line

What-if analysis

Excel Practice Test

Excel sheets run the business, and expertise in excel would go a long way in upscaling your career. This Excel practice test quiz gauges your practical knowledge on the subject and also provides you with valuable information that...

Questions: 10 | Attempts: 2940 | Last updated: Nov 17, 2023

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

Data Table

Data Validation

Scenarios

Goal Seek

Conditional Formatting

Questions: 10 | Attempts: 2305 | Last updated: Mar 22, 2023

Sample Question
When we want to show the Value in bar Chart which option of conditional formatting is used ?

Data Bar

Color Scales

Icons sets

Inserting, Deleting Columns & Rows

Questions: 10 | Attempts: 102 | Last updated: Dec 5, 2023

Sample Question
Do we have more than one way to insert or delet row and column on Excel worksheet ?

Yes

No

None of above

7th Grade: Microsoft Excel Exam! Trivia Quiz

Most people today have a hard time when it comes to using Excel to its full potential, and this is common when it comes to using formulas. How good are your Microsoft Excel skills so far as a 7thgrader? Take up this revision quiz...

Questions: 20 | Attempts: 2194 | Last updated: Dec 2, 2024

Sample Question
Q1: What does this button mean?

Align the text on the borders of the page.

Extend the content on the entire length of the cell.

Merge and center

Soal Uh1 Microsoft Excel Kelas 8

Soal UH1 Microsoft Excel Kelas 8

Pilih Jawaban Yang Tepat

Questions: 10 | Attempts: 118 | Last updated: Apr 9, 2024

Sample Question
Extention untuk dokumen yang dibuat dengan Ms. Excel adalah.....

.doc

.jpg

.xls

.html

.gif

Excel 2 Final

Final of concepts and terms for level 2.

Questions: 24 | Attempts: 652 | Last updated: Mar 21, 2023

Sample Question
To arrange rows in alphabetical order based on column A, you need to use the command _____.

Tools | Sort

Data | Sort

Edit | Data | Sort

None of the above

Excel 1 Final

Intro to Excel, concepts and terms

Questions: 19 | Attempts: 598 | Last updated: Mar 21, 2023

Sample Question
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is _____.

B1-G10

B1.G10

B1;G10

B1:G10

Excel 2007 Function/Formula Recap Quiz

This quiz is to test your knowledge and understanding of the two Excel trainings we have provided.

Questions: 15 | Attempts: 384 | Last updated: Mar 15, 2023

Sample Question
Angela Swift Paul Velasco Shawna RaeWhat of the below functions or Formulas could be used to combine the above data into one cell for each row?

Join

Concatenate

Text to Columns

Find/Replace

Excel - Formulas - Dates

Learning how to enter formulas into worksheets and perform simple calculations

Questions: 16 | Attempts: 336 | Last updated: Mar 15, 2023

Sample Question
In Excel 2007 you can write simple formulas that cannot automatically update their results when values change

True

False

FBLA: Spreadsheet Applications Quiz Questions!

What do you know about FBLA spreadsheet applications? Do you think you can pass this quiz? Regarding this quiz, you will be required to know which function returns the integer for the current date and time, what does the word...

Questions: 7 | Attempts: 975 | Last updated: Oct 27, 2023

Sample Question
The expression _____ returs the maximum value in the range A1:A100 and then divides the value by 100.

=MAX(A1:A100/100)

=MAX(100)/(A1:A100)

=MAX(A1:A100)/100

=MAXIMUM(A1:A100)/100

Excel Test Quiz For Graphical Analysis Of Data

Excel Test Quiz for Graphical Analysis of Data

Get ready to take our comprehensive Excel Test Quiz for Graphical Analysis of Data. This quiz is designed to assess your proficiency in using Excel for data visualization and analysis through various graphical...

Questions: 15 | Attempts: 344 | Last updated: Mar 12, 2024

Sample Question
When calculating cells what does a colon allow you to do?

Find the mean median and mode of a series of numbers

Calculate multiple cells by typing them in

Calculate multiple cells by highlighting them

Produce conditional statements like if and or not

Complex Formulas In Excel

Complex Formulas in Excel

This will be dealing wiith the order of operations Please Excuse My Dear Aunt Sally (P.E.M.D.A.S).

Questions: 5 | Attempts: 98 | Last updated: Dec 11, 2023

Sample Question
5+2*3

21

11

Food Services Excel Quiz

This quiz was designed by Custom Computer Specialists, Inc. as a followup for Food Services Excel Training. The purpose of this quiz is to see how much information you have retained since Excel Training. You may open...

Questions: 10 | Attempts: 122 | Last updated: Mar 20, 2023

Sample Question
What online resource can you use for Excel training videos, help and support?

Excel.com

Yahoo Questions and Answers

Microsoft.com

Spreadsheet Support

Excel Review Quiz Session 1: Roush

This quiz is a review for Session 1, Page 17, TechnoKids

Questions: 5 | Attempts: 318 | Last updated: Apr 6, 2023

Sample Question
1. What is #1 pointing to?

Cell

Formula Bar

Tab

Name Box

Sheet Tab

Microsoft Excel Vocabulary Quiz: 6th Grade!

Are you familiar with Microsoft Excel Vocabulary, and do you think you can pass this quiz? There are a plethora of special terms used for Microsoft Excel. Activate is to make a chart, sheet, or worksheet the active or selected...

Questions: 8 | Attempts: 1361 | Last updated: Nov 19, 2024

Sample Question
A cell is ...

Part of your genetic makeup

A phone

"boxes" within the spreedsheet that organized by colmns and rows can contain words, numbers, or formulas

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: 5409 | Last updated: Aug 17, 2023

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.

Microsoft Excel Vocabulary And Functions! Trivia Quiz

Microsoft Excel Vocabulary and Functions! Trivia Quiz

Microsoft Excel is a spreadsheet application produced by Microsoft that allows users to organize and calculate data with formulas. It's used for performing the basic calculation, graphing tools, creating pivot tables and...

Questions: 10 | Attempts: 812 | Last updated: Aug 20, 2024

Sample Question
A cell formula that stays the same when copied

Absolute reference

Relative reference

Active cell

Formula

CMP 540 Excel Trivia Questions Quiz

After taking the Excel tutorial, take this quiz.

Questions: 8 | Attempts: 3454 | Last updated: Mar 21, 2022

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.

« Previous 12Next »