wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

PowerPoint and Excel Quiz

Total questions: 100

Worksheet time: 52mins

Name
Class
Date
1.

What is Microsoft PowerPoint primarily used for?

a)

Creating spreadsheets

b)

Creating presentations

c)

Editing images

d)

Writing code

2.

Which of the following is not a type of presentation software?

a)

Microsoft PowerPoint

b)

Google Slides

c)

Photoshop

d)

Keynote

3.

What is the purpose of applying themes in Microsoft PowerPoint?

a)

To create animations

b)

To insert pictures

c)

To apply predefined sets of Colours, fonts, and effects

d)

To add audio to slides

4.

Which feature in PowerPoint allows you to change a slide's layout quickly?

a)

Zoom

b)

Slide Master

c)

Themes

d)

Layout

5.

What does the Thesaurus feature in PowerPoint help you with?

a)

Inserting pictures

b)

Checking spelling

c)

Finding synonyms and antonyms

d)

Creating templates

6.

Which ribbon tab in PowerPoint allows you to check and correct spelling and grammar?

a)

Insert

b)

Home

c)

Review

d)

Design

7.

To add a new slide with a different layout in PowerPoint, you should:

a)

Right-click on the slide

b)

uses the Duplicate slide command

c)

Select the existing slide and press Delete

d)

Use the New Slide command and choose the layout you want

8.

How can you quickly copy and paste a slide in PowerPoint?

a)

Right-click the slide and select "Copy Slide."

b)

Press Ctrl + C to copy and Ctrl + V to paste

c)

Drag and drop the slide to the desired location

d)

All of the above

9.

Which pane in PowerPoint helps you organize and manage your slides?

a)

Review Pane

b)

Slide Sorter Pane

c)

Slide Design Pane

d)

Slide Transition Pane

10.

What is the default layout when you insert a new slide in PowerPoint?

a)

Title Slide

b)

Content Slide

c)

Blank Slide

d)

Picture Slide

11.

Which feature allows you to adjust the size of the working area in PowerPoint?

a)

Ruler

b)

Zoom

c)

Ribbon

d)

Slide Sorter

12.

What is the purpose of a PowerPoint template?

a)

To insert animations

b)

To apply predefined styles to a presentation

c)

To insert hyperlinks

d)

To add background music

13.

Which command allows you to check the spelling and grammar in your PowerPoint presentation?

a)

Thesaurus

b)

Review

c)

Copy Slide

d)

Insert

14.

What is the main function of the Slide Master in PowerPoint?

a)

To insert new slides

b)

To apply themes

c)

To change the slide layout

d)

To customize the design and formatting for all slides

15.

Which of the following is NOT a multimedia inserted into a PowerPoint presentation?

a)

Images

b)

Videos

c)

Spreadsheets

d)

Audio

16.

To duplicate a slide in PowerPoint, what should you do?

a)

Right-click and select "Copy Slide"

b)

Use the "Duplicate Slide" command

c)

Press Ctrl+D

d)

All of the above

17.

What is the purpose of the Quick Access Toolbar in PowerPoint?

a)

It displays frequently used command tools.

b)

It applies themes to slides.

c)

It inserts new slides.

d)

It checks spelling and grammar.

18.

Which ribbon tab in PowerPoint allows you to apply themes to your presentation?

a)

Insert

b)

Review

c)

Design

d)

Home

19.

Which of the following is NOT a function of the Status Bar in PowerPoint?

a)

It displays the number of slides.

b)

It shows the language settings.

c)

It checks spelling and grammar.

d)

It indicates the zoom level

20.

What is the primary purpose of using the Thesaurus in PowerPoint?

a)

To find synonyms and antonyms for words

b)

To insert images

c)

To apply themes to slides

d)

To check spelling and grammar

21.

What is font size?

a)

The Colour of the text.

b)

The style of the text.

c)

How big or small a character or font is

d)

The space between lines of text

22.

How do you change font size in MS Word?

a)

Use the Bold command

b)

Click the Font Size drop-down arrow and select a size

c)

Use the Italic command

d)

Press Ctrl + S

23.

Which software is known for graphic design?

a)

Microsoft Word

b)

Excel

c)

Photoshop

d)

PowerPoint

24.

