wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

cc quiz rev

Total questions: 133

Worksheet time: 1hrs 7mins

Name
Class
Date
1.

If your cursor is placed before a word, and you want to delete that word, which key should you press?

a)

DELETE

b)

BACKSPACE

c)

ENTER

d)

CTRL

2.

If your cursor is placed after a word, and you want to delete that word, which key should you press?

a)

BACKSPACE

b)

ENTER

c)

DELETE

d)

CTRL

3.

If you want to save your file as a different file type, which option do you use?

a)

Save as

b)

Open

c)

Save

d)

File Name

4.

What is the correct extension when saving as Rich Text Format?

a)

.rtf

b)

.pot

c)

.ppt

d)

.emf

5.

What is the default file extension for all Word documents?

a)

DOCX

b)

WRD

c)

TXT

6.

Which key moves your cursor from one cell to the next in a table?

a)

Tab

b)

Shift

c)

Ctrl+Enter

7.

If the spell check suggests that a word is spelt wrong, when you know it is spelt correctly e.g., a company name, which button would you click?

a)

Ignore

b)

Change

c)

Suggest

d)

Change All

8.

Which keyboard shortcut would you use to begin a spell check?

a)

ALT + S

b)

F9

c)

F7

d)

CTRL + S

9.

Where would you locate the option to change the page orientation to portrait?

a)

Notes page

b)

Print Preview

c)

Page setup

d)

Formatting toolbar

10.

Setting the orientation of the page to landscape means

a)

Making the width of the page longer than the height of the page

b)

Making the width of the page shorter than the height of the page

c)

Making the width of the page the same as the height of the page

11.

Setting the orientation of the page to portrait means

a)

Making the width of the page longer than the height of the page

b)

Making the width of the page shorter than the height of the page

c)

Making the width of the page the same as the height of the page

12.

How do you select the text in an entire document using keyboard shortcut?

a)

CTRL + B

b)

CTRL + A

c)

CTRL + E

13.

How do you select all the text in an entire document using the mouse?

a)

Single click in the margin

b)

Double click in the margin

c)

Triple click in the margin

14.

How do you select the text of a paragraph from a document using the mouse?

a)

Single click in the margin next to that paragraph

b)

Double click in the margin next to that paragraph

c)

Triple click in the margin next to that paragraph

15.

What is the shortcut key to open the Print options?

a)

ALT + P

b)

SHIFT + P

c)

CTRL + P

16.

If you wanted to print just the odd pages of a five-page document, what would you type in the Print options Page range box?

a)

1-5

b)

1.3.5,

c)

1;3;5

d)

1, 3, 5

17.

Which key is the equivalent of using the Indent button?

a)

CTRL

b)

ENTER

c)

SHIFT

d)

TAB

18.

To quickly copy an area of text, which of the following keyboard shortcuts would you use?

a)

SHIFT + Y

b)

ALT + C

c)

CTRL + Y

d)

CTRL + C

19.

What is the keyboard shortcut for cutting a piece of text?

a)

CTRL + X

b)

CTRL + C

c)

SHIFT + C

d)

CTRL + ALT + DELETE

20.

What do Indentation Options allow you to do?

a)

Design a table

b)

Select type and distance for indents

c)

Insert a Blank Page

21.

To move a highlighted drawing object within a document you can:

a)

Use the arrow keys to move it into position

b)

Cut and paste the object into position

c)

Drag and drop the object into position

d)

All answers are correct

22.

Which of the following options can be used to move a drawing?

a)

Right click and select Move from the menu

b)

Pressing CTRL + X

c)

Pressing Enter to move down the page

d)

Using the cursor keys

23.

How many different documents can you have open at one time?

a)

Only one

b)

As many as your computer memory will hold

c)

Not more than your Taskbar can display

24.

How many times do you have to click to select a single line of text from the margin?

a)

Three Times.

b)

Four Times.

c)

One Time.

d)

Two Times.

25.

To select a line of text, press SHIFT + _____ (select the missing key from the options below)

