WorksheetsExcel Review
Total questions: 32
Worksheet time: 16mins
Name
Class
Date
1.
The _______ displays the location, or name, of a selected cell.
a)
Name Box
b)
Status Bar
2.
Sometimes you may need to work with workbooks that were created in earlier versions of Microsoft Excel, such as Excel 2003 or Excel 2000. When you open these types of workbooks, they will appear in _____________ Mode.
a)
Read-Only
b)
Compatibality
3.
Select a template to review it. A ________ of the template will appear, along with additional information on how the template can be used.
a)
Copy
b)
Preview
4.
You can browse templates by category or use the__________ bar to find something more specific.
a)
Tell Me
b)
Search
5.
____________ Mode disables certain features, so you'll only be able to access commands found in the program that was used to create the workbook.
a)
Safe
b)
Compatibility
6.
1. In the formula bar, you can enter or edit ________, a _______, or a _________ that will appear in a specific cell.
a)
data, formula, function
b)
workbooks, worksheet, cell
7.
The ______________ box works like a search bar to help you quickly find tools or commands you want to use.
a)
Tell Me
b)
Search
8.
A _______ is a group of cells that runs from the left of the page to the right. In Excel and Google Sheets, ___________ are identified by numbers.
a)
Column, Columns
b)
Row, Rows
c)
Cell, Cells
d)
Worksheet, Worksheets
9.
A ___________ is a group of cells that runs from the top of the page to the bottom. In a spreadsheet, ___________ are identified by letters.
a)
Row, rows
b)
Column, Columns
10.
Spreadsheet files are called a _________. Each __________ holds one or more __________. Click the tabs to switch between them, or right-click for more options.
a)
Worksheets, Columns
b)
Workbook, worksheets
11.
There are _______ ways to view a worksheet. Simply click a command to select the desired view.
a)
One
b)
Two
c)
Three
d)
Four
12.
The _____________________ lets you access common commands no matter which tab is selected. You can customize the commands depending on your preference.
a)
Quick Access Tool Bar
b)
BackStage View
c)
Home Tab
d)
View Tab
13.
Excel uses a ______ Ribbon system instead of traditional menus. Each _____ will have one or more groups.
a)
Tabbed, Tab
b)
Quick Access, Ribbon
14.
Some _________ will have an ________ you can click for more options.
a)
Groups, arrow
b)
Tabs, Arrow
15.
You can add any feature of Excel to the ______________ so that you can easily access it from anywhere
a)
Ribbon
b)
Quick Access Tool Bar
16.
Excel has 1000s of features, they are grouped into several ___________.
a)
Ribbons
b)
Tabs
17.
The _____________ is where any calculations or formulas you write will appear.
a)
Formula Bar
b)
Spreadsheet Grid
18.
When you create or edit a workbook, you'll use the Save command to save your changes.
a)
Save
b)
Save As
19.
If you want to save a different version of a workbook while keeping the original, you can create a copy by using the ___________.
a)
Save
b)
Save As
20.
It is preset in Excel and Google Sheets, and uses numbers or symbols to express a standard math process
a)
Function
b)
Heading
c)
Calculation
d)
Excel file
21.
The Fill Handle lets you do what in a spreadsheet? (Choose the BEST answer.)
a)
Copy text or values to another cell
b)
Apply a formula to other cells
c)
Two of these answers are correct.
d)
Format a table
22.
What is missing from this function?
=Average (B9, B12)
=Average (B9, B12)
a)
This is a cell range, so it should have a colon : between the cell addresses
b)
Nothing is missing
c)
There should be a math symbol between the cell addresses
d)
Average should not be part of it
23.
What is the difference between a function and a formula?
a)
A function is a commonly used, preset formula
b)
A formula is basic math while a function is more advanced math
c)
You have to create the formula but a function is like an "auto formula" in Excel
d)
Functions are used in statistics
24.
Which of the following is not an MS Excel data type?
a)
Money
b)
Date and Time
c)
Number
d)
Text
25.
Rio wants to create an attendance sheet for her class. The worksheet includes the names of the students, class number and dates for the school days. What data type will not be of used for the said worksheet?
a)
Numbers
b)
Texts
c)
Date and Time
d)
Currency
26.
John wants to create a chart that shows trends of sales for four quarters. What type of chart should he create?
a)
PivotChart
b)
Line Chart
c)
Embedded Chart
d)
Linked Chart
27.
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
a)
Decrease/Increase
b)
Collapse/Expand
c)
Reduce/Add
d)
Subtract/Add
28.
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature would she modify?
a)
Axis Title
b)
Chart Title
c)
Gridlines
d)
Plot Area
29.
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include?
a)
Axis
b)
Chart Title
c)
Data Label
d)
Legend
30.
What ribbon contains the commands used to create a chart in Excel?
a)
Home Ribbon
b)
Insert Ribbon
c)
Formulas Ribbon
d)
Data Ribbon
31.
In order to directly report the data, what must a PivotChart always be associated with?
a)
Table
b)
Range
c)
PivotTable
d)
Worksheet
32.
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type would he create?
a)
Bar
b)
Column
c)
Line
d)
Pie
100 %
