BECE / ICT HOT OBJECTIVES AND ANSWERS (SPREADSHEET)

 

1.    What is Microsoft Excel primarily used for?

a) Sending emails

b) Creating spreadsheets

c) Editing photos

d) Writing documents

2.    Which of the following is a cell reference in Excel?

a) A1

b) WordArt

c) ClipArt

d) Ctrl+C

3.    What is the intersection of a row and a column called in Excel?

a) Cell

b) Cell range

c) Spreadsheet

d) Chart

4.    Which Excel feature is used to automatically sum a range of numbers?

a) AutoFormat

b) AutoSum

c) AutoCorrect

d) AutoFilter

5.    What do you use to change the width of a column in Excel?

a) Mouse pointer

b) Keyboard arrows

c) Format Painter

d) Page Layout view

6.    In Excel, what function would you use to find the highest value in a range of cells?

a) MAX

b) MIN

c) SUM

d) AVG

7.    What is the shortcut key to paste values only in Excel?

a) Ctrl+V

b) Ctrl+C

c) Ctrl+Alt+V

d) Ctrl+Shift+V

8.    Which Excel feature is used to organize and analyze data in rows and columns?

a) Charts

b) Filters

c) Formulas

d) Macros

9.    Which tab in Excel contains commands for formatting cells and text?

a) Home

b) Insert

c) Data

d) View

10. How do you freeze panes in Excel?

a) Click on the "Freeze Panes" button under the "View" tab

b) Press Alt+F4

c) Right-click on the cell and choose "Freeze Panes"

d) Press Ctrl+P

11. Which Excel feature allows you to visually represent data through graphical elements?

a) Formulas

b) Charts

c) Filters

d) Sort

12. What is the function of the COUNTIF formula in Excel?

a) To count the total number of cells in a range

b) To count the number of cells that meet a specific condition

c) To count the number of rows in a worksheet

d) To count the number of columns in a worksheet

13. Which Excel tool is used to find and correct spelling mistakes in a worksheet?

a) Spell Check

b) AutoSum

c) Format Painter

d) Sort

14. What is the keyboard shortcut to save an Excel workbook?

a) Ctrl+P

b) Ctrl+S

c) Ctrl+X

d) Ctrl+Z

15. What does the "Merge & Center" option do in Excel?

a) Combines two cellsinto one and centers the content

b) Splits a cell into multiple cells

c) Converts text to numbers

d) Copies formatting from one cell to another

16. How do you apply a filter to a range of data in Excel?

a) Right-click on a cell and choose "Filter"

b) Click on the "Filter" button under the "Insert" tab

c) Click on the "Filter" button under the "Data" tab

d) Press Ctrl+Shift+F

17. What is the default extension of an Excel workbook file?

a) .docx

b) .xls

c) .ppt

d) .pdf

18. Which Excel feature is used to perform calculations on a range of cells?

a) Macros

b) Filters

c) Formulas

d) Charts

19. What is the purpose of the "IF" function in Excel?

a) To format cells based on specific conditions

b) To add rows and columns to a worksheet

c) To insert images into a worksheet

d) To perform logical tests and return different values based on theresult

20. How do you delete a worksheet in Excel?

a) Press Alt+Delete

b) Right-click on the worksheet tab and choose "Delete"

c) Press Ctrl+C

d) Click on the "Delete" button under the "View" tab