wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Microsoft Excel Terminology

Total questions: 40

Worksheet time: 23mins

Name
Class
Date
1.

What is the feature called that checks your spelling and grammar?

(a)  

2.

This is the file tab where you can do things with your file like, share, print, or save and protect it.

a)

Backstage

b)

Backboard

c)

Desktop

d)

Platform

3.

This feature allows you to line up or straighten content.

a)

Adjust

b)

Align

c)

Autocorrect

d)

Audit

4.

What is it called when you change the way an object or content look or appear?

(a)  

5.

Leaving comments on a document for others to read and review is called markup.

a)

True

b)

False

6.

These are the light gray lines that divide each of the cells, roes, and columns in a spreadsheet.

a)

Graph paper

b)

Graphic designs

c)

Gridlines

d)

Guard marks

7.

WordArt is a Microsoft design feature that is only accessible in Word.

a)

True

b)

False

8.

Margins are defined as the edge or border of something. Which tab in Excel gives you the option to adjust the margins of a spreadsheet?

a)

Home

b)

Insert

c)

Page Layout

d)

Formulas

9.

These include premade text, SmartArt, chart, table or image formatting so you can make objects look good quickly and easily.

a)

Styles

b)

Options

c)

Tabs

d)

Commands

10.

This tool allows you to copy animations or formatting easily from one object to another.

a)

Painter

b)

Copy/Paste

c)

Drawing

d)

Format

11.

A PDF is a type of file that can not be opened for free on any device which allows read privileges but not editing privileges.

a)

True

b)

False

12.

This is the horizontal space at the top of the window that organizes commands in tabs, and then groups the commands by topic. this is where all your tabs and menus are.

(a)  

13.

The Header is the section where information located at the top of each slide or page which includes the author name, page number, date, etc.

a)

True

b)

False

14.

The Footer is the section where information located at the top of each slide or page which includes the author name, page number, date, etc.

a)

True

b)

False

15.

SmartArt is a cool way to represent your information which includes all the following except _____.

a)

Charts

b)

Flowcharts

c)

Diagrams

d)

Pyramids

e)

None of these

16.

A link to another location or file, typically activated by clicking on a highlighted word or image on the screen is called a _____.

a)

Hyperbole

b)

Hyperactivity

c)

Hypersonic

d)

Hyperlink

17.

______ is the process by which data is formatted so that it can be used by another application.

a)

Code

b)

Process

c)

Export

d)

Save

18.

The process of combining multiple cells on a spreadsheet into one is known as _______.

a)

Save

b)

Merge

c)

Duplicate

d)

None of these

19.

A function is a formula or equation used to generate an answer.

a)

True

b)

False

20.

This function is used to combine strings of text into one, usually when combining First name and Last name cells into one cell.

a)

Concatenate

b)

Merge

c)

Duplicate

d)

Cut/Paste

21.

This tool fills in a field or cells automatically.

a)

AutoSum

b)

AutoCorrect

c)

AutoFill

d)

None of these

22.

Columns, the vertical, up/down parts of a spreadsheet are denoted by numbers.

a)

True

b)

False

23.

The horizontal, side-to-side parts of a spreadsheet, denoted numbers are called ____.

a)

Cells

b)

Rows

c)

Columns

d)

None of these

24.

Referring to a rectangle on a spreadsheet by naming the column and then the row in which it lies (i.e. B17) is called the ______.

a)

Cell Reference

b)

Cell Marker

c)

Cell Name

d)

Cell Location

25.

The rectangular field on a spreadsheet formed by the intersection of a column and a row in which information or data is typed is called a (a)   .

26.

Worksheets can contain multiple workbooks in Excel.

a)

True

b)

False

27.

This is the part/page of an Excel spreadsheet file in which you are working.

a)

Worksheet

b)

Workbook

c)

Workspace

d)

Document

28.

This feature automatically adds up values in a row or column.

a)

AutoCorrect

b)

AutoSum

c)

AutoFill

d)

None of these

29.

A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes is called ____.

a)

Graphic Lines

b)

Supply Curve

c)

Demand Curve

d)

Sparkline

30.

This feature in Microsoft allows you t put things in order.

(a)  

31.

If you want to remove unwanted pieces of data from view in a table you can use this special feature.

a)

Filter

b)

File

c)

Format

d)

Find

32.

This page orientation is vertical, up/down positioning of a sheet.

a)

Landmark

b)

Print

c)

Portrait

d)

Landscape

33.

This page orientation is horizontal, side-to-side positioning of a sheet.

a)

Landmark

b)

Print

c)

Portrait

d)

Landscape

34.

A spreadsheet cell that does not change regardless of its attributes.

a)

Reference

b)

Relative Reference

c)

Absolute Reference

d)

Automatic Reference

35.

A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on.

a)

Reference

b)

Relative Reference

c)

Absolute Reference

d)

Automatic Reference

36.

This refers to a cell or a range of cells on a worksheet and can be used in a formula so that Excel can find the values of data that you want that formula to calculate.

a)

Cell Reference

b)

Cell Marker

c)

Cell Address

d)

Cell Location

37.

A1:G7 is a specified group of cells and is an example of which of the following terms?

a)

Cell Formatting

b)

Cell Formula

c)

Cell Identification

d)

Cell Range

38.

Under which of the tabs listed below will you be able to add images, shapes, charts, or graphics to a spreadsheet?

a)

Home

b)

Insert

c)

Page Layout

d)

Formula

e)

Data

39.

Which of the tabs listed must you choose to print, share, export, or save your spreadsheet

a)

File

b)

Home

c)

Insert

d)

Page Layout

e)

Formulas

40.

To insert WordArt, which tab must you select.

a)

File

b)

Home

c)

Insert

d)

Page Layout

e)

Formulas