Font size
Worksheets2nd Term Quiz Gr6
Total questions: 80
Worksheet time: 37mins
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
In Excel, rows are identified by this
Letters
Numbers
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
This is a
Wrap text
Merge & Center
Copy
Paste
This is to
Wrap text
Merge & Center
Add border
Paste
This is to
Wrap text
Change color
Add border
Paste
This is to change
Width
Height
Font color
This is to change
Width
Height
Font color
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
Name of the workbook is displayed in the ___________
Menu bar
Title bar or ribbon
Tool bar
option bar
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Numbers in the worksheet represent
data
columns
rows
functions
Define Cell?
The dark bordered box in excel.
A box in Excel that has formulas.
The intersection of a column or row in a worksheet or table.
Fx Bar where you input data
1. What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen
The past cell in a worksheet. It is indicated by a dark border onscreen
1) Which cell is selected in this picture?
B2
B3
C3
m3
?
File
save
clear
1) A Row goes…
across
down
cross
A Column goes…
across
down
cross
?
minimize
maximize
exit/close
What is spreadsheet?
The cell address
The mouse pointer
The grid you see on the screen
A computer application that displays and organizes data is called __________.
PowerPoint Presentation
Publisher
Electronic Spreadsheet
Word
The rows in the spreadsheet represents the ___________.
Numbers
Letters
Vowels
Consonants
The columns represent the ____________.
Rows
Numbers
Letters
Columns
This is the intersection point of a column and row.
Cell Address
Cell Number
Cell
Cell Sheet
An individual box which contains data.
Cell Address
Cell Sheet
Cell
Cell Number
All of the following are the uses of MS Excel, EXCEPT:
Used for Calculations
Managing inventory
Presenting videos and audio
Collecting data from different sources
This is the file where data is stored in Excel.
Workbook
Folder
Worksheet
Publisher
Numeric data used in calculations is called _________.
Numeric
Value
Text
Formula
What do you call the entries that have no value associated with them?
Formula
Text
Value
Art
In which tab can you find the Merge and Center?
(a)
A -------------------- is a document that stores data in a grid of horizontal rows and vertical columns.
Row
Spreadsheet
Minus
Plus
Horizontal line of cells is
Row
Column
A small box that holds data
Row
Column
Cell
a vertical line of cells is
Row
Column
Spreadsheet computer program such as
Microsoft word
Microsoft Excel
Google Sheets
Microsoft Access
a computer program that imitates a paper worksheet
Video Game
Spreadsheets
Typing
Cell
You can use the spreadsheet for:
Collect data.
False
True
You can use the spreadsheet for:
Analyze information and produce graphs.
True
False
The text are used to show what values is
Values
Labels
Title
The number are used in calculations
Labels
Values
Numbers
To add up the total cost of the price, You use
AutoSum Function
A divide Formula
What is the intersection of a column and a row on a worksheet called ?
Column
Value
Address
Cell
In Excel, Columns are labelled as ___
A, B, C,...
1,2,3,....
A1, A2,....
$A$1, $A$2,....
How many sheets are there, by default, when we create a new Excel file ?
1
2
3
4
If we want to copy and paste some range of cells then no need to hold the control key along with the drag and drop process.
True
False
What happened when you press ctrl+X after selecting some cells from excel.
The content of selected cells got disappeared.
The cells selected are marked for cutting
The selected cells are deleted and shifted left
The selected cells are deleted and shifted up
Which of the following cell pointer is used to select the cells ?
Shortcut method for cut and paste.
Ctrl+ C, Ctrl +V
Ctrl+X, Ctrl+V
Ctrl+F
F4
The name box on to the left of the formula bar.
Shows the name of the workbook.
Shows the name of the worksheet
Shows the name of the cell
None of the above
A _____________ is a document that stores data in a grid of horizontal rows and vertical columns.
Row
Spreadsheet
Minus
Plus
In Excel, columns are labeled by?
Numbers
Letters
It is an Excel tool used to combine 2 or more cells together
Merge and Center
Center
Align Left
Justify
In Excel, rows are labeled by ________.
Letters
Numbers
Alphanumeric characters
Special characters