a)

END

b)

ALT

c)

CTRL

26.

Which function does the shortcut keys CTRL + E perform to a highlighted paragraph?

a)

Align Right.

b)

Align Left.

c)

Centre

d)

Justify.

27.

What is the keyboard shortcut to open the Find and Replace box?

a)

CTRL + R

b)

CTRL + F

c)

CTRL + ALT + F

d)

CTRL + S

28.

If the spell check highlights a word which it does not recognize but is spelt correctly, what should you do?

a)

Delete it

b)

Select an alternative word from the suggestion list

c)

Add it to the dictionary

29.

How can you highlight text without using the mouse?

a)

Use the arrow keys while holding down a Ctrl key

b)

Use the arrow keys while holding down a Shift key

c)

Use the F5 key

30.

Which set of keystrokes will take you to the beginning and to the end of a long document?

a)

Ctrl+PageUp and Ctrl+PageDown

b)

Ctrl+Home and Ctrl+End

c)

The only way is by using the right scroll bar

31.

A document in portrait prints:

a)

More characters per line than the same document in landscape

b)

The same characters per line with the same document in landscape

c)

Less characters per line than the same document in landscape

32.

Which button will update the misspelled word once?

a)

Replace All

b)

Replace

c)

Find Next

33.

What is the keyboard shortcut for underlining text?

a)

CTRL + U

b)

ALT + U

c)

SHIFT + U

34.

Can you create a custom page size in Microsoft Word?

a)

False

b)

True

35.

Page header or footer automatically applied to every page in that document when created?

a)

True

b)

False

36.

Can you use drag and drop when changing Margins?

a)

No

b)

Yes

37.

A feature in Microsoft Word that can reverse a change.

a)

Paint Brush

b)

Go to

c)

Undo

d)

Redo

38.

Can you use drag and drop when changing Margins?

a)

No

b)

Yes

39.

A feature in Microsoft Word that can reverse a change.

a)

Paint Brush

b)

Go to

c)

Undo

d)

Redo

40.

A feature in Microsoft Word that can reverse back an Undo.

a)

Paint Brush

b)

Go to

c)

Undo

d)

Redo

41.

The top part of every page is called:

a)

Header

b)

Footer

c)

Margin

d)

Slide

42.

The bottom part of every page is called:

a)

Header

b)

Footer

c)

Margin

d)

Slide

43.

To ensure that commonly used functions are always visible, we can add it to which toolbar?

a)

The mini toolbar

b)

The quick access toolbar

c)

The menu bar

44.

Functions used to do text formatting such as bold, italics, and underline can be found in which group?

a)

Clipboard

b)

Font

c)

Paragraph

d)

Styles

45.

Functions used to do text alignment such as center, left, right and justify can be found in which group?

a)

Clipboard

b)

Font

c)

Paragraph

d)

Styles

46.

Functions used to cut, copy, and paste text can be found in which group?

a)

Clipboard

b)

Font

c)

Paragraph

d)

Styles

47.

Functions used to insert pictures or shapes within a document can be found in which group?

a)

Illustrations

b)

Font

c)

Paragraph

d)

Styles

48.

Which button below you would use to open an existing presentation?

a)

File Open

b)

File Save

c)

EXIT

49.

What key do you press to close a Slide Show?

a)

Escape

b)

Backspace

c)

CTRL

d)

Enter

50.

Which of the following button below you would use to go to Slide Show view.

a)

Slide show

b)

start

c)

present

51.

What does 'fixed date' mean?

a)

The date will not change position on the slide

b)

The date will not be shown on the presentation

c)

The date will not update each time the file is opened

d)

The date will update each time file is opened

52.

You can right click anywhere on the slide to bring up the toolbar menu.

a)

False

b)

True

53.

To delete a slide what should you do?

a)

Press Delete key.

b)

Select the Exit command.

c)

Select the Removal command, type the slide number in the dialog box, and then select OK.

d)

Press the Backspace command.

54.

Shortcut key to start a slideshow is:

a)

