NEW
Font size
WorksheetsMs Excel Test
Total questions: 20
Worksheet time: 10mins
What is the Sum formula?
Sum( )
=( )Sum
Sum( )=
=Sum( )
When starting a formula what is the first thing you type in the cell?
%
#
&
=
ដើម្បីកំណត់ថ្ងៃខែត្រឹមត្រូវក្នុង Excel ត្រឹមត្រូវយើងត្រូ?
Format Cell => Number => Ok
Format Cell => Time => Ok
Format Cell => Date => Ok
Format Border => Cell => Ok
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
Bottom left of spreadsheet document
What version of Excel are we using in class?
Excel 2016
Excel 2018
Excel 2019
Excel 2013
If you see a series of "######" in a cell, that means the following:
You keyed in an incorrect number
The text is incorrectly spelled
The column width is not wide enough
The row height is too high
What is the name of this cell?
A4
B4
C4
D4
តើយើងប្រើប្រាស់ រូបមន្ត Sum ដើម្បីអ្វី?
ដើម្បី ដកតម្លៃផ្សេងៗ
ដើម្បី បូកសរុបតម្លៃអ្វី
ដើម្បី គុណតម្លៃណាមួយ
ដើម្បី ចែករកនូវតម្លៃអ្វីមួយ
តើយើងប្រើប្រាស់ រូបមន្ត Average ដើម្បីអ្វី?
បូកសរុបតម្លៃអ្វីមួយ
រកនូវចំនួនគត់ណាមួយ
រកមធ្យមភាគសិស្ស
រកចំនួនទស្សភាគ
តើយើងប្រើប្រាស់ រូបមន្ត rank ដើម្បីអ្វី?
រកតម្លៃណាមួយជាចំនួនទស្សភាគ
រកតម្លៃណាមួយជាចំនួនឯកតា
រកតម្លៃសរុបណាមួយ
រកចំណាត់ថ្នាក់សិស្សដែលបានពិន្ទុខ្ពស់
តើយើងប្រើប្រាស់ រូបមន្ត if ដើម្បីអ្វី?
ការកំណត់ ចំនួនគត់
ការកំណត់ ចំនួនទស្សភាគ
ការកំណត់លក្ខ័ណ្ឌណាមួយដែលយើងចង់បាន
ការកំណត់ តម្លៃខ្ទង់រាយ
How do you insert a new row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
Select the row heading where you want to insert the new row and select Edit >Row from the menu
All of the above
Which formula gets the biggest value of a range of cells?
Min
Max
Average
Sum
Which formula gets the smallest value of a range of cells?
Min
Max
Average
Sum
Which formula would you use to calculate how many sales are over $20 from a series.
=Countif
=Sumif
=if
=count
_____ are vertical.
Row
Column
________ are horizontal
Columns
Rows
A(n) _________ is a prewritten formula that is built into EXCEL.
function
equation
problem
equal sign
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
Cell address
Formula
Worksheet
Excel allows you to
invent ideas
read stories
work with data
work with row
