NEW
Font size
WorksheetsMSEXCEL QUIZ NO. 2
Total questions: 20
Worksheet time: 10mins
All formulas in Excel begin with the following symbol.
+
=
%
#
Which formula below will add the value of B2 to the value of C3
=B2+C3
=C3+B3
=6+4
=B+C
Which is the correct formula?
=SUM(A1:A5)
Add A1 - A5
Subtract the numbers from A1 to A5
A1 = A5
What kind of software is Excel?
Word processing software
Spreadsheet Software
Data Base Software
In Excel rows are labeled by
letters
numbers
rows and numbers
In excel, columns are labeled by
Letters
Numbers
Letters and numbers
What button will add up a group of numbers
Equals button
Plus symbol button
Auto-sum button
Excel refers to files as
Documents
Workbooks
data bases
Where rows and columns meet are referred to as
Blocks
Cells
Boxes
What kind of chart should you use to show the pieces (percentages) of a whole
Bar Chart
Column Chart
Pie Chart
If you see a series of "######" in a cell, that means the following:
You keyed in an incorrect number
The row height is too high
The text is incorrectly spelled
The column width is not wide enough
You can only work in one cell at a time. The actual cell that you are working in is called what?
Column
Name Box
Active Cell
Row
Display the file name of the spreadsheet.
Name Box
Spreadsheet Area
Worksheet Tabs
Title Bar
It is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and allow you to create and view formulas.
Active Cell
Formula Bar
Command Buttons
Ribbon Group
Alternatively referred to as a cell pointer, current cell, or selected cell, a ______ is a rectangular box that highlights the cell in a spreadsheet.
Formula Bar
Dialog Launcher
Ribbon Group
Active Cell
What would be a correct formula for SUM in excel?
=SUM(B3:B9)
=SUMB3+B9
SUM(B3:B9)
=ADD(B3:B9)
If the cell contains hashtags (#), what do you need to do?
Expand the column
Expand the row
Change the formula
Each Excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Which of these formulas will find the correct average of the cells?
=AVERAGE(A1:A10)
=MEAN(A1:A10)
AVERAGE(A1:A10)
What is the Formula sign for multiply?
+
-
/
*
