SSC CGL Computer Proficiency And Skill (Tier Ii Module) Flashcards

24 sample cards from the Computer Proficiency And Skill (Tier Ii Module) deck

Sampled from the end of the deck, so these are different cards from the ones shown on the syllabus page.

1. What is MS Excel and what file extension do its workbooks use?

   MS Excel is a spreadsheet application used for calculations, data analysis, charts, and tables organized in rows and columns. Files use the .xlsx extension (older: .xls).

2. In Excel, what is a cell, and how is a cell reference like A1 formed?

   A cell is the intersection of a row and a column where data is entered. A reference combines the column letter and row number, e.g., A1 means column A, row 1.

3. What symbol must every Excel formula begin with, and write the formula to add cells A1 to A10.

   Every formula begins with the equals sign (=). To add A1 through A10: =SUM(A1:A10).

4. In Excel, what do the AVERAGE, MAX, MIN, and COUNT functions do?

   AVERAGE returns the mean of values; MAX returns the largest value; MIN returns the smallest value; COUNT counts the number of cells containing numbers in a range.

5. What is the difference between a relative and an absolute cell reference in Excel?

   A relative reference (A1) changes when a formula is copied to another cell. An absolute reference ($A$1) stays fixed when copied, using dollar signs to lock the column and/or row.

6. What does the Excel IF function do? Give its basic syntax.

   IF performs a logical test and returns one value if true and another if false. Syntax: =IF(condition, value_if_true, value_if_false).

7. What is MS PowerPoint and what file extension do its presentations use?

   MS PowerPoint is presentation software used to create slide shows with text, images, charts, and multimedia. Files use the .pptx extension (older: .ppt).

8. In PowerPoint, what is the difference between a 'transition' and an 'animation'?

   A transition is the visual effect when moving from one slide to the next. An animation is an effect applied to individual objects (text, images) within a single slide.

9. Which key starts a PowerPoint slide show from the beginning, and which from the current slide?

   F5 starts the slide show from the beginning; Shift+F5 starts it from the current slide. Press Esc to end the show.

10. What is the difference between Normal view and Slide Sorter view in PowerPoint?

    Normal view is the main editing view showing one slide at a time with the outline/thumbnail pane. Slide Sorter view shows all slides as thumbnails for easy reordering and organizing.

11. What is the difference between a file and a folder?

    A file is a collection of related data stored under a single name (e.g., a document or image). A folder (directory) is a container used to organize and group multiple files and subfolders.

12. What do the shortcuts Ctrl+C, Ctrl+X, and Ctrl+V do in file management?

    Ctrl+C copies the selected item, Ctrl+X cuts (moves) it, and Ctrl+V pastes it into the new location.

13. What do the shortcuts Ctrl+Z and Ctrl+Y do?

    Ctrl+Z undoes the last action; Ctrl+Y redoes the action that was undone.

14. What is a file extension and what does .pdf indicate?

    A file extension is the suffix after the dot in a filename indicating the file type/format. .pdf indicates a Portable Document Format file, which preserves layout across devices.

15. What is the Internet and how does it differ from the World Wide Web (WWW)?

    The Internet is the global network of interconnected computers. The WWW is a service running on the Internet, consisting of interlinked web pages accessed via browsers using HTTP/HTTPS.

16. What is a web browser and name three examples?

    A web browser is software used to access and display web pages on the Internet. Examples: Google Chrome, Mozilla Firefox, Microsoft Edge, Safari, Opera.

17. What does a URL stand for and what are its main parts?

    URL stands for Uniform Resource Locator, the address of a web page. It includes the protocol (https://), domain name (www.example.com), and optional path/file (e.g., /page.html).

18. What is the difference between HTTP and HTTPS?

    HTTP (HyperText Transfer Protocol) transfers web data in plain text. HTTPS adds SSL/TLS encryption (the 'S' = Secure), protecting data exchanged between browser and server.

19. What is a search engine and name two examples?

    A search engine is a web service that finds and lists web pages matching a user's query keywords. Examples: Google, Bing, Yahoo, DuckDuckGo.

20. In email, what is the difference between CC and BCC?

    CC (Carbon Copy) sends a copy to recipients whose addresses are visible to all. BCC (Blind Carbon Copy) sends a copy while keeping those recipients' addresses hidden from others.

21. What is the difference between a LAN and a WAN?

    A LAN (Local Area Network) connects computers within a small area like an office or building. A WAN (Wide Area Network) connects computers over large geographic areas, such as cities or countries; the Internet is the largest WAN.

22. What is malware, and name three common types?

    Malware is malicious software designed to harm, exploit, or gain unauthorized access to a computer. Common types: virus, worm, Trojan horse, ransomware, spyware.

23. What is phishing in the context of cyber security?

    Phishing is a fraudulent attempt to obtain sensitive information (passwords, bank details) by disguising as a trustworthy entity, usually through fake emails, messages, or websites.

24. What is a firewall and what is its purpose?

    A firewall is a security system (hardware or software) that monitors and controls incoming and outgoing network traffic based on rules, blocking unauthorized access while permitting legitimate communication.

What this deck covers

Computer Proficiency And Skill (Tier Ii Module) flashcards FAQ