NEW
Font size
WorksheetsExcel Coursework
Total questions: 63
Worksheet time: 32mins
Which of the following is considered a range in Excel?
9B:30C
A1:B8
A1, C22, D14
They are all ranges
Which of the following is a row?
A
B
C
D
Which of the following is the Name Box?
A
B
C
D
What is the address of this cell?
B3
3B
AB3
None of them is correct
This mouse pointer allows you to _____.
Change the height of an entire row
Delete an entire row
Select an entire column
Select an entire row
What can a cell contain?
A column
A number, text, formula or function
A row
The cell address
What is a workbook?
Excel file
Excel spreadsheet page.
A number, text, formula or function
Which keyboard shortcut bolds text in a cell?
“Ctrl+B”
“Ctrl+I”
“Ctrl+U”
“Ctrl+X”
Which of the following is NOT a way to change the column width in Excel?
Right-click the column header and then click Column Width.
Click and drag the column's boundary line to the desired width.
Double-click the column header and then click Delete.
Double-click the column's boundary line.
Which of the following methods cannot be used to enter data in a cell
a. Pressing an arrow key
b. Pressing the Tab key
c. Pressing the Esc key
d. Clicking on the formula bar
Which of the following will not cut information?
a. Pressing Ctrl + C
b. Selecting Edit>Cut from the menu
c. Clicking the Cut button on the standard
d. Pressing Ctrl+X
You accidentally erased a record in the sheet. What command can be used to restore it immediately?
A. Insert
B. Copy
C. Undo
D. Replace
What is the shortcut key to highlight the entire column?
A. Ctrl+C
B. Ctrl+Enter
C. Ctrl+Page Up
D. Ctrl+Space Bar
Which of the following is not a term of MS-Excel?
A. Cells
B. Rows
C. Columns
D. Document
The basic unit of a worksheet into which you enter data in Excel is called a
A.cell
B.table
C.box
D.column
The advantage of using a spreadsheet is:
A. calculations can be done automatically.
B. changing data automatically updates calculations
C. more flexibility
D. All of the above
The options available in Backstage view are________
New
Save/Save as
Open
All of these
The Extend selection mode can be enabled using the __________key
F5
F2
F8
F12
The ________displays the address of the selected cell
Formula bar
Name box
Title Bar
None of the above
A______is a rectangular block of contiguous cells
Address
Range
Cell
Formula
Which of these icons will decrease decimal places?
A
B
C
D
Which symbol is placed at the beginning of a new formula in Excel?
=
+
-
/
What is the arrow pointing to?
Add a New Sheet Tab
Document Tab
Sheet Tab
Slides Tab
Where do your formulas appear when you type them in a worksheet?
Name Box
Formula Bar
Search Box
Function Bar
What is the address of this cell?
B3
3B
AB3
None of them is correct
IF, AND, OR and NOT are all part of which category of functions?
Math & Trig
Text
Logical
Lookup & Reference
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
VLOOKUP
HLOOKUP
LOOKUP
SEARCH
Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that range that are greater than 1,000. What function should she use?
AVERAGEIF
COUNTIF
SUMIF
TOTALIF
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?
SUMIF
AVERAGEIF
TOTALIF
COUNTIF
Define Function.
Must be the first character in the cell. It tells the spreadsheet a calculation is to be performed
A predefined formula that performs a calculation based on values that are entered in the function.
Indicates the operation to be performed, such as a sum
Contains the information you want to use in the function’s calculation.
What are the three parts of a formula?
Equal sign, Operand, Operator
Formula Bar, Cell Reference, Color
Complex, Simple, Order of Operations
Which of the following is NOT a way to change the column width in Excel?
Right-click the column header and then click Column Width.
Click and drag the column's boundary line to the desired width.
Double-click the column header and then click Delete.
All of the above
Double-click the column's boundary line.
What are the pieces of information that describe the appearance of a cell's content?
Active attributes
Paste attributes
Format attributes
Edit attributes
Which of the following statements is TRUE?
The content and format of a cell are independent.
Changing the format of a cell also affects its content.
The content and format of a cell are the same.
What can a cell contain?
A column
A number, text, formula or function
A row
The cell address
What is a workbook?
Excel file
Excel spreadsheet page.
A number, text, formula or function
What is the Sum formula?
Sum( )
Sum( )=
=Sum( )
=( )Sum
How would you write a cell reference formula for cell A1 subtracted from Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
Which formula gets the biggest value of a range of cells?
MAX
MIN
SHORT
SUM
Which formula gets the smallest value of a range of cells?
MAX
MIN
SMALL
SUM
A _________ is a prewritten formula that is built into EXCEL.
function
problem
equation
equal sign
A combination of numbers and symbols used to express a calculation. Always begins with an "=" sign.
Cell address
Worksheet
Formula
Which of the following formulas is not entered correctly?
=10+50
=B7+B8
=B7+14
=10+50;
Which of these symbols is used to do a division on a computer?
\
*
/
|
Formulas can be copied to adjacent cells with the ____________.
Fill handle
PgDn Key
Function key F4
None of the above
Which of the following is the proper format for a range?
A1-D10
A1:D10
A1thruD10
A1&D10
Which of the following describes a column?
Identified by letters; runs vertically
Identified by letters; runs horizontally
Identified by numbers; runs vertically
Identified by numbers; runs horizontally
True or False: The two types of cell references in Excel are relative and absolute.
True
False
True or False: If the parentheses are not included in a formula, the multiplication is calculated first and the result is incorrect.
True
False
True or False: Absolute references remain constant no matter where they are copied in Excel.
True
False
True or False: If a formula is too large to display in a cell it will appear as pound signs (#####) instead of a value.
True
False
Which of the following are parts of a function?
arguments
function name
equal sign
all of the above
What must each formula in Excel begin with?
(equal sign) =
(plus sign) +
(minus sign) -
(parenthesis) ( )
To add a new worksheet in an Excel document, you should click on:
The 'Make a Copy' box
File Menu
The 'Move Copy' box
The new worksheet tab
This function counts the number of cells with numerical data in the argument. This function is useful for quickly counting items in a cell range.
SUM
AVERAGE
COUNT
MAX
MIN
True or False: A function is a predefined formula that performs calculations using specific values in a particular order.
True
False
To view more than two workbooks simultaneously, you should choose:
Arrange all
Simultaneous workflow
Switch windows
View side-by-side
True or False: Excel will not always tell you if your formula contains an error.
True
False
What do you call a single spreadsheet in Excel?
A workbook
A work document
Workflow
A worksheet
What will you use to create a formula?
quick reference toolbar
cell reference
pen and paper
name box
True or False: In order to use a cell reference with multiple worksheets, begin the cell reference with the worksheet name followed by an exclamation point (!)
True
False
