NEW
Font size
S
M
L
XL
WorksheetsExcel Quiz
Total questions: 51
Worksheet time: 28mins
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.
A type of chart which displays information as a series of data points called 'markers' connected by straight line segments.
a)
Pie chart
b)
Line Chart
c)
Bar Graphs
d)
Graphs
12.
Making a change in the default settings
a)
Format
b)
Error
c)
Chart
d)
Average
13.
the sum of all numbers divided by the amount of numbers.
a)
Maximun
b)
Minimum
c)
Median
d)
Average
14.
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
15.
In an excel formula, it means substract
a)
Add sign
b)
Minus sign
c)
Divide sign
d)
Average Sign
16.
In an excel forumula it means divide
a)
Forwardslash
b)
Backwards
c)
Skip
d)
Multiply
17.
Horizontal line of cells
a)
Row
b)
Column
c)
Cell
d)
Spreadsheet
18.
A box that holds data
a)
Spreadsheet
b)
Cell
c)
Row
d)
Data
19.
a vertical line of cells
a)
Maximum
b)
Minimum
c)
Column
d)
Formulas
20.
Not next to each other
a)
non contiguous cells
b)
contiguous cells
c)
close cells
d)
apart cells
21.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
22.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
23.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
24.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
25.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
26.
When entering numbers in Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
27.
What is the term used where a column and row intersect?
a)
Toolbar
b)
Cell
c)
Name Box
d)
Formula Bar
28.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
29.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
30.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
31.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
32.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
33.
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
34.
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)
35.
How can you find specific information in a list?
a)
Select Tools > Finder from the menu
b)
Click the Find button on the standard toolbar
c)
Select Insert > Find from the menu
d)
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
36.
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
37.
To copy formatting from one area in a worksheet and apply it to another area you would use:
a)
The Edit>Copy Format and Edit>Paste Format commands form the menu.
b)
The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
c)
There is no way to copy and apply formatting in Excel � You have to do it manually
d)
The Format Painter button on the standard toolbar
38.
If the cell contains hashtags (#), what do you need to do?
a)
Expand the column
b)
Expand the row
c)
Change the formula
39.
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
40.
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
41.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
42.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
43.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
44.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
45.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
46.
Columns go...
a)
Across
b)
Down
47.
Rows go...
a)
Across
b)
Down
48.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
49.
Which of these symbols is used for divide on a computer?
a)
\
b)
*
c)
/
d)
|
50.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
51.
Which of these formulas will find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
Reset
