NEW
Font size
WorksheetsICT Final Exam
Total questions: 50
Worksheet time: 25mins
Which finger is used to press the "J" key on the QWERTY keyboard?
Left pinky
Left ring finger
Right index finger
Right middle finger
What is the home row key for the left index finger?
F
D
E
G
Which key is commonly used to move the cursor to the next line in typing?
Enter
Backspace
Shift
Tab
In typing practice, where should the right little finger rest?
Semicolon (;)
Enter
P
L
Which finger is used to press the "Spacebar"?
Left pinky
Left thumb
Right thumb
Right pinky
What is the function of the "Shift" key?
Deletes characters
Changes letters to uppercase
Moves the cursor to the next line
Saves the file
Which shortcut is used to open a new document in Word?
Ctrl + S
Ctrl + N
Ctrl + O
Ctrl + D
What is the default file extension for Microsoft Word documents?
.xls
.pptx
.docx
Which shortcut is used to close an active window in Microsoft Office?
Ctrl + Q
Alt + F4
Ctrl + W
Ctrl + Shift + W
Which shortcut key opens the "Print" dialog box in Word?
Ctrl + S
Ctrl + P
Ctrl + Q
Ctrl + R
What is the function of the F7 key in Microsoft Word?
Check spelling and grammar
Save the document
Insert a table
Start a slideshow
In Excel, what does the shortcut Ctrl + Z do?
Save the worksheet
Undo the last action
Redo the last action
Open the "Find" dialog box
Which key combination is used to insert a new worksheet in Excel?
Ctrl + Shift + N
Alt + Shift + N
Ctrl + Shift + M
Shift + F11
In PowerPoint, what is the shortcut to duplicate a slide?
Ctrl + D
Ctrl + Shift + D
Alt + D
Ctrl + C
In Excel, which function calculates the average of a range of numbers?
=TOTAL
=COUNT
=AVERAGE
=MEAN
What key toggles between insert and overwrite mode while typing?
Insert
Delete
Backspace
Alt
In Word, how do you create a bulleted list?
Ctrl + Shift + L
Ctrl + L
Ctrl + Alt + L
Ctrl + B
What is the shortcut to minimize all open windows in Windows?
Ctrl + D
Windows + M
Ctrl + M
Alt + Tab
What is the home row key for the right ring finger?
O
L
P
;
Which key is used to open the Start menu in Windows?
Alt
Ctrl
Windows key
Esc
Which finger is responsible for pressing the "Q" key on a QWERTY keyboard?
Left pinky
Left ring finger
Left middle finger
Left index finger
What is the shortcut to cut selected text or objects in Word?
Ctrl + C
Ctrl + X
Ctrl + V
Ctrl + Z
In Excel, how do you start editing a cell?
Press F2
Press Enter
Double-click the cell
Press F5
Which key combination is used to insert a hyperlink in Word?
Ctrl + H
Ctrl + K
Ctrl + L
Ctrl + M
If you need to apply italic formatting to text in Word, which shortcut should you use?
Ctrl + I
Ctrl + U
Ctrl + E
Ctrl + B
How can you quickly switch between open applications in Windows?
Alt + Tab
Ctrl + Tab
Shift + Tab
Windows + Tab
In PowerPoint, what is the shortcut for inserting a new slide?
Ctrl + Shift + M
Ctrl + M
Alt + M
Ctrl + Shift + N
Which Excel shortcut automatically adjusts the column width to fit the content?
Ctrl + W
Alt + Enter
Double-click the right edge of the column header
Ctrl + Shift + A
In Word, what is the quickest way to align text to the right?
Ctrl + L
Ctrl + R
Ctrl + E
Ctrl + J
In PowerPoint, which shortcut key is used to insert a text box?
Ctrl + T
Ctrl + Shift + X
Alt + X
Alt + N
You are tasked to type a paragraph using proper finger placement. Which fingers should press the "ASDF" keys?
Left pinky, ring, middle, and index fingers
Left pinky, ring, and index fingers only
Right pinky, ring, middle, and index fingers
Right pinky, ring, and index fingers only
You are preparing a report in Word and need to format headings consistently. Which combination of shortcuts will help you: Make text bold, Italicize a subheading, and Underline keywords?
Ctrl + B, Ctrl + I, Ctrl + U
Ctrl + I, Ctrl + U, Ctrl + P
Ctrl + U, Ctrl + B, Ctrl + I
Ctrl + I, Ctrl + B, Ctrl + U
In Excel, you are tasked to calculate the total sales for the month. Which formula should you use to sum up values in column B, rows 1 to 30?
=SUM(B1:B30)
=ADD(B1:B30)
=TOTAL(B1:B30)
=B1+B30
You are creating a slideshow in PowerPoint. How can you quickly align all text boxes on a slide?
Use the alignment tools in the toolbar
Press Ctrl + A to select all, then align
Drag and align manually
Use Alt + Drag
Imagine you are designing an Excel sheet with formulas. How would you make sure that cell references do not change when copying a formula?
Use absolute cell references with $ symbols
Use relative cell references without $ symbols
Use the SUM function
Use Ctrl + Z
While editing a Word document, you need to create a table of contents. What steps will you take to format headings properly before generating the table?
Use Bold and Italic formatting for headings
Apply built-in Heading Styles (e.g., Heading 1, Heading 2)
Manually underline all headings
Adjust the font size for each heading
You are preparing a PowerPoint presentation and want to create a slide with multiple pictures arranged symmetrically. What is the best way to ensure uniform alignment?
Manually adjust each picture using the mouse
Use the Align and Distribute options in the Format tab
Drag all pictures into one group
Use Ctrl + A and resize them simultaneously
In Excel, you are tasked to visualize data trends over time. Which feature will best achieve this?
Conditional Formatting
Insert a Line Chart
Use the Filter option
Create a PivotTable
You are typing a formal letter in Word and need to set a 1.5-inch left margin. How will you do this?
Drag the left margin ruler to 1.5 inches
Go to Layout > Margins > Custom Margins
Use Ctrl + Shift + L
Adjust the font size to match the margin
You need to save an Excel workbook as a PDF to share it. What steps will you take?
Click File > Save As > Choose PDF format
Use Ctrl + P and select Print to PDF
Save the file as a .txt and convert it
Copy the data to Word and save it as PDF
You are tasked to type a document that includes a table in Word. How can you quickly insert a table?
Go to Insert > Table and select the number of rows and columns
Use Ctrl + T
Type the table structure manually
Go to Format > Table Design
While working in PowerPoint, you want to embed a YouTube video. What is the correct process?
Insert > Media > Online Video > Paste the video link
Insert > Media > Audio > Add online video
Go to File > Embed Video
Use Ctrl + V to paste the video into the slide
In Excel, your manager asks you to highlight cells containing sales over $1,000. Which feature would you use?
Data Validation
Conditional Formatting
Filter by Value
Sort by Sales
You are creating a flyer in Word and want to insert a header with a logo. How can you do this?
Go to Insert > Header > Edit Header > Add logo
Copy and paste the logo into the body of the document
Go to File > Page Setup > Insert Logo
Use Ctrl + H to open the Header menu
To ensure consistency across a multi-slide PowerPoint presentation, what feature will you use to apply a uniform design?
Slide Master
Themes
Layouts
Background Styles
While preparing an Excel workbook, you want to calculate the total of values only if they meet a specific condition. Which function should you use?
SUM
AVERAGEIF
COUNTIF
SUMIF
In Word, you are tasked to insert page numbers that appear at the bottom right of each page. How will you do this?
Insert > Footer > Add Page Numbers > Bottom Right
Manually type the numbers in each footer
Format the document with a numbered list
Use Ctrl + P and select Page Setup
In PowerPoint, how can you change the background color of a slide?
Click on the slide and press Ctrl + B
Right-click on the slide and select Format Background
Use the Paint Bucket tool
Go to Design > Background Styles
What is the shortcut to paste copied text in Excel?
Ctrl + C
Ctrl + V
Ctrl + P
Ctrl + Shift + V
In Word, which feature allows you to create a table of contents automatically?
Layout > Table of Contents
Insert > Table of Contents
References > Table of Contents
Home > Table of Contents
