Have an account?
Skip to Content
Build your own quiz
Suggestions for you
30 questions
Show Answers
See Preview
- 1. Multiple ChoiceWhich tab is used to show print command?filehomepage layoutview
- 2. Multiple ChoiceIn cell address F25, "25" is identified as:cellcolumnrangerow
- 3. Multiple Choice
Which of the following is the intersection of a row and column?
range
tab
bar chart
cell
- 4. Multiple Choice
Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently?
A worksheet
The Help window
The Quick Access Toolbar
The ribbon
- 5. Multiple Choice
A feature of Microsoft office 2016 from which you access file and program management commands
active cell
cell address
backstage view
formula bar
- 6. Multiple ChoiceDavid wants to key the numbers 1-1000 in column A of the spreadsheet. What command should he use to complete this task?AutoFillfilterfind and replacesort
- 7. Multiple ChoiceWhich command on the Fill option dialog box is the default option if a month or day is entered?copy cellsfill formatting onlyfill without formattingfill series
- 8. Multiple ChoiceHow do you change the width of a column so that the widest entry will fit?SmartFitAutoFitBestFitTrueFit
- 9. Multiple Choice
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
Segment
Set
Range
Cluster
- 10. Multiple ChoiceWhich is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?Cell pointerColumn markerFill handleFormula bar
- 11. Multiple Choice
True or False: Using the Delete key removes both text and formats from a cell.
True
False
- 12. Multiple Choice
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Print
Edit
Windows
- 13. Multiple Choice
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Print
Open
- 14. Multiple Choice
Which of the following options can be used to fit the worksheet to one page?
Collated
Orientation
Margins
Scaling
- 15. Multiple Choice
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
- 16. Multiple Choice
If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.
TRUE
FALSE
- 17. Multiple Choice
Portrait orientation is the default orientation and it prints the page taller than it is wide.
TRUE
FALSE
- 18. Multiple ChoiceThe line between rows or columns.boundarycolumn widthpage breakfooter
- 19. Multiple ChoiceA predefined set of colors, fonts, and effects that can be applied to an entire workbook or to specific items in a workbook.document themeeffectsgridlinesorientation
- 20. Multiple ChoiceLines of text that appear at the bottom of each page.column widthheaderfootercolumn heading
- 21. Multiple ChoiceThe position of the content in a worksheet, so that it prints either vertically or horizontally on a page.boundarydocument themeeffectsorientation
- 22. Multiple Choice
Cells that run from top to bottom in a worksheet and are identified by letters
column
row
name box
active cell
- 23. Multiple Choice
A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface.
ribbon
quick access toolbar
row
command group
- 24. Multiple Choice
Which of the following procedures is not a way to delete one or more worksheets from a workbook?
Right-click a worksheet tab and click Delete.
Press Ctrl+A to select all cells in the worksheet and then press Delete.
Click the down arrow next to Delete on the Home tab and click Delete Sheet.
Select a group of worksheets, right-click the group, and click Delete.
- 25. Multiple Choice
Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?
It's the easiest way to make a backup before making changes.
It lets you reuse formats and formulas in a new sheet.
It helps Excel learn where your data ranges are located.
You should keep one worksheet hidden in case of an error.
- 26. Multiple Choice
Which of the following will return your worksheet to 100% with one click?
A
B
C
D
- 27. Multiple Choice
Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?
On the View tab, in the Window group, click Hide.
Select the visible area of the worksheet.
Right-click the worksheet's tab and click Hide.
Enter the name of the worksheet in the Hide dialog box.
- 28. Multiple Choice
Which cell would you click to freeze Rows 1-5 and Column A?
A5
B5
A6
B6
- 29. Multiple Choice
When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?
September
August (2)
Sheet2
July
- 30. Multiple Choice
Which of the following procedures is not a way to sort a table by the contents of one column?
Click the Sort button in the Sort & Filter group of the Data tab.
Click an AutoFilter button in the total row.
Click an AutoFilter button in the field names row.
Click the Filter button in the Sort & Filter group of the Data tab.
- Answer choicesTagsAnswer choicesTags