LC3- Grade 10 Worksheet
Question 1
Circle the correct answer
1. In the figure below, the arrow is pointing to the______.
a. Split box
b. Freezing box
c. Scroll bar
d. zoom
2. In the figure below, the arrow is pointing to the______.
a. Sheet tabs
b. Insert worksheet
c. Divide line
d. Scroll bar
3. Which button is used to copy format from one paragraph and apply it to another?
a.
b.
c.
d.
4. Which button is select different type of paste options?
a.
b.
c.
5. Which of the following is Merge and Center button?
a.
b.
c.
d.
6. In the figure below, the arrow is pointing to the______.
a. Font list arrow
b. Font size list arrow
c. Font color list arrow
d. Clear Formatting
7. The number or cell reference in a Excel formula is known as a(n) ______.
a. Operator
b. Relative Cell Reference
c. Operand
d. Value
8. In Ms Excel, which tab includes the button for formatting worksheet?
a.
b.
c.
d.
9. Which of the following buttons is used to decreas the indent level?
a.
b.
c.
d.
10. Which of the following buttons is used decrease decimal numbers?
a.
b.
c.
d.
11. Which of the following is used to wrap text?
a.
b.
c.
d.
12. Which of the following is button is used to the direction of the text within the cell to Angle Counterclockwise?
a.
b.
c.
d.
13. Which of the following pointers you would select to column in a worksheet?
a.
b.
c.
d.
14. Which button is used to clear format oftext and return it to its defult format
a.
b.
c.
d.
15. ______is a set of predefined formats you can apply to some of the worksheet data, such as header row, a cell showing a total, or cell showing the date and time.
a. Font
b. Font style
c. Cell style
d. Table style
16. The following button is used to format text in______.
a. Black
b. Bright
c. Bold
d. Blend
17. The following button is used to ______text.
a. Itemize
b. Ionize
c. Ignore
d. Italicize.
18. In MS Excel,______is a set of predefined formats you can apply to all the worksheet data with a single click.
a. Font
b. Font style
c. Cell style
d. Table style
19. which following button is used to convert the table aftr applying a table style into normal range in MS. Excel
a.
b.
c.
d.
20. In the figure below, the arrow is pointing to the______.
a. Convert to range
b. Autofilter Arrow
c. Sort Arrow
d. Sort and Filter
21. In MS Excel, the following dialog box is______.
a. Table Properties
b. Custome Auto filter
c. Sort
d. Paragraph
22. In MS Excel, the following dialog box is______.
a. Table Properties
b. Custom Autofilter
c. Sort
d. Paragraph
23. ______will show exactly how the worksheet will print
a. Page break preview
b. Normal Preview
c. Page orientation
d. Oage layout
24. Which button is used to add lines under text?
a.
b.
c.
25. Which button is used to align a paragraph with both the left and right margins?
a.
b.
c.
d.
26. The group of buttons shown is called the______.
a. Direction buttons
b. Bullets buttons
c. Alignment buttons
d. Style buttons
27. The following button is used to chanhe page orientation to ______.
a. Portrait
b. Wide
c. Landscape
d. Narrow
28. In MS Excel, Formulas containing more than one operator are called______.
a. Order of evaluation
b. Operand
c. Complex formula
d. Formula
29. The ______dialog box, can be used to change page orientation, margins, add header and footer and manage printed sheet.
a. Page setup
b. Font
c. Tab
d. Borders and shading
30. When you combine adjacent cells into a single larger cell, this is______.
a. Merge
b. Split
c. Divide
d. Combine
31. Which of the following can be used to move in a excel workbook.
a. Arrow keys
b. Tab key
c. Mouse
d. All of the above
32. ______is text or graphics that appears at the bottom of every page.
a. Header
b. Footer
c. Building blocks
d. Field
33. What happens when you double click a column border?
a. The column in the table are distributed evenly.
b. The column width is adjusted to fit the text.
c. A new column is added to the right.
d. A new column is added to the left.
34. What is the result of the following formula =(8*4)-(4/4)?
a. 24
b. 36
c. 48
d. 31
35. When typing the formula, it will be shown or appear in
a. Formula bar
b. Cell
c. Address bar
d. Both a and b
36. ______does not change when formula is copied or moved to a new location.
a. Relative cell reference
b. Absolute cell refrence
c. Mixed cell refrence
d. All of the above
37. Which key used to change the cell refrence from relative to absolute to mixed.
a. F1
b. F2
c. F3
d. F4
38. MS excel contains 300 built-in function for performing calculations,______perform calculations that you could perform using scientific calculator.
a. Statistical Functions
b. Mathematical Functions
c. Normal Functions
d. Algebra Functions
39. The components of the function formula are
a. Equal sign
b. Function name
c. Arguments
d. All of the above
40. The pointing arrow in the following figure pointing to
a. Equal sign
b. Function name
c. Arguments
d. Range
41. The following symbol ∑ is for
a. Average range of cells
b. Find the maximum of range of cells
c. Sum range of cells
d. Find the minimum of range of cells
42. To remove the error shown in the cell #####, you should
a. Remove the circular reference
b. Replace missing data
c. Increase the size of the column
d. Decrease the size of the column
43. ______useful in showing changes over a period of time, or making comparison among individual items.
a. Line chart
b. Column chart
c. Pie chart
d. Bar chart
44. You can create an instant chart by selecting the data and pressing
a. F1
b. F11
c. F4
d. F6
45. #NULL! Error caused by
a. Invalid numeric values in a formula.
b. Link to a program that is not running
c. Space where it isn’t approprite
d. Cell refrence in the formula refers back to its own cell.
46. #NUM! Error caused by
a. Invalid numeric values in a formula.
b. Link to a program that is not running
c. Space where it isn’t approprite
d. Cell refrence in the formula refers back to its own cell.
47. #REF! Error caused by
a. Invalid numeric values in a formula.
b. Link to a program that is not running
c. Space where it isn’t approprite
d. Cell refrence in the formula refers back to its own cell.
48. ______is a graphical representation of your worksheet data.
a. Pictures
b. Header and footer
c. Charts
d. Formulas
49. Which of the following pictures shown when an error exist next to the cell, which shows a screen tip describing the error.
a.
b.
c.
d.
50. Which of the following buttons used to collapse dialog button
a.
b.
c.
2