WorksheetsPre-assessment to Excel
Total questions: 20
Worksheet time: 10mins
What type of program is Microsoft Excel?
Word Processor
Spreadsheet
Presentation
Database
What is the default file extension for an Excel workbook?
.xlss
.exlsx
.xlsx
.txt
What is the intersection of a row and a column called?
Box
Grid
Cell
Table
Which bar shows the contents of the active cell?
Name Bar
Formula Bar
Status Bar
Menu Bar
What does the Name Box display?
The formula in the cell
The name of the worksheet
The cell address of the active cell
The sum of selected cells
How are columns labeled in Excel?
Numbers
Letters
Symbols
Colors
How are rows labeled in Excel?
Numbers
Letters
Symbols
Colors
What is an example of a cell address?
10E
Z10
5x5
C-3
What happens when you press Enter after typing in a cell?
Moves to the next column
Moves to the next row
Saves the document
Closes Excel
What is NOT a type of data that can be entered in Excel?
Labels
Values
Formulas
Videos
Where are the sheet tabs located?
Top of the window
Bottom of the window
Left side of the window
Right side of the window
What does the Fill Handle do?
Copies cell contents
Moves a worksheet
Changes cell color
Deletes data
How do you move between worksheets?
Click on the sheet tab
Use arrow keys
Drag the sheet tab
Press Enter
What are the three types of data that can be entered into a worksheet?
Labels, values, functions
Numbers, charts, tables
Labels, graphs, formulas
Symbols, values, equations
What happens when you click a cell and start typing?
It edits part of the content
It deletes the existing content and replaces it
It moves the cursor to the next cell
It applies a function
How can you edit only part of the text inside a cell?
Press Enter
Double-click the cell
Click the Select All button
Use Ctrl+A
What key do you press to confirm data entry in a cell?
Esc
Enter
Ctrl
Shift
If you press Esc while editing a cell, what happens?
The changes are saved
The changes are canceled
The worksheet closes
A new row is added
What does a worksheet consist of?
Only text
Only numbers
A grid of cells
Charts only
What does a formula start with?
#
@
$
=
