Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/21
Score 0
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
45
Split
Hide
Freeze Panes
Unhide
Q 2/21
Score 0
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
45
Title bar
Quick Access Toolbar
Status bar
Formula bar
21 questions
Q.
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
1
45 sec
Q.
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
2
45 sec
Q.
Which ribbon option opens a related dialog box?
3
45 sec
Q.
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
4
45 sec
Q.
Which of the following notebook- like features organizes the sheets for use in Excel?
5
45 sec
Q.
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
6
45 sec
Q.
Which tab do you use to display the area that contains the print command?
7
45 sec
Q.
What 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?
8
45 sec
Q.
Which command do you use to close an open file and completely exit the Microsoft Excel program?
9
45 sec
Q.
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
10
45 sec
Q.
What occurs when the cursor is moved over a cell and a user clicks?
11
45 sec
Q.
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
12
45 sec
Q.
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
13
45 sec
Q.
Sharon's spreadsheet contains information about the number of music downloads in F12. "12" identifies the:
14
45 sec
Q.
Joan 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?
15
45 sec
Q.
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
16
45 sec
Q.
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
17
45 sec
Q.
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?
18
45 sec
Q.
Which view is the default view used in Microsoft Excel?
19
45 sec
Q.
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
20
45 sec
Q.
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?