Font size
WorksheetsMicrosoft Excel Terminology
Total questions: 40
Worksheet time: 23mins
What is the feature called that checks your spelling and grammar?
(a)
This is the file tab where you can do things with your file like, share, print, or save and protect it.
Backstage
Backboard
Desktop
Platform
This feature allows you to line up or straighten content.
Adjust
Align
Autocorrect
Audit
What is it called when you change the way an object or content look or appear?
(a)
Leaving comments on a document for others to read and review is called markup.
True
False
These are the light gray lines that divide each of the cells, roes, and columns in a spreadsheet.
Graph paper
Graphic designs
Gridlines
Guard marks
WordArt is a Microsoft design feature that is only accessible in Word.
True
False
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?
Home
Insert
Page Layout
Formulas
These include premade text, SmartArt, chart, table or image formatting so you can make objects look good quickly and easily.
Styles
Options
Tabs
Commands
This tool allows you to copy animations or formatting easily from one object to another.
Painter
Copy/Paste
Drawing
Format
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.
True
False
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)
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.
True
False
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.
True
False
SmartArt is a cool way to represent your information which includes all the following except _____.
Charts
Flowcharts
Diagrams
Pyramids
None of these
A link to another location or file, typically activated by clicking on a highlighted word or image on the screen is called a _____.
Hyperbole
Hyperactivity
Hypersonic
Hyperlink
______ is the process by which data is formatted so that it can be used by another application.
Code
Process
Export
Save
The process of combining multiple cells on a spreadsheet into one is known as _______.
Save
Merge
Duplicate
None of these
A function is a formula or equation used to generate an answer.
True
False
This function is used to combine strings of text into one, usually when combining First name and Last name cells into one cell.
Concatenate
Merge
Duplicate
Cut/Paste
This tool fills in a field or cells automatically.
AutoSum
AutoCorrect
AutoFill
None of these
Columns, the vertical, up/down parts of a spreadsheet are denoted by numbers.
True
False
The horizontal, side-to-side parts of a spreadsheet, denoted numbers are called ____.
Cells
Rows
Columns
None of these
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 ______.
Cell Reference
Cell Marker
Cell Name
Cell Location
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) .
Worksheets can contain multiple workbooks in Excel.
True
False
This is the part/page of an Excel spreadsheet file in which you are working.
Worksheet
Workbook
Workspace
Document
This feature automatically adds up values in a row or column.
AutoCorrect
AutoSum
AutoFill
None of these
A small graphic designed to give a quick representation of numerical or statistical information taking the form of a graph without axes is called ____.
Graphic Lines
Supply Curve
Demand Curve
Sparkline
This feature in Microsoft allows you t put things in order.
(a)
If you want to remove unwanted pieces of data from view in a table you can use this special feature.
Filter
File
Format
Find
This page orientation is vertical, up/down positioning of a sheet.
Landmark
Portrait
Landscape
This page orientation is horizontal, side-to-side positioning of a sheet.
Landmark
Portrait
Landscape
A spreadsheet cell that does not change regardless of its attributes.
Reference
Relative Reference
Absolute Reference
Automatic Reference
A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on.
Reference
Relative Reference
Absolute Reference
Automatic Reference
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.
Cell Reference
Cell Marker
Cell Address
Cell Location
A1:G7 is a specified group of cells and is an example of which of the following terms?
Cell Formatting
Cell Formula
Cell Identification
Cell Range
Under which of the tabs listed below will you be able to add images, shapes, charts, or graphics to a spreadsheet?
Home
Insert
Page Layout
Formula
Data
Which of the tabs listed must you choose to print, share, export, or save your spreadsheet
File
Home
Insert
Page Layout
Formulas
To insert WordArt, which tab must you select.
File
Home
Insert
Page Layout
Formulas
