WorksheetsMicrosoft Excel Vocabulary
Total questions: 45
Worksheet time: 23mins
The term 'Absolute Value' in Microsoft Excel is defined as:
The value of a number without regard to its sign
The sum of all values in a range
The average of a set of numbers
The maximum value in a dataset
The term 'Autofill' in Microsoft Excel is defined as:
A feature that automatically fills cells with data based on the pattern of the selected cells.
A tool used to create charts and graphs from data.
A function that checks for errors in formulas.
A command to sort data alphabetically.
The term 'Backstage' in Microsoft Excel refers to:
A feature that allows users to manage files and data about them, including opening, saving, printing, and sharing Excel files.
A tool used for creating charts and graphs in Excel.
A function for performing complex calculations in Excel.
A setting for adjusting the appearance of Excel worksheets.
Define the term 'Cell' as used in Microsoft Excel.
A cell is a rectangular area in a worksheet that is used to enter data.
A cell is a type of chart used in Excel.
A cell is a function in Excel that performs calculations.
A cell is a tool for formatting text in Excel.
Define the term 'Cell Reference' as used in Microsoft Excel.
A unique identifier for a cell, formed by combining the column letter and row number.
A formula used to perform calculations in a spreadsheet.
A tool for formatting cells in Excel.
A feature to sort data in a spreadsheet.
Define the term 'CONCATENATE' as used in Microsoft Excel.
A function to merge text from multiple cells into one cell
A function to calculate the sum of a range of cells
A function to find the average of a set of numbers
A function to sort data in ascending order
Conditional Formatting in Microsoft Excel is used to:
Change the font style of text
Apply different colors to cells based on their values
Sort data in ascending order
Create charts and graphs
The term 'COUNTIF' in Microsoft Excel is used to:
Count the number of cells that meet a single condition.
Sum the values in a range that meet a single condition.
Count the number of cells in a range regardless of any condition.
Find the average of values in a range that meet a single condition.
Define the term 'Export' as used in Microsoft Excel.
A feature to import data from other software
A feature to save data in a different format
A feature to delete data
A feature to format data
Define the term 'Filter' as used in Microsoft Excel.
A tool to sort and display specific data based on criteria
A feature to create charts and graphs
A function to perform calculations
A method to protect a worksheet
Define the term 'Function' as used in Microsoft Excel.
A predefined formula that performs calculations using specific values in a particular order.
A tool used to create charts and graphs in Excel.
A feature that allows for the formatting of cells based on conditions.
A method to sort and filter data in Excel.
Define the term 'Header' as used in Microsoft Excel.
A row at the top of each page in a worksheet that contains information such as the page number, date, and title.
A column that contains the main data of the worksheet.
A cell that is used to perform calculations.
A feature that allows you to sort data in a worksheet.
Define the term 'Markup' as used in Microsoft Excel.
A feature to track changes in a document
A tool for creating charts and graphs
A function for calculating percentages
A method for formatting text
Define the term 'Merge' as used in Microsoft Excel.
A feature to combine multiple cells into one cell
A function to add numbers in a column
A tool to sort data alphabetically
A command to create a chart
The term 'PDF' in Microsoft Excel is defined as:
Portable Document Format
Page Description Format
Print Document File
Page Display File
The term 'Quick Access Toolbar' in Microsoft Excel is defined as:
A toolbar that provides quick access to frequently used commands.
A feature that allows sharing of Excel files.
A tool for creating complex formulas.
A menu for accessing Excel settings.
Define the term 'Quick Parts' as used in Microsoft Excel.
A feature to insert reusable pieces of content
A tool for data analysis
A function for creating charts
A setting for adjusting page layout
Define the term 'Relative Value' as used in Microsoft Excel.
A function to calculate the sum of a range of cells
A method to compare the value of one cell to another
A feature to format cells based on conditions
A tool to create charts and graphs
Define the term 'Ribbon' as used in Microsoft Excel.
A toolbar that provides quick access to commonly used commands
A type of chart used for data visualization
A function to calculate the sum of a range of cells
A feature to track changes in a worksheet
SmartArt in Microsoft Excel is used to:
Create charts and graphs
Insert images
Design and format flowcharts and diagrams
Perform complex calculations
Define the term 'Sort' as used in Microsoft Excel.
A function to filter data
A function to arrange data in a specific order
A function to calculate data
A function to delete data
Define the term 'Sparklines' as used in Microsoft Excel.
A type of chart that provides a graphical representation of data in a single cell
A tool for sorting and filtering data
A function for performing complex calculations
A feature for creating pivot tables
Define the term 'Styles' as used in Microsoft Excel.
A feature to change the font size
A tool to create charts
A set of formatting instructions
A function to calculate totals
Define the term 'Workbook' as used in Microsoft Excel.
A single spreadsheet within Excel
A collection of spreadsheets within Excel
A tool for data analysis
A function for creating charts
A 'Worksheet' in Microsoft Excel is defined as:
A single page in an Excel workbook where data is entered and manipulated.
A tool used to create graphs and charts in Excel.
A feature that automatically corrects spelling errors in Excel.
A security feature to protect Excel files from unauthorized access.
The rectangular fields you can type in on a spreadsheet formed when a column intersects with a row.
Cell
Row
Column
Sheet
Where you manage your slideshow’s data and information— create, save, and send documents, inspect documents for hidden stuff or personal information and set options such as turning on or off AutoComplete.
Backstage view
Slide Sorter
Normal View
Reading View
The horizontal space at the top of the window that organizes commands on tabs, and then groups the commands by topic. It’s where all your tabs and menus are.
Ribbon
Toolbar
Menu Bar
Status Bar
The entire Excel spreadsheet file you are working in, it can contain one or more worksheets (think of it as a book made up of many sheets of paper).
Workbook
Worksheet
Cell
Formula
To put in order.
Sort
Mix
Disorganize
Shuffle
A cool way to representing your information -- organization charts, flow charts, Venn diagrams, pyramids, etc.
SmartArt
ClipArt
WordArt
ChartArt
A part/page on an excel spreadsheet file you are working in, (think how many sheets make up a book).
Worksheet
Workbook
Cell
Chart
To remove unwanted pieces of data from view in a table.
Filter
Sort
Highlight
Merge
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 or data that you want that formula to calculate.
Range
Cell Reference
Data Link
Formula Reference
Apply a format to a cell or a range of cells based on certain criteria.
Conditional formatting
Data validation
Cell referencing
AutoSum
A spreadsheet cell that does change depending on what changes were made to the spreadsheet it is located on.
Relative cell reference
Absolute cell reference
Mixed cell reference
Static cell reference
Also known as comments, these are notes other people can leave you on your document.
Annotations
Footnotes
Highlights
Bookmarks
What does the function =MAX(A1:A10) return?
The minimum value in the range A1:A10
The maximum value in the range A1:A10
The average value in the range A1:A10
The sum of all values in the range A1:A10
Which function would you use to find the average value in a range of cells?
MEAN()
AVERAGE()
MEDIAN()
AVG()
Which of the following is not a logical function in Excel?
IF
AND
OR
FOR
Which function in Excel gives you the sum of a range of cells?
SUM()
ADD()
TOTAL()
PLUS()
Letters in Excel represent
rows
data
columns
functions
What does the function =ROUND(2.15, 1) return?
2.1
2.2
2
3
inserted columns are placed to the _______ of the selected columns in an excel worksheet
right
left
center
none of the above
What is the purpose of the VLOOKUP function in Excel?
To vertically align text within cells
To look up and retrieve data from a specific column in a table
To verify the lookup value in the first row of a table
To create a vertical lookup table
