WorksheetsExcel CH 1 & 2
Total questions: 20
Worksheet time: 10mins
An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?
A dialog box or task pane
An additional workbook
A list of worksheets
An additional part of the current range
Which feature enables you to preview headers and footers, page breaks, & other features that will print?
Page Layout
Print Layout
Synchronous Scrolling
Screen Tips
When you split a window, the window is divided inot how may panes?
two
three
four
two or four
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 windo
The Quick Access Toolbar
The ribbon
How many worksheets does a new Excel 2016 workbook open with?
one
two
three
four
The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.
True
False
The columns in a worksheet are identified by numbers.
True
False
The active cell in a worksheet is outlined by a bold rectangle.
True
False
Page Layout view is useful when preparing your data for printing.
True
False
Which of the following consists of details that describes or identify a file, including the author?
Paste
Document properties
Copy
RAnge
Which command is used to insert a cut or copied selection to a cell or range of cells?
Paste
Document properties
Copy
Range
If you want to use a workbook in another kind of document, you have the option to save using which of the following?
File format
Worksheet
File sheet
File range
Which 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 pointer
Column marker
Fill handle
Formula bar
Which of the following can you drag or double-click to change the width of a column?
Cell pointer
Column marker
Fill handle
Formula bar
Using the Delete key removes both text and formats from a cell.
True
False
You can assign keywords so that others can search for your documents online.
True
False
The formula bar is found at the bottom of the Excel window.
True
False
Use the fill handle to create a natural series, such as the months of the year.
True
False
Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel.
True
False