What is the purpose of changing the font size?

a)

To change the font style

b)

To add Colour to the text

c)

To make text bigger or smaller

d)

To insert images

25.

How can you change the default font for an entire PowerPoint presentation?

a)

Click on each slide and change the font individually

b)

Use the Format Painter tool

c)

Modify it in Slide Master View

d)

There is a way to change the default font.

26.

What does the Font Colour command in PowerPoint allow you to do?

a)

Change the font style

b)

Change the background colour of a slide

c)

Change the Colour of characters

d)

Change the layout of a slide

27.

How do you change the font Colour of a text box in PowerPoint?

a)

Click on the text box and press Ctrl + C

b)

Use the Format Painter tool

c)

Select the text in the text box and choose a font Colour

d)

Use the Underline command

28.

What is Slide Master View used for in a presentation?

a)

To insert new slides

b)

To change the font style of all slides

c)

To modify the background for all slides

d)

To view your presentation in slideshow mode

29.

What is the primary purpose of the Master Slide in PowerPoint?

a)

To define the layout, fonts, and Colours for all slides

b)

To create animations

c)

To add transitions between slides

d)

To insert videos

30.

What does Slide Master View allow you to customize in a presentation?

a)

Background graphics

b)

Slide transitions

c)

Font size

d)

Animations

31.

What is the primary purpose of spreadsheet applications?

a)

Word processing

b)

Mathematical calculations

c)

Graphic design

d)

Web browsing

32.

Which of the following is not a type of spreadsheet software?

a)

Microsoft Excel

b)

Adobe Photoshop

c)

Google Sheets

d)

LibreOffice Calc

33.

What feature of spreadsheet software organises and manages numerical data effectively?

a)

Fonts

b)

Formulas

c)

Graphs

d)

Colours

34.

Why is it essential to use spreadsheet software for business administrative tasks?

a)

It's a legal requirement

b)

It saves time and effort

c)

It's expensive

d)

It's a tradition

35.

How can you change the font size in a cell in Excel?

a)

Right-click and select "Font Size."

b)

Use the "Format Text Effects" option

c)

Click on "Fonts" in the top menu

d)

Press Ctrl + S

36.

What is the purpose of wrapping text in a cell?

a)

To make the text invisible

b)

To make the text italicized

c)

To display text on multiple lines within a cell

d)

To delete the text

37.

Which view in Excel allows you to see how the printed worksheet will appear?

a)

Normal view

b)

Page Layout view

c)

Page Break Preview

d)

Full-Screen view

38.

What is the purpose of headers and footers in Excel?

a)

To add decorative elements to a worksheet

b)

To include content that appears on every page when printed

c)

To change the page orientation

d)

To merge cells

39.

How do you apply AutoFill to continue a data series in Excel?

a)

Press Ctrl + A

b)

Right-click and select "AutoFill."

c)

Click and drag the fill handle

d)

Use the "AutoFill" tab

40.

What is the correct symbol for multiplication in Excel formulas?

a)

A

b)

*

c)

+

d)

/

41.

What does the "Merge & Centre" option do in Excel?

a)

Combine cells into one and centre the text horizontally

b)

Split cells into multiple smaller cells

c)

Align text to the right

d)

Make text bold

42.

Which of the following is NOT a valid data type in Excel?

a)

Text

b)

Formula

c)

Value

d)

Graphic

43.

What is the default alignment of text in a cell in Excel?

a)

Centred

b)

Right-aligned

c)

Left-aligned

d)

Justified

44.

How can you delete data from a cell in Excel?

4 lines
45.

What is the default alignment of text in a cell in Excel?

a)

Centred

b)

Right-aligned

c)

Left-aligned

d)

Justified

46.

How can you delete data from a cell in Excel?

a)

Press the Delete key

b)

Use the 'Format Cells' option

c)

Right-click and select 'Delete.

d)

Shake your computer

47.

Which view in Excel allows you to see page breaks and adjust the print area?

a)

Normal view

b)

Page Break Preview

c)

Page Layout view

d)

Full-Screen view

48.

Which of the following is NOT a valid page orientation in Excel?

a)

Landscape

b)

Diagonal

c)

Portrait

d)

None of the above

49.

What is the purpose of using the Fill Handle pointer in Excel?

