wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Review

Total questions: 101

Worksheet time: 2hrs 41mins

Name
Class
Date
1.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
2.
In Excel it means Add
a)
Plus sign
b)
sort 
c)
Forward slash 
d)
asterisk 
3.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
4.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
5.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
6.
2 or more cells that are selected to create a source to be used in a formula
a)
Range
b)
Max
c)
Filter
d)
Colums 
7.
Adding two cells
a)
=SUM(A1+A13)
b)
=SUM(__)
c)
A1+A13= SUM
d)
Total
8.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
9.
A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.
a)
Line Chart
b)
Pie Chart
c)
Bar Chart
d)
Graphs
10.
A Graphic representation of data. The bar can be VERTICAL or Horizontal, but a vertical graph is also known as a column chart.
a)
Bar Chart
b)
Pie Chart
c)
Graphs
d)
Line Chart
11.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
12.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow
13.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign 
14.
In an excel forumula it means divide
a)
Forwardslash 
b)
Backwards
c)
Skip
d)
Multiply 
15.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
16.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
17.
a vertical line of cells
a)
Maximum
b)
Minimum 
c)
Column 
d)
Formulas
18.
What kind of software is Excel?
a)
Spreadsheet software
b)
Word Processing
c)
Drawing
19.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
20.
What do you call the rectangles on a spreadsheet?
a)
Cell
b)
Button
c)
Sentence
21.

Excel allows you to work with?

a)

Sentences

b)

Paragraphs

c)

data

22.
Blank are horizontal
a)
Rows
b)
Columns
23.
Blank are vertical
a)
Columns
b)
Rows
24.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
25.
What is the Formula sign for multiply? 
a)
\
b)
*
26.
True or False: Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses?
a)
false
b)
true
27.

In Excel rows are labeled by

a)

Letters

b)

Numbers

28.

In Excel, columns are labeled by?

a)

Numbers

b)

Letters

29.

What button will add up a group of numbers?

a)

Equals button

b)

Auto sum button

c)

Plus symbol button

30.

Excel would be the ideal program to type a book report?

a)

False

b)

True

31.

You can use the auto-sum key to subtract numbers.

a)

True

b)

False

32.
How do you make a cell the active cell?
a)
Click the ACTIVE button
b)
Click INSERT CELL
c)
Click on the cell
d)
Cells are always active
33.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
34.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
35.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
36.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
37.
What key should you use to take you to the cell to the right
a)
Tab key
b)
Right arrow key
c)
just click in it
38.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
39.
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
a)
Page preview
b)
Print Layout
c)
Synchronous Scrolling
d)
Window View
40.
After a file has been opened, the filename appears in which of the following?
a)
Title bar
b)
footer
c)
header
d)
description pane
41.
When you click the Help button, what opens?
a)
screen tips
b)
keytips
c)
help window
d)
dialog box
42.
Which of the folowing starts off with open, undo, and can be customized to contain the commands you use most frequently?
a)
a worksheet
b)
the help window
c)
the quick access toolbar
d)
the ribbon
43.
How many worksheets does a new Excel 2013 workbook open with?
a)
one
b)
two 
c)
three
d)
four
44.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

45.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

46.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

47.

What is a sheet in Excel?

a)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single template that typically contains labels, values, formulas, functions, and graphical representations of data.

d)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

48.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

49.

Excel spreadsheets that are already created and ready for you to edit are known as?

a)

spreadsheets

b)

templates

c)

data inputs

d)

pages

50.

What is the green bar at the top of Excel referred to as?

a)

the data bar

b)

the function bar

c)

the ribbon

d)

the row

51.

When making a graph whats the first thing you need to do?

a)

Pick the type of Graph

b)

Use the function = sign

c)

Highlight your data being used.

d)

Double click the active cell

52.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

53.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

54.

What does the Max formula do?

a)

Returns the highest three values in a set of values and ignores text.

b)

Returns the largest value in a set of values and ignores text.

c)

Returns the text that you are searching for.

d)

Returns the smallest value in a set of values and ignores text.

55.

What does the Min formula return?

a)

Returns the smallest three numbers form a set and ignores text.

b)

Returns the smallest value in a set of values and ignores text.

c)

Returns the largest three numbers form a set and ignores text.

d)

Returns the largest value in a set of values and ignores text.

56.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
57.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
58.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
59.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
60.
Each Excel file is called a workbook because
a)
It can contain text and data
b)
It can be modified
c)
It can contain many sheets including worksheets and chart sheets
d)
You have to work hard to create it
61.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
62.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
63.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
64.

Which of the following indicates a proper cell address?

a)

3A

b)

:A3

c)

A3

d)

@A3

65.

Which of the following is the selection pointer?

a)
b)
c)
66.

Which of the following is the move handle?

a)
b)
c)
67.

If you have too much text and would like to display it on multiple lines of the same cell, you need to:

a)

Merge the cell

b)

Wrap the text

c)

Auto-fit the cell

d)

Resize the cell

68.

Combining multiple cells into a single cell is:

a)

Wrapping

b)

Re-sizing

c)

Merging

d)

Auto-fitting

69.

The name for an outline or grid around cells

a)

Margin

b)

Layout

c)

Wrap

d)

Border

70.

To enter text in a cell, you must first:

a)

Insert a text box

b)

Right click the cell

c)

Double click the cell

