wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel Review

Total questions: 55

Worksheet time: 2hrs 16mins

Name
Class
Date
1.
The _______ displays the location, or name, of a selected cell.
a)
Name Box
b)
Status Bar
2.
Each rectangle in a workbook is called a Cell. A Cell is the intersection of a row and a column. Simply click to select a ___________.
a)
Cell
b)
Row
c)
Column
d)
Worksheet
3.
Excel has 1000s of features, they are grouped into several ___________.
a)
Ribbons
b)
Tabs
4.
The _____________ is where any calculations or formulas you write will appear. 
a)
Formula Bar
b)
Spreadsheet Grid
5.
What is a file that contains one or more spreadsheets?
a)
spreadsheet
b)
workbook
c)
cell
d)
cell range
6.
Which is an example of a cell address?
a)
126
b)
A9
c)
SUM
d)
75/65
7.
Which is an example of a cell range?
a)
65-75
b)
=SUM(A1)
c)
1295
d)
C1:C9
8.

Every function or formula you enter in excel starts with.....

a)

an equal sign

b)

a plus sign

c)

a minus sign

9.
What combines one or more cells?
a)
merge
b)
wrap text
c)
cell address
10.
A column is vertical.
a)
true
b)
false
11.
A row is horizontal.
a)
true
b)
false
12.

In Excel, MAX and AVERAGE are examples of _____.

a)

lists

b)

formula prefix

c)

reference operator

d)

functions

13.

##### in a cell means that the _____.

a)

content in that cell is hidden

b)

column is too narrow to display the value completely

c)

formula contains an error

d)

column is too wide for the content

14.

On a chart created in Excel, the horizontal axis is also called the ______.

a)

x-axis

b)

y-axis

c)

z-axis

d)

category axis

15.

On a chart created in Excel, the vertical axis is also called the ______.

a)

x-axis

b)

y-axis

c)

value axis

d)

z-axis

16.
Located at the bottom of your workbook file, they represent worksheets within the workbook.
a)
worksheet
b)
workbook
c)
sheet tab
d)
scroll bar
17.
The name of the cell's location; such as A8
a)
Active cell
b)
Cell Address
c)
Row
d)
Heading
18.
It is preset in Excel, and uses numbers or symbols to express a standard math process
a)
Function
b)
Heading
c)
Calculation
d)
Excel file
19.
Located below the ribbon, it shows the formula, data, or cell address for the active cell
a)
Function
b)
Formula button
c)
Formula bar
d)
Insert
20.
Cell Range
a)
combines multiple lines into on cell
b)
A combination of numbers and symbols used to express a calculation
c)
to copy a cell’s contents and formatting into other cells
d)
a block of cells that can be selected (B4:B16)
21.
Fill Handle
a)
The name of the cell is determined by the name of the row and the column intersecting, such as A8
b)
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows
c)
the black symbol in the lower right corner of an active cell. Clicking & dragging it can copy cell contents or duplicate the cell contents
d)
adds the values in a function or set of cells (also, AutoSum)
22.
AutoSum
a)
adds the values in a function or set of cells
b)
provides the middle number of the range of numbers used
c)
A combination of numbers and symbols used to express a calculation.
d)
to copy a cell’s contents and formatting into other cells
23.
What is missing from this function?
=(F8 : F13)
a)
It doesn't need parentheses ( )
b)
The name of the function being applied
c)
SUM should be in front of the equal sign
d)
Nothing is missing
24.
What is missing from this function?
=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
25.
What is the symbol for multiplication in an Excel function?
a)
x
b)
/
c)
*
d)
#
26.
If you see this code, what should you do?
#VALUE!
a)
Change the function
b)
Check your values entered
c)
Check the function's syntax
d)
Add a math symbol like * or +
27.
If you use the MAX function, what are you trying to find?
a)
The average for the cell range
b)
The median number in the cell range
c)
The largest number in the cell range
d)
The total of averages in different columns
28.
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
29.
Each cell's name is based on its _______ and _______.
a)
column, row
b)
column, cell
30.
You can use the _______ key on your keyboard to clear content from multiple cells at once.
a)
Clear
b)
Delete
31.
Which command is used to insert a cut or copied selection to a cell or range of cells?
a)
Cut
b)
Copy
c)
Paste
d)
Drag and Drop
32.
Predefined set of colors, fonts, effects that can be applied to an entire or specific workbook. 
a)
Document Theme
b)
Template
33.
An Excel view that enables you to see what your document will look like before printing.
a)
Print Preview
b)
BackStage
34.

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

a)

SUM

b)

COUNTA

c)

MIN

d)

MAX

35.

Which function returns the lowest value in a range?

a)

SUM

b)

AVERAGE

c)

MAX

d)

MIN

36.

Which function would you use instead of this formula: =B1+B2+B3+B4+B5+B6+B7?

a)

=SUM(B1:B7)

