Font size
WorksheetsICT Test Brighton
Total questions: 25
Worksheet time: 13mins
These are topics we have discussed, except ....
Canva: editing video
Ms. Word: making letter
Ms. Excel: using formula
Ms. Word: making table
What tab will you use to increase the size of the font in your document?
Home
Insert
Design
Review
TRUE OR FALSE
You use "Save As" when you want to save a document with a current name with a different name.
True
False
What is a rectangular box in a MS EXCEL Spreadsheet called?
row
column
cell
How are ROWS in MS EXCEL spreadsheet named?
numbers
letters
cells
columns
What does every formula in MS EXCEL start with?
+
-
=
*
What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol?
SUMMING
SUM
ALL
None at all
What is an example of a RANGE in MS Excel?
B2-F5
F5:B2
B2:5F
(B2:F5)
In Excel, Columns are labelled as ....
A, B, C, etc
1,2,3 etc
A1, A2, etc
$A$1, $A$2, etc.
In Microsoft Excel, the file you create and edit is called:
A form
A ledger
A table
A workbook
A record
What is the symbol for division when using MS EXCEL?
/
+
*
-
What is the name of the cell that is colored blue?
A
B
2B
B2
What is a multiplication formula for MS Excel using the picture?
=1Ax1B
B1*G1
=C3xD3
=B4*C4
The ... function finds the average of a set of values in a column or row.
Max
Min
Sum
Average
What function in excel to make dropdown list?
Data validation
Alignment
Formula
List
These are the formula that we have learnt, except ....
=SUM(A1:A9)
=AVERAGE(A1:A9)
=IF(G4>=83;"A";"B")
=ROUND(A1:A9)
Which tab is used to make numbers (9000) in currency (Rp9.000)?
File
Home
Insert
Data
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
?
File
save
clear
?
minimize
maximize
exit/close
If you type =2*(6-4) in cell A1, what will be the display value?
2
4
6
8
Which is the correct example for formula data
=5+10
A1+B1=
=A1B1
What is the total cost?
(a)
