wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Basics Semester Exam

Total questions: 29

Worksheet time: 14mins

Name
Class
Date
1.

What is a workbook in Excel?

a)

A single spreadsheet within a workbook

b)

A file that contains one or more related worksheets

c)

A document that stores and manipulates data in columns and rows

d)

A frozen row or column that remains visible on the screen

2.

What does the term "worksheet" refer to in Excel?

a)

A file that contains one or more related worksheets

b)

A single spreadsheet within a workbook

c)

A document that stores and manipulates data in columns and rows

d)

A tool for monitoring changes or growth in data over time

3.

What is the default file extension for Excel workbooks?

a)

CSV

b)

XLSX

c)

TXT

d)

DOCX

4.

What does the "Freeze Panes" feature do in Excel?

a)

Hides rows or columns from view

b)

Keeps a row or column visible on the screen regardless of scrolling

c)

Applies formatting from copied cells to destination cells

d)

Switches rows and columns of copied cells

5.

What is the purpose of the "Hide/Unhide" feature in Excel?

a)

To delete rows or columns permanently

b)

To hide rows or columns from view without deleting them

c)

To apply formatting to copied cells

d)

To switch rows and columns of copied cells

6.

What does "Paste Formatting" do in Excel?

a)

Copies only the values of the copied cells

b)

Applies the formatting from copied cells to destination cells

c)

Switches rows and columns of copied cells

d)

Hides rows or columns from view

7.

What does the "Navigate" feature allow you to do in Excel?

a)

Move through different parts of a workbook or worksheet

b)

Import data from another source

c)

Arrange data systematically within a workbook

d)

Perform mathematical operations on numbers

8.

What is the purpose of the "Import" feature in Excel?

a)

To move through different parts of a workbook

b)

To bring data into Excel from another source

c)

To arrange data systematically within a workbook

d)

To perform mathematical operations on numbers

9.

What is the function of "Calculate" in Excel?

a)

To monitor changes or growth in data

b)

To perform mathematical operations on numbers within a spreadsheet

c)

To arrange data systematically within a workbook

d)

To bring data into Excel from another source

10.

What are arithmetic operations in Excel?

a)

Operations like addition, subtraction, multiplication, and division

b)

Monitoring changes or growth in data

c)

Arranging data systematically within a workbook

d)

Importing data from another source

11.

What does "AutoFit" do in Excel?

a)

Automatically adjusts the width and height of a column, row, or cell

b)

Automatically performs a calculation on a group of cells

c)

Draws an outline around a cell or group of cells

d)

Combines selected cells into one large cell

12.

What is the function of "AutoSum" in Excel?

a)

Automatically adjusts the width and height of a column

b)

Automatically performs a calculation (like addition) on a group of cells

c)

Draws an outline around a cell or group of cells

d)

Combines selected cells into one large cell

13.

What does "Cell Borders" do in Excel?

a)

Draws an outline around a cell or group of cells

b)

Automatically adjusts the width and height of a column

c)

Combines selected cells into one large cell

d)

Displays numerical information like date or percentage

14.

What are "Cell Styles" in Excel?

a)

Predefined formatting options for cells or groups of cells

b)

The color of the cell background

c)

A set of calculations applied to values in a spreadsheet

d)

A computational procedure that performs a specific operation

15.

What does "Fill Color" refer to in Excel?

a)

The color of the cell background

b)

Predefined formatting options for cells

c)

A set of calculations applied to values in a spreadsheet

d)

A computational procedure that performs a specific operation

16.

What is a "Formula" in Excel?

a)

A set of calculations applied to values in a spreadsheet

b)

Predefined formatting options for cells

c)

The color of the cell background

d)

A computational procedure that performs a specific operation

17.

What is the "Formula Bar" used for in Excel?

a)

To display the contents of the active cell

b)

To apply predefined formatting options

c)

To draw an outline around a cell

d)

To automatically adjust the width and height of a column

18.

What is a "Function" in Excel?

a)

A computational procedure that performs a specific operation

b)

A set of calculations applied to values in a spreadsheet

c)

Predefined formatting options for cells

d)

The color of the cell background

19.

What are "Function Arguments" in Excel?

a)

The values inside the parentheses of a function

b)

A computational procedure that performs a specific operation

c)

A set of calculations applied to values in a spreadsheet

d)

Predefined formatting options for cells

20.

What does "Merge and Center" do in Excel?

a)

Combines selected cells into one large cell and centers the content

b)

Automatically adjusts the width and height of a column

c)

Draws an outline around a cell or group of cells

d)

Displays numerical information like date or percentage

21.

What is "Number Formatting" used for in Excel?

a)

Displays numerical information like date, monetary value, or percentage

b)

Combines selected cells into one large cell

c)

Automatically adjusts the width and height of a column

d)

Draws an outline around a cell or group of cells

22.

What does "Print Area" designate in Excel?

a)

A section of a worksheet to be printed

b)

Rows or columns repeated on each printed page

c)

Text that begins a new line when reaching the end of a cell

d)

Combines selected cells into one large cell

23.

What are "Print Titles" in Excel?

a)

Rows or columns repeated on each printed page

b)

A section of a worksheet to be printed

c)

Text that begins a new line when reaching the end of a cell

d)

Combines selected cells into one large cell

24.

What does "Wrap Text" do in Excel?

a)

Begins a new line when text reaches the end of a cell

b)

Combines selected cells into one large cell

c)

Displays numerical information like date or percentage

d)

Draws an outline around a cell or group of cells

25.

What is the purpose of "Paste Values" in Excel?

a)

Copies only the values of the copied cells without formatting

b)

Applies formatting from copied cells to destination cells

c)

Switches rows and columns of copied cells

d)

Hides rows or columns from view

26.

What is the purpose of "Navigate" in Excel?

a)

To move through different parts of a workbook or worksheet

b)

To import data from another source

c)

To arrange data systematically within a workbook

d)

To perform mathematical operations on numbers

27.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
28.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

29.
The _____ function that adds all of the numbers in a range of cells.
a)
AutoSum
b)
minimum
c)
maximum
d)
Average