NEW
Font size
WorksheetsMS Excel
Total questions: 20
Worksheet time: 10mins
The main function of Microsoft Excel is....
Texting Word
Manage Document
Processing Numerical Data
To help make calculating easier
The function in Microsoft Excel to add up several data is...
Count
Sum
Average
Rank
Function in Excel that is used to calculate the average of several data is...
Average
Count
Rank
Sum
To write the correct formula for the sum in cell B2 with cell C2 below is:
=Sum(B2…C2)
=Sum(B2;C2)
=Sum(B2,C2)
=Sum(B2:C2)
The shortcut key for save as in an Excel worksheet is
Alt+S
Shift+S
CTRL+Shift+S
Alt+Shift+S
B3 is an example of
Cell
Row
Column
Range
To give a frame to a cell(like table), the menu that must be selected in the Format Cells box is
Font
Alignment
Numbers
Borders
The function to combine several cells into one cell is by using
Alignment
Borders
Merge
Font
Can you insert images into an excel document?
Yes
No
What is the meaning of "Cell" in Excel?
Collection of worksheets
Collection of several cells
The intersection between rows and columns
The meeting between cells and ranges
What is the meaning of "Range" in Excel?
Collection of worksheets
A collection of several cells
The intersection between rows and columns
Worksheet in excel
Page in excel is called
Slide
Page
Table
Worksheet
The function used to calculate the smallest value of numeric data
Min
Max
Sum
Average
The function used to calculate the largest value of numeric data
Min
Max
Sum
Average
The area where Excel formulas are written is called
Menubar
Titlebar
Toolbar
Formulabar
Which of the following is a valid way to reference a cell in Excel?
1A
Row1Column1
A1
Cell(1,1)
Which of the following is NOT a valid Excel function?
Sum
Average
Rank
Searchall
To create a table in Excel, there is a sorting function, using...
Merge and center
Alignment
Filter
Borders
What is the purpose of the "Filter" function in Excel?
To display specific data based on criteria
To sort data
To format data
To hide data
Which of the following is a valid way to create a chart in Excel?
Format > Chart
View > Chart
Data > Chart
Insert > Chart
