Show:
1
2
3
4
5
100
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
100
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Template
100
What area contains the command used to print a worksheet in Microsoft Excel?
File Tab
100
To help organize and identify Microsoft Excel files by providing details about the files which of the following would you use?
Document properties
100
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
Save As
200
Which command on the insert ribbon creates a link to a web page, picture, email address, or program in a worksheet?
Hyperlink
200
Alicia needs to delete the data in cell B5. Which command would she select?
Clear
200
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Format Cells
200
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
Copy using the Fill Handle
200
Where can you find the Insert Function button in Microsoft Excel?
Formula Bar
300
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Sheet Options
300
Which command do you use to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks-drop-down area
300
On which shortcut menu can a user hide a row or column from view without permanently deleting the information?
Choose the Hide command on the shortcut menu
300
Which command on the page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Breaks
300
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
Delete
400
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
Freeze
400
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
String
400
How is an exact copy of a worksheet created within the same workbook?
Right click the sheet tab, then choose Move or Copy from the shortcut menu
400
How would you move sheet tabs to a new position in a workbook?
Click and drag the sheet tab to the new location
400
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
500
Which of the following is made up of two values and a relational operator, and is true or false for each cell in the range?
Condition
500
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
Today
500
Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?
functions
500
Jennifer is calculating her GPA. If she uses "+(A1+A2+A3+A4)/4", this is an example of which type of entry?
Formulas
500
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
Rotate