WorksheetsMicrosoft Excel Basics - Video 2
Total questions: 14
Worksheet time: 11mins
Templates: Which of the following best describes an Excel Template
A blank spreadsheet
A budget
A prebuilt spreadsheet that you can customize
A chart
True or false: You can create your own templates
True
False
In Excel, a cell is :
A variable
One box on the spreadsheet
A range of boxes on the spreadsheet
Either one box or a range of boxes
Cells are named using:
The Row Number and then the Column Letter, like 6B
The Column Letter and then the Row Number, like B6
Either format (B6 or 6B) is correct
The name of the selected cell in this image is:
B4
C4
4B
4C
Not enough information
The grey area shown would best be called:
Microsoft Excel
A cell
A range
A spreadsheet
The correct name for the grey area on this image would be:
G9-D3
D9-G3
D9:G3
D3:G9
In the image the words "Stair Wars" could be named:
A1
A1:B1
B1
Any of these
In the video we watched, there was a difference between being "on the cell" or "in the cell". Describe the difference as you understand it
If we wanted to make the column wider for cell A1, the way(s) we learned to do this in the video was/were: (select all that apply)
Position the cursor between the 1 and 2 on the row names, then click and drag down.
Position the cursor between the A and B on the column names, then click and drag to the right.
Position the cursor between the 1 and 2 on the row names, then double-click on the line between the rows.
Position the cursor between the A and B on the column names, then double-click on the line between the columns.
We want to change "Stair Wars" to "Star Wars". Which of the following would work to do that? (Select all that apply)
Click once on the cell and type delete and then press enter
Double click on the cell and use the arrow keys to get next to the "I" and click delete or backspace and then press enter
Click in the Formula Bar and use the arrow keys to get next to the "I" and click delete or backspace and then press enter
Click once on the cell and type "Star" and hit enter
Click once on the cell and retype "Star Wars"
In this image, when you click on the line in between the column names, you can either drag the line, or double-click it. Which of the following correctly describes the differences between the two actions? Select all that apply.
Dragging only effects one column
Dragging sets the same width for all the selected columns
Double-clicking automatically makes each column the right size for all its data
Double-clicking makes all column widths the same as the widest column.
Select all that finish the statement correectly:
The Excel "ribbon" is:
The same for all tabs
Different for each tab
Divided into groups of functions
The Launch button is used to:
Launch another application like Microsoft Powerpoint
Open a new Workbook
Expose more functions than the ones that fit on the ribbon
