Spreadsheets quizzes
67 quizzes by 51 users · Page 1 of 2
This Spreadsheets page on GoConqr gathers over 50 community-made quizzes on formulas, formatting, charts and macros. School students can practise spreadsheet skills, while teachers can find quizzes for lesson checks. Most resources are at school level, with a few at university and professional level. Pick a quiz to get started.
Quizzes
-
20 questionsExcel 1 Which of the following is a set of formatting elements that includes font style, size, color, alignment, bo...
-
20 questionsExcel 2 Which of the following characters always starts a formula?
-
10 questionsExcel 4 In an Excel table, which of the following contains descriptive titles or labels?
-
22 questionsExcel and Macros Follow the code and identify the output Private Sub WrokBookOpen() Sheets(“sheet1”).Range(“A1”)=Date End Sub
-
10 questionsExcel 3 Which of the following is not a true statement when applying shape fill, outline, and effects?
-
10 questionsMS Excel Pre-Assessment Test Suppose you want a message to pop up each time a particular cell is selected, How do you make this happen?
-
2 questionsExcel Fundamentals True of False. If you choose a larger font size, the height of the row is automatically made taller.
-
35 questionsHow much can you remember about Excel? Level 2. What symbol do you use for "less" if you had to create a formula to calculate Profit and were told this is ...
-
30 questionsHow much can you remember about Excel? Level 1. What symbol do you use for "less" if you had to create a formula to calculate Profit and were told this is ...
-
23 questionsChecking your Excel knowledge. What symbol do you use for "less" if you had to create a formula to calculate Profit and were told this is ...
-
20 questionsOCR ICT AS Level - Spreadsheet Concepts (Chapter 4) What are four advantages of using a spreadsheet to answer 'what-if?' questions?
-
17 questionsHow much can you remember about Excel? Part 1. What symbol would you use to divide?
-
35 questionsExam 2 Tutorial 4
-
10 questionsSpreadsheets - Year 9 L1 Label the key sections of a spreadsheet by dragging and dropping the labels
-
5 questionsMicrosoft Excel Pretest What is the purpose of a pivot table?
-
98 questionsexcel tut 4-6
-
144 questionsOMIS New workbooks typically contain how many worksheets?
-
100 questionsUntitled Which of the following is a cloud storage area where you can store files in a private and secure online loc...
-
12 questionsHow much can you remember about Excel? Part 2. You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
-
20 questionsExcel basics introduction quiz What software would you use to make a gif for sending to your mates on instagram?
-
19 questionsCAT PAT What is the function of this formula? =sum(A1:B1)
-
15 questionsIntro to MS Excel_Quiz 2 Quiz 2 of 3 Into to MS Excel with Ms. Brown at BHS
-
22 questionsExam 2 Tutorial 11
-
25 questionsExam 2 Tutorial 2
-
36 questionsExcel Exam 1 With Microsoft Excel we can create
-
20 questionsExam 2 (Tutorial 1)
-
20 questionsSpreadsheet quiz An instruction used to carry out operations on numerical data
-
15 questionsSpreadsheets Quiz Which of the following is capable of producing a spreadsheet Tick all that apply?
-
10 questionsUntitled Which step is not part of planning a worksheet design?
-
19 questionsExam 2 Tutorial 3
-
10 questionsIntro to MS Excel Quiz 3 Quiz 3
-
20 questionsSpreadsheet The information represented in the rows in a worksheet is called ..............................
-
15 questionsExam 2 Tutorial 6 True/False. When you edit cells in a worksheet group, the changes you make to one worksheet are automatical...
-
10 questionsFind and Replace and Sorting Quiz When sorting data in Excel you can only ever sort one column at a time.
-
10 questionsChapter 2 Study Guide If you hide columns 7-10 in your worksheet, column 8 will print.
-
12 questionsUntitled To let Excel know that you want to enter a formula, what is the symbol to type?
-
6 questionsUntitled A label is...
-
6 questionsSpreadsheet Quiz What is a common short term, if you want to sort your list by name, starting with A and ending with Z (smal...
-
10 questionsComputer Apps Excel Chapter 1 Learn the basics of Microsoft Excel.
-
14 questionsBIS T1-T2 A spreadsheet is a collection of numbers, not text.
More Spreadsheets resources
About spreadsheets quizzes
GoConqr OriginalUsing spreadsheets quizzes
These quizzes offer different ways to check your spreadsheet knowledge. Excel Fundamentals includes questions on selecting cells and changing font size. Microsoft Excel Pretest asks about pivot tables, while Excel and Macros includes questions on macros and working out the number of working days between dates.
For a starting point, try Excel Fundamentals if you want to focus on basic worksheet actions. If you want to check formulas, a numbered Excel quiz asks about the character that starts a formula and errors in cell references.
Turn answers into revision
After a quiz, note the questions you found difficult and group them by topic. If cell references need more attention, switch to a mind map on the unit page. For function practice, the unit also has notes on the IF function.
Choose a topic and explore a quiz that covers it.
Frequently asked questions
Which quiz could I start with?
Excel Fundamentals is a useful starting point for checking basic worksheet actions. Its questions include selecting a range of cells and changing font size. If you want to focus on formulas instead, one of the numbered Excel quizzes asks about starting a formula and identifying errors.
What do the quizzes cover?
The selection includes questions on formulas, formatting, charts and tables. Microsoft Excel Pretest asks about pivot tables, while MS Excel Pre-Assessment Test includes array formulas. Excel and Macros covers macros and a function for finding the number of working days between dates.
Are the quizzes free to use?
Yes. Every quiz listed here is free to open, study and take without an account. A free account can also save your quiz scores and let you make your own quizzes, mind maps, flashcards and notes. The listed resources were made by GoConqr users.
Who are these quizzes for?
Most of the resources are at school level, making the page relevant to school students practising spreadsheet skills and teachers looking for quiz material. There are also a few resources at university and professional level. Individual quizzes focus on different topics, from basic worksheet actions to macros.