NEW
Font size
WorksheetsExcel Module 1 Quiz
Total questions: 35
Worksheet time: 35mins
What is Microsoft Excel primarily used for?
Word processing
Spreadsheet analysis
Presentation design
Database management
What is a Worksheet in the context of spreadsheet software?
A graphical representation of data
A single spreadsheet computer file where you enter information
A collection of charts and graphs
A tab within a word processing document
How are rows labeled in a worksheet?
Alphabetically
Numerically
With special characters
Randomly
How are columns labeled in a worksheet?
Numerically
With special characters
Alphabetically
Randomly
What is the intersection of a column and a row in a worksheet called?
A cell
A block
A field
A range
What does the Title Bar display in a program?
The commands and tools grouped by category
The active cell by the letter of the column and the number of the row that it intersects
The current workbook and name of program
The range of cells being selected
What is the purpose of Tabs in a program?
To identify the active cell
To display the current workbook and name of program
To access tools & commands related to the name of tab
To identify the range of cells being selected
What does the Ribbon contain?
The range of cells being selected
The active cell by the letter of the column and the number of the row that it intersects
The current workbook and name of program
The commands and tools grouped by category on different tabs
What does the Name Box identify?
The commands and tools grouped by category
The current workbook and name of program
The active cell by the letter of the column and the number of the row that it intersects
The tools & commands related to the name of tab
What does the Formula Bar display in a spreadsheet application?
The result of the calculation in the active cell
The contents of the active cell and is used to create or edit text or values
The formatting options for the active cell
The name of the active cell
What are Scroll Bars used for in a Microsoft Excel worksheet?
To add new rows or columns
To move horizontally or vertically within a worksheet
To adjust the page margins
To sort data alphabetically
What is the function of the Thick White Plus Sign in spreadsheet software?
It is used for deleting cells
It is used for selecting and highlighting cells
It represents the Fill Handle
It is used for changing cell colors
What is the Thin Black Plus Sign known as in spreadsheet software?
Cursor
Fill Handle
Formatting Tool
AutoSum Feature
What is the purpose of the Fill Handle in spreadsheet software?
It is used for formatting text within cells
It is used for inserting new rows or columns
It is used for copying information
It is used for creating charts
How would you denote a range of cells from the first cell in column A to the tenth cell in column F in spreadsheet notation?
A1:A10
A1:F1
A:F
A1:F10
How do all formulas in a spreadsheet begin?
+
=
-
@
What does 'fx' stand for in a spreadsheet?
Function
Fix
Formula
Fraction
What happens when you double click between the columns/rows where the cursor appears as a line with two arrows pointing outward?
It deletes the column or row
It hides the column or row
It auto fits the column or row to the content
It locks the column or row
What is indicated by "####" in a cell within a spreadsheet?
The cell contains an error
The cell is currently being calculated
The cell contains a date that cannot be displayed
There is not enough space in the column for the content
What is the purpose of using ALT + Enter key in a spreadsheet cell?
To delete the contents of the cell
To merge the cell with another cell
To type two lines within the same cell
To apply a formula to the cell
Which of the following tabs lets you set worksheet print options?
Review
Home
Page Layout
View
Which of the following is a predefined procedure that returns a value?
clipboard
mode indicator
named range
function
Why is it necessary to use care when inserting worksheet cells?
It might automatically change the functions you are using.
It can change relative references to absolute references in formulas.
You will have to manually correct cell references in formulas.
It may disturb row or column alignment, which can affect worksheet accuracy.
In the formula =A8*S$A$1, which of the following describes A8?
Relative cell reference
Absolute cell reference
Function
AutoSum
In the formula =B6*S$B$2, which of the following describes S$B$2?
Relative cell reference
Absolute cell reference
Function
Average
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =B6+B7+B8+B9+B10.
The formula =TOTAL(B6:B10)
The formula =SUM(B6:B10)
The formula +SUM(B6:B10)
Which of the following lets you edit the contents of a cell?
Click the cell, click the status bar, and press Enter.
Click the cell and click in the status bar.
Double-click the cell, click in the status bar, or just start typing.
Double-click the cell or click in the formula bar.
Which of the following is the temporary storage area that holds selections you copy or cut?
Clipboard
Backstage
Name box
Worksheet window
In the formula =SUM(A6:A9), which of the following best describes A6:A9?
argument
function
cell reference
range
When should you use relative cell references?
When you want to preserve the exact cell address in a formula.
When you want to preserve the relationship to the formula location.
When you want to insert a function.
When you want to enter sequential values in a range of cells.
In a complex formula, how does Excel determine which calculation to perform first?
It calculates the leftmost formulas first.
It calculates operations outside parentheses first.
It follows the order of operations.
It calculates functions first.
Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?
Hide the column headings.
Insert a function.
Copy columns to the next page.
Change the page orientation to landscape.
To have Excel enter the lowest price from a range of prices, which of the following would you use?
MAX function
COUNT function
MIN function
COUNTA function
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?
mode indicator
Page Break Preview
scroll bar
Fill handle
Which worksheet view shows headers, footers, and rulers?
Normal view
Page Break Preview
Page Layout view
Formula view
