Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Test 2024

Total questions: 20

Worksheet time: 20mins

Name
Class
Date
1.

What is the intersection point of a column and a row in Excel called?

a)
grid
b)
cell
c)
square
d)
block
2.

Which term refers to the vertical arrangement of cells?

a)
stack
b)
column
c)
row
d)
tier
3.

What do you call the process of changing the appearance of data in a cell?

a)
modifying
b)
transforming
c)
editing
d)
formatting
4.

Which option allows you to apply a consistent appearance to selected cells?

a)
Color Picker
b)
Copy Paste
c)
Font Selector
d)
Format Painter
5.

What is the name for the entire collection of rows and columns?

a)
spreadsheet
b)
grid
c)
table
d)
chart
6.

Which feature in Excel allows you to automatically adjust the width of a column to fit the contents?

a)
Typing 'AutoFit' in the formula bar and pressing Enter
b)
Double-clicking the right edge of the column header
c)
Pressing Ctrl + A to select the entire sheet and then double-clicking the right edge of the column header
d)
Right-clicking the column header and selecting 'AutoFit Column Width'
7.

What is the term for the action of combining multiple cells into one larger cell?

a)
Merge Rows
b)
Combine Cells
c)
Join Cells
d)
Merge Cells
8.

Which function in Excel allows you to add up a range of numbers quickly?

a)
ADD
b)
SUMMATION
c)
SUM
d)
TOTAL
9.

Which term refers to the action of moving data from one location to another within an Excel worksheet?


a)
insert and delete
b)
drag and drop
c)
cut and paste
d)
copy and paste
10.

What do you call a predefined set of formatting options in Excel?

a)
Formatting Styles
b)
Predefined Formats
c)
Excel Templates
d)
Cell Styles
11.

What is the name for a group of adjacent cells?

a)
range
b)
bunch
c)
set
d)
cluster
12.

What does the abbreviation "CSV" stand for?

Responses


a)
Comma-Separated Values
b)
Code Syntax Validator
c)
Centralized Software Version
d)
Computer System Verification
13.

Which feature allows you to temporarily hide selected rows or columns?

a)
Delete feature
b)
Hide feature
c)
Show feature
d)
Format feature
14.

What is the term for the process of making data easier to read by emphasizing certain values and de-emphasizing others?

a)
Data Analysis
b)

Data Formatting

c)
Data Transformation
d)
Data Interpretation
15.

Which function allows you to count the number of cells in a range that contain numbers?

a)
SUM
b)
AVERAGE
c)
MAX
d)
COUNT
16.

What is the term for the small black square in the bottom-right corner of a selected cell or range?


a)
Fill handle
b)
Corner marker
c)
Selection indicator
d)
Grid reference
17.

Which feature allows you to automatically fill cells with data based on a pattern or sequence?


a)
AutoGenerate
b)
AutoFill
c)
AutoPopulate
d)
AutoComplete
18.

What is the term for a set of rules for organizing and managing data?

a)
data model
b)
database schema
c)
data structure
d)
data organization
19.

Which function allows you to find the highest value in a range of cells?


a)
AVERAGE
b)
SUM
c)
MAX
d)
MIN
20.

What does the term "Formula Bar" refer to?

a)
A type of graph in data visualization
b)
Input field in spreadsheet software
c)
A feature in word processing software
d)
A tool for creating animations