Windows Key

b)

F5

c)

F12

d)

F10

55.

The notes pane in PowerPoint is for:

a)

Does not serve any purpose.

b)

To display additional information in the presentation.

c)

Not used anymore

d)

To write notes for the speaker.

56.

What is Microsoft PowerPoint used for?

a)

Database

b)

Drawing

c)

Presentation

d)

Desktop Publishing

57.

You can insert the following in Microsoft PowerPoint:

a)

Shapes

b)

All answers are correct

c)

Text

d)

SmartArt

58.

During the Slideshow you press Esc key to:

a)

To go to the last slide

b)

Display the previous slide

c)

Stop the presentation

d)

To go to the first slide

59.

Animations can be applied to:

a)

Shape

b)

Image

c)

Text

d)

All answers are correct

60.

Transitions can be applied to:

a)

Image

b)

Text

c)

Shape

d)

Slide

61.

A slide Header and Footer can have:

a)
b)

Date and Time

c)

All answers are correct

d)

Slide Number

62.

The placeholders in Microsoft PowerPoint allows:

a)

To enter text, shapes, and images

b)

Slides

c)

Animations

d)

Enter filename

63.

_________ shows when you go to next slide

a)

Animation

b)

Transition

c)

Movement

d)

Design

64.

_______ shows when you go to the next object in PowerPoint

a)

Animation

b)

Transition

c)

Movement

d)

Design

65.

To access the slide master in PowerPoint, which menu option should be used?

a)

Insert

b)

Draw

c)

Review

d)

View

66.

What is the purpose of the slide master in PowerPoint?

a)

controls all information about the theme, layout, background, color, fonts, and positioning of all slides

b)

controls all information about the theme, layout, background, color, fonts, and positioning of slide 1 only

c)

it does not have any effect on other slides

67.

What are the advantages of using the slide master in PowerPoint?

a)

custom templates

b)

consistency made easy

c)

save templates for future use

d)

all answers are correct

68.

To apply a design layout to a slide, you need to do the following

a)

Select Home tab then Layout

b)

Select Insert tab then Layout

c)

Select Draw tab then Layout

d)

Select Design tab then Layout

69.

How many types of layouts are in the PowerPoint?

a)

7

b)

8

c)

9

d)

10

70.

Normal View is one of the presentation view modes

a)

True

b)

False

71.

Slide Show View is one of the presentation view modes

a)

True

b)

False

72.

Edit View is one of the presentation view modes

a)

True

b)

False

73.

To hide toolbars in PowerPoint, you must do the following

a)

right-click any of the ribbon tabs, and then select Collapse the ribbon

b)

click the Ribbon Display Option buttons, and then select Auto-hide Ribbon

c)

both options will work

74.

To display toolbars in PowerPoint, you must do the following

a)

right-click any of the ribbon tabs, and then select Show Tabs and Commands

b)

click the Ribbon Display Options button, and then select Show Tabs and Commands

c)

both options will work

75.

The PowerPoint application allows for the printing of multiple slides on one page

a)

True

b)

False

76.

To insert a picture in a slide in PowerPoint, you need to do the following

a)

Select Insert tab then Illustrations group

b)

Select Insert tab then Image group

c)

Select Draw tab then Image group

d)

Select Design tab then Illustrations group

77.

What is the purpose of adding notes to slides in PowerPoint

a)

helps the speaker to remember what to say when presenting

b)

helps the audience to better understand the presentation

c)

all the answers are correct

78.

When using numbering in PowerPoint slides, there is no option but to display the numbers on all slides

a)

True

b)

False

79.

To set the way you want PowerPoint to do proofing (corrects and formats your text), you must do the following

a)

Select Home tab, Option then Proofing

b)

Select File tab, Option then Proofing

c)

Select Review tab, Option then Proofing

d)

Select View tab, Option then Proofing

80.

What is the keyboard shortcut for spell check in PowerPoint

a)

F5

b)

F6

c)

F7

d)

F8

81.

