On The Ribbon
What People Want
Worksheets Ect.
Randomness
Random II
100
Which command on the home ribbon do you use to remove cells, rows, or columns from a worksheet or table? A. Delete B.Remove C.Format D.Format as Table
What is Delete
100
Jack would like the data in row 10 not to display on his spreadsheet, which option should he select? A.Freeze B.Header C. Hide D.Scale
What is Hide
100
In Microsoft excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? A. Formatting B.Printing C.Arranging D.Configuration
What is Formatting
100
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose? A.Insert B.Move C. Rename D.Tab Color
What is Rename
100
John would like to change the order of the worksheets in his workbook, what should he do? A.Insert B.Delete C.Copy D. Move
What is Move
200
Which command on the page layout ribbon enables a user to mark where a new page will begin on the printed copy? A.Print Area B. Breaks C.Background D.Effects
What is Breaks
200
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? A.Orientation B.Page Break C.Print Area D. Print Titles
What is Print Titles
200
Joan is showing her spreadsheet to a customer and does not want them to see the wholesale prices column, what should she do? A.Freeze B.Split C.Page Break D. Hide
What is Hide
200
What Feature of Microsoft Excel keeps a portion of the worksheet visible while the other scrolls? A.Zoom B.Select C. Freeze Panes D.Rotate
What is freeze panes
200
which term describes the blank portions of a page that fall outside of the main body of the printed document? A.Borders B.Edges C.Frames D. Margins
What is Margins
300
Which command group on the page layout ribbon controls the presence of grid lines and headings on a worksheet? A.Themes B.Page Setup C. Sheet Options D.Arrange
What is Sheet options
300
John notices that column D is not showing on his spreadsheet, what action does he need to take to view column D? A.Freeze Panes B.Split C.Hide D. Unhide
What is unhide
300
Which command do you use to remove manual page breaks from a worksheet? A.Select break, press DELETE B. Select Remove Break from drop down arrow C.Select break, press BACKSPACE on keyboard D.Select Break, press remove page break from shortcut menu
What is Select Remove Break for drop down arrow
300
How would you move sheet tabs to a new position? A.Choose Move on the home ribbon B. Click and drag the sheet tab to the new location C.Choose move on the insert ribbon D.Choose relocate on quick access toolbar
What is Click and drag the sheet tab to the new location
300
what command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page? A.Margins B.Print Titles C. Header and Footer D.Page Setup
What is Header and Footer
400
Which ribbon contains the command to apply a theme to a worksheet in Microsoft excel? A. Home B.Page Layout C. Data D. View
What is Page Layout
400
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet, what should he do? A. Freeze Panes B.Split C.Hide D.Unhide
What is Freeze Panes
400
David want to change all occurrences of "North Carolina" to "NC" in his spreadsheet, what should he do? A.Autofill B.Filter C. Find and Replace D.Sort
What is Find and Replace
400
Virgil wants to emphasize the sheet tabs in his workbook, which command should he use? A.Insert B.Move C.Rename D. Tab Color
What is Tab Color
400
which set of formatting choices includes a set of colors, fonts, and effects the you can apply in a worksheet to enhance its appearance? A.Layout B.Template C. Theme D.Design
What is Theme
500
Which command in the home ribbon allows you to format row height and column width, organize sheets, and protect cells in a worksheet? A.Insert B.Form C.Sort and Filter D. Format
What is Format
500
Jack would like to force the data in his spreadsheet to fit in one page when printed, which option should he select? A.Freeze B.Header C.Hide D. Scale
What is Scale
500
What is a single character, word or phrase in a cell on a worksheet that is typically used in searches? A.Text B. String C.Thread D.Key
What is String
500
Which command on the home ribbon do you use to replace information in a selected cell with new information or new formatting? A.Font B.Format cell C.Cell Styles D. Find and Select
What is Find and Select
500
how is an exact copy of a worksheet created within the same workbook? A.While pointing to the sheet tab, choose copy from shortcut menu B. Right click the sheet tab, choose move or copy from shortcut menu C.While pointing to the select all button, choose move or copy from shortcut menu D.Choose move or copy from quick access toolbar
What is Right Click sheet tab, choose move or copy from shortcut menu
M
e
n
u