BARU
Ukuran huruf
S
M
L
XL
Lembar kerjaExcel Functions and Formulas
Total soal: 20
Worksheet time: 16mins
Nama
Kelas
Tanggal
1.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
2.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
3.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
4.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
5.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
6.
What text formula joins the text from two or more cells?
a)
concatenate
b)
proper
c)
left
d)
e=mc2
7.
Which formula will calculate the average based on a condition? (return the average of sales if over $20)
a)
average
b)
countif
c)
averageif
d)
sumif
8.
Which formula would you use to calculate how many sales are over $20 from a series.
a)
sum
b)
sumif
c)
count
d)
countif
9.
Which formula will automatically capitalize the first letter of a word?
a)
abra-ka-dabra
b)
proper
c)
capitalize
d)
upper-case
10.
Which tool is used to add a graphic representation of data based on a condition within a cell? For example, adding green data bars to a column of data.
a)
format cell
b)
conditional formatting
c)
fill color
d)
magic cell
11.
Which tab contains the tool "Freeze Panes"?
a)
Home
b)
Page Layout
c)
View
d)
Review
12.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
13.
_____ are vertical.
a)
Rows
b)
Columns
14.
________ are horizontal
a)
Rows
b)
Columns
15.
A(n) _________ is a prewritten formula that is built into EXCEL.
a)
function
b)
problem
c)
equation
d)
equal sign
16.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
17.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
18.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
19.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
20.
What allow quickly apply the content for one cell to another cell?
a)
Active cell
b)
Autocell
c)
Auto sum
d)
Auto Fill
Setel ulang
