Worksheetsរំឮកមេរៀន
Total questions: 52
Worksheet time: 43mins
A visual representation of data
Graph
Grid Lines
Row
Selecting
If I want to add a Chart, one way is to select the ____________ tab.
Home
Insert
Page
Data
Which of the following is a correct syntax?
SUM=(A2:A8,E2:E8)
=SUM (A2:A8,E2:E8)
SUM(A2:A8, E2:E8)=
=A2:A8(SUM)
What is the cell that you are working on called?
Active cell
value
auto sum
dormant
What is a chart?
a visual way to display and compare data
a way of arranging data
a calculation that describes the relationship between cells
a group of cells
Where can you enter a formula in a worksheet?
1.In the Formula Bar only
2.In cell only
3.in 1 or 2
4.in the Name Box
In Google Sheets, a FORMULA BAR is
a predefined formula that performs calculations using specific values in a particular order
each rectangle in a spreadsheet
a group of cells that run vertically
the place to enter and edit data, functions, and formulas for a specific cell
In Google Sheets, a COLUMN is
a group of cells that run horizontally
a predefined formula that performs calculations using specific values in a particular order
a group of cells that run vertically
the place to enter and edit data, functions, and formulas for a specific cell
What formula would be used in cell B14 to find the average number of miles the person biked in a month?
=(B2/B10)
=AVERAGE(C2:C10)
=AVERAGE(B2+B10)
=AVERAGE(B2:B10)
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
Active Cell
Formula
Cell
Cell address
A combination of numbers and symbols used to express a calculation.
Active Cell
Label
Formula Bar
Formula
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
Which formula gets the biggest value of a range of cells?
MAX
MIN
SHORT
SUM
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
Which of the following formulas is not entered correctly?
=10+50
=B7+B8
=B7+14
=10+50;
To edit a formula you
A. Double-click the cell
B. Click in the formula bar
C. Press Esc
D. Both A & B
Answer =2+3*3-2
9
10
11
12
Answer =3+5*(6-2)
23
32
31
64
What kind of a chart is this?
a pie chart
a bar chart
a cake chart
a line graph
What kind of a chart is this?
A line graph
A bar chart
A pie chart
Scatter Chart
What function will calculate the AVERAGE of all the numbers in a column?
=IF(A1:A6)
=SUM(E1:E5)
=AVERAGE(E1:E5)
=CONCAT(E1:E5)
Which cell reference deals with just the column?
$A2
A$2
$A$2
$A$2$
Which cell reference deals with just the row?
$A2
A$2
$A$2
$A$2$
Which cell reference deals with a specific cell?
$A2
A$2
$A$2
$A$2$
តើការប្រើបា្រស់រូបមន្តនៅក្នុង Google Sheets និង Microsoft Excel ដូចគ្នាដែរឬទេ?
ដូចគ្នា
មិនដូចគ្នាទេ
ចូរសរសេររូបមន្ត បូកសរុប
(a)
ចូរជ្រើសរើសរូបមន្ត អតិបរមា ដែលត្រឹមត្រូវ
=Min()
=Minimum()
=Max()
=Maximum()
ចូរសរសេររូបមន្ត រកចំណាត់ថ្នាក់
(a)
ចូរជ្រើសរើសរូបមន្ត អប្បបរមា ដែលត្រឹមត្រូវ
=Min()
=Minimum()
=Max()
=Maximum()
ចូរជ្រើសរើសលទ្ធផលដែលត្រឹមត្រូវ
អតិថិជននឹងទទួលបានបញ្ចុះតម្លៃ ២០% បើចំណាយចាប់១០០$
=if(A1>=100, “Discount 20%”, “No Discount”)
អតិថិជនម្នាក់ចំណាយអស់85$ (A1 = 85)
Discount 20%
No Discount
Total 85$
Discount 20$
ចូរជ្រើសរើសរូបមន្ត មធ្យមភាគ ដែលត្រឹមត្រូវ
=ave()
=averag()
=average()
=averge()
តើមួយណាមិនមែនជារូបមន្តរាប់(Count)?
=COUNT()
=COUNTA()
=CUONT()
=COUNTIF()
=COUNTA() ខុសពី COUNT() ធម្មតាត្រង់...
រាប់បានតែអក្សរប៉ុណ្ណោះ
រាប់បានតែលេខប៉ុណ្ណោះ
រាប់បានទាំងលេខនិងអក្សរ
រាប់បានតែ Cell ដែលគ្មានទិន្ន័យប៉ុណ្ណោះ
បើសិនជាចង់រាប់ទំនិញតែ១ មុខក្នុងចំណោមទំនិញច្រើនមុខ។ តើត្រូវប្រើរូបមន្តមួយណា?
=COUNTIF()
=COUNT()
=COUNTA()
=COUNTBLANK
ដើម្បីប្តូរលុយពីលុយខ្មែរ(20,000រៀល)ទៅលុយដុល្លារយើងត្រូវ...
4,000 / លុយខ្មែរ
លុយដុល្លារ / 4,000
លុយដុល្លារ * 4,000
លុយខែ្មរ / 4,000
ដើម្បីដាក់លេខ ID ដែលមានលេខសូន្យ (001)នៅពីមុខបាន យើងត្រូវប្តូរ Number Format ទៅប្រភេទអ្វី?
Automatic
Number
Plain text
Accountant
តើយើងអាច Custom Number Format ក្នុងទូរសព្ទដៃបានដែរឬទេ?
បាន
មិនបានទេ
ចូរជ្រើសរើសលទ្ធផលដែលត្រឹមត្រូវ
អតិថិជននឹងទទួលបានបញ្ចុះតម្លៃ ៤០% បើចំណាយចាប់៨០$
=if(A1>=80, “Discount 40%”, “No Discount”)
អតិថិជនម្នាក់ចំណាយអស់85$ (A1 = 85)
Discount 40%
No Discount
Total 85$
Discount 20$
Which of the following is an example of a multiplication formula?
=L3 * C7
=B2 + B3/ C4
=B4 x B6
=46 x 39
Identify the type of graph represented in the picture.
Pie
Scatter
Line
Column
What formula would I write in the blue box to count how many students prefer the beach to the pool?
=COUNTIF(A2:A15,Beach)
=COUNTIF(A2:A15,"Pool")
=COUNTIF(A2:A15,Pool)
=COUNTIF(A2:A15,"Beach")