a)

To delete data

b)

To apply bold formatting

c)

To perform autofill functions

d)

To change the font Colour

50.

What is the purpose of using 'borders' in Excel?

a)

To add images to a worksheet

b)

To apply shading to cells

c)

To create boxes around cells

d)

To change the font style

51.

Afia bought some items from the market. The things were so much that she could not calculate the amount of money she had spent at the market. Which application software would you recommend for Afia to help her with the calculation?

a)

Spreadsheet

b)

Word processor

c)

Database

d)

Money counting machine software

52.

Choose the odd one out

a)

Lotus 1,2,3

b)

Google sheet

c)

MS PowerPoint

d)

MS Excel

53.

This is a common feature among all spreadsheets

a)

They display multimedia contents

b)

They are mainly used for creating a text-based document

c)

They are used for presentations

d)

They have grids of rows and columns

54.

This software is mainly designed for mathematical calculations using formulas and functions

a)

Quattro pro

b)

MS PowerPoint

c)

MS Access

d)

MS Paint

55.

Oppong wants to arrange 10 numbers in ascending order. Which software application would you advise him to use?

a)

MS PowerPoint

b)

OpenOffice Calc

c)

MS Word

d)

Ascend software application

56.

These are all common features of spreadsheet applications except?

a)

Function

b)

Formula

c)

Chart

d)

Drawing and painting

57.

Row headers are identified by

a)

Numbers

b)

Alphabets

c)

Alphanumeric

d)

Symbols

58.

Column headers are identified by

a)

Numbers

b)

Alphabets

c)

Alphanumeric

d)

Symbols

59.

Spreadsheet file usually contains one or more pages. Each page is called?.........

a)

Workbook

b)

Worksheet

c)

Entry page

d)

Calculation page

60.

In a spreadsheet, the intersection of a row and column is called?

a)

Formula

b)

Function

c)

Ribbon

d)

Cell

61.

Your computer screen should never be above?

a)

Your head.

b)

Eye level.

c)

Shoulder level.

d)

None of the above.

62.

What legislation is aimed at keeping you safe at work?

a)

Data Protection Act.

b)

Health & Safety at Work Act.

c)

Copyright, Designs and Patents Act.

d)

None of the above.

63.

AutoCorrect was originally designed to replace words as you type.

a)

grammatically incorrect

b)

short, repetitive

c)

misspelled

d)

none of the above

64.

What is the function of Ctrl + B in Ms-Word?

a)

It converts selected text into the next larger size of the same font.

b)

It adds a line break to the document.

c)

It makes the selected text bold.

d)

It applies Italic formatting to the selected text.

65.

All the following software are word processors except..........

a)

Ms Word

b)

iWork Pages

c)

iWork Numbers

d)

WordPad

66.

A device used to protect the computer from power failure and also to store power for limited period when power is disrupted is _______

a)

UPS

b)

Computer power guard

c)

Stabilizer

d)

Generator

67.

What is Microsoft Word mainly used for?

a)

Playing games

b)

Creating and editing documents

c)

Watching movies

d)

Browsing the internet

68.

Which tab in Microsoft Word contains the Bold, Italic, and Underline options?

a)

Insert

b)

Home

c)

Layout

d)

View

69.

What is the shortcut key to save a document in Microsoft Word?

a)

Ctrl + S

b)

Ctrl + P

c)

Ctrl + X

d)

Ctrl + V

70.

What is the file extension for Microsoft Word documents in the latest versions?

a)

.txt

b)

.pdf

c)

.docx

d)

.pptx

71.

Which feature allows you to copy formatting from one text to another?

a)

Font Color

b)

Format Painter

c)

Page Layout

d)

Text Wrapping

72.

What is the purpose of the Undo button in Microsoft Word?

a)

To redo an action

b)

To delete a file

c)

To reverse the last action

d)

To close the document

73.

Which option is used to insert pictures into a Word document?

a)

Home tab

b)

Insert tab

c)

Layout tab

d)

Review tab

74.

What happens when you press Ctrl + B on selected text?

a)

The text becomes bold

b)

The text is deleted

c)

The text is copied

d)

The text is underlined

75.

Where are headers and footers usually located in a Word document?

a)

