NEW
Font size
WorksheetsExcel Quiz
Total questions: 40
Worksheet time: 30mins
A fast way to add up this column of numbers is to click on the cell below the numbers and then:
Click Subtotals on the Data menu
View the sum in the formula bar.
Click the AutoSum button on the Standard toolbar, then press ENTER.
None of the above
By default, how many sheet/s are there as you open the excel workbook?
1
2
3
4
It is a set of coordinates that identifies a specific cell.
rows and columns
formatted cell
cell reference
active cell
What do you call the term that refers to a combination of two or more cells?
cell
merged cell
workbook cell
active cell
It will display the contents of an active cell.
status bar
formatting bar
formula
formula bar
It enables you to effortless copy data to more than one cell.
Auto Fill
Auto Sum
Auto Format
Auto Filter
They are designed to help simplify potentially complex formulas in a worksheet.
outline
functions
formats
formulas
It is a set of intersecting lines used to align objects.
intersection
area
grid
graph
Indicates the name of the file and program
Formatting bar
Title bar
Quick Access Toolbar
Scroll bar
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
Split
Freeze Panes
Hide
Unhide
Which command do you use to close an open file and completely exit the Microsoft Excel program?
Quit
Save As
Close
Exit
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Workbook
Worksheet
Notepad
Folder
What occurs when the cursor is moved over a cell and a user clicks?
The column is selected
The cell is selected
The worksheet is selected
The row is selected
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
PowerPoint
Excel
Word
Access
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
Arrange All
Freeze Panes
Zoom to Selection
New Window
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
Ctrl + Home
Ctrl + End
Ctrl + 1
Ctrl + Up Arrow
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
Save As
Exit
Open
Save
Which view is the default view used in Microsoft Excel?
Web
Normal
Page Layout
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
Row
Column
Entry
Workbook
A formula that has at least two different mathematical operators is called what?
simple formula
complex formula
function
complex function
Multiple worksheets within one file are collectively called what?
excel
workbook
text
A formula that has just one mathematical operation is called what?
simple formula
complex formula
operator
function
A single sheet within a workbook that contains data
table
cell
workbook
worksheet
Cells labeled with numbers going down a worksheet are called what?
columns
tables
charts
rows
Cells labeled with letters that go across a worksheet are called what?
tables
columns
charts
rows
The location or name of the cell is called it's what? Example A2
column
workbook
row
Cell Address
A group of cells represented by a colon : is called what? Ex: A5:A8
function
cell range
absolute reference
sorting
A predefined formula used to calculate data where you don't need to use any mathematical operator signs.
cell ranges
Function
simple formula
complex formula
Cells can only contain numbers
True
False
If #### appear in your cell after inserting a formula, your formula is incorrect.
True
False
To rename a worksheet or copy a worksheet, I should
right click on cell A1
right-click on the sheet tab at the bottom of the screen
go to the insert tab
all of these
To edit a formula I can
use the formula bar to edit the formula
double click on the cell with the formula in it
all of these
When should I use an absolute reference?
when I am using a percent
when using cells in the same row or colun
When I want to use the same cell over and over again when copying a formula to other cells.
none of these
A benefit to using a function instead of a formula would be
less steps to take than when creating a formula
many more calculations to choose from
simpler look than a formula
all of the above
What is Microsoft Excel's main function?
working with numbers
working with text
creating publications
creating presentations
The new window view allows you to
freeze row B
view two sheets within the same workbook side by side
freeze column A
split your screen in two
What must be followed when working with complex formulas in order to get the correct answer?
order of operations
functions inserted
freezing panes
conditional formatting
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
values
formulas
labels
images
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4/C4
=B4+C4
=B4*C4
=B4-C4
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
=B4/C4
=B4+C4
=B4*C4
=B4-C4
