WorksheetsEXCEL CORE LESSON 1 & 2 TEST (Part 2)
Total questions: 20
Worksheet time: 17mins
To select cells that are not adjacent (next to) each other, use which of the following keys while clicking on each cell?
Ctrl
Alt
Shift
Fn
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
Print Layout
Page Layout
ScreenTips
Split Windows
Which of the following indicates a proper cell address?
3A
:A3
A3
@A3
Which of the following is the intersection of a row and column?
range
tab
bar chart
cell
Which of the following is the proper format for a range?
A1-D10
A1:D10
A1thruD10
A1&D10
Which of the following is the selection pointer?
Which of the following is the fill handle?
Which of the following is the move handle?
Which of the following describes a row?
Identified by letters; runs vertically
Identified by letters; runs horizontally
Identified by numbers; runs vertically
Identified by numbers; runs horizontally
Which of the following consists of details that describe 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 only fill the formatting of a selected cell and not the contents which fill option do you choose?
Copy Cells
Fill Formatting Only
Fill Without Formatting
Flash Fill
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
You can quickly fill a column of data using an example that is based on existing data in adjacent columns using the Fill Series command.
TRUE
FALSE
You manually move the column marker to autofit a column.
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
Content that has been cut or copied to the clipboard will have a solid green border around it.
TRUE
FALSE
Which of the following describes a column?
Identified by letters; runs vertically
Identified by letters; runs horizontally
Identified by numbers; runs vertically
Identified by numbers; runs horizontally
