NEW
Font size
WorksheetsGrade 6
Total questions: 48
Worksheet time: 39mins
Worksheet is an ________________ document.
electronic
tabular
word processing
Worksheet is an electronic document in which data is arranged in rows and __________.
columns
pages
tabs
A column is a _______________set of cells.
vertical
horizontal
straight
diagonal
A row is a _______________set of cells.
vertical
horizontal
straight
diagonal
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Identify the name of the arithmetic operator
minus -
plus +
A formula begins with an EQUAL SIGN.
true
false
Identify the arithmetic operator by looking at the image
plus +
multiply *
minus -
I am able to add, subtract and multiply numbers in excel using formula
yes
no
Sum of 15 and 9 is ------------
24
25
26
The graph is Ms Excel will represent your
date
shapes
class
data
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
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
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
There are ______________ columns in a worksheet.
16385
16384
18634
13684
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
The name box or the address bar contains
Formulas
menu options
Cell address
Numbers
Numbers in the worksheet represent
data
columns
rows
functions
1) Which cell is selected in this picture?
B2
B3
C3
m3
?
File
save
clear
To edit something on a worksheet you need to select this first?
Columns
Rows
Cell Range
Worksheet
Columns go in what direction?
Vertical
Horizontal
This symbol must be typed first to use a formula.
Plus Sign
Equal Sign
FX
Function
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Which of the following is an operator for multiplication in Excel?
/
*
%
&
The formula =2+3*5 gives the result as
25
17
22
11
Which view of table is used to insert a field name in table.
Date sheet
Design
Database
all of the above
Which data type would be most suitable for the 'DateofBirth' field?
Currency
Number
Date/Time
Yes/No
Memo
The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.
Fields
records
Data
None of these
Which field has primary key in the given table
Address 1
CustomerName
Customer ID
In Microsoft Access, a field labelled “Price” must be created as
Currency
Primary Key
Number
Short Text
Which view do we usually use to enter field and datatype in the database?
Design View
Record View
Field View
Form View
Information we enter in MS Access is stored in the ______________ we created
Column
Row
Database
Data type
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
?
B1
B2
B3
?
B1
B2
B3
1) Which cell is selected in this picture?
B2
B3
C3
m3