In the middle of the page

b)

At the beginning of the document

c)

At the top and bottom of each page

d)

At the end of the document

76.

What is the function of Spell Check in Microsoft Word?

a)

To check internet speed

b)

To correct spelling and grammar mistakes

c)

To change font size

d)

To print a document

77.

What is the default font in Microsoft Word?

a)

Times New Roman

b)

Calibri

c)

Arial

d)

Comic Sans

78.

Which feature allows you to move text from one place to another?

a)

Copy and Paste

b)

Cut and Paste

c)

Find and Replace

d)

Format Painter

79.

What is the shortcut key for printing a document?

a)

Ctrl + S

b)

Ctrl + P

c)

Ctrl + X

d)

Ctrl + Z

80.

Which tab in Microsoft Word is used to change the page orientation?

a)

Layout

b)

Insert

c)

Home

d)

View

81.

What is the function of the Zoom tool in Microsoft Word?

a)

To increase font size

b)

To change text color

c)

To adjust the view of the document

d)

To print the document

82.

Which tab contains the 'Table' option to insert tables?

a)

Home

b)

Insert

c)

Layout

d)

Review

83.

What happens when you press Ctrl + U on selected text?

a)

It becomes bold

b)

It is copied

c)

It is underlined

d)

It is deleted

84.

What is the purpose of Find and Replace in Microsoft Word?

a)

To search for words and change them automatically

b)

To delete unwanted text

c)

To create new documents

d)

To check spelling errors

85.

Which part of the Word window displays the name of the document?

a)

Status Bar

b)

Title Bar

c)

Ribbon

d)

Scroll Bar

86.

What is the function of the Thesaurus tool in Microsoft Word?

a)

To check spelling mistakes

b)

To find synonyms and antonyms for words

c)

To print the document

d)

To count the number of words

87.

Which of the following is the main part of a computer that processes information?

a)

Monitor

b)

Keyboard

c)

Central Processing Unit (CPU)

d)

Mouse

88.

Which device is used to display information on the screen?

a)

Printer

b)

Monitor

c)

Speaker

d)

Scanner

89.

What is the function of the keyboard?

a)

To enter data into the computer

b)

To print documents

c)

To display pictures

d)

To store files

90.

Which of these is an example of an output device?

a)

Keyboard

b)

Mouse

c)

Monitor

d)

Scanner

91.

What is the function of a mouse in a computer?

a)

It processes information

b)

It is used to move the cursor and select items

c)

It prints documents

d)

It stores data permanently

92.

Which component of the computer stores information permanently?

a)

RAM

b)

Hard drive

c)

Processor

d)

Power supply

93.

What is the function of the Slide Sorter view in PowerPoint?

a)

To edit text on slides

b)

To insert charts

c)

To rearrange slides easily

d)

To apply transitions

94.

How can you create a hyperlink in a PowerPoint presentation?

a)

By using the Insert tab and selecting Hyperlink

b)

By right-clicking and choosing 'Add Link'

c)

By pressing Ctrl + H

d)

By using the Format Painter

95.

What does the 'Merge Cells' feature do in Excel?

a)

Splits a single cell into multiple cells

b)

Combines multiple cells into one

c)

Changes the background colour of cells

d)

Formats text within a cell

96.

What function would you use to find the average of a range of cells in Excel?

a)

AVERAGE

b)

SUM

c)

MAX

d)

COUNT

97.

How can you add a transition effect between slides in PowerPoint?

a)

All of the above

b)

Right-click on the slide and choose "Add Transition"

c)

Click on the Transition tab and select an effect

d)

Use the Animation tab

98.

What is the purpose of using conditional formatting in Excel?

a)

To change the font style

b)

To highlight cells based on specific criteria

c)

To insert charts

d)

To create hyperlinks

99.

What feature in PowerPoint allows you to add animations to your slides?

a)

Design

b)

Insert

c)

Transitions

d)

Animations

100.

Which option in PowerPoint helps you to create a new slide?

a)

New Slide

b)

Add Slide

c)

Slide Layout

d)

Insert Slide

Similar Resources on Wayground

Excel Formulu Izpratne 100Q

100 questions

Excel Formulu Izpratne 100Q

quiz

Worksheet

•

7th Grade