wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

review gcc 8

Total questions: 80

Worksheet time: 40mins

Name
Class
Date
1.

What does a cell represent in Excel?

a)

A row of data

b)

A column of data

c)

A box where you type data

d)

A formula result

2.

Which formula is used to find the sum of A1 to A5?

a)

=ADD(A1:A5

b)

=SUM(A1:A5

c)

=TOTAL(A1:A5

d)

=PLUS(A1:A5

3.

What does =AVERAGE(B1:B5) do?

a)

Finds the total

b)

Finds the average

c)

Finds the minimum

d)

Counts blank cells

4.

What will =LEFT("INFORMATICS",4) return?

a)

INFO

b)

MATI

c)

TICS

d)

FORM

5.

Which function finds the largest number?

a)

=MIN(A1:A5

b)

=MAX(A1:A5

c)

=COUNT(A1:A5

d)

=AVERAGE(A1:A5

6.

Which function counts how many numbers are in a range?

a)

=COUNT(E1:E10

b)

=SUM(E1:E10

c)

=LEN(E1:E10

d)

=MAX(E1:E10

7.

What is the first character of “Microsoft”?

a)

M

b)

C

c)

F

d)

S

8.

What is the result of =RIGHT("INFORMATICS",4)?

a)

INFO

b)

TICS

c)

MICS

d)

FORM

9.

Which function changes text to uppercase?

a)

UPPER

b)

LOWER

c)

CAPITAL

d)

FORMAT

10.

Which function joins several texts together?

a)

CONCAT

b)

JOIN

c)

TEXT

d)

COMBINE

11.

The formula =LEN("Excel 2025") will result in...

a)

10

b)

8

c)

9

d)

11

12.

Sorting data from A–Z is called...

a)

Ascending

b)

Descending

c)

Filtering

d)

Arranging

13.

Sorting data from Z–A is called...

a)

Ascending

b)

Descending

c)

Grouping

d)

Filtering

14.

What is the main use of Filter?

a)

To display only certain data

b)

To add numbers

c)

To remove formulas

d)

To color cells

15.

Where can you find Filter in Excel?

a)

Data tab

b)

Home tab

16.

What symbol must every formula start with?

a)

=

b)

+

c)

*

d)

#

17.

Which function finds the smallest number?

a)

MIN

b)

MAX

c)

LOW

d)

SMALL

18.

What is the result of =MID("INFORMATICS",3,4)?

a)

INFO

b)

TICS

c)

FORM

d)

MATI

19.

What type of data can be sorted in Excel?

a)

Both text and numbers

b)

Only text

c)

Only numbers

d)

Only formulas

20.

The Filter tool uses what symbol on columns?

a)

Dropdown arrow

b)

Star

c)

Checkbox

d)

Highlight

21.

In Excel, a table is made up of...

a)

Rows and columns

b)

Only text

c)

Only numbers

d)

Images only

22.

Which function gives the total score of a list of students?

a)

SUM

b)

COUNT

c)

MAX

d)

LEN

23.

Which is a text function?

a)

LEFT

b)

SUM

c)

MIN

d)

COUNT

24.

To find how many students took the test, use…

a)

COUNT

b)

SUM

c)

AVERAGE

d)

MIN

25.

What is the benefit of sorting data?

a)

Easier to analyze and find information

b)

Makes Excel slower

c)

Deletes duplicates

d)

Hides formulas

26.

A function is a built-in formula in Excel.

a)

True

b)

False

27.

The equal sign (=) is optional when writing a formula.

a)

True

b)

False

28.

The CONCAT function is used to join text.

a)

True

b)

False

29.

=MAX(A1:A5) gives the smallest number.

a)

True

b)

False

30.

LEN counts the number of characters in a text.

a)

True

b)

False

31.

Sorting A–Z means arranging from largest to smallest.

a)

True

b)

False

32.

Filtering allows you to see only the data you need.

a)

True

b)

False

33.

Text functions can only work with numbers.

a)

True

b)

False

34.

You can filter multiple columns at once.

a)

True

b)

False

35.

The UPPER function makes text lowercase.

a)

True

b)

False

36.

Excel cannot handle both text and number data.

a)

True

b)

False

37.

A cell is the intersection of a row and column.

a)

True

b)

False

38.

=AVERAGE(A1:A5) adds numbers together.

a)

True

b)

False

39.

Using formulas helps calculate data faster.

a)

True

b)

False

40.

Filtering removes data permanently.

a)

True

b)

False

41.

Which menu is used to insert a Cover Page?

a)

Home

b)

Insert

c)

Design

d)

Layout

42.

The front page of a document is called...

a)

Cover

b)

Heading

c)

Title

d)

Footer

43.

Which part lists the document’s sections with page numbers?

a)

Table of Contents

b)

Footer

c)

Summary

d)

Cover Page

44.

