wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

MIDTERM EXAM IN OP1

Total questions: 50

Worksheet time: 25mins

Name
Class
Date
1.

Which option in the File tab allows you to save a workbook with a new name?

a)

Open

b)

Save

c)

Save As

d)

Print

2.

Which of the following actions can be performed using the File tab?

a)

Print the worksheet

b)

Insert a table

c)

Format cells

d)

Merge cells

3.

The File tab allows you to:

a)

Insert shapes

b)

Create a chart

c)

Save a workbook

d)

Perform a spelling check

4.

Which option in the File tab is used to export the workbook as a PDF?

a)

Print

b)

Share

c)

Export

d)

Open

5.

Under which option in the File tab can you check for compatibility with earlier versions of Excel?

a)

Info

b)

Save As

c)

Open

d)

Options

6.

To protect a workbook with a password, you can find this option under:

a)

Home

b)

File -> Info

c)

Insert

d)

View

7.

Which option in the File tab allows you to access recent documents?

a)

New

b)

Info

c)

Recent

d)

Options

8.

Which of the following can be found under the Info option in the File tab?

a)

Protect Workbook

b)

View Macros

c)

Format Cells

d)

Insert Table

9.

To print a worksheet, which of the following options would you use from the File tab?

a)

Open

b)

Export

c)

Print

d)

Save As

10.

The Options command in the File tab allows you to:

a)

Insert a new chart

b)

Change Excel's default settings

c)

Create a new workbook

d)

Apply conditional formatting

11.

In the Home tab, the option to apply bold formatting to text is found under:

a)

Font group

b)

Alignment group

c)

Styles group

d)

Cells group

12.

The Format Cells dialog box is accessed from which group in the Home tab?

a)

Font

b)

Styles

c)

Cells

d)

Editing

13.

In the Home tab, which command is used to change the number format (e.g., General, Currency)?

a)

Font Size

b)

Merge & Center

c)

Number Format

d)

Cell Styles

14.

Which of the following commands is located in the Home tab's Alignment group?

a)

Wrap Text

b)

Insert Table

c)

Conditional Formatting

d)

Find & Select

15.

The Home tab allows you to add or remove borders through which group?

a)

Editing

b)

Styles

c)

Alignment

d)

Font

16.

The Fill Color option is located in which group on the Home tab?

a)

Font

b)

Cells

c)

Styles

d)

Alignment

17.

The Merge & Center option is found in which group in the Home tab?

a)

Font

b)

Alignment

c)

Editing

d)

Styles

18.

In the Home tab, what does the Wrap Text command do?

a)

Adds text borders

b)

Moves text to a new line within a cell

c)

Combines multiple cells

d)

Deletes the text from the cell

19.

The Conditional Formatting option in the Home tab is used for:

a)

Applying borders to cells

b)

Adding headers and footers

c)

Highlighting cells based on rules

d)

Changing text alignment

20.

Where is the Cut, Copy, and Paste command found in the Home tab?

a)

Editing group

b)

Font group

c)

Clipboard group

d)

Cells group

21.

Which group in the Home tab contains the Insert Rows and Columns command?

a)

Styles

b)

Cells

c)

Editing

d)

Alignment

22.

The Home tab's Editing group contains which of the following commands?

a)

Sort & Filter

b)

Find & Select

c)

Fill

d)

All of the above

23.

In the Home tab, which option allows you to format numbers with a comma separator?

a)

Wrap Text

b)

Merge Cells

c)

Comma Style

d)

Conditional Formatting

24.

The Home tab's Styles group includes:

a)

Format Painter

b)

Font Color

c)

Cell Styles

d)

Fill Color

25.

The Home tab contains which feature to help adjust cell width automatically?

a)

Conditional Formatting

b)

AutoFit

c)

Freeze Panes

d)

Format Painter

26.

To delete cells or rows, you would use which group in the Home tab?

a)

Alignment

b)

Editing

c)

Cells

d)

Font

27.

AutoSum is located in which group of the Home tab?

a)

Alignment

b)

Editing

c)

Font

d)

Styles

28.

Which group in the Home tab allows you to add cell borders?

a)

Alignment

b)

Font

c)

Editing

d)

Styles

29.

The Home tab's Number group is used to:

a)

Merge cells

b)

Apply number formats such as Currency, Date, or Percentage

c)

Insert charts

d)

Format tables

30.

Which command in the Home tab helps in clearing contents or formatting?

a)

Delete

b)

Clear

c)

Format Painter

d)

Filter

31.

In the Insert tab, which command allows you to insert a table into a worksheet?

a)

Shapes

b)

Table

c)

PivotTable

d)

SmartArt

32.

Which of the following objects can you add using the Insert tab?

a)

PivotTable

b)

Chart

c)

Shapes

d)

All of the above

33.

The Insert tab provides an option to add a Chart in which group?

a)

Charts

b)

Tables

c)

Links

d)

Illustrations

34.

The Insert tab's Links group allows you to:

a)

Add a hyperlink

b)

Insert shapes

c)

Format cells

d)

Adjust number formatting

35.

Where can you find the PivotTable command in the Insert tab?

a)

Tables group

b)

Illustrations group

c)

Links group

d)

Text group

36.

The Insert tab allows you to add headers and footers using which group?

a)

Text

b)

Tables

c)

Illustrations

d)

Charts

37.

Which group in the Insert tab contains the Pictures command?

a)

Charts

b)

Links

c)

Illustrations

d)

Text

38.

In the Insert tab, which command helps in adding a hyperlink to a worksheet?

a)

PivotTable

b)

Header & Footer

c)

Hyperlink

d)

SmartArt

39.

The Insert tab allows you to add WordArt from which group?

a)

Charts

b)

Text

c)

Illustrations

d)

Tables

40.

To insert a Shape, which group would you use in the Insert tab?

a)

Tables

b)

Illustrations

c)

Charts

d)

Text

41.

Which of the following features is NOT found in the Insert tab?

a)

Conditional Formatting

b)

SmartArt

c)

PivotTable

d)

Pictures

42.

Which group in the Insert tab allows you to create a Sparklines graph?

a)

Illustrations

b)

Tables

c)

Charts

d)

Sparklines

43.

In the Insert tab, you can add a Slicer for filtering data from which group?

a)

Tables

b)

Links

c)

Illustrations

d)

Charts

44.

To insert a Text Box into your Excel worksheet, which group in the Insert tab would you use?

a)

Illustrations

b)

Text

c)

Charts

d)

Links

45.

The Insert tab includes a command to add SmartArt in which group?

a)

Illustrations

b)

Charts

c)

Text

d)

Tables

46.

Which of the following can be inserted using the Insert tab?

a)

PivotTable

b)

Picture

c)

Chart

d)

All of the above

47.

The Insert tab provides the option to create a new worksheet using which command?

a)

Table

b)

PivotTable

c)

New Sheet

d)

None of the above

48.

In the Insert tab, which option allows you to add an online picture?

a)

Picture

b)

Online Pictures

c)

Clip Art

d)

Hyperlink

49.

The Insert tab's Illustrations group includes the following commands EXCEPT:

a)

Shapes

b)

Chart

c)

Picture

d)

SmartArt

50.

To add a Chart to your worksheet, which group should you use in the Insert tab?

a)

Tables

b)

Links

c)

Charts

d)

Illustrations