WorksheetsTLE MS Excel
Total questions: 24
Worksheet time: 48mins
Shows the contents of the active cell and can be used to edit it
Formula bar
Sheet box
Row heading
Active cell
Horizontal bars on top of the worksheet. They are labeled with letters from A to XFD.
Column heading
Sheet tabs
Row heading
Active cell
Components of MS Excel that contains the names of the available worksheets in the workbook.
Sheet tabs
Row heading
Active cell
Name box
Vertical bars at the left side of the worksheet. They are labeled number from 1 to 1048576.
Row heading
Column heading
Formula bar
Active cell
Auto Sum function used to compute the total of all items in the specified range
=Sum(range)
=Average(range)
=Count(range)
=Max(range)
Auto Sum function used to count the values found in the range
=Sum(range)
=Average(range)
=Count(range)
=Max(range)
Auto Sum function used to get the average of the items in a range
=Sum(range)
=Average(range)
=Count(range)
=Max(range)
Auto Sum function used to get the largest value within the range
=Sum(range)
=Average(range)
=Count(range)
=Max(range)
Auto Sum function used to get the smallest value within the range
=Sum(range)
=Average(range)
=Min(range)
=Max(range)
A widely used spreadsheet program.
Microsoft Excel
Open office Calc
Lotus 1-2-3
Quattro Pro
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign =
Equal to
Subtract
Unequal
Division
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign ^
Equal to
Exponentiation
Unequal
Division
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign -
Equal to
Exponentiation
Subtraction
Division
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign &
Equal to
Exponentiation
Subtraction
Concatenation
What function in excel should use to accomplish the the given problem. You want to find the cheapest brand from worksheet about burgers of all popular fast food chain
Sum
Min
Max
Average
What function in excel should use to accomplish the the given problem. You want to know who is the tallest player if from a worksheet of basketball league.
Sum
Min
Max
Average
What function in excel should use to accomplish the the given problem. You want to determine the number of registered voters from an electoral worksheet.
Sum
Min
Max
Average
What function in excel should use to accomplish the the given problem. You want to know the total number of canned goods from worksheet about donations that a charitable organization has gathered
Sum
Min
Max
Average
Give the correct analogy
MS Word:Document:MS Excel:___________
Workbook
Sheet tabs
Slides
Spreadsheet
Give the correct analogy
MS PowerPoint:Presentation Tool :MS Excel:___________
Spreadsheet program
Word Processing
Computation program
Liver-spread program
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign /
Equal to
Exponentiation
Subtraction
Division
Identify the operation represented by the operators used in Microsoft Excel. What do you call this sign *
Multiplication
Exponentiation
Subtraction
Division
Based on the given picture identify the active cell
(a)
Based on the given picture identify the formula of cell aaddress J9
(a)
