All Exams  >   Class 5  >   Year 5 Computing IGCSE (Cambridge)  >   All Questions

All questions of MS Office at a Glance for Class 5 Exam

What can you do with Microsoft Access that you cannot do with Microsoft Excel?
  • a)
    Manage complex datasets with relationships
  • b)
    Create presentations
  • c)
    Perform basic calculations
  • d)
    Write text documents
Correct answer is option 'A'. Can you explain this answer?

Vp Classes answered
Microsoft Access allows users to manage complex datasets that involve multiple relationships between tables, which is something Excel is not designed to do. Access is optimized for database management, enabling efficient data retrieval and organization, making it suitable for large-scale data projects.

In Microsoft Word, which formatting option allows you to emphasize text for headings?
  • a)
    Italics
  • b)
    Underline
  • c)
    Center alignment
  • d)
    Bold
Correct answer is option 'D'. Can you explain this answer?

The bold formatting option is commonly used in Microsoft Word to highlight headings, making them stand out in a document. This helps improve the document's organization and readability, allowing readers to quickly identify important sections. An interesting note is that the use of bold text dates back to early print media, where it was employed to draw attention to key information.

What is the purpose of using formulas in Excel?
  • a)
    To change formatting of cells
  • b)
    To create text documents
  • c)
    To insert images
  • d)
    To perform calculations
Correct answer is option 'D'. Can you explain this answer?

Formulas in Excel are used to perform calculations on data within the spreadsheet. For example, using a formula like =SUM(A1:A5) allows users to quickly calculate the total of a range of cells. This capability is fundamental for data analysis and financial modeling.

Which of the following formatting options can be used to enhance document readability in Word?
  • a)
    Adding hyperlinks
  • b)
    Inserting images
  • c)
    Adjusting font style and size
  • d)
    Changing text color
Correct answer is option 'C'. Can you explain this answer?

Adjusting the font style and size is a key formatting option that enhances document readability. Selecting appropriate fonts and sizes can make a document more visually appealing and easier to read, which is particularly important in formal writing and presentations.

What is the main function of Microsoft Excel?
  • a)
    Creating presentations
  • b)
    Organizing data in spreadsheets
  • c)
    Managing databases
  • d)
    Editing images
Correct answer is option 'B'. Can you explain this answer?

Microsoft Excel is primarily used for organizing data in a spreadsheet format, which allows users to manipulate and analyze numerical data effectively. Users can perform calculations, create charts, and manage substantial datasets, making Excel a powerful tool for data analysis and visualization.

What does the alignment feature in Microsoft Word allow you to do?
  • a)
    Adjust the layout of the document
  • b)
    Position text relative to the page
  • c)
    Change the background color of the document
  • d)
    Insert tables into the document
Correct answer is option 'B'. Can you explain this answer?

The alignment feature in Microsoft Word enables you to position text relative to the page, allowing options such as left, right, center, or justified alignment. This feature is important for creating organized and visually appealing documents, enhancing overall readability.

What is the first step to create a new document in Microsoft Word?
  • a)
    Click on File > New
  • b)
    Click on File > Save As
  • c)
    Click on File > Exit
  • d)
    Click on File > Open
Correct answer is option 'A'. Can you explain this answer?

Indu Gupta answered
To create a new document in Microsoft Word, the first step is to click on File > New. This action allows users to choose between starting with a blank document or selecting from various templates. Using templates can significantly speed up the document creation process by providing pre-formatted layouts. An interesting fact is that Microsoft Word has evolved through many versions, incorporating user feedback to enhance usability and functionality over the years.

Which of the following features allows you to create visual representations of data in Excel?
  • a)
    Templates
  • b)
    Text Styles
  • c)
    Charts
  • d)
    Formatting
Correct answer is option 'C'. Can you explain this answer?

Charts in Excel serve to create visual representations of data, such as bar graphs or pie charts. This feature helps users understand trends and patterns in their data more intuitively, facilitating better data analysis and presentation.

Which of the following statements best describes Microsoft Access?
  • a)
    It is primarily for word processing tasks.
  • b)
    It is used for creating presentations.
  • c)
    It manages databases and organizes complex datasets.
  • d)
    It is used to create spreadsheets.
Correct answer is option 'C'. Can you explain this answer?

Indu Gupta answered
Microsoft Access is a database management system designed to store and organize large amounts of information efficiently. Unlike Excel, which is primarily for numerical data analysis, Access can handle complex datasets with relationships among multiple tables, making it ideal for managing extensive data. An additional fact: Access supports SQL (Structured Query Language), enabling users to perform advanced data manipulations and queries.

In Microsoft Word, what is the purpose of using templates?
  • a)
    To change the document's font style
  • b)
    To create a structured layout for documents
  • c)
    To create charts
  • d)
    To perform calculations
Correct answer is option 'B'. Can you explain this answer?

Templates in Microsoft Word provide structured layouts for various types of documents, such as resumes or business letters. By using a template, you can save time on formatting and focus on adding your content, ensuring a professional appearance without starting from scratch.

How can you save a document in Microsoft Word?
  • a)
    Click on File > Open
  • b)
    Click on Home > Save
  • c)
    Click on Edit > Save
  • d)
    Click on File > Save As
Correct answer is option 'D'. Can you explain this answer?

To save a document in Microsoft Word, you need to click on "File" and then select "Save As." This allows you to choose the location to store the file, name it, and select the desired file format. This step is crucial for ensuring that your work is not lost.

Which Microsoft Office program would you use to create a slideshow presentation?
  • a)
    PowerPoint
  • b)
    Access
  • c)
    Excel
  • d)
    Word
Correct answer is option 'A'. Can you explain this answer?

PowerPoint is the program designed for creating slideshow presentations. It allows users to integrate text, images, charts, and videos into slides, making it ideal for delivering engaging presentations in educational and professional environments.

Which program in the Microsoft Office Suite is primarily used for creating and editing text documents?
  • a)
    Word
  • b)
    Excel
  • c)
    Access
  • d)
    PowerPoint
Correct answer is option 'A'. Can you explain this answer?

Microsoft Word is the program specifically designed for creating and editing text documents. It offers various features such as adding images, tables, and charts to enhance the document's content. It's widely used in both professional and academic settings for tasks like writing reports and essays.

Chapter doubts & questions for MS Office at a Glance - Year 5 Computing IGCSE (Cambridge) 2025 is part of Class 5 exam preparation. The chapters have been prepared according to the Class 5 exam syllabus. The Chapter doubts & questions, notes, tests & MCQs are made for Class 5 2025 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests here.

Chapter doubts & questions of MS Office at a Glance - Year 5 Computing IGCSE (Cambridge) in English & Hindi are available as part of Class 5 exam. Download more important topics, notes, lectures and mock test series for Class 5 Exam by signing up for free.

Top Courses Class 5