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/19
Score 0
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
45
Page layout
Home
Data
Hide
Q 2/19
Score 0
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
45
Scale
Header
Freeze
Hide
19 questions
Q.
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
1
45 sec
Q.
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
2
45 sec
Q.
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
3
45 sec
Q.
Which term describes the blank portions of a page that fall outside the main body of the printed document?
4
45 sec
Q.
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?
5
45 sec
Q.
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
6
45 sec
Q.
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?
7
45 sec
Q.
Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?
8
45 sec
Q.
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
9
45 sec
Q.
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
10
45 sec
Q.
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
11
45 sec
Q.
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
12
45 sec
Q.
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
13
45 sec
Q.
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
14
45 sec
Q.
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
15
45 sec
Q.
Which command do you use to remove manual page breaks from a worksheet area?
16
45 sec
Q.
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
17
45 sec
Q.
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
18
45 sec
Q.
Column B in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column B?
