Computing Basics and Excel Functions
24 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the default file extension for Word documents?

  • .xls
  • .txt
  • .doc
  • .docx (correct)
  • Which of the following file formats is typically used for text documents that preserve formatting?

  • .xml
  • .pdf (correct)
  • .csv
  • .html
  • Which option is NOT a common file format used for data storage?

  • .txt
  • .xlsx
  • .mp4 (correct)
  • .jpg
  • Which file extension indicates a Microsoft Access database?

    <p>.accdb</p> Signup and view all the answers

    What does the acronym .txt represent in file formats?

    <p>Text File</p> Signup and view all the answers

    Which of the following is an example of a non-proprietary file format?

    <p>.csv</p> Signup and view all the answers

    Which file extension is commonly associated with spreadsheet software?

    <p>.xls</p> Signup and view all the answers

    Which of the following formats is specifically designed for portable document sharing?

    <p>.pdf</p> Signup and view all the answers

    What does PDF stand for?

    <p>Portable Document Format</p> Signup and view all the answers

    Which application is typically used to create PDF files?

    <p>Microsoft Word</p> Signup and view all the answers

    What is one main advantage of using PDF files?

    <p>They maintain formatting regardless of the software used.</p> Signup and view all the answers

    Which of the following is a typical use for PDF files?

    <p>For distributing fixed-layout documents, such as forms or reports.</p> Signup and view all the answers

    Which of these is a characteristic of PDF files?

    <p>They can include hyperlinks and multimedia.</p> Signup and view all the answers

    What is a common tool used to convert documents to PDF format?

    <p>Print to PDF feature</p> Signup and view all the answers

    What is a limitation of PDF files?

    <p>Editing PDF files usually requires specific software.</p> Signup and view all the answers

    Which software is primarily used for viewing PDF files?

    <p>Adobe Acrobat Reader</p> Signup and view all the answers

    Which command is used to close the currently active window in most applications?

    <p>Alt + F4</p> Signup and view all the answers

    What is the function of the TODAY() function in Excel?

    <p>Returns the current date</p> Signup and view all the answers

    Which of the following is the correct syntax to reference a cell in another worksheet in Excel?

    <p>Sheet Name!Cell Address</p> Signup and view all the answers

    Which function in Excel would you use to display the current date and time?

    <p>NOW()</p> Signup and view all the answers

    Which of the following is an example of application software?

    <p>Microsoft Word</p> Signup and view all the answers

    The primary purpose of a router in a network is to:

    <p>Connect devices to a network</p> Signup and view all the answers

    Which protocol is essential for web browsing?

    <p>HTTP</p> Signup and view all the answers

    In programming, which language is commonly associated with web development?

    <p>JavaScript</p> Signup and view all the answers

    Study Notes

    Excel Functions

    • COUNT function is used to count the number of cells containing numbers.
    • COUNTA is used to count the number of cells that are not empty.
    • COUNTIF counts the number of cells that meet a specific condition.
    • COUNTBLANK counts the number of blank cells

    Word Features

    • The feature in Word for creating bulleted or numbered lists is called "Numbering".

    Keyboard Shortcuts

    • The keyboard shortcut to undo an action is Ctrl + Z.
    • The keyboard shortcut to redo an action is Ctrl + Y.

    Computing Basics

    • "Bit" stands for "Binary Digit", and it is the smallest unit of data in a computer.
    • A byte is composed of 8 bits.
    • ROM (Read Only Memory) is a non-volatile type of memory.
    • RAM (Random Access Memory) is volatile, losing its data when the power is turned off.

    Excel Formatting

    • The default row height in Excel is 15
    • CONCATENATE function combines two or more strings in Excel.

    Word Features

    • The keyboard shortcut to find a word in a document in MS Word is Ctrl + F.
    • The shortcut key to create a hyperlink in MS Word is Ctrl + K.

    Software Types

    • MS Access is an example of database software.
    • HTML (Hyper Text Markup Language) is not a programming language but used for web development.
    • JavaScript is a common programming language used for web development.
    • MS Word, MS Excel, and Adobe Photoshop are examples of application software.
    • The most common type of software is operating system software like Windows OS.

    Computer Components

    • The CPU (Central Processing Unit) is considered the brain of the computer.
    • The ALU (Arithmetic Logic Unit) performs arithmetic and logical operations within the CPU.

    Excel & Other Software

    • The DATEDIF function in Excel calculates the number of days between two dates.
    • The MAX function finds the highest number in a range of cells.
    • Alt + F1 is the keyboard shortcut to create a chart from selected data in Excel.
    • Print Preview in MS Word allows you to preview how the document will look when printed.
    • The NOW() function in Excel returns the current date and time.

    Network Concepts

    • HTTP (Hypertext Transfer Protocol) is the protocol used for browsing the web.
    • ISP stands for Internet Service Provider.
    • A router is a networking device that connects devices to a network.
    • The feature in Word that controls the space between page content and the edge of the page is called "Margins".

    Security

    • Phishing is a type of online fraud.
    • Antivirus programs help protect computers from malicious software.

    PDF

    • PDF stands for Portable Document Format.

    • Note:* The question numbers are not included in this summary.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    p question.pdf

    Description

    Test your knowledge on essential Excel functions like COUNT, COUNTA, and CONCATENATE, as well as the basic concepts of computing. This quiz also covers critical Word features, keyboard shortcuts, and memory types. Perfect for anyone looking to enhance their computing skills!

    More Like This

    Use Quizgecko on...
    Browser
    Browser