WorksheetsExcel Basics #1
Total questions: 25
Worksheet time: 13mins
Which of the following is not a correct cell address?
22D
A27
BB15
ZC3
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.
What is the file extension for Excel worksheets?
.png
.pptx
.xlsx
.docx
In order to type extra long text in cells so that all are visible, we use
Merge and Center
Find & Select
Wrap Text
Conditional Formatting
Which command would you use to group a set of cells together?
Merge
Cut
Format as Table
Cell Group
Which tool allows you to draw edges to cells?
Cell fill
Borders
Wrap Text
Alignment
How do you correctly write/type a range of cells?
A1;D1
A1:D1
A1-D1
A1--D1
What is a file that contains one or more worksheets?
Worksheet
cell
column
workbook
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
Apa yang dimaksud dengan Range dalam excel ?
Kumpulan dari worksheet
Kumpulan dari beberapa sel
Pertemuan antara baris dengan kolom
Pertemuan antara sel dengan range
Yang termasuk dalam rumus statistic sederhana adalah…
SUM, MAX, MIN
COUNT, MAX, DATE
COUNT, IF, LOOKUP
AVERAGE, LOOKUP, DATE
Sel C4 berisi 90, sel D4 berisi 80 maka formula yang tepat untuk menghitung RATA-RATA dan hasil yang benar adalah...
=C4+(D4/2); hasil 170
=(C4+D4)/2; hasil 85
=average(95..80); hasil 85
=C4+D4/2; hasil 85
Alamat Absolut adalah alamat cell yang nilainya tidak berubah jika data harus dicopykan. Adapun penulisan cell absolute yang benar adalah …
$A1$
A$$1
$A$1
A1$
A simple formula always start with :
+
=
-
*
This is a valid simple formula
A2+A4
=AB3+Y5
(a2*t3)/100
=(a2*t3)/100
* is a symbol for:
Multiplication
Addition
Subtraction
Dividing
/ is a symbol for:
Multiplication
Addition
Subtraction
Dividing
