Font size
Worksheets6 ICT Mid Term 2024-25
Total questions: 119
Worksheet time: 1hrs 20mins
Select two different methods of opening workbook in MS Excel 2019 from the options provided.
Use 'File' > 'Open' to browse for the workbook.
Double-click the Excel file in file explorer.
Which is the samllest unit of a Excel worksheet?
Where can we see the address of a cell in Excel worksheet?
How are rows numbered in MS Excel?
How are columns numbered in MS Excel?
Columns in MS Excel are numbered using symbols like @, #, and $ instead of letters.
Columns in MS Excel are numbered using colors, such as red, blue, and green.
Columns in MS Excel are numbered using numbers, starting from 1 to 100.
Reorder the following
Click the File tab
Click the Save option
When Save As diakog box opens, select the location
Write the name of the file in the File Name box
Click the Save button
Match the following keyboard shortcuts in MS Excel 2019.
creating a new workbook
Ctrl + N
saving the current workbook
Ctrl + S
opening an existing workbook
Ctrl + O
closing the current workbook
Ctrl + W
Reorder the following
Click on Insert tab
In the Images group, click on Pictures.
Click This Device dialog box.
Select the picture and click on Insert.
What do you mean by animation in Powerpoint?
Animation is the use of visual effects to enhance the presentation of slides.
Animation in PowerPoint is used solely for video editing and not for presentation.
Reorder the following steps to insert a footer in MS Word 2019
On the ibsert tab, in the Header and Footer group, click on Header or Footer
Choose your desired template
Make changes in footer accordingly
Press Escape key to close header and footer
What is the difference between headers and footers?
at the top of document
used for titles and chapter names
can include page numbers
allows for different headers on odd and even pages
can be customized with images or logos
supports different formatting options
can be removed or modified easily
appears on every page unless specified otherwise
at the bottom of the document
used for page numbers and copyright information
can include text or images
allows for different footers on odd and even pages
can be customized with styles
The name of workbook is displayed in the (a) .
The (a) are numbered as 1,2,3 and so on, while the are numbered as A, B, C and so on.
MS Excel 2019 files have the extension (a) .
The default name for a workbook is (a) .
Match the following.
William Oughtred
Slide Rule
EDVAC
1st Gen Computer
PDP 8
3rd Gen Computer
Xerox Alto
4th Gen Computer
Charles Babbage
Analytical engine
Write the full names of each of ENIAC.
(a)
Write the full names of each of EDVAC.
(a)
Full from of EDSAC.
(a)
Write the full name of ASCC.
(a)
What is an abacus used for?
A tool for measuring distances
A device for storing data
A machine for printing documents
Performing arithmetic calculations.
Who is known as the 'Father of Modern Computers'?
Charles Babbage
Alan Turing
Ada Lovelace
Bill Gates
What was the first general purpose computer designed by Charles Babbage?
Difference Engine
UNIVAC
ENIAC
Analytical Engine
What is a microprocessor?
A microprocessor is a software application for data analysis.
A microprocessor is the brain of a computer that processes data and executes instructions.
A microprocessor is a type of memory storage device.
A microprocessor is a peripheral device.
What does VLSI stand for?
Variable Large Scale Integration
Very Low Scale Integration
Very Large Scale Integration
Vast Logic System Integration
What is the main component of modern computers?
Central Processing Unit (CPU)
Graphics Processing Unit (GPU)
Hard Disk Drive (HDD)
Random Access Memory (RAM)
Which generation of computers used microprocessors?
Fifth generation of computers
Second generation of computers
Fourth generation of computers
Third generation of computers
What is the purpose of the beads in an abacus?
The beads serve as a timer for calculations.
The beads are meant to hold the abacus together.
The beads are used for decoration purposes.
The beads are used to represent numerical values.
What type of engineer was Charles Babbage?
Mechanical engineer
Electrical engineer
Civil engineer
Software engineer
What is the Difference Engine?
A software program used for statistical analysis.
A digital computer created by Alan Turing for data processing.
A mechanical calculator to compute polynomial functions.
A type of modern smartphone designed for calculations.
How do microprocessors enhance computer performance?
Microprocessors reduce power consumption significantly.
Microprocessors are solely responsible for data storage.
Microprocessors only improve graphics performance.
Microprocessors increasing speed, and integrates advanced features.
What materials are used to create microprocessors?
Silicon, copper, aluminum, silicon dioxide, phosphorus, boron
Carbon, nitrogen, sulfur, phosphorus, boron
phosphorus, boron, Plastic, rubber, glass
Gold, silver, iron, Carbon, nitrogen, sulfur, phosphorus, boron, rubber, glass
What cycle did Charles Babbage visualize?
The cycle of memory storage in early computers.
The cycle of data processing in the Difference Engine.
The cycle of operations in the Analytical Engine.
The cycle of user input in modern programming languages.
What are the characteristics of fourth-generation computers?
They primarily rely on assembly language and have advanced user interfaces..
They support high-level programming languages and have advanced user interfaces.
Fourth-generation computers use vacuum tubes, they use vacuum tubes and have advanced user interfaces..
Fourth-generation computers are not capable of networking, use vacuum tubes and have advanced user interfaces..
Why are integrated circuits important in computing?
Integrated circuits enable miniaturization, improved performance, and energy efficiency in computing.
Integrated circuits are mainly used for mechanical applications.
Integrated circuits are only beneficial for large-scale manufacturing.
Integrated circuits are primarily used for audio amplification.
Status bar and View bar are the same.
True
False
By default there are 3 worksheets in a workbook.
True
False
MS Excel files are saved with an extension .xxls.
True
False
Formula bar and name box are used to write the formula.
True
False
Alt+F4 is used to close a workbook.
True
False
Opening Excel using the (a) Win + R→ dilalog box→ excel.
Saving a workbook (a) .
Shortcut to opening a new workbook (a) .
Opening an existing workbook (a) .
By default footers are printed 0.5 inches from the (a) of the page.
You can add date and time to a (a) or footer.
Headers can be edited or deleted.
True
False
Watermarks are added to protect the documents from water.
True
False
There are two types of page orientations available in MS Word.
True
False
(a) is the text that appears at the bottom of our document page.
To insert a table in ms word click on (a) tab
(a) is the text that appears on the top of a document page.
Portrait and landscape are two options for setting the page (a) .
(a) are special tabs in the ribbon that are not visible all the time.
(a) is a collection of pictures or graphics, organized into categories such as people, objects, nature, etc, that can be imported into a program.
(a) is usually divided into categories like List, Process, Cycle, Hierarchy, Relationship, Matrix, Pyramid and Picture.
The special visual effects that you can add to the objects on a slide are called (a) .
The (a) under the Insert tab allows us to insert pictures, shapes, Screenshots, Clip Art and SmartArt.
Screenshot is the image of your active MS PowerPoint window.
True
False
You cannot insert pictures in a presentation.
True
False
Clip Art is a collection of pictures.
True
False
You cannot rotate or resize a selected shape.
True
False
Animations give special effects to the text and pictures.
True
False
(a) Is an example of a first generation computer.
Choose the "True" satements.
Xerox Alto was an early personal computer developed in 1973.
PDP 8 was the last successful commercial minicomputer.
IBM 1400 series featured some famous second-generation computers.
UNIVAC was the first general purpose electronic computer designed for commercial use.
The first electronic digital computer used over 18,000 transistors.
The (a) of computers used integrated circuits.
The fifth generation computer are expected to take intelligent decisions such as (a) .
(a) was built by Maurice Wilkes and his team.
What tab do you click on to insert a footer?
Layout
Page Setup
Insert
Design
What does the Footer gallery provide?
A collection of images or visual elements.
A navigation menu for the website.
A section for user comments and feedback.
A list of links to social media profiles.
How can you select a footer style?
Ignore footer settings completely and customize the footer settings.
Select a header style instead and customize the footer settings..
Choose a design template and customize the footer settings.
Use a random color for the footer and customize the footer settings.
What key do you press to return to the main document after inserting a footer?
Enter
Alt + F4
Ctrl + S
Esc
How do you delete a header in MS Word?
Use the 'Delete' key while the header is selected.
Select the header and press 'Ctrl + X' to cut it.
Right-click the header and select 'Remove Header'.
Double-click the header, select the content, and press Delete.
What does a header refer to in a document?
A header is a section at the bottom of a document.
The section at the top of a document that contains identifying information.
A header refers to the main body of the document identifying information.
A header is a type of footer used in documents.
What does a footer refer to in a document?
A footer is a type of header used in documents.
A footer refers to the main content area of a document.
A footer is the section at the top of a document page.
A footer is the section at the bottom of a document page.
What is the first step to insert a table in MS Word?
Select 'File' and then 'New'.
Right-click on the document and choose 'Insert Table'.
Click on the 'Home' tab.
Go to the 'Insert' tab.
What button do you click on to insert a table?
Insert > Chart
Insert > Table
Format > Table
Edit > Insert Table
How do you determine the number of rows and columns in a table?
Count the entries for rows and the fields for columns.
Multiply the number of rows by the number of columns.
Identify the maximum number of entries in a single column.
Count the total number of cells in the table.
What action do you take to finalize the table size?
Choose the table material and measure the table height with the width also.
Measure the table height with the width also.
Confirm the measurements of the table.
Select the table color.
Where will the table appear after you click the mouse button?
At the bottom right corner
In the center of the window
At the mouse cursor location
At the top of the screen
Can you edit the text in a header after inserting it?
Editing headers is not allowed in any document.
You can only edit the header before inserting it.
No, headers cannot be edited after insertion.
Yes, you can edit the text in a header after inserting it.
What happens when you double-click on a header?
It opens a context menu.
It highlights the header only.
It selects the entire column.
It selects the entire row.
Is it possible to insert both headers and footers in a document?
Headers and footers are not allowed in any document
Yes
No, only headers can be inserted
Footers can be added without headers
What is the first step to add a picture from the web?
Download the image to your computer.
Find the image and copy its URL.
Open the image in a new tab.
Resize the image before adding it.
Where do you click to insert a picture on the slide?
Select the 'Design' tab and click on 'Background'.
Click on the 'Home' tab and select 'Shapes'.
Click on the 'Insert' tab and select 'Pictures'.
Right-click on the slide and choose 'Add Image'.
What do you need to type in the search box to find an image?
a URL link
random numbers
keywords or phrases related to the image
a song title
What should you do after selecting the picture?
Print the picture without reviewing.
Review and save or upload the picture.
Share the picture on social media without editing.
Delete the picture immediately.
Which tab do you click on to run the Slide Show?
View
Edit
Insert
Slide Show
What is one option you can choose to start the Slide Show?
Click on the File menu
Press F5
Use the Ctrl + S shortcut
Press F1
What does the 'From Current Slide' option do?
It allows editing the current slide.
It exports the current slide as an image.
It starts the slideshow from the current slide.
It starts the slideshow from the beginning.
Can you broadcast a Slide Show?
Only if you have a premium account.
Broadcasting is only available for videos.
Yes, you can broadcast a slide show.
No, you cannot broadcast a slide show.
What is the purpose of the 'Custom Slide Show' option?
To add animations to all slides.
To print the presentation in a booklet format.
To change the background color of the slides.
To create a tailored presentation by selecting specific slides.
How do you exit the Slide Show once it is running?
Press 'F5' to restart the presentation
Press 'Esc' key or right-click and select 'End Show'.
Click the 'Next' button to continue
Minimize the window to pause the show
What is the purpose of animation in presentations?
To make the presentation look more colorful without purpose istract the audience from the main content.
To enhance engagement and clarify information.
To fill time when the presenter runs out of material and to enhance engagement and clarify information.
To distract the audience from the main content.
How can you set a motion path for an object?
Drag the object to a new location without any path settings and adjust the object's properties to follow it.
Use the shape tool to create a new object instead and adjust the object's properties to follow it.
Select the object, use the motion path tool to draw the path, and adjust the object's properties to follow it.
Select the object and apply a color change to it and adjust the object's properties to follow it.
What are the four ways to run a slide show?
Signal
Remote control
Manually
Keyboard shortcuts
Automatically
What color star represents entrance animations?
yellow
blue
green
red
What do emphasis animations do?
Emphasis animations are used to change the background color.
Emphasis animations make elements disappear from the screen.
Emphasis animations highlight and draw attention.
Emphasis animations create transitions between slides.
What color star indicates exit animations?
red
blue
yellow
green
What section of the animation pane has add-on effects?
Animation Speed
Playback Options
Effect Options or Add Animation
Transition Effects
Can you apply sound effects to animations?
No, sound effects cannot be applied to animations.
Sound effects can only be used in video editing, not animations.
Animations do not support any audio features.
Yes, you can apply sound effects to animations.
What happens when an object with entrance animation appears?
The object smoothly transitions into view with an animation effect.
The object shakes violently before settling in place.
The object instantly appears without animation.
The object disappears without any effect.
What is the function of the Custom Slide Show option?
To add animations to all slides in the presentation.
To create a tailored presentation by selecting specific slides.
To change the background color of the slides.
To delete unwanted slides from the presentation.
How do you emphasize a particular object in a slide?
Use only text to describe the object.
Place the object in the corner of the slide.
Use size, color, borders, animations, and positioning to emphasize the object.
Avoid using any colors or animations.
What is the significance of the Broadcast Slide Show option?
It provides tools for editing slides in real-time.
It enables remote presentations to an audience over the internet.
It allows for local presentations without internet access.
It is used to create video recordings of presentations.
What type of animation is shown with red stars?
Looping animation
Static animation
Fade-in animation
Explosive animation
What is the first step to add animation to an object?
Select the object to animate.
Delete the object.
Resize the object.
Change the object's color.
How does the animation pane help in creating presentations?
The animation pane only displays static images in presentations.
The animation pane automatically generates slide transitions without user input.
The animation pane is used to edit text content in slides.
The animation pane helps in creating presentations by allowing users to manage and customize animations for better visual impact.
What is the first step to open an existing workbook?
Create a new workbook instead.
Launch the spreadsheet application.
Delete the existing workbook.
Close the application first.
Which tab do you click on to start opening a file?
File
Edit
View
Help
What appears after you click on Open?
A pop-up message appears.
The screen goes blank.
You are redirected to a different page.
The file or application opens.
What should you do to find your Excel file?
Ask a colleague if they have seen it.
Look in the 'Recent' section or use file search.
Check the recycle bin for deleted files.
Look for it in your email attachments.
What do you need to do after selecting the file?
Click 'Save'
Press 'Cancel'
Select 'Download'
Click 'Open' or 'Upload'.
What keyboard shortcut can you use to open a workbook?
Shift + S
Ctrl + O
Alt + N
Ctrl + P
What does pressing Control and O do?
Refreshes the current webpage.
Closes the current application.
Minimizes the active window.
Opens a file dialog to select a file.
What is the final action to display the workbook?
Open or Display the workbook
Close the workbook
Save the workbook
Print the workbook
Can you open a workbook without using the mouse?
You need to use a touchscreen to open a workbook.
No, you can only use the mouse.
It's impossible to open a workbook without a keyboard.
Yes, you can open a workbook without using the mouse.
What type of file are you looking for when opening a workbook?
Audio file (e.g., .mp3, .wav)
Spreadsheet file (e.g., .xlsx, .xls, .ods)
Image file (e.g., .jpg, .png)
Text document (e.g., .txt, .doc)
