NEW
Font size
Worksheets9th_1st quarter Excel Examination
Total questions: 30
Worksheet time: 15mins
What does every formula in MS EXCEL start with?
+
-
=
*
Excel file is saved as a ____________
Document
workbook
worksheets
Presentation
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
To colour those cells blue where temperature is above 50 degree you will
Apply filtering
Use fill colour option
Shade Cells
Use Conditional Formatting
What is the meaning of ####### in a cell?
Entered formula is wrong
Invalid date or time
The width of the cell is not enough to show the number
The height of the cell is very little
See the following formula. Which of the following formula is the another method of the given formula?
=(B2+C2+D2+E2)/4
= SUM (B2,C2,D2,E2)
= MAX(B2:E2)
= SUM(B2,E2/4)
= AVERAGE (B2:E2)
The result of the following Excel formula is____?
=SUM(Max(9,5,1),Average(3,4,8))
9
14
5
18
You have a list which contains students information from all classes. But, you want to see only one class. Which Excel feature should you use?
Validation
Filter
Data Validation
Format as Table
Cell A1 contains a Function that shows the following data. What can be the function in A1?
22.10.2020
=TIME()
=ABS(-18.12)
=TODAY()
=NOW()
The box on the chart that contains the name of each individual record is called a ________.
Cell
Title
Legend
Zoom
Which function should be written in the D6 selected cell to have such result?
=COUNT(C4,D3)
=SUM(A1,B2)
=AVERAGE(A1:C4)
Which of the following is a valid formula in Excel?
=A1<>4A
K1+K9
=SUMM(A2:B6)
=D3/E4
Which of the followings can not be performed in Microsoft Excel?
Creating chart, making mathematical calculations.
Inserting pictures, creating table.
Making graphic design
Using formulas and functions
How many cells have from B3:B8?
What is the name given to the intersection of a row and a column in a spreadsheet?
cell
cell range
active cell
Numbers down the left side of the spreadsheet are referred to as?
formula column
formula bar
row labels
Which of the formula's would correctly output Yes/No in column D.
=IF(D2 < 10) "Yes", "No"
=IF(D2 < 10, "Yes", "No")
=IF(D2 > 10, "Yes", "No")
IF(D2 > 10, "Yes", "No")
Which of the formula's would output the price of the cheapest item in the bakery?
=MIN(B2:B7)
=LOW(B2:B7)
=SML(B2:B7)
=BOTTOM(B2:B7)
Example: Your grade in Reading since the beginning of this year.
Example: % of people who bought whole milk and % of people who bought skim milk in December.
This part of the chart is usually vertical and contains data.
Y axis
X axis
Legend
Chart title
What are some common chart elements in Excel?
titles, axes, data labels, legends, gridlines, and trendlines
formulas, functions, macros, pivot tables
colors, fonts, shapes, sizes
bars, pie slices, scatter points, lines