b)

=COUNT(B1:B7)

c)

=AVERAGE(B1:B7)

d)

=MAX(B1:B7)

37.

Which function was used in E1?

a)

=COUNT(A1:A9)

b)

=COUNTA(A1:A9)

c)

=COUNTBLANK(A1:A9)

38.

Which function was used in E2?

a)

=COUNT(B1:B9)

b)

=COUNTA(B1:B9)

c)

=COUNTBLANK(B1:B9)

39.

Which of the following options can be used to fit the worksheet to one page?

a)

Collated

b)

Orientation

c)

Margins

d)

Scaling

40.

To change printer, layout, or margin settings, you click the File tab and use which of the following options?

a)

Info

b)

Options

c)

Print

d)

Open

41.

Which of the following options will print borders around each cell in your printed worksheet?

a)

Gridlines

b)

Draft Quality

c)

Print Titles

d)

Print Area

42.

Portrait orientation is the default orientation and it prints the page taller than it is wide.

a)

TRUE

b)

FALSE

43.

Which Excel ribbon contains the command to Insert Data from Text?

a)

Insert

b)

Data

c)

Home

d)

Page Layout

44.

To have Excel remove any duplicate records that have the same ID#, which value(s) should be checked?

a)

ID# only

b)

ID# and Last Name

c)

ID # and Last Name and First Name

d)

No values should contain a check mark

45.

Which sort option would showing increasing values or alphabetical order?

a)

Ascending

b)

Descending

46.

Referring to the table above, which sort box will sort by Country (with United States listed first), then by State in ascending order, then by Postal Code in ascending order?

a)
b)
c)
d)
47.

Referring to the table above, what is the quickest method of filtering so that only Oklahoma (OK) is shown?

a)

Uncheck every state or province except OK

b)

Uncheck Select All and then check OK

c)

Sort A to Z and then check OK

d)

Sort Z to A and then check OK.

48.

How do you add a Total Row to a table?

a)

Enable the Total Row table style option

b)

Insert a blank row at the bottom of the table and then type "Total Row" as its heading

c)

Enable the Total Row conditional formatting option

d)

Use the Insert ribbon, then check Total Row

49.

What should you do if there is a worksheet that needs to remain in the workbook but does not need to be viewed by everyone who has access to the workbook.

a)

Delete the worksheet

b)

Move the worksheet to the end of the workbook

c)

Hide the worksheet

d)

Click the undisplay command

50.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

a)

It's the easiest way to make a backup before making changes.

b)

It lets you reuse formats and formulas in a new sheet.

c)

It helps Excel learn where your data ranges are located.

d)

You should keep one worksheet hidden in case of an error.

51.

Which of the following will return your worksheet to 100% with one click?

a)

A

b)

B

c)

C

d)

D

52.

Which of the following statements describes how to change the color of a worksheet tab?

a)

On the Page Layout tab, in the Themes group, select Colors.

b)

Right-click the tab and select Tab Color.

c)

Use the Fill Color tool on the Home tab.

d)

You cannot change the color of a worksheet tab.

53.

Which cell would you click to freeze Rows 1-5 and Column A?

a)

A5

b)

B5

c)

A6

d)

B6

54.

In order for you to freeze the first column of a worksheet into a frozen pane:

a)

The entire contents of the column must be visible.

b)

The first row of the column must be non-blank.

c)

Duplicate worksheets must also be able to have their first columns frozen.

d)

You can click Freeze First Column in the Freeze Panes menu.

55.

When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?

a)

September

b)

August (2)

c)

Sheet2

d)

July

Similar Resources on Wayground

Aplikasi Pengolah Angka (Spreadsheet)

50 questions

Aplikasi Pengolah Angka (Spreadsheet)

quiz

Worksheet

•

9th - 12th Grade

Persiapan SAS Informatika kelas X SMK

50 questions

Persiapan SAS Informatika kelas X SMK

quiz

Worksheet

•

10th Grade

RO81 Pre Production

53 questions

RO81 Pre Production

quiz

Worksheet

•

11th Grade

KISI2 PTS GNP MULOK MIKROTIKK

50 questions

KISI2 PTS GNP MULOK MIKROTIKK

quiz

Worksheet

•

12th Grade

ULANGAN KEAMANAN JARINGAN SEMESTER GANJIL 2023/2024

50 questions

ULANGAN KEAMANAN JARINGAN SEMESTER GANJIL 2023/2024

quiz

Worksheet

•

10th Grade

สอบครั้งที่ 1 วิชาธุรกิจและการเป็นผู้ประกอบการ

51 questions

สอบครั้งที่ 1 วิชาธุรกิจและการเป็นผู้ประกอบการ

quiz

Worksheet

•

12th Grade

SISTEM JARINGAN INTERNET

50 questions

SISTEM JARINGAN INTERNET

quiz

Worksheet

•

10th Grade