The Header and Footer option in PowerPoint can be accessed from which tab?

a)

Home tab

b)

Insert tab

c)

File tab

d)

Design tab

82.

What is the file extension for PowerPoint files?

a)

.pdf

b)

.pptx

c)

.ptt

d)

.pptt

83.

To delete an unwanted column, it must:

a)

Have three rows

b)

Have content

c)

Be highlighted

d)

Not to be highlighted

84.

If you wanted to move to the cell to the right of your current cell, which key would you press?

a)

Enter

b)

Backspace

c)

CTRL

d)

Tab

85.

How do you select a column in a table?

a)

Click directly above the column you want selected

b)

Hold CTRL and click inside the column you want selected

c)

Drag the cursor over the column you want selected

d)

Use the highlight function in the toolbar

86.

Which of the button below you would use to close an individual worksheet?

a)
b)

b

c)

a

87.

You can clear content from a cell by right clicking it and selecting clear content.

a)

False

b)

True

88.

You can clear content from a cell by right clicking it and selecting clear content.

a)

False

b)

True

89.

If you have already merged some cells containing a title, but decided you want to change it back to individual cells, which button should you click?

a)

Merge and Center

b)

Center

c)

Align Left

d)

Borders

90.

Which character represents the division arithmetic operator?

a)

\

b)

/

c)

*

d)

!

91.

If B6 has the value 5, and C6 has the value 4 in the Formula bar, what will the result of the formula be?

a)

9

b)

20

c)

36

d)

1.25

92.

For the formula ' =IF(C9<25,”Buy”,”Sell”) ', which is the true value?

a)

C9

b)

Buy

c)

Sell

d)

25

93.

For the formula ' =IF(C9<25,”Buy”,”Sell”) ', which is the false value?

a)

C9

b)

Buy

c)

Sell

d)

25

94.

Which formula is correct if you want to get the total of cells B1, B5, and B8?

a)

= SUM(B1,B5,B8)

b)

=SUM(B1;B5)

c)

=SUM(B1:B8)

95.

Which function calculates the smallest value in a set of numbers?

a)

Smallest

b)

Max

c)

Min

96.

Which function will get the total numbers of numeric values in a given cell range?

a)

Sum

b)

Count

c)

Total

97.

If you want to edit the cell contents directly in the cell, what must you do?

a)

Double-click the cell

b)

Click the cell

c)

CTRL + click the cell

d)

SHIFT + click the cell

98.

What keyboard shortcut would you use for pasting a cell?

a)

ALT + X

b)

CTRL + X

c)

CTRL + V

d)

SHIFT + P

99.

Which key will move you down to the cell below your currently selected cell?

a)

Backspace

b)

Down cursor

c)

Tab

100.

Which button on the toolbar below you would use to Merge and Center cells?

a)

a

b)

b

c)

c

101.

Which tool would you use to copy format of a selected cell?

a)

Copy Handle

b)

Copy

c)

Format Painter

d)

Paste

102.

To switch between worksheets:

a)

Press SHIFT + arrow key for the direction of the worksheet

b)

Click on the worksheet tab

c)

Press ALT + TAB

d)

Press CTRL + TAB

103.

It is good practice to enter the cell reference '(for example =D4-C4)' rather than cell values '(for example =9-3)' into formulas because

a)

If the cell value changes, the result will be automatically updated

b)

Formulas only work with cell references

c)

It is more accurate

d)

It the cell name changes, the result will be automatically updated

104.

Which function would you use to count the number of non-numerical items in the list?

a)

COUNTA

b)

AUTOSUM

c)

SUM

d)

COUNT

105.

What character is used to separate cell references when adding a series of cells to a formula?

a)

: (colon)

b)

; (semi-colon)

c)

! (exclamation mark)

d)

? (question mark)

106.

To resize a chart, what must you click?

a)

Copy

b)

Delete

c)

Cut

d)

A sizing handle

107.

After selecting the chart area click the mouse ______ to display the Format Chart Area window.

a)

Once

b)

Three times

c)

