Excel Exercise 1 Practice Questions
1. What is the combination of the column letter and the row number that
designate a specific cell called?
a. Cell reference
b. Cell address
c. Cell name
d. All the above
2. What displays the name or address of the selected cell.
a. Name box
b. Formula bar
c. Cell
d. Rows
3. What is the name given to Excel files ____
a. Worksheet
b. Workbook
c. Name box
d. Formula bar
4. What is formed by the collection of columns and rows?
a. Worksheet
b. Workbook
c. Name box
d. Formula bar
5. Excel files or Workbook can contain one or more worksheets. (True / False)
6. What key do you press to select a non-continuous range of cells?
a. Press Ctrl
b. Press Enter
c. Press Tab
7. Which of the following feature is used for copying formats and
formulas, filling in lists, dates, numbers to rest of the cells?
a. Auto Fill
b. Auto fit column width
c. Insert sheet rows
d. Insert sheet columns
8. You can hide or unhide the column/rows in excel. (True/False)
9. what symbol appears, If a column is too narrow to display all contents?
a. #####
b. ?????
c. !!!!!!!!
d. *****
10. What happens after you enter the new column width value?
a. The column is deleted
b. The column width will be changed
c. The column height will be adjusted
d. A new column is inserted
11. After clicking the Format command, what should you select to
change the column width?
a. Row height
b. Column width
c. Column height
d. Default width
12. Which of the following sequence of steps is correct to rotate the text horizontally or
vertically,
I. Click the required cell or group of cells to rotate.
II. Select one of the orientation styles in the dropdown list of
III. Click the Orientation command under Home tab.
a. I, II, III
b. I, III, II
c. II, I, III
13. Which options should be used to write the text as shown in the figure.
a. Merge and centre
b. Wrap text
c. Conditional Formatting
14. Which excel feature is used here?
a. Merge and centre
b. Wrap text
c. Conditional Formatting
15. What is known as the equations that perform calculations on values
in your Excel worksheet.
a. Formula
b. Functions
c. Sum
d. Workbook
16. Which cell style is used here?
a. Check Cell
b. Warning text
c. Output
17. Which if the following symbols is necessary to write the formulas in
Excel?
a. =
b. +
c. *
d. #
18. Which of the formula is correct to calculate the percentage of
student?
a. =C2/100 *100
b. =C2//100 *100
c. C2/100 *100
d. =C2*100 *100
19. Which of the following is used to combine two or more cells in Excel?
a. &
b. *
c. /
d. #
20. Which of the following option is correct to change the percentage in
cell D2 to Percentage format.
I. Select the required cells.
II. Use drop down and select Percentage format
III. Go to the Home tab, go to Number group
a. I, II, III
b. I, III, II
c. II, 1, III
21. Which of the following is the absolute formula?
a. =C2*$G$1
b. C2*$G$1
c. =C2*&G&1
d. =C2*G1
22. Which of the formula is correct for calculating Peter’s total hours in
cell G4.
a. =Sum (b4: f4)
b. =Sum (b4, c4, d4, e4, f4)
c. Sum (b4: f4)
d. Both a and b
23. What happens when you drag the Fill Handle over a range of cells?
a. The selected cells are deleted
b. The formula or value is copied to the selected range
c. A new worksheet is created
d. The cursor changes to hand icon
24. When a user copied the formula =B3+C3 from row 3 to row 4, the
formula became =B4+C4. Which type of cell reference is this?
a. Absolute
b. Relative
c. Relatively absolute
d. Both a and b
25. Which of the following is used to apply data bars to one or more
cells based on the cell value.
a. Absolute
b. Relative
c. Conditional Formatting
d. Data visualization
26. Which of the following is used to remove all conditional formatting
from the worksheet.
a. select Clear Rules from Entire Sheet.
b. select Clear Rules from selected cell.
c. select Clear Rules from Entire Workbook.
d. None of the above
27. What makes easy for users to compare and see patterns and trends
in the data.
a. Charts
b. Formula
c. Functions
d. Formatting
28. Which of the following is the range
a. A1:D7
b. A1, D7
c. “A1D7”
d. None of the above
29. Every chart should be labelled appropriately
a. True
b. False
30. Which of the following are the important chart elements
a. Data labels
b. Chart title
c. X and Y axis titles
d. All of them
31. Which of the following is used if table has mixed data types or data
with different units.
a. Combinational (Combo) Chart.
b. Pie chart
c. Column chart
d. All the above
32. Which of the following is used to label the chart.
a. Design tab
b. + button
c. Both a and b
d. None of them
**********************************The
End****************************************
