Computer Fundamental and Programming (EXCEL)
1. The intersection of a row and a column is called a ________. Ans: Cell
2. A group of cells is called a ________. Ans: Cell range
3. Where is the fill handle located? Ans: in the bottom-right corner of the selected cell
4. In this image, why does the value in cell G1 look slightly different from the value in the formula bar?
Ans: It’s using the Currency number format.
5. You can click the tabs at the bottom of a workbook to switch between ________. Ans: Worksheet
6. Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?
Ans: It should have an equals sign (=) at the beginning.
7. True or False: You can view a formula by double-clicking the cell that contains the formula. ANS: True
8. Which of the following is an absolute cell reference? Ans: $A$2
9. Which of the formulas below are valid? Select all that apply.
Ans: =F2+F3+F4-53 and =R2*D2
10. What value would Excel return for this formula? =(82-32)/5+8*2
Ans: 26
11. What feature did we use to quickly apply the formatting shown in this image?
Ans: Conditioning Formatting
12. What is the main advantage of selecting the Mark as Final option?
Ans: It discourages other users from editing the workbook.
13. The four areas in this image are used to create a ________.
Ans: Pivot Table
14. Which feature starts with a desired result, then calculates the input value that will give that result?
Ans: Goal Seek
15. What is a workbook in Excel? Ans: a file that stores one or more worksheets
16. How can you select multiple cells at once in Excel? Ans: All of these ways
17. How do you resize a column or row in Excel? Ans: Click and drag the border of the column or row.
18. How do you merge two or more cells in Excel?
Ans: Select the cells you want to merge, then click the "Merge & Center" button on the Home tab.
19. What number format(s) can you use in Excel? Ans: All of these format
20. How do you apply a cell style to a range of cells in Excel?
Ans: Click the "Cell Styles" button on the Home tab, then select the style you want to apply.
21. Which of the following is NOT a type of alignment in Excel? Ans: Forward
22. What is the purpose of grouping worksheets in Excel?
Ans: all of these functions
23. What symbol is used in Excel formulas to represent multiplication? Ans: *
24. What is the formula to calculate the sum of cells A1 through A5? Ans: =SUM(A1:A5)
25. What is an example of a relative cell reference? Ans: A1
26. Which option allows you to lock certain rows or columns in place while scrolling through a large worksheet?
Ans: Freeze Panes
27. What is filtering in Excel? Ans: viewing data based on certain criteria
28. Which chart type would be best for comparing values across categories? Ans: Column chart
29. What is a PivotTable? Ans: a tool used to summarize data
30. What is the goal of "What-if" analysis? Ans: to explore how changing input values affects calculated values