NEW
Font size
WorksheetsExcel Exam 1: Multiple Choice
Total questions: 30
Worksheet time: 19mins
Which of the following is the intersection of a row and column?
range
tab
bar chart
cell
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
A feature of Microsoft office 2016 from which you access file and program management commands
active cell
cell address
backstage view
formula bar
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
Segment
Set
Range
Cluster
True or False: Using the Delete key removes both text and formats from a cell.
True
False
Which of the following is where you can save, select a template, change document properties, and close or exit Excel?
Backstage
Edit
Windows
To change printer, layout, or margin settings, you click the File tab and use which of the following options?
Info
Options
Open
Which of the following options can be used to fit the worksheet to one page?
Collated
Orientation
Margins
Scaling
Which predesigned file already has a significant amount of formatting, text, and other features?
Blank workbook
Preset file
Text file
Template
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
Portrait orientation is the default orientation and it prints the page taller than it is wide.
TRUE
FALSE
Cells that run from top to bottom in a worksheet and are identified by letters
column
row
name box
active cell
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
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.
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.
Which of the following will return your worksheet to 100% with one click?
A
B
C
D
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.
Which cell would you click to freeze Rows 1-5 and Column A?
A5
B5
A6
B6
When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?
September
August (2)
Sheet2
July
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.
