1. What is the shortcut key to paste content from the clipboard in Windows?
a) Ctrl + V b) Ctrl + P c) Ctrl + C d) Ctrl + X
2. Which of the following is an example of an output device?
a) Keyboard b) Mouse c) Monitor d) Scanner
3. What does HTML stand for?
a) Hyper Tool Markup Language b) Hyper Text Markup Language
c) Hyperlinks and Text Markup Language d) High-level Text Markup Language
4. Which of the following file extensions represents a spreadsheet file?
a) .docx b) .xlsx c) .pptx d) .txt
5. What is the function of the CTRL + Z shortcut key?
a) Cut b) Undo c) Copy d) Paste
6. In Microsoft Excel, what function would you use to find the highest value in a range of
cells?
a) MAX b) MIN c) AVERAGE d) SUM
7. What does CSV stand for?
a) Comma-Separated Values b) Computer System Validation
c) Common Source Versioning d) Code Structured Variables
8. What is the purpose of a pivot table in Excel?
a) To calculate averages b) To create charts
c) To summarize and analyze data d) To sort data alphabetically
9. What does "F" mean on the F1, F2, F3, F4, etc. keyboard keys?
a. Find b. File c. Format d. Function
10. You have completed the worksheet and want to make certain that you have not made
spelling or grammar errors. Which button will you select?
a. A b.B c.C d. D
11. Which software is commonly used for data entry tasks?
a) Microsoft Word b) Microsoft Excel c) Adobe Photoshop d) Mozilla Firefox
12. What does the term "data validation" refer to in the context of data entry?
a)Checking for data accuracy b) Ensuring data security
c) Verifying data integrity d) Validating user input against specified criteria
13. Which keyboard shortcut is used to copy selected data?
a) Ctrl + C b) Ctrl + V c) Ctrl + X d) Ctrl + Z
14. What is the purpose of using filters in spreadsheet programs like Microsoft Excel?
a)To apply formatting to cells b) To perform calculations
c) To organize and manipulate data d) To create charts and graph
15. A computer cannot boot if it does not have the
a) Compiler b) Loader c) Operating System d) Assembler
16. How rows are numbered in MS Excel?
a) Alphabetically b) Numerically c) Alphanumerically d) Special characters
17. How columns are named in MS Excel?
a) Alphabetically b) Numerically c) Alphanumerically d) Special characters
18. What type of software is MS Office?
a) Application Software b) Operating System
c) Programming Language d) System Software
19. What is the file extension of Excel 2010?
a) xls b) xlsb c) xlsm d)xlsx
20. Which one of the following will starts with “=” sign in Excel 2010?
a) Data b) Text c)Numbers d)Formulas
21. Which of the following is a data validation technique?
a) Data compression b) Data encryption
c) Data scrubbing d) Data verification
22. What is the correct sequence of steps to sort data in Microsoft Excel?
a) Select data range, click on the Sort button, choose sorting options
b) Select data range, choose sorting options, click on the Sort button
c) Choose sorting options, select data range, click on the Sort button
d) Click on the Sort button, select data range, choose sorting options
23. The part of a computer that coordinates all its functions is called
a)ROM program b) System Board c) Arithmetic Logic Unit d) Control unit
24. By default, MS-PowerPoint 365 presentations are saved with which of the following
extensions?
A) .xps B) .pptm C) .pptx D) .ppt
[Link] you are typing an equation into a cell the first thing that must be entered is
_________.
a) Parenthesis b) The first cell referenced
c) Quotation marks d) An equal sign
[Link] Which of the following options is not available in Insert >> Picture?
a) Chart b) Clip Art c) Graph d) Word Art
27. Which command is used to delete all the files with extension .txt on the current drive and
directory?
a) Erase .txt b) Del .txt c) Del ./p d) Del *.txt
28. What is the main advantage of networking?
a) Sharing of data b) Sharing of peripherals
c) All of these d) Interactive data transfer
29. which command is used to copy all files with extension .txt into one file named [Link]?
a) Copy *.txt a:
b) Copy *.txt [Link]
c) Copy a: *.txt
d) Copy *.txt c:
30. Excel uses the _________ Function when creating a data table.
a) Sum b) Table c) Average d) Count
31.
