WorksheetsKuiz Excel
Total questions: 20
Worksheet time: 12mins
What is the "Active Cell" in Excel?
The Bottom cell in a worksheet. It is indicated by a dark border onscreen.
The current cell in a worksheet. It is indicated by a dark border onscreen.
The top cell in a worksheet. It is indicated by a dark border onscreen.
The past cell in a worksheet. It is indicated by a dark border onscreen.
What is a spreadsheet?
An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.
An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.
An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.
An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
When starting a formula what is the first thing you type in the cell?
+
-
%
=
When you open Excel you are viewing Excel in the ____ View?
Backstage
Frontstage
Spreadsheet
Template
Excel is useful for using ________ as opposed to words or presentations?
Excel is useful in presenting
Excel is useful in documents
Excel is useful in numbers
Excel is useful in publishing
The letters in Excel represent the _______?
columns
rows
data
functions
When making a graph whats the first thing you need to do?
Pick the type of Graph
Use the function = sign
Highlight your data being used.
Double click the active cell
A function in Excel is represented by what to letters?
f( )
xF
xf
fx
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Accounting format
A
B
C
D
E
Increase decimals
A
B
C
D
E
Which of the following is an example of an absolute cell reference?
A9
A$9
$A$9
A9:E9
To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).
TRUE
FALSE
The formula = 6 * 2 + 3 produces the same result as = 6 * (2 + 3).
TRUE
FALSE
Which sort option would showing increasing values or alphabetical order?
Ascending
Descending
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?
Referring to the table above, what is the quickest method of filtering so that only Oklahoma (OK) is shown?
Uncheck every state or province except OK
Uncheck Select All and then check OK
Sort A to Z and then check OK
Sort Z to A and then check OK.
Which cell would you click to freeze Rows 1-5 and Column A?
A5
B5
A6
B6
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.
Delete the worksheet
Move the worksheet to the end of the workbook
Hide the worksheet
Click the undisplay command
