
Microsoft Excel and Word
Quiz by Kel Jackson
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
20 questions
Show answers
- Q1In Microsoft Excel, which function is used to find the average of a range of numbers?MAXSUMAVERAGECOUNT30s
- Q2In Microsoft Excel, which tool would you use to visually represent data trends over time?FilterChartConditional FormattingPivot Table30s
- Q3In Microsoft Word, what is the purpose of using 'Headers' and 'Footers'?To insert page numbersTo change the document fontTo create bullet pointsTo add consistent text or images at the top or bottom of every page30s
- Q4In Microsoft Excel, which function would you use to count the number of cells that contain numeric values?SUMCOUNTAVERAGEMIN30s
- Q5In Microsoft Word, what does the 'Alignment' feature control?The size of the textThe font style of the textThe color of the textThe position of text within a paragraph30s
- Q6In Microsoft Excel, what does the 'IF' function do?Performs a logical test and returns one value for true and another for falseFinds duplicates in a listSorts data in ascending orderCalculates the average of a range30s
- Q7Which feature in Microsoft Excel allows you to automatically fill a series of numbers or dates?AutoFillData ValidationConditional FormattingChart Wizard30s
- Q8In Microsoft Excel, which formula would you use to find the smallest number in a range of cells?AVERAGEMINSUM
LEAST
30s - Q9What is the primary purpose of using formulas in Excel?To create tablesTo insert imagesTo format textTo perform calculations automatically30s
- Q10In Microsoft Excel, which symbol is used to begin a formula?$=&@%30s
- Q11What feature in Microsoft Word allows you to organize text into rows and columns?ChartFormTableList30s
- Q12Which Microsoft Word feature automatically checks your spelling and grammar as you type?Format PainterSpell CheckTrack ChangesMail Merge30s
- Q13What is the keyboard shortcut for saving a document in Microsoft Word?Ctrl + PCtrl + ZCtrl + CCtrl + S30s
- Q14In Excel, what is the purpose of the SUM function?To add a range of numbersTo average a set of valuesTo find the maximum valueTo count the number of cells30s
- Q15What feature in Microsoft Word allows you to create a list of sources for your research paper?MarginHeaderBibliographyFooter30s