Font size
WorksheetsTLE 6 - Spreadsheets
Total questions: 55
Worksheet time: 37mins
A blank sheet in a MS Excel is known as -----------
canvas
document
spreadsheet
Each cell has a different name.
true
false
Words in excel are known as -------------
labels
values
Numbers in excel are known as --------------
labels
values
Identify the name of the cell
A3
B3
C3
We can rename a spreadsheet.
true
false
Identify the name of the red cell
A11
A10
A12
Rectangular boxes in Excel spreadsheet are called CELLS.
true
false
Identify the name of the cell
A3
B3
C3
__________ run from left to right and are identified by numbers.
Rows
Columns
Worksheets
Files
Which of the images below represent Microsoft Excel work environment ?
The (a) is where you'll find the commands you need to perform common tasks in Excel.
The Ribbon contains multiple (a) , each with a group of commands.
Excel files are called (a) .
Each workbook holds one or more (a) .
On which tab would you find the command to create a new workbook?
File
Home
Insert
View
You can format text in Excel by making it bold, italic, etc.
True
False
Worksheets are made up of rows and columns.
True
False
__________ run from left to right and are identified by numbers.
Rows
Columns
Worksheets
Files
A cell formed at the intersection of row 8 and column E is addressed as _____________.
E8
8E
Using the __________________ feature, sum of the numbers can be calculated easily.
Autofill
Autosum
A group of cells which are adjacent to each other are called _________________.
Active Cell
Cell range
MS Excel is a __________________________ software.
Worksheet
Spreadsheet
Currently selected cell in which cell pointer lies is called _______________________.
Cell Pointer
Active Cell
The address of the currently active cell is displayed in the ___________________________.
Formula Bar
Name Box
A _____________ is a small rectangular area formed at the intersection of a row and a column.
Column
Cell
Which options are used to move data from one place to another.
Copy and Paste
Cut and Paste
Combination of column letter and row number that identifies a cell.
Cell Address
Cell Range
A page of Excel file is called a _________________________.
Worksheet
Workbook
We must __________________ data to do operations on it.
select
click
Thick border around the active cell is called the ______________________________.
Cell pointer
Active cell
An excel file is saved with ______________ extension.
.xlsx
.pptx
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Data entered in a cell appears in Formula bar as well as in active cell.
True
False
The active cell is not bordered with a black outline.
False
True
It refers to the colored row of letters which is used to identify each column.
select all button
name box
column header
row header
This refers to the column of numbers at the left side of the worksheet.
column header
row header
scroll bar
sheet tab
The _______________ shows the address of the cell you have selected.
formula
Name Box
cell address
Microsoft Excel is a
Word Processing Software
Presentation Software
Spreadsheet Software
All of the above
The __________________________ allows access to frequently used commands.
Quick Access toolbar
Drop down arrow
Show and hide
Show tabs
The default view for all worksheets is called ?
Normal view
Page layout view
Page break view
Backstage view
Have you ever made a spreadsheet before? If yes, for what reason?
Give three uses of spreadsheet software like MS Excel.
