NEW
Font size
S
M
L
XL
WorksheetsMs Excel Beginners Quiz
Total questions: 30
Worksheet time: 17mins
Name
Class
Date
1.
An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available?
a)
dialog box
b)
additional workbook
c)
list of worksheets
d)
additional part of the current range
2.
Which of the following is a selected cell?
a)
current command
b)
default option
c)
active Cell
d)
default cell
3.
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
4.
After a file has been opened, the filename appears in which of the following?
a)
Title bar
b)
footer
c)
header
d)
description pane
5.
When you split a window, the window is divided into how many panes?
a)
two
b)
three
c)
four
d)
two or four
6.
When you click the Help button, what opens?
a)
screen tips
b)
keytips
c)
help window
d)
dialog box
7.
What is an intersection of a row and a column?
a)
range
b)
tab
c)
bar chart
d)
cell
8.
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
9.
To get to the last cell on the worksheet, which of the following should you press?
a)
ctrl+home
b)
ctrl+end
c)
ctrl+right
d)
ctrl+left
10.
Pressing the F1 key displays Backstage view.
a)
true
b)
false
11.
Pressing the Alt key activates Keytips that allow you to use the keyboard to choose tabs instead of click them with the mouse.
a)
true
b)
false
12.
Ctrl + O opens a new blank workbook.
a)
true
b)
false
13.
The Quick Access Toolbar appears on the right side of the title bar, above the ribbon.
a)
true
b)
false
14.
Ctrl + F displays Backstage view.
a)
true
b)
false
15.
Click the FILE tab to get to Backstage view.
a)
true
b)
false
16.
Press Ctrl + Home to go to cell A1.
a)
true
b)
false
17.
The columns in a worksheet are identified by numbers.
a)
true
b)
false
18.
The active cell in a worksheet is outlined by a bold rectangle.
a)
true
b)
false
19.
. Page Layout view is useful when preparing your data for printing.
a)
true
b)
false
20.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
21.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell Address
b)
Worksheet
c)
Formula
22.
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
23.
In Excel, columns are labeled by?
a)
Numbers
b)
Letters
24.
Which of the following is not an arithmetic operator?
a)
=
b)
+
c)
s
d)
^
25.
Why do you start a formula with an = sign?
a)
to tell Excel you are entering a formula
b)
just because
c)
you are entering text
26.
What is the answer to the following formula: =2^4 + 7
a)
13
b)
71
c)
23
d)
123
27.
Does Excel allow the use of numbers in formulas?
a)
yes
b)
no
28.
What is this graph?
a)
Pie chart
b)
Line graph
c)
Bar graph
29.
What is this graph?
a)
Pie chart
b)
Bar graph
c)
Line graph
30.
Which tab do you click to add a chart?
a)
Home
b)
File
c)
Insert
Reset