PART 2 — Microsoft Word: Create a Cover, TOC, and Format Headings Heading 1 is used for...

a)

a) Main chapter titles

b)

b) Subtitles

c)

c) Body text

d)

d) Footnotes

45.

PART 2 — Microsoft Word: Create a Cover, TOC, and Format Headings Heading 2 is used for...

a)

Main title

b)

Subtitles inside a chapter

c)

Normal text

d)

Cover

46.

What is the purpose of a Table of Contents?

a)

To help readers find sections easily

b)

To add pictures

c)

To format text

d)

To count words

47.

Which menu is used to create an automatic TOC?

a)

Insert

b)

Home

48.

The shortcut to save a document is...

a)

Ctrl + S

b)

Ctrl + Z

c)

Ctrl + Y

d)

Ctrl + F

49.

To undo your last action, use...

a)

Ctrl + Z

b)

Ctrl + Y

c)

Ctrl + P

d)

Ctrl + F

50.

The main function of Heading Styles is...

a)

To organize document structure

b)

To make pictures colorful

c)

To change page layout

d)

To print documents

51.

The Cover page should be...

a)

Centered and clean

b)

Left-aligned only

c)

Hidden

d)

Small font

52.

Which font is recommended for official documents?

a)

Times New Roman or Calibri

b)

Comic Sans MS

c)

Chiller

d)

Jokerman

53.

Which heading is for sub-subtitles?

a)

Heading 3

b)

Heading 1

c)

Heading 2

d)

Normal

54.

To apply a Heading Style:

a)

Highlight → Home → Styles → Choose Heading

b)

Insert → Picture

c)

Design → Font

d)

Layout → Page Setup

55.

What feature helps you move quickly to sections?

a)

Navigation Pane

b)

Review tab

c)

Insert tab

d)

Page Setup

56.

Which TOC type updates automatically?

a)

Automatic

b)

Manual

c)

Typed list

d)

Linked text

57.

To modify a heading appearance, choose...

a)

Modify

b)

Rename

c)

Edit

d)

Reset

58.

Which part gives the first impression of the document?

a)

Cover Page

b)

Heading

c)

Table

d)

Footer

59.

The TOC title should be...

a)

Centered

b)

Right-aligned

c)

Left-aligned

d)

Hidden

60.

What is the purpose of spacing 1.15 or 1.5?

a)

To make text easier to read

b)

To add color

c)

To shrink text

d)

To print faster

61.

21. Heading Styles make creating TOC...

a)

Faster and automatic

b)

Manual and slow

c)

Decorative only

d)

Useless

62.

A document without headings cannot...

a)

Generate an automatic TOC

b)

Be saved

63.

Ctrl + P shortcut means...

a)

Print document

b)

Paste

c)

Paragraph

d)

Page setup

64.

If page numbers in TOC are wrong, what should you do?

a)

Update Table

b)

Delete TOC

c)

Copy again

d)

Print again

65.

The main benefit of using Cover, Heading, and TOC is...

a)

A neat, professional document

b)

A colorful page

c)

Random fonts

d)

Bigger file size

66.

The Cover Page is always the last page.

a)

True

b)

False

67.

Heading Styles help create an automatic TOC.

a)

True

b)

False

68.

TOC stands for Table of Contents.

a)

True

b)

False

69.

Heading 1 is used for subtitles.

a)

True

b)

False

70.

You can create TOC without headings.

a)

True

b)

False

71.

Ctrl + S is used to save the file.

a)

True

b)

False

72.

Ctrl + F is used to find words.

a)

True

b)

False

73.

TOC can be updated when pages change.

a)

True

b)

False

74.

Heading Styles make documents messy.

a)

True

b)

False

75.

Cover Page should be centered and clean.

a)

True

b)

False

76.

Heading 3 is for main titles.

a)

True

b)

False

77.

Line spacing helps readability.

a)

True

b)

False

78.

Automatic TOC saves time.

a)

True

b)

False

79.

The References menu is used for TOC.

a)

True

b)

False

80.

Using Heading Styles is optional for TOC creation.

a)

True

b)

False

Similar Resources on Wayground

Big Data 4: Presto

75 questions

Big Data 4: Presto

quiz

Worksheet

•

University

SQL Server Management Studio Quiz

85 questions

SQL Server Management Studio Quiz

quiz

Worksheet

•

12th Grade - University

Computer Science 3

83 questions

Computer Science 3

quiz

Worksheet

•

University

GEC Summative Test

80 questions

GEC Summative Test

quiz

Worksheet

•

University

G-MS FR

85 questions

G-MS FR

quiz

Worksheet

•

University

Information Systems Fundamentals Practice Questions 1

78 questions

Information Systems Fundamentals Practice Questions 1

quiz

Worksheet

•

University

Untitled Quiz

76 questions

Untitled Quiz

quiz

Worksheet

•

University

BA 4

80 questions

BA 4

quiz

Worksheet

•

University