Podcast
Questions and Answers
What is the default file extension for Word documents?
What is the default file extension for Word documents?
Which of the following file formats is typically used for text documents that preserve formatting?
Which of the following file formats is typically used for text documents that preserve formatting?
Which option is NOT a common file format used for data storage?
Which option is NOT a common file format used for data storage?
Which file extension indicates a Microsoft Access database?
Which file extension indicates a Microsoft Access database?
Signup and view all the answers
What does the acronym .txt represent in file formats?
What does the acronym .txt represent in file formats?
Signup and view all the answers
Which of the following is an example of a non-proprietary file format?
Which of the following is an example of a non-proprietary file format?
Signup and view all the answers
Which file extension is commonly associated with spreadsheet software?
Which file extension is commonly associated with spreadsheet software?
Signup and view all the answers
Which of the following formats is specifically designed for portable document sharing?
Which of the following formats is specifically designed for portable document sharing?
Signup and view all the answers
What does PDF stand for?
What does PDF stand for?
Signup and view all the answers
Which application is typically used to create PDF files?
Which application is typically used to create PDF files?
Signup and view all the answers
What is one main advantage of using PDF files?
What is one main advantage of using PDF files?
Signup and view all the answers
Which of the following is a typical use for PDF files?
Which of the following is a typical use for PDF files?
Signup and view all the answers
Which of these is a characteristic of PDF files?
Which of these is a characteristic of PDF files?
Signup and view all the answers
What is a common tool used to convert documents to PDF format?
What is a common tool used to convert documents to PDF format?
Signup and view all the answers
What is a limitation of PDF files?
What is a limitation of PDF files?
Signup and view all the answers
Which software is primarily used for viewing PDF files?
Which software is primarily used for viewing PDF files?
Signup and view all the answers
Which command is used to close the currently active window in most applications?
Which command is used to close the currently active window in most applications?
Signup and view all the answers
What is the function of the TODAY() function in Excel?
What is the function of the TODAY() function in Excel?
Signup and view all the answers
Which of the following is the correct syntax to reference a cell in another worksheet in Excel?
Which of the following is the correct syntax to reference a cell in another worksheet in Excel?
Signup and view all the answers
Which function in Excel would you use to display the current date and time?
Which function in Excel would you use to display the current date and time?
Signup and view all the answers
Which of the following is an example of application software?
Which of the following is an example of application software?
Signup and view all the answers
The primary purpose of a router in a network is to:
The primary purpose of a router in a network is to:
Signup and view all the answers
Which protocol is essential for web browsing?
Which protocol is essential for web browsing?
Signup and view all the answers
In programming, which language is commonly associated with web development?
In programming, which language is commonly associated with web development?
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
, andAdobe 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 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.
Related Documents
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!