Podcast
Questions and Answers
What is the shortcut key for saving a document in MS Excel?
What is the shortcut key for saving a document in MS Excel?
Which of the following shortcut keys is used for cutting text?
Which of the following shortcut keys is used for cutting text?
Which of the following is NOT a function in Microsoft Excel spreadsheets?
Which of the following is NOT a function in Microsoft Excel spreadsheets?
What is Microsoft PowerPoint used for?
What is Microsoft PowerPoint used for?
Signup and view all the answers
Which command can be used to paste copied content?
Which command can be used to paste copied content?
Signup and view all the answers
What does the shortcut Ctrl + A do in MS Word?
What does the shortcut Ctrl + A do in MS Word?
Signup and view all the answers
To create a new workbook in MS Excel, which shortcut is used?
To create a new workbook in MS Excel, which shortcut is used?
Signup and view all the answers
In the SQL statement INSERT INTO employee, what is required in the parentheses?
In the SQL statement INSERT INTO employee, what is required in the parentheses?
Signup and view all the answers
What are the components of a table in Excel?
What are the components of a table in Excel?
Signup and view all the answers
Which function is NOT one of the five basic functions of Excel?
Which function is NOT one of the five basic functions of Excel?
Signup and view all the answers
What does DBMS stand for?
What does DBMS stand for?
Signup and view all the answers
How can you create a table in SQL?
How can you create a table in SQL?
Signup and view all the answers
Which feature allows you to send the same letter to different people?
Which feature allows you to send the same letter to different people?
Signup and view all the answers
Which of the following is NOT a type of entry in accounting?
Which of the following is NOT a type of entry in accounting?
Signup and view all the answers
What is needed to combine multiple text documents in MS Word?
What is needed to combine multiple text documents in MS Word?
Signup and view all the answers
Which term refers to adjusting the space between lines in a document?
Which term refers to adjusting the space between lines in a document?
Signup and view all the answers
Flashcards
Excel Table
Excel Table
A table in MS Excel is an organized arrangement of data in rows and columns, making it easy to view, sort, and analyze information.
Excel Row
Excel Row
A row in MS Excel is a horizontal series of cells containing related data.
Excel Column
Excel Column
A column in MS Excel is a vertical series of cells containing data which relates to a specific category or property.
Excel Cell
Excel Cell
Signup and view all the flashcards
Excel Basic Functions
Excel Basic Functions
Signup and view all the flashcards
Mail Merge (MS Word)
Mail Merge (MS Word)
Signup and view all the flashcards
Database Sorting
Database Sorting
Signup and view all the flashcards
Database Filtering
Database Filtering
Signup and view all the flashcards
Ctrl+S in MS Excel
Ctrl+S in MS Excel
Signup and view all the flashcards
Cut, Copy, Paste shortcuts
Cut, Copy, Paste shortcuts
Signup and view all the flashcards
Microsoft PowerPoint
Microsoft PowerPoint
Signup and view all the flashcards
Spreadsheet program
Spreadsheet program
Signup and view all the flashcards
Function in Excel
Function in Excel
Signup and view all the flashcards
SQL keyword INSERT INTO
SQL keyword INSERT INTO
Signup and view all the flashcards
Database Management System
Database Management System
Signup and view all the flashcards
SQL Field keyword
SQL Field keyword
Signup and view all the flashcards
Study Notes
MS Excel
- Define table, row, column, and cell in MS Excel
- List 5 basic functions of Excel
MS Word
- Explain header and footer
- Explain 2 line spacing in MS-Word
Database Management System (DBMS)
- Define DBMS
- Explain how to create a table in SQL
Tally
- List 3 accounts in Tally
General Office Automation
- Explain how to send the same letter to different people (e.g., using templates or mail merge)
- Explain sorting and filtering in a database
- Define voucher entry and describe various types of vouchers in Tally
- Explain Cut, Copy, Paste, and Format Painter functions
- State the shortcut keys for Cut, Copy, and Paste
- Define Microsoft PowerPoint
- State the full form of DBMS
- Explain how to create a bulleted or numbered list in Word.
- Define DR and CR in Tally.
- Detail the use of pictures in MS Word
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Related Documents
Description
Test your knowledge on various office automation tools including MS Excel, MS Word, and Database Management Systems. This quiz covers definitions, functions, and basic operations you need to efficiently use these applications. Challenge yourself with questions on Tally and general office practices as well!