d)

Merge the cell

71.

What is a file?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

c)

A document that is stored on your computer.

d)

An Excel file that contains individual worksheets. Also called a spreadsheet file.

72.

What is Autofill?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

c)

A combination of numbers and symbols used to express a calculation.

d)

A document that is stored on your computer.

73.

What is an Active Cell?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

The cell in your worksheet that has been selected. It will have bolder gridlines around it.

c)

A combination of numbers and symbols used to express a calculation.

d)

A document that is stored on your computer.

74.

What is a formula?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

c)

A combination of numbers and symbols used to express a calculation.

d)

A document that is stored on your computer.

75.

What is a worksheet?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

A “page” within an Excel workbook that contains columns, rows, and cells.

c)

A combination of numbers and symbols used to express a calculation.

d)

A document that is stored on your computer.

76.

What is a workbook?

a)

A function that automatically identifies and adds ranges of cells in your worksheet.

b)

A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.

c)

An Excel file that contains individual worksheets. Also called a spreadsheet file.

d)

A document that is stored on your computer.

77.

In Excel, what symbol do you use for multiplication?

a)

x

b)

+

c)

/

d)

*

78.

In Excel, where in a cell would you click if you wanted to drag and copy a formula to nearby cells?

a)

top left

b)

top right

c)

bottom right

d)

bottom left

79.

In Excel, how do you combine 2 cells and put the words in the middle?

a)

Merge and Center

b)

Combine and Center

c)

You can't do this

d)

Merge and Middle

80.
Located at the bottom of your workbook file, they represent worksheets within the workbook.
a)
worksheet
b)
workbook
c)
sheet tab
d)
scroll bar
81.

In the picture, why is D2 through D5 placed in paranthesis?

a)

So Excel knows to total the cells before performing the next operation.

b)

So the total of the cells can be multiplied rather than added.

c)

So the calculation will be done last.

82.
If the parenthesis is removed, what will 9.5% be multiplied by? 
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
83.

Which response best completes the following statement: A formula is used to

a)

perform calculations or other actions.

b)

find averages.

c)

Look Up data

84.

The discount formula can be explained by saying the _______ minus 10% of the ___________ or multiplying the ________ times 90%.

a)

total

b)

Sum

c)

percentage

85.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
86.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
87.

In the picture, why is D2 through D5 placed in paranthesis?

a)

So Excel knows to total the cells before performing the next operation.

b)

So the total of the cells can be multiplied rather than added.

c)

So the calculation will be done last.

88.

Which response best completes the following statement: A formula is used to

a)

perform calculations or other actions.

b)

find averages.

c)

Look Up data

89.

What type of chart is displayed in the picture?

a)

BAR

b)

LINE

c)

STOCK

d)

COMBO

90.

Which chart type shows values as parts of a whole?

a)

Column

b)

Bar

c)

Area

d)

Pie

91.

What is a function in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

92.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

93.

What symbol comes first when using a function?

a)

:

b)

*

c)

(

d)

=

94.

How are cells named?

a)

By row (number) and column (letter)

b)

By column (letter) and row (number)

c)

By the contents of the cell

d)

Names are randomly assigned

95.

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?

a)

=SUM(C1-C5)

b)

=SUM(C1,C5)

c)

=SUM(C1:C5)

d)

=SUM(C1*C5)

96.

What function finds the mean of a data set?

a)

There is no function to calculate mean

b)

MEAN

c)

MEDIAN

d)

AVERAGE

97.
A ______________ is an equation in a worksheet.
a)
Range
b)
Argument
c)
Formula
d)
Excel
98.

How can you use Excel to help in your everyday life?

a)

Address List

b)

Create a schedule

c)

Create a budget

d)

Create a gradebook

e)

All of the above

99.

Which button do you use to reverse your last action?

a)

ReDo

b)

Zoom

c)

Undo

d)

Close

100.

Sheet tabs are located ____________

a)

Bottom right and identifies the name of the sheet

b)

Bottom left and identifies the name of the worksheet

c)

Center of the page

d)

Top right corner of the workbook

101.

What are worksheets______________?

a)

The pages in your math workbook

b)

The pages in your student handbook

c)

The pages of a workbook

d)

The handouts I give you to work from

Similar Resources on Wayground

SAS Informatika 7 Semester Ganjil

98 questions

SAS Informatika 7 Semester Ganjil

quiz

Worksheet

•

7th Grade

Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 _LV1_2024)

96 questions

Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 _LV1_2024)

quiz

Worksheet

•

1st Grade - University

ICT benchmarking test y6

106 questions

ICT benchmarking test y6

quiz

Worksheet

•

7th - 9th Grade

Ulangan Informatika Kelas 7 Sem 1

100 questions

Ulangan Informatika Kelas 7 Sem 1

quiz

Worksheet

•

7th Grade - University

ميزات التصميم ثنائي الأبعاد والتصميم ثلاثي الأبعاد

99 questions

ميزات التصميم ثنائي الأبعاد والتصميم ثلاثي الأبعاد

quiz

Worksheet

•

6th Grade - University

LATIHAN UJIAN TULIS TIK KELAS 6

100 questions

LATIHAN UJIAN TULIS TIK KELAS 6

quiz

Worksheet

•

6th - 8th Grade

6ano

99 questions

6ano

quiz

Worksheet

•

7th Grade - University