Twice

108.

Which of the following are Worksheet Orientation?

a)

Portrait and Landscape

b)

Diagram and Object

c)

Forms and Tables

109.

Is it possible to downsize the page content to make fit on one page?

a)

Yes

b)

No

110.

“The default page orientation of Microsoft Excel is Landscape.”

a)

False

b)

True

111.

Gridlines and row/column heading are only visible in Print Preview, they will not be printed.

a)

True

b)

False

112.

The settings you change for gridlines and row/column headings affect all the sheets in your workbook.

a)

False

b)

True

113.

When printing one or a range of cells you use the option 'Selection'.

a)

True

b)

False

114.

Selecting the entire workbook option will print all worksheets.

a)

False

b)

True

115.

Which key must be held down when selecting multiple non-adjacent cells?

a)

SHIFT

b)

ALT

c)

TAB

d)

CTRL

116.

The Zoom tool is used to minimize your spreadsheets.

a)

False

b)

True

117.

What is quick way of inserting a new row into a spreadsheet?

a)

Right click on the row heading

b)

Double click on the row heading

c)

CTRL + clicking on the row heading

118.

If you want to use Format Painter to copy the format across several ranges of cells, what must you do?

a)

Click the Format Painter

b)

Click each cell

c)

CTRL + click Format Painter

d)

Double click Format Painter

119.

How do you select individual columns/rows at the same time?

a)

Hold SHIFT and click the columns/rows you want selected

b)

Hold CTRL and click the columns/rows you want selected

c)

Click on the cells/rows you want selected

120.

To auto-adjust several rows or columns what must you do first?

a)

Highlight them all

b)

Click Format

c)

Drag them to the correct position

d)

Right click on them

121.

To copy a worksheet, you need to Select

a)

Right click the worksheet tab and select Move or Copy

b)

Press the copy button in the Standard Toolbar

c)

All answers are correct

d)

Press CTRL + C

122.

It is good practice to click on the cell you need to include in the formula because ____

a)

It reduces the risk of making a typing mistake in the formula

b)

It ensures the values in the cells are automatically updated

c)

Arithmetic operators work only when cells are referenced by a mouse click

d)

It is more efficient as you can enter multiple cells at once

123.

The #REF! error will occur if ____________

a)

You divide a cell value by an empty cell value or cell value set to zero

b)

You include a cell reference to a text value rather than a numeric value

c)

You refer to a row, cell, or worksheet that has been deleted

d)

The cell reference cannot be found

124.

When creating a formula, Excel uses relative referencing by default.

a)

False

b)

True

125.

The AutoSum function automatically adds the following to the Formula bar

a)

=MIN( , )

b)

=AUTOSUM( , )

c)

=MAX( , )

d)

=SUM( , )

126.

In which category would you find the IF function?

a)

Text

b)

Math & Trig

c)

Logical

d)

Statistical

127.

To resize a chart and maintain its proportions, which key can you press whilst dragging a corner sizing handle

a)

ENTER

b)

CTRL

c)

SHIFT

d)

ALT

128.

You can rename an Excel sheet

a)

True

b)

False

129.

To perform a logical test with a condition ____ function should be used

a)

Sum

b)

Average

c)

Count

d)

IF

130.

Microsoft Excel is a:

a)

Word Processor Software

b)

Spreadsheet program

c)

Presentation program

d)

None of the above

131.

Formulas in Excel starts with:

a)

=

b)

%

c)

==

d)

+

132.

To add borders to worksheet in Excel, you must do the following

a)

Select the required cells, go to File tab, then click on Border from the Font group

b)

Select the required cells, go to Home tab, then click on Border from the Font group

c)

Select the required cells, go to Insert tab, then click on Border from the Font group

133.

To create charts or graphs in Excel, you must do the following

a)

Select the required cells, go to File tab, then click on any chart type from the Charts group

b)

Select the required cells, go to Home tab, then click on any chart type from the Charts group

c)

Select the required cells, go to Insert tab, then click on any chart type from the Charts group