
Excel Unit 3
Quiz by Jennifer Michaels
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
6 questions
Show answers
- Q1If you only want to print a certain part of your worksheet what must you do?Change the MarginsChange the Page OrientationSet the Print AreaSet Print Titles30s
- Q2What tool/button do you use if you want a row or rows to appear at the top of every page that you print?Print TitlesPrint AreaMarginsOrientation30s
- Q3What is the answer to the problem =3+4*5-6-129173230s
- Q4You want to enter a cell in E3 that you can fill to E4:E6. To calculate Tax you must multiply the Total in column D by the percent in E1. Which formula is set up so that you can just fill it?=D3*E1=D3*7%=D3*$E$1=D3*730s
- Q5What do you use if you want Excel to highlight all cells that contain numbers that are less than 100?TableConditional FormattingShadingCell Styles30s
- Q6What function allows Excel to analyze a condition in order to put the correct value in a cell?IFCHOOSESUMCOUNT30s