Welcome to your CS001 – Module 4 Lectures 28–36 Microsoft Excel
Which application is used to perform calculations and data analysis?
. The default file extension for Excel 2003 is:
A single Excel file is called a:
The intersection of a row and column is called a:
Columns in Excel are labeled as:
Rows in Excel are identified by
Which symbol is used to begin a formula in Excel?
The active cell in Excel is identified by:
Which key is used to edit the active cell?
Which function adds a range of numbers?
The default number of worksheets in a new workbook (Excel 2003) is:
The Formula Bar displays:
The maximum column label in Excel 2003 is:
The shortcut key to create a new workbook is:
The chart best suited for showing trends over time is:
The AutoSum button is located on which toolbar?
The COUNT() function is used to;
The Sort option is found under which menu?
Which option combines two or more cells into one?
Why are formulas used in Excel?
The purpose of cell referencing is:
Why use absolute referencing in Excel?
The Fill Handle helps to:
The main purpose of charts in Excel is to:
Using cell borders and shading helps to:
The AVERAGE function is used to:
Deleting a row in Excel will:
The main purpose of sorting data is:
The Freeze Panes option helps to:
The Find and Replace feature is used to:
The Print Preview command allows users to:
The Page Orientation option allows you to:
Which formula totals values in cells B2 through B10?
To find the average of C2 to C10, use:
To multiply A2 by B2, use:
To find the largest value in a list, use:
Which step Autofits a column width automatically?
Which tool copies formatting from one cell to another?
To lock specific cells before sharing, use:
Before inserting a chart, you must:
To sort a list alphabetically, choose:
Which function displays the current date?
To duplicate a worksheet, choose:
To print only selected cells, use;
To continue a number pattern down a column, use:
Which formula calculates profit if Revenue is B2 and Cost is C2?
To print gridlines on paper, enable it in:
