
Excel Lesson 1
Quiz by Lisa DeCastillia
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
21 questions
Show answers
- Q1John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?SplitHideFreeze PanesUnhide45s
- Q2Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?Title barQuick Access ToolbarStatus barFormula bar45s
- Q3Which ribbon option opens a related dialog box?SliderLauncherDrop down arrowEllipse45s
- Q4Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?Formula boxAddress boxCell boxName box45s
- Q5Which of the following notebook- like features organizes the sheets for use in Excel?FolderWorkbookWorksheetNotepad45s
- Q6Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?WebNormalPage layoutPrint45s
- Q7Which tab do you use to display the area that contains the print command?ViewHomeFilePage Layout45s
- Q8What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?Enlarge Selected AreaZoom to SelectionAmplify RangeMagnify Area45s
- Q9Which command do you use to close an open file and completely exit the Microsoft Excel program?QuitExitSave AsClose45s
- Q10Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?WorkbookNotepadWorksheetFolder45s
- Q11What occurs when the cursor is moved over a cell and a user clicks?The column is selectedThe worksheet is selectedThe cell is selectedThe row is selected45s
- Q12Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?PowerPointPublisherWordExcel45s
- Q13What command will arrange Microsoft Excel windows so that they appear side by side on the screen?Arrange AllZoom to SelectionFreeze PanesNew Window45s
- Q14Sharon's spreadsheet contains information about the number of music downloads in F12. "12" identifies the:CellRangeColumnRow45s
- Q15Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?Ctrl + HomeCtrl + 1Ctrl + EndCtrl + Up Arrow45s